| 1 | SELECT `Setting`.`key`, `Setting`.`value` FROM `bayeks_derin`.`settings` AS `Setting` WHERE 1 = 1 | | 15 | 15 | 1 |
| 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 `CategoryDetail`.`id`, `CategoryDetail`.`category_id`, `CategoryDetail`.`lang`, `CategoryDetail`.`name`, `CategoryDetail`.`title`, `CategoryDetail`.`slug`, `CategoryDetail`.`description`, `CategoryDetail`.`meta_description`, `CategoryDetail`.`meta_keywords`, `CategoryDetail`.`created`, `CategoryDetail`.`modified`, `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`image`, `Category`.`average_price`, `Category`.`home_status`, `Category`.`is_hidden`, `Category`.`product_count`, `Category`.`created`, `Category`.`modified` FROM `bayeks_derin`.`category_details` AS `CategoryDetail` LEFT JOIN `bayeks_derin`.`categories` AS `Category` ON (`CategoryDetail`.`category_id` = `Category`.`id`) WHERE `CategoryDetail`.`slug` = 'anahtarliklar' AND `lang` = 'tr' LIMIT 1 | | 1 | 1 | 1 |
| 5 | 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`.`status` = 1 AND `ProductCategory`.`category_id` = 2 ORDER BY `Product`.`sort_order` desc, `Product`.`created` desc LIMIT 500 | | 112 | 112 | 4 |
| 6 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_derin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (906, 64, 62, 644, 1310, 913, 2480, 915, 1616, 918, 634, 929, 2055, 1606, 810, 2479, 1146, 52, 2956, 2803, 2800, 2679, 2618, 2617, 2616, 2598, 2545, 2518, 2481, 2478, 2477, 2461, 2456, 2455, 2268, 2267, 2117, 1951, 1950, 1949, 1948, 1947, 1618, 1617, 1608, 1607, 1603, 1601, 1597, 1437, 1436, 1434, 1315, 1311, 1308, 1307, 1147, 1144, 1143, 1138, 1137, 1133, 1132, 1131, 1127, 1125, 1124, 1123, 1122, 936, 935, 934, 933, 932, 931, 930, 927, 926, 925, 924, 923, 922, 921, 920, 919, 917, 914, 912, 911, 910, 909, 908, 811, 807, 643, 642, 641, 640, 639, 547, 536, 63, 53, 49, 46, 44, 42, 40, 39, 38, 37, 36) ORDER BY `sort_order` asc, `ProductImage`.`id` asc | | 261 | 261 | 3 |
| 7 | 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` FROM `bayeks_derin`.`product_details` AS `ProductDetail` WHERE `ProductDetail`.`lang` = 'tr' AND `ProductDetail`.`product_id` IN (906, 64, 62, 644, 1310, 913, 2480, 915, 1616, 918, 634, 929, 2055, 1606, 810, 2479, 1146, 52, 2956, 2803, 2800, 2679, 2618, 2617, 2616, 2598, 2545, 2518, 2481, 2478, 2477, 2461, 2456, 2455, 2268, 2267, 2117, 1951, 1950, 1949, 1948, 1947, 1618, 1617, 1608, 1607, 1603, 1601, 1597, 1437, 1436, 1434, 1315, 1311, 1308, 1307, 1147, 1144, 1143, 1138, 1137, 1133, 1132, 1131, 1127, 1125, 1124, 1123, 1122, 936, 935, 934, 933, 932, 931, 930, 927, 926, 925, 924, 923, 922, 921, 920, 919, 917, 914, 912, 911, 910, 909, 908, 811, 807, 643, 642, 641, 640, 639, 547, 536, 63, 53, 49, 46, 44, 42, 40, 39, 38, 37, 36) | | 112 | 112 | 3 |
