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

SQL: SELECT * FROM `settings` ORDER BY `position` ASC [ 0.091 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.146 ms ]
SQL: SELECT * FROM `directoryImages` WHERE `section`='home' [ 0.1 ms ]
SQL: DELETE FROM `shop_items_on_main` WHERE `udate` + INTERVAL 1 MINUTE < NOW() [ 0.278 ms ]
SQL: SELECT * FROM `shop_items_on_main` [ 0.185 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) [ 3.476 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('372', '2018-01-20 20:39:44', '1') [ 0.149 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('227', '2018-01-20 20:39:44', '2') [ 0.124 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('313', '2018-01-20 20:39:44', '3') [ 0.114 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('352', '2018-01-20 20:39:44', '4') [ 0.113 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('225', '2018-01-20 20:39:44', '5') [ 0.106 ms ]
SQL: INSERT INTO `shop_items_on_main` (`shop_item_id`, `udate`, `type`) VALUES ('270', '2018-01-20 20:39:44', '6') [ 0.113 ms ]