| 1 | SELECT `Setting`.`key`, `Setting`.`value` FROM `bayeks_derin`.`settings` AS `Setting` WHERE 1 = 1 | | 15 | 15 | 0 |
| 2 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`image`, `Category`.`average_price` FROM `bayeks_derin`.`categories` AS `Category` WHERE `Category`.`is_hidden` = 0 ORDER BY `lft` asc | | 78 | 78 | 1 |
| 3 | SELECT `CategoryDetail`.`slug`, `CategoryDetail`.`name`, `CategoryDetail`.`category_id` FROM `bayeks_derin`.`category_details` AS `CategoryDetail` WHERE `CategoryDetail`.`lang` = 'tr' AND `CategoryDetail`.`category_id` IN (36, 23, 60, 35, 86, 47, 48, 94, 90, 87, 91, 63, 30, 65, 66, 73, 77, 1, 59, 57, 50, 49, 51, 52, 53, 54, 2, 71, 72, 95, 39, 68, 89, 7, 33, 32, 28, 13, 16, 18, 58, 88, 9, 55, 56, 10, 29, 3, 5, 6, 8, 14, 43, 61, 62, 70, 81, 11, 12, 15, 17, 19, 20, 42, 67, 37, 38, 80, 41, 76, 78, 79, 45, 46, 74, 75, 34, 40) | | 78 | 78 | 1 |
| 4 | SELECT `ProductDetail`.`id`, `ProductDetail`.`product_id`, `ProductDetail`.`title`, `ProductDetail`.`slug`, `ProductDetail`.`seo_title`, `ProductDetail`.`description`, `ProductDetail`.`excerpt`, `ProductDetail`.`seo_description`, `ProductDetail`.`meta_description`, `ProductDetail`.`meta_keywords`, `ProductDetail`.`lang`, `ProductDetail`.`created`, `ProductDetail`.`modified`, `Product`.`id`, `Product`.`parent_id`, `Product`.`product_category_id`, `Product`.`code`, `Product`.`price`, `Product`.`discounted_price`, `Product`.`currency`, `Product`.`is_turkish_made`, `Product`.`lang`, `Product`.`status`, `Product`.`featured`, `Product`.`suggested`, `Product`.`hidden_stock`, `Product`.`discounted`, `Product`.`sort_order`, `Product`.`product_category_count`, `Product`.`product_detail_count`, `Product`.`redirection`, `Product`.`created`, `Product`.`modified` FROM `bayeks_derin`.`product_details` AS `ProductDetail` LEFT JOIN `bayeks_derin`.`products` AS `Product` ON (`ProductDetail`.`product_id` = `Product`.`id`) WHERE `ProductDetail`.`slug` = 'ayyildiz-masa-seti' AND `ProductDetail`.`lang` = 'tr' LIMIT 1 | | 1 | 1 | 2 |
| 5 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_derin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (1227) ORDER BY `sort_order` asc, `id` asc | | 1 | 1 | 2 |
| 6 | SELECT `ProductMeta`.`id`, `ProductMeta`.`product_id`, `ProductMeta`.`meta`, `ProductMeta`.`value`, `ProductMeta`.`lang` FROM `bayeks_derin`.`product_metas` AS `ProductMeta` WHERE `ProductMeta`.`product_id` = (1227) | | 0 | 0 | 1 |
| 7 | SELECT `ProductCategory`.`id`, `ProductCategory`.`product_id`, `ProductCategory`.`category_id` FROM `bayeks_derin`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`product_id` = (1227) | | 1 | 1 | 1 |
| 8 | SELECT `ProductInventory`.`name`, SUM(`ProductInventory`.`stock`) as stock FROM `bayeks_derin`.`product_inventories` AS `ProductInventory` LEFT JOIN `bayeks_derin`.`products` AS `Product` ON (`ProductInventory`.`product_id` = `Product`.`id`) WHERE `ProductInventory`.`code` LIKE '%2117%' GROUP BY `ProductInventory`.`name` | | 1 | 1 | 4 |
| 9 | SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`product_category_id`, `Product`.`code`, `Product`.`price`, `Product`.`discounted_price`, `Product`.`currency`, `Product`.`is_turkish_made`, `Product`.`lang`, `Product`.`status`, `Product`.`featured`, `Product`.`suggested`, `Product`.`hidden_stock`, `Product`.`discounted`, `Product`.`sort_order`, `Product`.`product_category_count`, `Product`.`product_detail_count`, `Product`.`redirection`, `Product`.`created`, `Product`.`modified` FROM `bayeks_derin`.`products` AS `Product` INNER JOIN `bayeks_derin`.`product_categories` AS `ProductCategory` ON (`Product`.`id`=`ProductCategory`.`product_id`) WHERE `Product`.`id` != 1227 AND `Product`.`status` = 1 ORDER BY rand() ASC LIMIT 4 | | 4 | 4 | 47 |
| 10 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_derin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (2708) ORDER BY `sort_order` asc, `id` asc LIMIT 2 | | 2 | 2 | 2 |
| 11 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_derin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (250) ORDER BY `sort_order` asc, `id` asc LIMIT 2 | | 1 | 1 | 2 |
| 12 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_derin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (2820) ORDER BY `sort_order` asc, `id` asc LIMIT 2 | | 1 | 1 | 2 |
| 13 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_derin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (2486) ORDER BY `sort_order` asc, `id` asc LIMIT 2 | | 2 | 2 | 2 |
| 14 | SELECT `ProductDetail`.`title`, `ProductDetail`.`slug`, `ProductDetail`.`product_id` FROM `bayeks_derin`.`product_details` AS `ProductDetail` WHERE `ProductDetail`.`lang` = 'tr' AND `ProductDetail`.`product_id` IN (2708, 250, 2820, 2486) | | 4 | 4 | 2 |
