| 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` = 'kalem-setleri' 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` = 9 ORDER BY `Product`.`sort_order` desc, `Product`.`created` desc LIMIT 500 | | 123 | 123 | 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 (2219, 2218, 147, 2260, 1531, 1193, 728, 135, 2966, 2961, 2950, 2809, 2808, 2807, 2798, 2687, 2686, 2493, 2476, 2384, 2383, 2381, 2380, 2379, 2378, 2377, 2376, 2341, 2339, 2338, 2337, 2335, 2334, 2333, 2318, 2317, 2056, 2047, 2046, 2045, 2044, 2043, 2042, 2018, 1966, 1965, 1964, 1962, 1961, 1959, 1958, 1923, 1727, 1726, 1725, 1723, 1721, 1720, 1719, 1717, 1716, 1715, 1566, 1550, 1548, 1546, 1542, 1538, 1537, 1536, 1535, 1534, 1533, 1532, 1530, 1504, 1368, 1345, 1342, 1341, 1340, 1337, 1335, 1327, 1212, 1210, 1203, 1202, 1201, 1196, 1195, 1194, 1192, 1191, 1190, 1189, 1188, 1187, 975, 733, 731, 730, 729, 727, 725, 723, 722, 715, 713, 704, 698, 695, 694, 504, 436, 380, 240, 141, 134, 127, 124, 115, 113) ORDER BY `sort_order` asc, `ProductImage`.`id` asc | | 406 | 406 | 4 |
| 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 (2219, 2218, 147, 2260, 1531, 1193, 728, 135, 2966, 2961, 2950, 2809, 2808, 2807, 2798, 2687, 2686, 2493, 2476, 2384, 2383, 2381, 2380, 2379, 2378, 2377, 2376, 2341, 2339, 2338, 2337, 2335, 2334, 2333, 2318, 2317, 2056, 2047, 2046, 2045, 2044, 2043, 2042, 2018, 1966, 1965, 1964, 1962, 1961, 1959, 1958, 1923, 1727, 1726, 1725, 1723, 1721, 1720, 1719, 1717, 1716, 1715, 1566, 1550, 1548, 1546, 1542, 1538, 1537, 1536, 1535, 1534, 1533, 1532, 1530, 1504, 1368, 1345, 1342, 1341, 1340, 1337, 1335, 1327, 1212, 1210, 1203, 1202, 1201, 1196, 1195, 1194, 1192, 1191, 1190, 1189, 1188, 1187, 975, 733, 731, 730, 729, 727, 725, 723, 722, 715, 713, 704, 698, 695, 694, 504, 436, 380, 240, 141, 134, 127, 124, 115, 113) | | 123 | 123 | 3 |
