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

SQL: SELECT * FROM `settings` ORDER BY `position` ASC [ 0.096 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.091 ms ]
SQL: SELECT * FROM `directoryImages` WHERE section='slider' ORDER BY id ASC [ 0.129 ms ]
SQL: SELECT * FROM `directoryImages` WHERE `section`='home' [ 0.142 ms ]
SQL: DELETE FROM `shop_items_on_main` WHERE `udate` + INTERVAL 1 MINUTE < NOW() [ 7.607 ms ]
SQL: SELECT * FROM `shop_items_on_main` [ 0.219 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.062 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('308', '2018-08-19 21:48:25', '3') [ 0.163 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('348', '2018-08-19 21:48:25', '4') [ 0.12 ms ]