| 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` = 'kalemler' 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` = 28 ORDER BY `Product`.`sort_order` desc, `Product`.`created` desc LIMIT 500 | | 311 | 311 | 8 |
| 6 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_derin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (2213, 2212, 2211, 274, 199, 768, 1513, 1518, 1171, 1730, 1517, 1353, 1169, 1499, 1348, 2722, 2457, 2052, 1156, 2519, 2035, 1503, 1498, 1496, 758, 756, 746, 279, 275, 250, 215, 213, 186, 2344, 1510, 237, 223, 212, 192, 181, 3039, 3038, 2970, 2960, 2959, 2958, 2892, 2890, 2888, 2886, 2829, 2828, 2826, 2825, 2824, 2823, 2822, 2821, 2820, 2818, 2817, 2816, 2815, 2814, 2813, 2812, 2811, 2810, 2806, 2805, 2804, 2788, 2689, 2685, 2684, 2683, 2682, 2675, 2661, 2660, 2659, 2658, 2583, 2582, 2581, 2580, 2579, 2578, 2577, 2576, 2575, 2531, 2530, 2520, 2475, 2474, 2429, 2428, 2399, 2398, 2397, 2396, 2395, 2394, 2393, 2392, 2391, 2390, 2389, 2388, 2387, 2386, 2385, 2366, 2343, 2332, 2331, 2330, 2214, 2165, 2116, 2080, 2070, 2053, 2036, 2031, 2030, 2029, 2014, 2009, 2008, 2006, 2005, 2004, 2003, 2001, 2000, 1999, 1998, 1996, 1995, 1994, 1993, 1991, 1990, 1988, 1987, 1985, 1983, 1982, 1980, 1978, 1977, 1976, 1972, 1971, 1970, 1969, 1968, 1967, 1946, 1945, 1944, 1943, 1942, 1941, 1940, 1939, 1938, 1937, 1904, 1898, 1897, 1714, 1713, 1712, 1711, 1710, 1526, 1525, 1524, 1523, 1522, 1521, 1520, 1519, 1516, 1515, 1514, 1511, 1506, 1501, 1500, 1497, 1495, 1494, 1493, 1492, 1491, 1490, 1487, 1482, 1481, 1480, 1479, 1478, 1477, 1476, 1475, 1474, 1473, 1472, 1471, 1469, 1468, 1467, 1466, 1465, 1464, 1463, 1462, 1461, 1460, 1459, 1458, 1457, 1456, 1453, 1407, 1406, 1322, 1321, 1318, 1174, 1173, 1172, 1170, 1167, 1166, 1164, 1163, 1162, 1161, 1159, 1158, 1157, 1155, 1154, 844, 841, 840, 838, 837, 785, 769, 767, 764, 762, 757, 755, 754, 753, 752, 751, 750, 748, 747, 744, 743, 742, 741, 740, 739, 738, 737, 486, 476, 470, 458, 453, 432, 430, 413, 411, 284, 280, 278, 277, 276, 256, 247, 245, 243, 239, 236, 234, 227, 226, 224, 217, 216, 214, 209, 198, 197, 193, 191, 190, 188, 183, 125) ORDER BY `sort_order` asc, `ProductImage`.`id` asc | | 1084 | 1084 | 6 |
| 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 (2213, 2212, 2211, 274, 199, 768, 1513, 1518, 1171, 1730, 1517, 1353, 1169, 1499, 1348, 2722, 2457, 2052, 1156, 2519, 2035, 1503, 1498, 1496, 758, 756, 746, 279, 275, 250, 215, 213, 186, 2344, 1510, 237, 223, 212, 192, 181, 3039, 3038, 2970, 2960, 2959, 2958, 2892, 2890, 2888, 2886, 2829, 2828, 2826, 2825, 2824, 2823, 2822, 2821, 2820, 2818, 2817, 2816, 2815, 2814, 2813, 2812, 2811, 2810, 2806, 2805, 2804, 2788, 2689, 2685, 2684, 2683, 2682, 2675, 2661, 2660, 2659, 2658, 2583, 2582, 2581, 2580, 2579, 2578, 2577, 2576, 2575, 2531, 2530, 2520, 2475, 2474, 2429, 2428, 2399, 2398, 2397, 2396, 2395, 2394, 2393, 2392, 2391, 2390, 2389, 2388, 2387, 2386, 2385, 2366, 2343, 2332, 2331, 2330, 2214, 2165, 2116, 2080, 2070, 2053, 2036, 2031, 2030, 2029, 2014, 2009, 2008, 2006, 2005, 2004, 2003, 2001, 2000, 1999, 1998, 1996, 1995, 1994, 1993, 1991, 1990, 1988, 1987, 1985, 1983, 1982, 1980, 1978, 1977, 1976, 1972, 1971, 1970, 1969, 1968, 1967, 1946, 1945, 1944, 1943, 1942, 1941, 1940, 1939, 1938, 1937, 1904, 1898, 1897, 1714, 1713, 1712, 1711, 1710, 1526, 1525, 1524, 1523, 1522, 1521, 1520, 1519, 1516, 1515, 1514, 1511, 1506, 1501, 1500, 1497, 1495, 1494, 1493, 1492, 1491, 1490, 1487, 1482, 1481, 1480, 1479, 1478, 1477, 1476, 1475, 1474, 1473, 1472, 1471, 1469, 1468, 1467, 1466, 1465, 1464, 1463, 1462, 1461, 1460, 1459, 1458, 1457, 1456, 1453, 1407, 1406, 1322, 1321, 1318, 1174, 1173, 1172, 1170, 1167, 1166, 1164, 1163, 1162, 1161, 1159, 1158, 1157, 1155, 1154, 844, 841, 840, 838, 837, 785, 769, 767, 764, 762, 757, 755, 754, 753, 752, 751, 750, 748, 747, 744, 743, 742, 741, 740, 739, 738, 737, 486, 476, 470, 458, 453, 432, 430, 413, 411, 284, 280, 278, 277, 276, 256, 247, 245, 243, 239, 236, 234, 227, 226, 224, 217, 216, 214, 209, 198, 197, 193, 191, 190, 188, 183, 125) | | 311 | 311 | 4 |
