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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(64) 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();
'64' 'poker-cards' 'regular-playing-cards'
'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 => '64', (int) 1 => 'poker-cards', (int) 2 => 'regular-playing-cards' )
$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 => 'eng/category/64/poker-cards/regular-playing-cards' base => '' webroot => '/' here => '/eng/category/64/poker-cards/regular-playing-cards' [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 => 'eng/category/64/poker-cards/regular-playing-cards' base => '' webroot => '/' here => '/eng/category/64/poker-cards/regular-playing-cards' [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 => 'eng/category/64/poker-cards/regular-playing-cards' base => '' webroot => '/' here => '/eng/category/64/poker-cards/regular-playing-cards' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array( [maximum depth reached] ) }
Our store in Kontich is currently open until 18:00.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__nld`.`content`) AS `Store__i18n_disable_checkout_msg_nld` FROM `tbiback_tbshops`.`stores` AS `Store` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__nld` ON (`Store`.`id` = `I18n__homepagetitle__nld`.`foreign_key` AND `I18n__homepagetitle__nld`.`model` = 'Store' AND `I18n__homepagetitle__nld`.`field` = 'homepagetitle' AND `I18n__homepagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__nld` ON (`Store`.`id` = `I18n__homepagedescription__nld`.`foreign_key` AND `I18n__homepagedescription__nld`.`model` = 'Store' AND `I18n__homepagedescription__nld`.`field` = 'homepagedescription' AND `I18n__homepagedescription__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__nld` ON (`Store`.`id` = `I18n__homepage_footer__nld`.`foreign_key` AND `I18n__homepage_footer__nld`.`model` = 'Store' AND `I18n__homepage_footer__nld`.`field` = 'homepage_footer' AND `I18n__homepage_footer__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__nld` ON (`Store`.`id` = `I18n__homepage_content__nld`.`foreign_key` AND `I18n__homepage_content__nld`.`model` = 'Store' AND `I18n__homepage_content__nld`.`field` = 'homepage_content' AND `I18n__homepage_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__nld` ON (`Store`.`id` = `I18n__header_points__nld`.`foreign_key` AND `I18n__header_points__nld`.`model` = 'Store' AND `I18n__header_points__nld`.`field` = 'header_points' AND `I18n__header_points__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__nld` ON (`Store`.`id` = `I18n__footer_blocks__nld`.`foreign_key` AND `I18n__footer_blocks__nld`.`model` = 'Store' AND `I18n__footer_blocks__nld`.`field` = 'footer_blocks' AND `I18n__footer_blocks__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__nld` ON (`Store`.`id` = `I18n__sidebar_content__nld`.`foreign_key` AND `I18n__sidebar_content__nld`.`model` = 'Store' AND `I18n__sidebar_content__nld`.`field` = 'sidebar_content' AND `I18n__sidebar_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__nld` ON (`Store`.`id` = `I18n__disable_checkout_msg__nld`.`foreign_key` AND `I18n__disable_checkout_msg__nld`.`model` = 'Store' AND `I18n__disable_checkout_msg__nld`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__nld`.`locale` = 'nld') WHERE `url` = 'pokerhandel.be' LIMIT 1 | 1 | 1 | 0 | |
SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (10) | 16 | 16 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-30' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-30' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__eng`.`content`) AS `Store__i18n_homepagetitle_eng`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__eng`.`content`) AS `Store__i18n_homepagedescription_eng`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__eng`.`content`) AS `Store__i18n_homepage_footer_eng`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__eng`.`content`) AS `Store__i18n_homepage_content_eng`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__eng`.`content`) AS `Store__i18n_header_points_eng`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__eng`.`content`) AS `Store__i18n_footer_blocks_eng`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__eng`.`content`) AS `Store__i18n_sidebar_content_eng`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__eng`.`content`) AS `Store__i18n_disable_checkout_msg_eng`, (`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__eng` ON (`Store`.`id` = `I18n__homepagetitle__eng`.`foreign_key` AND `I18n__homepagetitle__eng`.`model` = 'Store' AND `I18n__homepagetitle__eng`.`field` = 'homepagetitle' AND `I18n__homepagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepagedescription__eng`.`foreign_key` AND `I18n__homepagedescription__eng`.`model` = 'Store' AND `I18n__homepagedescription__eng`.`field` = 'homepagedescription' AND `I18n__homepagedescription__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepage_footer__eng`.`foreign_key` AND `I18n__homepage_footer__eng`.`model` = 'Store' AND `I18n__homepage_footer__eng`.`field` = 'homepage_footer' AND `I18n__homepage_footer__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepage_content__eng`.`foreign_key` AND `I18n__homepage_content__eng`.`model` = 'Store' AND `I18n__homepage_content__eng`.`field` = 'homepage_content' AND `I18n__homepage_content__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__header_points__eng`.`foreign_key` AND `I18n__header_points__eng`.`model` = 'Store' AND `I18n__header_points__eng`.`field` = 'header_points' AND `I18n__header_points__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__footer_blocks__eng`.`foreign_key` AND `I18n__footer_blocks__eng`.`model` = 'Store' AND `I18n__footer_blocks__eng`.`field` = 'footer_blocks' AND `I18n__footer_blocks__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__sidebar_content__eng`.`foreign_key` AND `I18n__sidebar_content__eng`.`model` = 'Store' AND `I18n__sidebar_content__eng`.`field` = 'sidebar_content' AND `I18n__sidebar_content__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__disable_checkout_msg__eng`.`foreign_key` AND `I18n__disable_checkout_msg__eng`.`model` = 'Store' AND `I18n__disable_checkout_msg__eng`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__eng`.`locale` = 'eng') 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 | 7 | maybe slow |
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__eng`.`content`) AS `Message__i18n_message_eng`, (`I18n__message__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__eng` ON (`Message`.`id` = `I18n__message__eng`.`foreign_key` AND `I18n__message__eng`.`model` = 'Message' AND `I18n__message__eng`.`field` = 'message' AND `I18n__message__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__nld` ON (`Message`.`id` = `I18n__message__nld`.`foreign_key` AND `I18n__message__nld`.`model` = 'Message' AND `I18n__message__nld`.`field` = 'message' AND `I18n__message__nld`.`locale` = 'nld') WHERE `type` = 'popover' AND `start` <= '2024-03-29' AND `end` >= '2024-03-29' AND `store_id` IN (0, 10) LIMIT 1 | 0 | 0 | 1 | maybe slow |
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` = 'https://pokerhandel.be/eng/category/64/poker-cards/regular-playing-cards' 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` = 'rbfl9t72gb5h7277qoqqfq1686' AND `qty` > 0 | 0 | 0 | 1 | maybe slow |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`sorting`, `Category`.`topmenu`, `Category`.`store_id`, (`I18n__name__eng`.`content`) AS `Category__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Category__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Category__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld`, (`I18n__description__eng`.`content`) AS `Category__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Category__i18n_description_nld`, (`I18n__description_short__eng`.`content`) AS `Category__i18n_description_short_eng`, (`I18n__description_short__nld`.`content`) AS `Category__i18n_description_short_nld`, (`I18n__path__eng`.`content`) AS `Category__i18n_path_eng`, (`I18n__path__nld`.`content`) AS `Category__i18n_path_nld`, (`I18n__pagetitle__eng`.`content`) AS `Category__i18n_pagetitle_eng`, (`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__eng` ON (`Category`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Category' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Category' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Category' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Category' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__path__eng`.`foreign_key` AND `I18n__path__eng`.`model` = 'Category' AND `I18n__path__eng`.`field` = 'path' AND `I18n__path__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Category' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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` = 64 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 5 | 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` = (64) | 0 | 0 | 0 | |
SELECT `ParentCategory`.`id`, (`I18n__name__eng`.`content`) AS `ParentCategory__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `ParentCategory__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `ParentCategory__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `ParentCategory__i18n_slug_nld`, (`I18n__description__eng`.`content`) AS `ParentCategory__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `ParentCategory__i18n_description_nld`, (`I18n__description_short__eng`.`content`) AS `ParentCategory__i18n_description_short_eng`, (`I18n__description_short__nld`.`content`) AS `ParentCategory__i18n_description_short_nld`, (`I18n__path__eng`.`content`) AS `ParentCategory__i18n_path_eng`, (`I18n__path__nld`.`content`) AS `ParentCategory__i18n_path_nld`, (`I18n__pagetitle__eng`.`content`) AS `ParentCategory__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `ParentCategory__i18n_pagetitle_nld` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`ParentCategory`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Category' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Category' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Category' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Category' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__path__eng`.`foreign_key` AND `I18n__path__eng`.`model` = 'Category' AND `I18n__path__eng`.`field` = 'path' AND `I18n__path__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Category' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`ParentCategory`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') WHERE `ParentCategory`.`id` = 42 AND `ParentCategory`.`store_id` = 10 LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 64 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 42 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, (`I18n__slug__eng`.`content`) AS `Category__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__eng` ON (`Category`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Category' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') WHERE `Category`.`id` = 42 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 1 | |
SELECT `CategoryFilter`.`id`, `CategoryFilter`.`category_id`, `CategoryFilter`.`storeattribute_id`, `CategoryFilter`.`active`, `Storeattribute`.`id`, `Storeattribute`.`type`, `Storeattribute`.`created` FROM `tbiback_tbshops`.`category_filters` AS `CategoryFilter` LEFT JOIN `tbiback_tbshops`.`storeattributes` AS `Storeattribute` ON (`CategoryFilter`.`storeattribute_id` = `Storeattribute`.`id`) WHERE `category_id` IN (0, 64) | 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` = 'eng' | 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` = 'eng' AND `StoreattributeOption`.`storeattribute_id` = (8) ORDER BY `id` asc | 0 | 0 | 0 | |
SELECT 'Productgroup' as model, Productgroup.id, promoprice, created, I18n__name__eng.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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(64) 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__eng.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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(64) 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 | 19 | maybe slow |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 212 LIMIT 1 | 1 | 1 | 13 | 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` = (212) ORDER BY `sorting` ASC | 2 | 2 | 3 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 350 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 213 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` = (213) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 351 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 215 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` = (215) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 353 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 217 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` = (217) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 355 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 219 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` = (219) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 357 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 220 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` = (220) ORDER BY `sorting` ASC | 3 | 3 | 3 | |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 358 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 223 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` = (223) ORDER BY `sorting` ASC | 3 | 3 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 361 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 264 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` = (264) ORDER BY `sorting` ASC | 3 | 3 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 402 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 268 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` = (268) ORDER BY `sorting` ASC | 4 | 4 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 406 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 270 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` = (270) ORDER BY `sorting` ASC | 2 | 2 | 2 | |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 408 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 272 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` = (272) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 410 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 273 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` = (273) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 411 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 274 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` = (274) ORDER BY `sorting` ASC | 2 | 2 | 2 | |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 412 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 278 LIMIT 1 | 1 | 1 | 11 | 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` = (278) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 416 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 365 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` = (365) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 508 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 378 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` = (378) ORDER BY `sorting` ASC | 0 | 0 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 531 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 425 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` = (425) ORDER BY `sorting` ASC | 3 | 3 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 581 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 243 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` = (243) ORDER BY `sorting` ASC | 8 | 8 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 381 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Bundle`.`id`, `Bundle`.`promoprice`, `Bundle`.`wholesaleprice`, `Bundle`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Bundle__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Bundle__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Bundle__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Bundle__i18n_slug_nld` FROM `tbiback_tbshops`.`bundles` AS `Bundle` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Bundle`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Bundle' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Bundle`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Bundle' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__eng` ON (`Bundle`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Bundle' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Bundle`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Bundle' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Bundle`.`id` AND `CategoryGroup`.`group_model` = 'Bundle') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Bundle`.`id` AND `Description`.`group_model` = 'Bundle') WHERE `Bundle`.`id` = 35 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` = 'Bundle' AND `Image`.`group_id` = (35) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 613 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 424 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` = (424) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 580 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 376 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` = (376) ORDER BY `sorting` ASC | 2 | 2 | 3 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 529 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 261 LIMIT 1 | 1 | 1 | 11 | 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` = (261) ORDER BY `sorting` ASC | 2 | 2 | 3 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 399 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 427 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` = (427) ORDER BY `sorting` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 583 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 232 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` = (232) ORDER BY `sorting` ASC | 3 | 3 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 370 LIMIT 1 | 1 | 1 | 1 | |
SELECT count(*) as count FROM (SELECT 'Productgroup' as model, Productgroup.id, promoprice, created, I18n__name__eng.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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(64) 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__eng.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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(64) 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 | 20 | 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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(64) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(64) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '') as prices | 1 | 1 | 17 | maybe slow |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-29' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-30' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-30' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__eng`.`content`) AS `Store__i18n_homepagetitle_eng`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__eng`.`content`) AS `Store__i18n_homepagedescription_eng`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__eng`.`content`) AS `Store__i18n_homepage_footer_eng`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__eng`.`content`) AS `Store__i18n_homepage_content_eng`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__eng`.`content`) AS `Store__i18n_header_points_eng`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__eng`.`content`) AS `Store__i18n_footer_blocks_eng`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__eng`.`content`) AS `Store__i18n_sidebar_content_eng`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__eng`.`content`) AS `Store__i18n_disable_checkout_msg_eng`, (`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__eng` ON (`Store`.`id` = `I18n__homepagetitle__eng`.`foreign_key` AND `I18n__homepagetitle__eng`.`model` = 'Store' AND `I18n__homepagetitle__eng`.`field` = 'homepagetitle' AND `I18n__homepagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepagedescription__eng`.`foreign_key` AND `I18n__homepagedescription__eng`.`model` = 'Store' AND `I18n__homepagedescription__eng`.`field` = 'homepagedescription' AND `I18n__homepagedescription__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepage_footer__eng`.`foreign_key` AND `I18n__homepage_footer__eng`.`model` = 'Store' AND `I18n__homepage_footer__eng`.`field` = 'homepage_footer' AND `I18n__homepage_footer__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepage_content__eng`.`foreign_key` AND `I18n__homepage_content__eng`.`model` = 'Store' AND `I18n__homepage_content__eng`.`field` = 'homepage_content' AND `I18n__homepage_content__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__header_points__eng`.`foreign_key` AND `I18n__header_points__eng`.`model` = 'Store' AND `I18n__header_points__eng`.`field` = 'header_points' AND `I18n__header_points__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__footer_blocks__eng`.`foreign_key` AND `I18n__footer_blocks__eng`.`model` = 'Store' AND `I18n__footer_blocks__eng`.`field` = 'footer_blocks' AND `I18n__footer_blocks__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__sidebar_content__eng`.`foreign_key` AND `I18n__sidebar_content__eng`.`model` = 'Store' AND `I18n__sidebar_content__eng`.`field` = 'sidebar_content' AND `I18n__sidebar_content__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__disable_checkout_msg__eng`.`foreign_key` AND `I18n__disable_checkout_msg__eng`.`model` = 'Store' AND `I18n__disable_checkout_msg__eng`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__eng`.`locale` = 'eng') 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__eng`.`content`) AS `Message__i18n_message_eng`, (`I18n__message__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__eng` ON (`Message`.`id` = `I18n__message__eng`.`foreign_key` AND `I18n__message__eng`.`model` = 'Message' AND `I18n__message__eng`.`field` = 'message' AND `I18n__message__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__nld` ON (`Message`.`id` = `I18n__message__nld`.`foreign_key` AND `I18n__message__nld`.`model` = 'Message' AND `I18n__message__nld`.`field` = 'message' AND `I18n__message__nld`.`locale` = 'nld') WHERE `type` = 'popover' AND `start` <= '2024-03-29' AND `end` >= '2024-03-29' AND `store_id` IN (0, 10) LIMIT 1 | 0 | 0 | 0 | |
SELECT `UrlRedirect`.`id`, `UrlRedirect`.`old_url`, `UrlRedirect`.`new_url`, `UrlRedirect`.`redirect_type`, `UrlRedirect`.`store_id` FROM `tbiback_tbshops`.`url_redirects` AS `UrlRedirect` WHERE `old_url` = 'https://pokerhandel.be/eng/category/64/poker-cards/regular-playing-cards' 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` = 'rbfl9t72gb5h7277qoqqfq1686' 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` = 64 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` = 'fra') WHERE `Category`.`id` = 64 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 1 |
Peak Memory Use 13.81 MB
Message | Memory use |
---|---|
Component initialization | 3.30 MB |
Controller action start | 5.11 MB |
Component initialization #2 | 6.48 MB |
Controller action start #2 | 6.88 MB |
Controller render start | 6.91 MB |
View render complete | 7.71 MB |
Total Request Time: 746 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 26.96 | |
Event: Controller.initialize | 38.09 | |
Event: Controller.startup | 1.41 | |
Controller action | 503.61 | |
» Event: Controller.initialize #2 | 20.19 | |
» Event: Controller.startup #2 | 0.30 | |
Controller action #2 | 0.00 | |
» Event: Controller.beforeRender | 18.26 | |
» » Processing toolbar data | 17.87 | |
» Rendering View | 49.07 | |
» » Event: View.beforeRender | 0.06 | |
» » Rendering CORE/Cake/View/Errors/pdo_error.ctp | 9.26 | |
» » » Rendering CORE/Cake/View/Elements/exception_stack_trace.ctp | 8.33 | |
» » Event: View.afterRender | 0.07 | |
» » Event: View.beforeLayout | 0.04 | |
» » Rendering APP/View/Layouts/default.ctp | 18.39 | |
» » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp | 0.20 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp | 6.73 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp | 1.39 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp | 2.55 | |
» » » Rendering APP/View/Elements/layout/top-notice.ctp | 0.21 | |
» » » Rendering APP/View/Elements/layout/content.ctp | 0.60 | |
» » » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp | 0.24 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp | 0.53 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 | 1.79 | |
» » » » Rendering APP/View/Elements/layout/footer-hours.ctp | 0.37 | |
» » » » Rendering APP/View/Elements/layout/footer-contact.ctp | 0.19 | |
Event: View.afterLayout | 0.00 |