×
Execution time: [ 37.839 ms ] Memory usage: [ 2.00 MB ] Included files count: [ 45 ] Database queries count: [ 9 ]

SQL: SELECT * FROM `settings` ORDER BY `position` ASC [ 0.088 ms ]
SQL: SELECT shop_categories.*,shop_categories_text.* FROM `shop_categories` INNER JOIN `shop_categories_text` ON shop_categories.id = shop_categories_text.category_id AND shop_categories_text.lang = 'ua' WHERE isRemoved = 0 ORDER BY shop_categories.position ASC [ 0.086 ms ]
SQL: SELECT * FROM `directoryImages` WHERE section='slider' ORDER BY id ASC [ 0.12 ms ]
SQL: SELECT * FROM `directoryImages` WHERE `section`='home' [ 0.092 ms ]
SQL: DELETE FROM `shop_items_on_main` WHERE `udate` + INTERVAL 1 MINUTE < NOW() [ 0.205 ms ]
SQL: SELECT * FROM `shop_items_on_main` [ 0.194 ms ]
SQL: (SELECT shop_items.id, shop_items.category_id, shop_items.alias, shop_items.mainImage, shop_items_text.name, 1 as folderType FROM `shop_items` INNER JOIN `shop_items_text` ON shop_items.id = shop_items_text.item_id AND shop_items_text.lang = 'ua' WHERE shop_items.category_id = 9 ORDER BY RAND() LIMIT 1) UNION (SELECT shop_items.id, shop_items.category_id, shop_items.alias, shop_items.mainImage, shop_items_text.name, 2 as folderType FROM `shop_items` INNER JOIN `shop_items_text` ON shop_items.id = shop_items_text.item_id AND shop_items_text.lang = 'ua' WHERE shop_items.category_id = 54 ORDER BY RAND() LIMIT 1) UNION (SELECT shop_items.id, shop_items.category_id, shop_items.alias, shop_items.mainImage, shop_items_text.name, 3 as folderType FROM `shop_items` INNER JOIN `shop_items_text` ON shop_items.id = shop_items_text.item_id AND shop_items_text.lang = 'ua' WHERE shop_items.category_id = 58 ORDER BY RAND() LIMIT 1) UNION (SELECT shop_items.id, shop_items.category_id, shop_items.alias, shop_items.mainImage, shop_items_text.name, 4 as folderType FROM `shop_items` INNER JOIN `shop_items_text` ON shop_items.id = shop_items_text.item_id AND shop_items_text.lang = 'ua' WHERE shop_items.category_id = 57 ORDER BY RAND() LIMIT 1) UNION (SELECT shop_items.id, shop_items.category_id, shop_items.alias, shop_items.mainImage, shop_items_text.name, 5 as folderType FROM `shop_items` INNER JOIN `shop_items_text` ON shop_items.id = shop_items_text.item_id AND shop_items_text.lang = 'ua' WHERE shop_items.category_id = 53 ORDER BY RAND() LIMIT 1) UNION (SELECT shop_items.id, shop_items.category_id, shop_items.alias, shop_items.mainImage, shop_items_text.name, 6 as folderType FROM `shop_items` INNER JOIN `shop_items_text` ON shop_items.id = shop_items_text.item_id AND shop_items_text.lang = 'ua' WHERE shop_items.category_id = 59 ORDER BY RAND() LIMIT 1) [ 2 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('310', '2018-10-15 17:44:15', '3') [ 0.14 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('318', '2018-10-15 17:44:15', '4') [ 0.12 ms ]