Category: Mugs
(default) 12 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`key`, `Setting`.`value` FROM `bayeks_pmtion`.`settings` AS `Setting` WHERE 1 = 1770
2SELECT `ProductCategory`.`id`, `ProductCategory`.`slug`, `ProductCategory`.`name`, `ProductCategory`.`parent_id` FROM `bayeks_pmtion`.`product_categories` AS `ProductCategory` WHERE 1 = 1 ORDER BY `lft` asc37371
3SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`title`, `ProductCategory`.`description`, `ProductCategory`.`image`, `ProductCategory`.`meta_description`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`home_status`, `ProductCategory`.`product_count` FROM `bayeks_pmtion`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`slug` = 'mugs' LIMIT 1111
4SELECT `ChildProductCategory`.`id`, `ChildProductCategory`.`parent_id`, `ChildProductCategory`.`lft`, `ChildProductCategory`.`rght`, `ChildProductCategory`.`name`, `ChildProductCategory`.`slug`, `ChildProductCategory`.`title`, `ChildProductCategory`.`description`, `ChildProductCategory`.`image`, `ChildProductCategory`.`meta_description`, `ChildProductCategory`.`meta_keywords`, `ChildProductCategory`.`home_status`, `ChildProductCategory`.`product_count` FROM `bayeks_pmtion`.`product_categories` AS `ChildProductCategory` WHERE `ChildProductCategory`.`parent_id` = (9)000
5SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`product_category_id`, `Product`.`code`, `Product`.`title`, `Product`.`slug`, `Product`.`description`, `Product`.`excerpt`, `Product`.`price`, `Product`.`discounted_price`, `Product`.`currency`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`lang`, `Product`.`status`, `Product`.`featured`, `Product`.`suggested`, `Product`.`hidden_stock`, `Product`.`discounted`, `Product`.`sort_order`, `Product`.`created`, `Product`.`modified` FROM `bayeks_pmtion`.`products` AS `Product` WHERE `Product`.`status` = 1 AND `Product`.`product_category_id` = 9 ORDER BY `Product`.`sort_order` desc, `Product`.`created` desc LIMIT 500772
6SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_pmtion`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (167) ORDER BY `sort_order` asc, `id` asc LIMIT 2111
7SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_pmtion`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (166) ORDER BY `sort_order` asc, `id` asc LIMIT 2221
8SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_pmtion`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (165) ORDER BY `sort_order` asc, `id` asc LIMIT 2220
9SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_pmtion`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (164) ORDER BY `sort_order` asc, `id` asc LIMIT 2110
10SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_pmtion`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (163) ORDER BY `sort_order` asc, `id` asc LIMIT 2111
11SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_pmtion`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (162) ORDER BY `sort_order` asc, `id` asc LIMIT 2110
12SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_pmtion`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (161) ORDER BY `sort_order` asc, `id` asc LIMIT 2111