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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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(160,55) 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();
'55' 'jetons-de-poker' 'budget-jetons'
'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 => '55', (int) 1 => 'jetons-de-poker', (int) 2 => 'budget-jetons' )
$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/55/jetons-de-poker/budget-jetons' base => '' webroot => '/' here => '/fra/category/55/jetons-de-poker/budget-jetons' [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/55/jetons-de-poker/budget-jetons' base => '' webroot => '/' here => '/fra/category/55/jetons-de-poker/budget-jetons' [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/55/jetons-de-poker/budget-jetons' base => '' webroot => '/' here => '/fra/category/55/jetons-de-poker/budget-jetons' [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] ) }
Currently our store in Kontich is closed. Of course you can still place orders online, your package will be shipped ASAP!
We will be back open 19 mars at 10: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-19' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 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-19' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 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-19' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 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-19' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 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-19' AND `end` >= '2024-03-19' 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/55/jetons-de-poker/budget-jetons' 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` = '321j940205hqpkipsd3nie5m52' 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` = 55 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` = (55) | 1 | 1 | 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` = 40 AND `ParentCategory`.`store_id` = 10 LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `ChildCategory`.`id`, (`I18n__name__fra`.`content`) AS `ChildCategory__i18n_name_fra`, (`I18n__name__nld`.`content`) AS `ChildCategory__i18n_name_nld`, (`I18n__slug__fra`.`content`) AS `ChildCategory__i18n_slug_fra`, (`I18n__slug__nld`.`content`) AS `ChildCategory__i18n_slug_nld`, (`I18n__description__fra`.`content`) AS `ChildCategory__i18n_description_fra`, (`I18n__description__nld`.`content`) AS `ChildCategory__i18n_description_nld`, (`I18n__description_short__fra`.`content`) AS `ChildCategory__i18n_description_short_fra`, (`I18n__description_short__nld`.`content`) AS `ChildCategory__i18n_description_short_nld`, (`I18n__path__fra`.`content`) AS `ChildCategory__i18n_path_fra`, (`I18n__path__nld`.`content`) AS `ChildCategory__i18n_path_nld`, (`I18n__pagetitle__fra`.`content`) AS `ChildCategory__i18n_pagetitle_fra`, (`I18n__pagetitle__nld`.`content`) AS `ChildCategory__i18n_pagetitle_nld` FROM `tbiback_tbshops`.`categories` AS `ChildCategory` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__fra` ON (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 (`ChildCategory`.`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 `ChildCategory`.`id` = 160 AND `ChildCategory`.`store_id` = 10 LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 55 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 40 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` = 40 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, 55) | 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(160,55) 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(160,55) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc LIMIT 0, 24 | 24 | 24 | 17 | 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` = 641 LIMIT 1 | 1 | 1 | 15 | 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` = (641) ORDER BY `sorting` ASC | 0 | 0 | 3 | 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` = 864 LIMIT 1 | 1 | 1 | 2 | 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` = 643 LIMIT 1 | 1 | 1 | 12 | 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` = (643) ORDER BY `sorting` ASC | 1 | 1 | 3 | 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` = 866 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` = 644 LIMIT 1 | 1 | 1 | 8 | 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` = (644) 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` = 867 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` = 645 LIMIT 1 | 1 | 1 | 8 | 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` = (645) 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` = 868 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` = 646 LIMIT 1 | 1 | 1 | 8 | 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` = (646) 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` = 869 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` = 647 LIMIT 1 | 1 | 1 | 8 | 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` = (647) 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` = 870 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` = 648 LIMIT 1 | 1 | 1 | 8 | 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` = (648) ORDER BY `sorting` ASC | 0 | 0 | 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` = 871 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` = 649 LIMIT 1 | 1 | 1 | 8 | 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` = (649) ORDER BY `sorting` ASC | 0 | 0 | 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` = 872 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` = 650 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` = (650) ORDER BY `sorting` ASC | 0 | 0 | 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` = 873 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` = 651 LIMIT 1 | 1 | 1 | 9 | 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` = (651) 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` = 874 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` = 317 LIMIT 1 | 1 | 1 | 8 | 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` = (317) 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` = 455 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` = 322 LIMIT 1 | 1 | 1 | 9 | 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` = (322) 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` = 460 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` = 324 LIMIT 1 | 1 | 1 | 9 | 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` = (324) 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` = 462 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` = 318 LIMIT 1 | 1 | 1 | 9 | 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` = (318) 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` = 456 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` = 320 LIMIT 1 | 1 | 1 | 8 | 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` = (320) 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` = 458 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` = 326 LIMIT 1 | 1 | 1 | 9 | 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` = (326) 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` = 464 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` = 319 LIMIT 1 | 1 | 1 | 10 | 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` = (319) 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` = 457 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` = 321 LIMIT 1 | 1 | 1 | 12 | 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` = (321) ORDER BY `sorting` ASC | 1 | 1 | 3 | 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` = 459 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` = 323 LIMIT 1 | 1 | 1 | 9 | 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` = (323) 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` = 461 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` = 325 LIMIT 1 | 1 | 1 | 10 | 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` = (325) 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` = 463 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` = 341 LIMIT 1 | 1 | 1 | 14 | 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` = (341) ORDER BY `sorting` ASC | 1 | 1 | 3 | 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` = 479 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` = 343 LIMIT 1 | 1 | 1 | 9 | 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` = (343) 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` = 481 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` = 345 LIMIT 1 | 1 | 1 | 9 | 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` = (345) 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` = 483 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` = 347 LIMIT 1 | 1 | 1 | 10 | 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` = (347) 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` = 485 LIMIT 1 | 1 | 1 | 2 | maybe slow |
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(160,55) 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(160,55) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc ) as groups | 1 | 1 | 18 | 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(160,55) 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(160,55) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '') as prices | 1 | 1 | 16 | 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-19' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 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-19' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 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-19' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 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-19' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 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-19' AND `end` >= '2024-03-19' 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/55/jetons-de-poker/budget-jetons' 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` = '321j940205hqpkipsd3nie5m52' 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` = 55 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` = 55 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 1 |
Peak Memory Use 12.33 MB
Message | Memory use |
---|---|
Component initialization | 3.11 MB |
Controller action start | 4.99 MB |
Component initialization #2 | 6.34 MB |
Controller action start #2 | 6.74 MB |
Controller render start | 6.77 MB |
View render complete | 7.63 MB |
Total Request Time: 824 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 58.04 | |
Event: Controller.initialize | 52.00 | |
Event: Controller.startup | 1.66 | |
Controller action | 535.22 | |
» Event: Controller.initialize #2 | 18.35 | |
» Event: Controller.startup #2 | 0.39 | |
Controller action #2 | 0.00 | |
» Event: Controller.beforeRender | 11.57 | |
» » Processing toolbar data | 11.12 | |
» Rendering View | 55.03 | |
» » Event: View.beforeRender | 0.07 | |
» » Rendering CORE/Cake/View/Errors/pdo_error.ctp | 10.05 | |
» » » Rendering CORE/Cake/View/Elements/exception_stack_trace.ctp | 8.72 | |
» » Event: View.afterRender | 0.06 | |
» » Event: View.beforeLayout | 0.07 | |
» » Rendering APP/View/Layouts/default.ctp | 19.67 | |
» » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp | 0.25 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp | 7.28 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp | 1.39 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp | 2.47 | |
» » » Rendering APP/View/Elements/layout/top-notice.ctp | 0.20 | |
» » » Rendering APP/View/Elements/layout/content.ctp | 0.74 | |
» » » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp | 0.26 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp | 0.49 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 | 2.01 | |
» » » » Rendering APP/View/Elements/layout/footer-hours.ctp | 0.45 | |
» » » » Rendering APP/View/Elements/layout/footer-contact.ctp | 0.18 | |
Event: View.afterLayout | 0.00 |