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` = 'matbaa' 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` = 95 ORDER BY `Product`.`sort_order` desc, `Product`.`created` desc LIMIT 500 | | 17 | 17 | 2 |
6 | SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order` FROM `bayeks_derin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (3058, 1417, 3076, 3075, 3059, 2896, 2677, 1259, 1258, 1257, 1256, 1044, 1043, 1042, 1041, 1040, 1039) ORDER BY `sort_order` asc, `ProductImage`.`id` asc | | 41 | 41 | 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 (3058, 1417, 3076, 3075, 3059, 2896, 2677, 1259, 1258, 1257, 1256, 1044, 1043, 1042, 1041, 1040, 1039) | | 17 | 17 | 3 |