| 1 | SELECT `Setting`.`key`, `Setting`.`value` FROM `bayeks_pmtion`.`settings` AS `Setting` WHERE 1 = 1 | | 7 | 7 | 0 |
| 2 | SELECT `ProductCategory`.`id`, `ProductCategory`.`slug`, `ProductCategory`.`name`, `ProductCategory`.`parent_id` FROM `bayeks_pmtion`.`product_categories` AS `ProductCategory` WHERE 1 = 1 ORDER BY `lft` asc | | 37 | 37 | 1 |
| 3 | SELECT `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 1 | | 1 | 1 | 1 |
| 4 | SELECT `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) | | 0 | 0 | 0 |
| 5 | SELECT `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 500 | | 7 | 7 | 2 |
| 6 | SELECT `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 2 | | 1 | 1 | 1 |
| 7 | SELECT `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 2 | | 2 | 2 | 1 |
| 8 | SELECT `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 2 | | 2 | 2 | 0 |
| 9 | SELECT `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 2 | | 1 | 1 | 0 |
| 10 | SELECT `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 2 | | 1 | 1 | 1 |
| 11 | SELECT `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 2 | | 1 | 1 | 0 |
| 12 | SELECT `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 2 | | 1 | 1 | 1 |
