Сортувати:
БРЕНДИ
×
Execution time: [ 52.997 ms ] Memory usage: [ 2.50 MB ] Included files count: [ 45 ] Database queries count: [ 6 ]

SQL: SELECT * FROM `settings` ORDER BY `position` ASC [ 0.093 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.094 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 id = 3 AND isRemoved = 0 LIMIT 1 [ 0.097 ms ]
SQL: SELECT shop_brands.id, shop_brands.name FROM `shop_items` INNER JOIN `shop_brands` ON shop_items.brand_id = shop_brands.id WHERE shop_items.isRemoved = 0 AND shop_items.isPublic = 1 AND shop_items.top_category_id = '3' GROUP BY shop_items.brand_id ORDER BY shop_brands.alias ASC [ 0.89 ms ]
SQL: SELECT COUNT(shop_items.id) as itemsCount FROM `shop_items` INNER JOIN `shop_items_text` ON shop_items.id = shop_items_text.item_id AND shop_items_text.lang = 'ua' INNER JOIN `shop_categories` ON shop_items.category_id = shop_categories.id WHERE shop_items.isRemoved = 0 AND shop_items.top_category_id = '3' ORDER BY shop_items.date DESC [ 0.952 ms ]
SQL: SELECT shop_items.id, shop_items.category_id, shop_items.alias, shop_categories.alias as catAlias, shop_items.price, shop_items.price_usd, shop_items.discount, shop_items.mainImage, shop_items_text.name, 0 as isCategory, shop_items.date FROM `shop_items` INNER JOIN `shop_items_text` ON shop_items.id = shop_items_text.item_id AND shop_items_text.lang = 'ua' INNER JOIN `shop_categories` ON shop_items.category_id = shop_categories.id WHERE shop_items.isRemoved = 0 AND shop_items.top_category_id = '3' ORDER BY shop_items.date DESC LIMIT 9 OFFSET 0 [ 0.888 ms ]