Error: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Brand.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL Query: SELECT name as value, id, sum(count) as count FROM (SELECT Brand.name as name, Brand.id as id, count(DISTINCT Productgroup.id) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' GROUP BY Brand.id UNION SELECT Brand.name as name, Brand.id as id, count(DISTINCT Bundle.id) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
try {
$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$this->_results = $query;
array()
$options += array('log' => $this->fullDebug);
$t = microtime(true);
$this->_result = $this->_execute($sql, $params);
'SELECT name as value, id, sum(count) as count FROM (SELECT Brand.name as name, Brand.id as id, count(DISTINCT Productgroup.id) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' GROUP BY Brand.id UNION SELECT Brand.name as name, Brand.id as id, count(DISTINCT Bundle.id) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name' array()
if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
return $cached;
}
if ($result = $this->execute($sql, array(), $params)) {
$out = array();
'SELECT name as value, id, sum(count) as count FROM (SELECT Brand.name as name, Brand.id as id, count(DISTINCT Productgroup.id) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' GROUP BY Brand.id UNION SELECT Brand.name as name, Brand.id as id, count(DISTINCT Bundle.id) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name' array() array()
$recursive = null;
if (count($args) === 1) {
return $this->fetchAll($args[0]);
} elseif (count($args) > 1 && (strpos($args[0], 'findBy') === 0 || strpos($args[0], 'findAllBy') === 0)) {
'SELECT name as value, id, sum(count) as count FROM (SELECT Brand.name as name, Brand.id as id, count(DISTINCT Productgroup.id) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' GROUP BY Brand.id UNION SELECT Brand.name as name, Brand.id as id, count(DISTINCT Bundle.id) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name'
'SELECT name as value, id, sum(count) as count FROM (SELECT Brand.name as name, Brand.id as id, count(DISTINCT Productgroup.id) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' GROUP BY Brand.id UNION SELECT Brand.name as name, Brand.id as id, count(DISTINCT Bundle.id) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name'
public function query($sql) {
$params = func_get_args();
$db = $this->getDataSource();
return call_user_func_array(array(&$db, 'query'), $params);
}
array( (int) 0 => object(Mysql) {}, (int) 1 => 'query' ) array( (int) 0 => 'SELECT name as value, id, sum(count) as count FROM (SELECT Brand.name as name, Brand.id as id, count(DISTINCT Productgroup.id) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' GROUP BY Brand.id UNION SELECT Brand.name as name, Brand.id as id, count(DISTINCT Bundle.id) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name' )
// wrapper count
$sql = "SELECT name as value, id, sum(count) as count FROM ($union) as Brand GROUP BY Brand.id ORDER BY name";
$query = $this->query($sql);
// fix index 0 structure with calculated value
'SELECT name as value, id, sum(count) as count FROM (SELECT Brand.name as name, Brand.id as id, count(DISTINCT Productgroup.id) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' GROUP BY Brand.id UNION SELECT Brand.name as name, Brand.id as id, count(DISTINCT Bundle.id) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name'
}
// Find Brands
$brands = $this->Group->filterBrands();
'83' 'jeux-de-cartes' 'cartes-tarot'
'action' => $request->params['action']
));
}
return $method->invokeArgs($this, $request->params['pass']);
object(CategoriesController) { components => array( [maximum depth reached] ) helpers => array( [maximum depth reached] ) cacheAction => true settings => array([maximum depth reached]) name => 'Categories' uses => array( [maximum depth reached] ) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Categories' layoutPath => null viewVars => array( [maximum depth reached] ) view => 'view' layout => 'default' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => null passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Category' modelKey => 'category' validationErrors => null ImgResize => object(ImgResizeComponent) {} Session => object(SessionComponent) {} Redirect => object(RedirectComponent) {} Seo => object(SeoComponent) {} Facebook => object(FacebookComponent) {} Cookie => object(CookieComponent) {} RequestHandler => object(RequestHandlerComponent) {} Email => object(EmailComponent) {} Cache => object(CacheComponent) {} AutoLogin => object(AutoLoginComponent) {} Auth => object(AuthComponent) {} Mailchimp => object(MailchimpComponent) {} Aws => object(AwsComponent) {} CustomerAuth => object(CustomerAuthComponent) {} Checkout => object(CheckoutComponent) {} Toolbar => object(ToolbarComponent) {} Hour => object(Hour) {} Country => object(Country) {} Store => object(Store) {} _activestore => array( [maximum depth reached] ) ShippingmethodsStore => object(ShippingmethodsStore) {} Message => object(Message) {} UrlRedirect => object(UrlRedirect) {} Cart => object(Cart) {} __carts => array([maximum depth reached]) Navigation => object(Navigation) {} theme => 'Pokerhandel' Category => object(Category) {} Group => object(Group) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } array( (int) 0 => '83', (int) 1 => 'jeux-de-cartes', (int) 2 => 'cartes-tarot' )
$controller->startupProcess();
$render = true;
$result = $controller->invokeAction($request);
if ($result instanceof CakeResponse) {
object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'fra/category/83/jeux-de-cartes/cartes-tarot/limit:24/page:1/direction:desc' base => '' webroot => '/' here => '/fra/category/83/jeux-de-cartes/cartes-tarot/limit:24/page:1/direction:desc' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' }
));
}
$response = $this->_invoke($controller, $request, $response);
if (isset($request->params['return'])) {
object(CategoriesController) { components => array( [maximum depth reached] ) helpers => array( [maximum depth reached] ) cacheAction => true settings => array([maximum depth reached]) name => 'Categories' uses => array( [maximum depth reached] ) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Categories' layoutPath => null viewVars => array( [maximum depth reached] ) view => 'view' layout => 'default' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => null passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Category' modelKey => 'category' validationErrors => null ImgResize => object(ImgResizeComponent) {} Session => object(SessionComponent) {} Redirect => object(RedirectComponent) {} Seo => object(SeoComponent) {} Facebook => object(FacebookComponent) {} Cookie => object(CookieComponent) {} RequestHandler => object(RequestHandlerComponent) {} Email => object(EmailComponent) {} Cache => object(CacheComponent) {} AutoLogin => object(AutoLoginComponent) {} Auth => object(AuthComponent) {} Mailchimp => object(MailchimpComponent) {} Aws => object(AwsComponent) {} CustomerAuth => object(CustomerAuthComponent) {} Checkout => object(CheckoutComponent) {} Toolbar => object(ToolbarComponent) {} Hour => object(Hour) {} Country => object(Country) {} Store => object(Store) {} _activestore => array( [maximum depth reached] ) ShippingmethodsStore => object(ShippingmethodsStore) {} Message => object(Message) {} UrlRedirect => object(UrlRedirect) {} Cart => object(Cart) {} __carts => array([maximum depth reached]) Navigation => object(Navigation) {} theme => 'Pokerhandel' Category => object(Category) {} Group => object(Group) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'fra/category/83/jeux-de-cartes/cartes-tarot/limit:24/page:1/direction:desc' base => '' webroot => '/' here => '/fra/category/83/jeux-de-cartes/cartes-tarot/limit:24/page:1/direction:desc' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array( [maximum depth reached] ) }
$Dispatcher->dispatch(
new CakeRequest(),
new CakeResponse()
);
object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'fra/category/83/jeux-de-cartes/cartes-tarot/limit:24/page:1/direction:desc' base => '' webroot => '/' here => '/fra/category/83/jeux-de-cartes/cartes-tarot/limit:24/page:1/direction:desc' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array( [maximum depth reached] ) }
Our store in Kontich is currently open until 18:00.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__nld`.`content`) AS `Store__i18n_disable_checkout_msg_nld` FROM `tbiback_tbshops`.`stores` AS `Store` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__nld` ON (`Store`.`id` = `I18n__homepagetitle__nld`.`foreign_key` AND `I18n__homepagetitle__nld`.`model` = 'Store' AND `I18n__homepagetitle__nld`.`field` = 'homepagetitle' AND `I18n__homepagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__nld` ON (`Store`.`id` = `I18n__homepagedescription__nld`.`foreign_key` AND `I18n__homepagedescription__nld`.`model` = 'Store' AND `I18n__homepagedescription__nld`.`field` = 'homepagedescription' AND `I18n__homepagedescription__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__nld` ON (`Store`.`id` = `I18n__homepage_footer__nld`.`foreign_key` AND `I18n__homepage_footer__nld`.`model` = 'Store' AND `I18n__homepage_footer__nld`.`field` = 'homepage_footer' AND `I18n__homepage_footer__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__nld` ON (`Store`.`id` = `I18n__homepage_content__nld`.`foreign_key` AND `I18n__homepage_content__nld`.`model` = 'Store' AND `I18n__homepage_content__nld`.`field` = 'homepage_content' AND `I18n__homepage_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__nld` ON (`Store`.`id` = `I18n__header_points__nld`.`foreign_key` AND `I18n__header_points__nld`.`model` = 'Store' AND `I18n__header_points__nld`.`field` = 'header_points' AND `I18n__header_points__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__nld` ON (`Store`.`id` = `I18n__footer_blocks__nld`.`foreign_key` AND `I18n__footer_blocks__nld`.`model` = 'Store' AND `I18n__footer_blocks__nld`.`field` = 'footer_blocks' AND `I18n__footer_blocks__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__nld` ON (`Store`.`id` = `I18n__sidebar_content__nld`.`foreign_key` AND `I18n__sidebar_content__nld`.`model` = 'Store' AND `I18n__sidebar_content__nld`.`field` = 'sidebar_content' AND `I18n__sidebar_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__nld` ON (`Store`.`id` = `I18n__disable_checkout_msg__nld`.`foreign_key` AND `I18n__disable_checkout_msg__nld`.`model` = 'Store' AND `I18n__disable_checkout_msg__nld`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__nld`.`locale` = 'nld') WHERE `url` = 'pokerhandel.be' LIMIT 1 | 1 | 1 | 0 | |
SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (10) | 16 | 16 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-30' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-30' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__fra`.`content`) AS `Store__i18n_homepagetitle_fra`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__fra`.`content`) AS `Store__i18n_homepagedescription_fra`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__fra`.`content`) AS `Store__i18n_homepage_footer_fra`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__fra`.`content`) AS `Store__i18n_homepage_content_fra`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__fra`.`content`) AS `Store__i18n_header_points_fra`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__fra`.`content`) AS `Store__i18n_footer_blocks_fra`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__fra`.`content`) AS `Store__i18n_sidebar_content_fra`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__fra`.`content`) AS `Store__i18n_disable_checkout_msg_fra`, (`I18n__disable_checkout_msg__nld`.`content`) AS `Store__i18n_disable_checkout_msg_nld` FROM `tbiback_tbshops`.`stores` AS `Store` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__fra` ON (`Store`.`id` = `I18n__homepagetitle__fra`.`foreign_key` AND `I18n__homepagetitle__fra`.`model` = 'Store' AND `I18n__homepagetitle__fra`.`field` = 'homepagetitle' AND `I18n__homepagetitle__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__nld` ON (`Store`.`id` = `I18n__homepagetitle__nld`.`foreign_key` AND `I18n__homepagetitle__nld`.`model` = 'Store' AND `I18n__homepagetitle__nld`.`field` = 'homepagetitle' AND `I18n__homepagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__fra` ON (`Store`.`id` = `I18n__homepagedescription__fra`.`foreign_key` AND `I18n__homepagedescription__fra`.`model` = 'Store' AND `I18n__homepagedescription__fra`.`field` = 'homepagedescription' AND `I18n__homepagedescription__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__nld` ON (`Store`.`id` = `I18n__homepagedescription__nld`.`foreign_key` AND `I18n__homepagedescription__nld`.`model` = 'Store' AND `I18n__homepagedescription__nld`.`field` = 'homepagedescription' AND `I18n__homepagedescription__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__fra` ON (`Store`.`id` = `I18n__homepage_footer__fra`.`foreign_key` AND `I18n__homepage_footer__fra`.`model` = 'Store' AND `I18n__homepage_footer__fra`.`field` = 'homepage_footer' AND `I18n__homepage_footer__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__nld` ON (`Store`.`id` = `I18n__homepage_footer__nld`.`foreign_key` AND `I18n__homepage_footer__nld`.`model` = 'Store' AND `I18n__homepage_footer__nld`.`field` = 'homepage_footer' AND `I18n__homepage_footer__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__fra` ON (`Store`.`id` = `I18n__homepage_content__fra`.`foreign_key` AND `I18n__homepage_content__fra`.`model` = 'Store' AND `I18n__homepage_content__fra`.`field` = 'homepage_content' AND `I18n__homepage_content__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__nld` ON (`Store`.`id` = `I18n__homepage_content__nld`.`foreign_key` AND `I18n__homepage_content__nld`.`model` = 'Store' AND `I18n__homepage_content__nld`.`field` = 'homepage_content' AND `I18n__homepage_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__fra` ON (`Store`.`id` = `I18n__header_points__fra`.`foreign_key` AND `I18n__header_points__fra`.`model` = 'Store' AND `I18n__header_points__fra`.`field` = 'header_points' AND `I18n__header_points__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__nld` ON (`Store`.`id` = `I18n__header_points__nld`.`foreign_key` AND `I18n__header_points__nld`.`model` = 'Store' AND `I18n__header_points__nld`.`field` = 'header_points' AND `I18n__header_points__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__fra` ON (`Store`.`id` = `I18n__footer_blocks__fra`.`foreign_key` AND `I18n__footer_blocks__fra`.`model` = 'Store' AND `I18n__footer_blocks__fra`.`field` = 'footer_blocks' AND `I18n__footer_blocks__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__nld` ON (`Store`.`id` = `I18n__footer_blocks__nld`.`foreign_key` AND `I18n__footer_blocks__nld`.`model` = 'Store' AND `I18n__footer_blocks__nld`.`field` = 'footer_blocks' AND `I18n__footer_blocks__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__fra` ON (`Store`.`id` = `I18n__sidebar_content__fra`.`foreign_key` AND `I18n__sidebar_content__fra`.`model` = 'Store' AND `I18n__sidebar_content__fra`.`field` = 'sidebar_content' AND `I18n__sidebar_content__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__nld` ON (`Store`.`id` = `I18n__sidebar_content__nld`.`foreign_key` AND `I18n__sidebar_content__nld`.`model` = 'Store' AND `I18n__sidebar_content__nld`.`field` = 'sidebar_content' AND `I18n__sidebar_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__fra` ON (`Store`.`id` = `I18n__disable_checkout_msg__fra`.`foreign_key` AND `I18n__disable_checkout_msg__fra`.`model` = 'Store' AND `I18n__disable_checkout_msg__fra`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__nld` ON (`Store`.`id` = `I18n__disable_checkout_msg__nld`.`foreign_key` AND `I18n__disable_checkout_msg__nld`.`model` = 'Store' AND `I18n__disable_checkout_msg__nld`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__nld`.`locale` = 'nld') WHERE `url` = 'pokerhandel.be' LIMIT 1 | 1 | 1 | 0 | |
SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (10) | 16 | 16 | 0 | |
SELECT `ShippingmethodsStore`.`id`, `ShippingmethodsStore`.`shippingmethod_id`, `ShippingmethodsStore`.`store_id`, `Shippingmethod`.`id`, `Shippingmethod`.`code`, `Shippingmethod`.`sorting`, `Shippingmethod`.`countries`, `Shippingmethod`.`store_id`, `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores` FROM `tbiback_tbshops`.`shippingmethods_stores` AS `ShippingmethodsStore` LEFT JOIN `tbiback_tbshops`.`shippingmethods` AS `Shippingmethod` ON (`ShippingmethodsStore`.`shippingmethod_id` = `Shippingmethod`.`id`) LEFT JOIN `tbiback_tbshops`.`stores` AS `Store` ON (`ShippingmethodsStore`.`store_id` = `Store`.`id`) WHERE `Store`.`id` = 10 AND `Shippingmethod`.`code` = 'shipment' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingRate`.`id`, `ShippingRate`.`shippingmethod_id`, `ShippingRate`.`country`, `ShippingRate`.`floor`, `ShippingRate`.`ceiling`, `ShippingRate`.`criteria`, `ShippingRate`.`price` FROM `tbiback_tbshops`.`shipping_rates` AS `ShippingRate` WHERE `ShippingRate`.`shippingmethod_id` = (8) | 41 | 41 | 0 | |
SELECT `Message`.`id`, `Message`.`type`, `Message`.`start`, `Message`.`end`, `Message`.`store_id`, `Message`.`from_override`, (`I18n__message__fra`.`content`) AS `Message__i18n_message_fra`, (`I18n__message__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__fra` ON (`Message`.`id` = `I18n__message__fra`.`foreign_key` AND `I18n__message__fra`.`model` = 'Message' AND `I18n__message__fra`.`field` = 'message' AND `I18n__message__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__nld` ON (`Message`.`id` = `I18n__message__nld`.`foreign_key` AND `I18n__message__nld`.`model` = 'Message' AND `I18n__message__nld`.`field` = 'message' AND `I18n__message__nld`.`locale` = 'nld') WHERE `type` = 'popover' AND `start` <= '2024-03-29' AND `end` >= '2024-03-29' AND `store_id` IN (0, 10) LIMIT 1 | 0 | 0 | 0 | |
SELECT `UrlRedirect`.`id`, `UrlRedirect`.`old_url`, `UrlRedirect`.`new_url`, `UrlRedirect`.`redirect_type`, `UrlRedirect`.`store_id` FROM `tbiback_tbshops`.`url_redirects` AS `UrlRedirect` WHERE `old_url` = 'http://pokerhandel.be/fra/category/83/jeux-de-cartes/cartes-tarot/limit:24/page:1/direction:desc' AND `store_id` = 10 LIMIT 1 | 0 | 0 | 0 | |
SELECT `Cart`.`id`, `Cart`.`display`, `Cart`.`group_id`, `Cart`.`group_model`, `Cart`.`session_id`, `Cart`.`qty`, `Cart`.`price`, `Cart`.`price_excl_vat`, `Cart`.`price_vat`, `Cart`.`price_incl_vat`, `Cart`.`vat`, `Cart`.`created`, `Cart`.`loaded`, `Cart`.`store_id`, `Cart`.`default`, `Cart`.`defaultqty`, `Cart`.`order_type`, `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed`, `Bundle`.`id`, `Bundle`.`SKU`, `Bundle`.`brand_id`, `Bundle`.`price`, `Bundle`.`promoprice`, `Bundle`.`purchaseprice`, `Bundle`.`wholesaleprice`, `Bundle`.`qtychange_price`, `Bundle`.`hidden`, `Bundle`.`available`, `Bundle`.`created` FROM `tbiback_tbshops`.`carts` AS `Cart` LEFT JOIN `tbiback_tbshops`.`productgroups` AS `Productgroup` ON (`Cart`.`group_id` = `Productgroup`.`id` AND `Cart`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`bundles` AS `Bundle` ON (`Cart`.`group_id` = `Bundle`.`id` AND `Cart`.`group_model` = 'Bundle') WHERE `session_id` = 'c1o9hvshaqoihkgjdqpktt8jl3' AND `qty` > 0 | 0 | 0 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`sorting`, `Category`.`topmenu`, `Category`.`store_id`, (`I18n__name__fra`.`content`) AS `Category__i18n_name_fra`, (`I18n__name__nld`.`content`) AS `Category__i18n_name_nld`, (`I18n__slug__fra`.`content`) AS `Category__i18n_slug_fra`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld`, (`I18n__description__fra`.`content`) AS `Category__i18n_description_fra`, (`I18n__description__nld`.`content`) AS `Category__i18n_description_nld`, (`I18n__description_short__fra`.`content`) AS `Category__i18n_description_short_fra`, (`I18n__description_short__nld`.`content`) AS `Category__i18n_description_short_nld`, (`I18n__path__fra`.`content`) AS `Category__i18n_path_fra`, (`I18n__path__nld`.`content`) AS `Category__i18n_path_nld`, (`I18n__pagetitle__fra`.`content`) AS `Category__i18n_pagetitle_fra`, (`I18n__pagetitle__nld`.`content`) AS `Category__i18n_pagetitle_nld`, `ParentCategory`.`id`, `ParentCategory`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__fra` ON (`Category`.`id` = `I18n__name__fra`.`foreign_key` AND `I18n__name__fra`.`model` = 'Category' AND `I18n__name__fra`.`field` = 'name' AND `I18n__name__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Category`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Category' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__fra` ON (`Category`.`id` = `I18n__slug__fra`.`foreign_key` AND `I18n__slug__fra`.`model` = 'Category' AND `I18n__slug__fra`.`field` = 'slug' AND `I18n__slug__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__fra` ON (`Category`.`id` = `I18n__description__fra`.`foreign_key` AND `I18n__description__fra`.`model` = 'Category' AND `I18n__description__fra`.`field` = 'description' AND `I18n__description__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Category`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Category' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__fra` ON (`Category`.`id` = `I18n__description_short__fra`.`foreign_key` AND `I18n__description_short__fra`.`model` = 'Category' AND `I18n__description_short__fra`.`field` = 'description_short' AND `I18n__description_short__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Category`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Category' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__path__fra` ON (`Category`.`id` = `I18n__path__fra`.`foreign_key` AND `I18n__path__fra`.`model` = 'Category' AND `I18n__path__fra`.`field` = 'path' AND `I18n__path__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__path__nld` ON (`Category`.`id` = `I18n__path__nld`.`foreign_key` AND `I18n__path__nld`.`model` = 'Category' AND `I18n__path__nld`.`field` = 'path' AND `I18n__path__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__fra` ON (`Category`.`id` = `I18n__pagetitle__fra`.`foreign_key` AND `I18n__pagetitle__fra`.`model` = 'Category' AND `I18n__pagetitle__fra`.`field` = 'pagetitle' AND `I18n__pagetitle__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`Category`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`id` = 83 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 6 | maybe slow |
SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`sorting`, `ParentCategory`.`topmenu`, `ParentCategory`.`store_id` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 0 | 0 | 0 | 0 | |
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (83) | 0 | 0 | 0 | |
SELECT `ParentCategory`.`id`, (`I18n__name__fra`.`content`) AS `ParentCategory__i18n_name_fra`, (`I18n__name__nld`.`content`) AS `ParentCategory__i18n_name_nld`, (`I18n__slug__fra`.`content`) AS `ParentCategory__i18n_slug_fra`, (`I18n__slug__nld`.`content`) AS `ParentCategory__i18n_slug_nld`, (`I18n__description__fra`.`content`) AS `ParentCategory__i18n_description_fra`, (`I18n__description__nld`.`content`) AS `ParentCategory__i18n_description_nld`, (`I18n__description_short__fra`.`content`) AS `ParentCategory__i18n_description_short_fra`, (`I18n__description_short__nld`.`content`) AS `ParentCategory__i18n_description_short_nld`, (`I18n__path__fra`.`content`) AS `ParentCategory__i18n_path_fra`, (`I18n__path__nld`.`content`) AS `ParentCategory__i18n_path_nld`, (`I18n__pagetitle__fra`.`content`) AS `ParentCategory__i18n_pagetitle_fra`, (`I18n__pagetitle__nld`.`content`) AS `ParentCategory__i18n_pagetitle_nld` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__fra` ON (`ParentCategory`.`id` = `I18n__name__fra`.`foreign_key` AND `I18n__name__fra`.`model` = 'Category' AND `I18n__name__fra`.`field` = 'name' AND `I18n__name__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`ParentCategory`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Category' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__fra` ON (`ParentCategory`.`id` = `I18n__slug__fra`.`foreign_key` AND `I18n__slug__fra`.`model` = 'Category' AND `I18n__slug__fra`.`field` = 'slug' AND `I18n__slug__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`ParentCategory`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__fra` ON (`ParentCategory`.`id` = `I18n__description__fra`.`foreign_key` AND `I18n__description__fra`.`model` = 'Category' AND `I18n__description__fra`.`field` = 'description' AND `I18n__description__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`ParentCategory`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Category' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__fra` ON (`ParentCategory`.`id` = `I18n__description_short__fra`.`foreign_key` AND `I18n__description_short__fra`.`model` = 'Category' AND `I18n__description_short__fra`.`field` = 'description_short' AND `I18n__description_short__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`ParentCategory`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Category' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__path__fra` ON (`ParentCategory`.`id` = `I18n__path__fra`.`foreign_key` AND `I18n__path__fra`.`model` = 'Category' AND `I18n__path__fra`.`field` = 'path' AND `I18n__path__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__path__nld` ON (`ParentCategory`.`id` = `I18n__path__nld`.`foreign_key` AND `I18n__path__nld`.`model` = 'Category' AND `I18n__path__nld`.`field` = 'path' AND `I18n__path__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__fra` ON (`ParentCategory`.`id` = `I18n__pagetitle__fra`.`foreign_key` AND `I18n__pagetitle__fra`.`model` = 'Category' AND `I18n__pagetitle__fra`.`field` = 'pagetitle' AND `I18n__pagetitle__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`ParentCategory`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') WHERE `ParentCategory`.`id` = 42 AND `ParentCategory`.`store_id` = 10 LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 83 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 42 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, (`I18n__slug__fra`.`content`) AS `Category__i18n_slug_fra`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__fra` ON (`Category`.`id` = `I18n__slug__fra`.`foreign_key` AND `I18n__slug__fra`.`model` = 'Category' AND `I18n__slug__fra`.`field` = 'slug' AND `I18n__slug__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') WHERE `Category`.`id` = 42 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 1 | |
SELECT `CategoryFilter`.`id`, `CategoryFilter`.`category_id`, `CategoryFilter`.`storeattribute_id`, `CategoryFilter`.`active`, `Storeattribute`.`id`, `Storeattribute`.`type`, `Storeattribute`.`created` FROM `tbiback_tbshops`.`category_filters` AS `CategoryFilter` LEFT JOIN `tbiback_tbshops`.`storeattributes` AS `Storeattribute` ON (`CategoryFilter`.`storeattribute_id` = `Storeattribute`.`id`) WHERE `category_id` IN (0, 83) | 1 | 1 | 0 | |
SELECT `Storetranslation`.`id`, `Storetranslation`.`translation_model`, `Storetranslation`.`translation_id`, `Storetranslation`.`locale`, `Storetranslation`.`value` FROM `tbiback_tbshops`.`storetranslations` AS `Storetranslation` WHERE `Storetranslation`.`translation_id` = 8 AND `locale` = 'fra' | 1 | 1 | 0 | |
SELECT `StoreattributeOption`.`id`, `StoreattributeOption`.`locale`, `StoreattributeOption`.`value`, `StoreattributeOption`.`standard`, `StoreattributeOption`.`group`, `StoreattributeOption`.`storeattribute_id` FROM `tbiback_tbshops`.`storeattribute_options` AS `StoreattributeOption` WHERE `locale` = 'fra' AND `StoreattributeOption`.`storeattribute_id` = (8) ORDER BY `id` asc | 0 | 0 | 0 | |
SELECT 'Productgroup' as model, Productgroup.id, promoprice, created, I18n__name__fra.content as name FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' UNION SELECT 'Bundle' as model, Bundle.id, promoprice, created, I18n__name__fra.content as name FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name desc LIMIT 0, 24 | 2 | 2 | 11 | maybe slow |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__fra`.`content`) AS `Productgroup__i18n_name_fra`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__fra`.`content`) AS `Productgroup__i18n_slug_fra`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__fra` ON (`Productgroup`.`id` = `I18n__name__fra`.`foreign_key` AND `I18n__name__fra`.`model` = 'Productgroup' AND `I18n__name__fra`.`field` = 'name' AND `I18n__name__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Productgroup`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Productgroup' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__fra` ON (`Productgroup`.`id` = `I18n__slug__fra`.`foreign_key` AND `I18n__slug__fra`.`model` = 'Productgroup' AND `I18n__slug__fra`.`field` = 'slug' AND `I18n__slug__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Productgroup`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Productgroup' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `Productgroup`.`id` = 377 LIMIT 1 | 1 | 1 | 7 | maybe slow |
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (377) ORDER BY `sorting` ASC | 2 | 2 | 2 | |
SELECT `Description`.`id`, (`I18n__description_short__fra`.`content`) AS `Description__i18n_description_short_fra`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__fra` ON (`Description`.`id` = `I18n__description_short__fra`.`foreign_key` AND `I18n__description_short__fra`.`model` = 'Description' AND `I18n__description_short__fra`.`field` = 'description_short' AND `I18n__description_short__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 530 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__fra`.`content`) AS `Productgroup__i18n_name_fra`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__fra`.`content`) AS `Productgroup__i18n_slug_fra`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__fra` ON (`Productgroup`.`id` = `I18n__name__fra`.`foreign_key` AND `I18n__name__fra`.`model` = 'Productgroup' AND `I18n__name__fra`.`field` = 'name' AND `I18n__name__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Productgroup`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Productgroup' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__fra` ON (`Productgroup`.`id` = `I18n__slug__fra`.`foreign_key` AND `I18n__slug__fra`.`model` = 'Productgroup' AND `I18n__slug__fra`.`field` = 'slug' AND `I18n__slug__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Productgroup`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Productgroup' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `Productgroup`.`id` = 440 LIMIT 1 | 1 | 1 | 7 | maybe slow |
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (440) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__fra`.`content`) AS `Description__i18n_description_short_fra`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__fra` ON (`Description`.`id` = `I18n__description_short__fra`.`foreign_key` AND `I18n__description_short__fra`.`model` = 'Description' AND `I18n__description_short__fra`.`field` = 'description_short' AND `I18n__description_short__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 604 LIMIT 1 | 1 | 1 | 1 | |
SELECT count(*) as count FROM (SELECT 'Productgroup' as model, Productgroup.id, promoprice, created, I18n__name__fra.content as name FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' UNION SELECT 'Bundle' as model, Bundle.id, promoprice, created, I18n__name__fra.content as name FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name desc ) as groups | 1 | 1 | 11 | maybe slow |
SELECT MAX(maxprice) as maxprice, MIN(minprice) as minprice FROM (SELECT MAX(promoprice) as maxprice, MIN(promoprice) as minprice FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__fra ON (Productgroup.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Productgroup' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' AND Description.group_model = 'Productgroup' AND hidden = '' UNION SELECT MAX(promoprice) as maxprice, MIN(promoprice) as minprice FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__fra ON (Bundle.id = I18n__name__fra.foreign_key AND I18n__name__fra.model = 'Bundle' AND I18n__name__fra.field = 'name' AND I18n__name__fra.locale = 'fra') WHERE CategoryGroup.category_id IN(83) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '') as prices | 1 | 1 | 10 | maybe slow |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-30' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-30' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__fra`.`content`) AS `Store__i18n_homepagetitle_fra`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__fra`.`content`) AS `Store__i18n_homepagedescription_fra`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__fra`.`content`) AS `Store__i18n_homepage_footer_fra`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__fra`.`content`) AS `Store__i18n_homepage_content_fra`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__fra`.`content`) AS `Store__i18n_header_points_fra`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__fra`.`content`) AS `Store__i18n_footer_blocks_fra`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__fra`.`content`) AS `Store__i18n_sidebar_content_fra`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__fra`.`content`) AS `Store__i18n_disable_checkout_msg_fra`, (`I18n__disable_checkout_msg__nld`.`content`) AS `Store__i18n_disable_checkout_msg_nld` FROM `tbiback_tbshops`.`stores` AS `Store` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__fra` ON (`Store`.`id` = `I18n__homepagetitle__fra`.`foreign_key` AND `I18n__homepagetitle__fra`.`model` = 'Store' AND `I18n__homepagetitle__fra`.`field` = 'homepagetitle' AND `I18n__homepagetitle__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__nld` ON (`Store`.`id` = `I18n__homepagetitle__nld`.`foreign_key` AND `I18n__homepagetitle__nld`.`model` = 'Store' AND `I18n__homepagetitle__nld`.`field` = 'homepagetitle' AND `I18n__homepagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__fra` ON (`Store`.`id` = `I18n__homepagedescription__fra`.`foreign_key` AND `I18n__homepagedescription__fra`.`model` = 'Store' AND `I18n__homepagedescription__fra`.`field` = 'homepagedescription' AND `I18n__homepagedescription__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__nld` ON (`Store`.`id` = `I18n__homepagedescription__nld`.`foreign_key` AND `I18n__homepagedescription__nld`.`model` = 'Store' AND `I18n__homepagedescription__nld`.`field` = 'homepagedescription' AND `I18n__homepagedescription__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__fra` ON (`Store`.`id` = `I18n__homepage_footer__fra`.`foreign_key` AND `I18n__homepage_footer__fra`.`model` = 'Store' AND `I18n__homepage_footer__fra`.`field` = 'homepage_footer' AND `I18n__homepage_footer__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__nld` ON (`Store`.`id` = `I18n__homepage_footer__nld`.`foreign_key` AND `I18n__homepage_footer__nld`.`model` = 'Store' AND `I18n__homepage_footer__nld`.`field` = 'homepage_footer' AND `I18n__homepage_footer__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__fra` ON (`Store`.`id` = `I18n__homepage_content__fra`.`foreign_key` AND `I18n__homepage_content__fra`.`model` = 'Store' AND `I18n__homepage_content__fra`.`field` = 'homepage_content' AND `I18n__homepage_content__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__nld` ON (`Store`.`id` = `I18n__homepage_content__nld`.`foreign_key` AND `I18n__homepage_content__nld`.`model` = 'Store' AND `I18n__homepage_content__nld`.`field` = 'homepage_content' AND `I18n__homepage_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__fra` ON (`Store`.`id` = `I18n__header_points__fra`.`foreign_key` AND `I18n__header_points__fra`.`model` = 'Store' AND `I18n__header_points__fra`.`field` = 'header_points' AND `I18n__header_points__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__nld` ON (`Store`.`id` = `I18n__header_points__nld`.`foreign_key` AND `I18n__header_points__nld`.`model` = 'Store' AND `I18n__header_points__nld`.`field` = 'header_points' AND `I18n__header_points__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__fra` ON (`Store`.`id` = `I18n__footer_blocks__fra`.`foreign_key` AND `I18n__footer_blocks__fra`.`model` = 'Store' AND `I18n__footer_blocks__fra`.`field` = 'footer_blocks' AND `I18n__footer_blocks__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__nld` ON (`Store`.`id` = `I18n__footer_blocks__nld`.`foreign_key` AND `I18n__footer_blocks__nld`.`model` = 'Store' AND `I18n__footer_blocks__nld`.`field` = 'footer_blocks' AND `I18n__footer_blocks__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__fra` ON (`Store`.`id` = `I18n__sidebar_content__fra`.`foreign_key` AND `I18n__sidebar_content__fra`.`model` = 'Store' AND `I18n__sidebar_content__fra`.`field` = 'sidebar_content' AND `I18n__sidebar_content__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__nld` ON (`Store`.`id` = `I18n__sidebar_content__nld`.`foreign_key` AND `I18n__sidebar_content__nld`.`model` = 'Store' AND `I18n__sidebar_content__nld`.`field` = 'sidebar_content' AND `I18n__sidebar_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__fra` ON (`Store`.`id` = `I18n__disable_checkout_msg__fra`.`foreign_key` AND `I18n__disable_checkout_msg__fra`.`model` = 'Store' AND `I18n__disable_checkout_msg__fra`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__nld` ON (`Store`.`id` = `I18n__disable_checkout_msg__nld`.`foreign_key` AND `I18n__disable_checkout_msg__nld`.`model` = 'Store' AND `I18n__disable_checkout_msg__nld`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__nld`.`locale` = 'nld') WHERE `url` = 'pokerhandel.be' LIMIT 1 | 1 | 1 | 0 | |
SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (10) | 16 | 16 | 0 | |
SELECT `ShippingmethodsStore`.`id`, `ShippingmethodsStore`.`shippingmethod_id`, `ShippingmethodsStore`.`store_id`, `Shippingmethod`.`id`, `Shippingmethod`.`code`, `Shippingmethod`.`sorting`, `Shippingmethod`.`countries`, `Shippingmethod`.`store_id`, `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores` FROM `tbiback_tbshops`.`shippingmethods_stores` AS `ShippingmethodsStore` LEFT JOIN `tbiback_tbshops`.`shippingmethods` AS `Shippingmethod` ON (`ShippingmethodsStore`.`shippingmethod_id` = `Shippingmethod`.`id`) LEFT JOIN `tbiback_tbshops`.`stores` AS `Store` ON (`ShippingmethodsStore`.`store_id` = `Store`.`id`) WHERE `Store`.`id` = 10 AND `Shippingmethod`.`code` = 'shipment' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingRate`.`id`, `ShippingRate`.`shippingmethod_id`, `ShippingRate`.`country`, `ShippingRate`.`floor`, `ShippingRate`.`ceiling`, `ShippingRate`.`criteria`, `ShippingRate`.`price` FROM `tbiback_tbshops`.`shipping_rates` AS `ShippingRate` WHERE `ShippingRate`.`shippingmethod_id` = (8) | 41 | 41 | 0 | |
SELECT `Message`.`id`, `Message`.`type`, `Message`.`start`, `Message`.`end`, `Message`.`store_id`, `Message`.`from_override`, (`I18n__message__fra`.`content`) AS `Message__i18n_message_fra`, (`I18n__message__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__fra` ON (`Message`.`id` = `I18n__message__fra`.`foreign_key` AND `I18n__message__fra`.`model` = 'Message' AND `I18n__message__fra`.`field` = 'message' AND `I18n__message__fra`.`locale` = 'fra') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__nld` ON (`Message`.`id` = `I18n__message__nld`.`foreign_key` AND `I18n__message__nld`.`model` = 'Message' AND `I18n__message__nld`.`field` = 'message' AND `I18n__message__nld`.`locale` = 'nld') WHERE `type` = 'popover' AND `start` <= '2024-03-29' AND `end` >= '2024-03-29' AND `store_id` IN (0, 10) LIMIT 1 | 0 | 0 | 0 | |
SELECT `UrlRedirect`.`id`, `UrlRedirect`.`old_url`, `UrlRedirect`.`new_url`, `UrlRedirect`.`redirect_type`, `UrlRedirect`.`store_id` FROM `tbiback_tbshops`.`url_redirects` AS `UrlRedirect` WHERE `old_url` = 'http://pokerhandel.be/fra/category/83/jeux-de-cartes/cartes-tarot/limit:24/page:1/direction:desc' AND `store_id` = 10 LIMIT 1 | 0 | 0 | 0 | |
SELECT `Cart`.`id`, `Cart`.`display`, `Cart`.`group_id`, `Cart`.`group_model`, `Cart`.`session_id`, `Cart`.`qty`, `Cart`.`price`, `Cart`.`price_excl_vat`, `Cart`.`price_vat`, `Cart`.`price_incl_vat`, `Cart`.`vat`, `Cart`.`created`, `Cart`.`loaded`, `Cart`.`store_id`, `Cart`.`default`, `Cart`.`defaultqty`, `Cart`.`order_type`, `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed`, `Bundle`.`id`, `Bundle`.`SKU`, `Bundle`.`brand_id`, `Bundle`.`price`, `Bundle`.`promoprice`, `Bundle`.`purchaseprice`, `Bundle`.`wholesaleprice`, `Bundle`.`qtychange_price`, `Bundle`.`hidden`, `Bundle`.`available`, `Bundle`.`created` FROM `tbiback_tbshops`.`carts` AS `Cart` LEFT JOIN `tbiback_tbshops`.`productgroups` AS `Productgroup` ON (`Cart`.`group_id` = `Productgroup`.`id` AND `Cart`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`bundles` AS `Bundle` ON (`Cart`.`group_id` = `Bundle`.`id` AND `Cart`.`group_model` = 'Bundle') WHERE `session_id` = 'c1o9hvshaqoihkgjdqpktt8jl3' AND `qty` > 0 | 0 | 0 | 0 | |
SELECT `Category`.`id`, (`I18n__path`.`content`) AS `Category__i18n_path` FROM `tbiback_tbshops`.`categories` AS `Category` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__path` ON (`Category`.`id` = `I18n__path`.`foreign_key` AND `I18n__path`.`model` = 'Category' AND `I18n__path`.`field` = 'path' AND `I18n__path`.`locale` = 'nld') WHERE `Category`.`id` = 83 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Category`.`id`, (`I18n__path`.`content`) AS `Category__i18n_path` FROM `tbiback_tbshops`.`categories` AS `Category` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__path` ON (`Category`.`id` = `I18n__path`.`foreign_key` AND `I18n__path`.`model` = 'Category' AND `I18n__path`.`field` = 'path' AND `I18n__path`.`locale` = 'eng') WHERE `Category`.`id` = 83 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 1 |
Peak Memory Use 11.98 MB
Message | Memory use |
---|---|
Component initialization | 3.12 MB |
Controller action start | 4.99 MB |
Component initialization #2 | 6.15 MB |
Controller action start #2 | 6.55 MB |
Controller render start | 6.58 MB |
View render complete | 7.45 MB |
Total Request Time: 358 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 46.29 | |
Event: Controller.initialize | 46.60 | |
Event: Controller.startup | 1.54 | |
Controller action | 133.81 | |
» Event: Controller.initialize #2 | 19.45 | |
» Event: Controller.startup #2 | 0.31 | |
Controller action #2 | 0.00 | |
» Event: Controller.beforeRender | 17.42 | |
» » Processing toolbar data | 16.94 | |
» Rendering View | 54.48 | |
» » Event: View.beforeRender | 0.05 | |
» » Rendering CORE/Cake/View/Errors/pdo_error.ctp | 9.91 | |
» » » Rendering CORE/Cake/View/Elements/exception_stack_trace.ctp | 8.56 | |
» » Event: View.afterRender | 0.04 | |
» » Event: View.beforeLayout | 0.04 | |
» » Rendering APP/View/Layouts/default.ctp | 21.58 | |
» » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp | 0.19 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp | 9.30 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp | 1.47 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp | 2.44 | |
» » » Rendering APP/View/Elements/layout/top-notice.ctp | 0.23 | |
» » » Rendering APP/View/Elements/layout/content.ctp | 0.67 | |
» » » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp | 0.24 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp | 0.52 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 | 1.93 | |
» » » » Rendering APP/View/Elements/layout/footer-hours.ctp | 0.37 | |
» » » » Rendering APP/View/Elements/layout/footer-contact.ctp | 0.20 | |
Event: View.afterLayout | 0.00 |