ConfigurationRequestRouterLogsProfilingDatabaseEventsAsset BundlesMailTimelineUserDump
Prev Next
All Latest
685e6976ad511: GET https://stag.lurex.in.ua/tape/index/13 at 2025-06-27 12:50:46 pm by 216.73.216.194

Performance Profiling

Total processing time: 104 ms; Peak memory: 8.114 MB. Show Profiling Timeline

Всего 230 записи.
TimeDurationCategoryInfo
  
12:50:46.7444.8 msyii\db\Command::querySELECT `opts`.`product_id`, `opts`.`attribute_id`, `opts`.`value`, `list`.`sort_order`, `attr`.`type`, `listlang`.`title` AS `listValue`, `list`.`color`, SUM(store.quantity) AS `total_quantity`, `alang`.`title` AS `title` FROM `shop_product_store_options` `opts` LEFT JOIN `shop_attributes` `attr` ON attr.id=opts.attribute_id LEFT JOIN `shop_attributes_lang` `alang` ON alang.owner_id=opts.attribute_id AND alang.language='uk' LEFT JOIN `shop_product_store` `store` ON opts.store_id = store.id LEFT JOIN `shop_attributes_list` `list` ON list.id=opts.value LEFT JOIN `shop_attributes_list_lang` `listlang` ON listlang.owner_id=opts.value AND listlang.language='uk' WHERE `store`.`product_id` IN ('1846', '1079', '169', '1871', '2311', '1259', '585', '1692', '2324', '835') GROUP BY `opts`.`product_id`, `opts`.`attribute_id`, `opts`.`value`, `attr`.`type`, `listlang`.`title`, `list`.`color` ORDER BY `attr`.`sort_order`, `total_quantity` DESC
12:50:46.7344.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT `main`.`id`, `main`.`article`, `main`.`sort_order`, `lang`.`title` AS `selectTitle`, `lang`.`description` AS `selectDescription`, `category_lang`.`owner_id` AS `selectCategoryId`, `category_lang`.`title` AS `selectCategoryTitle`, `main`.`created_at` AS `created_at`, `pp`.`value` AS `typePrice`, CASE WHEN SUM(ps.quantity) > 0 THEN 1 ELSE 0 END AS `storeCount` FROM `shop_product` `main` LEFT JOIN `category_lang` `category_lang` ON main.parent_id=category_lang.owner_id LEFT JOIN `shop_product_lang` `lang` ON lang.owner_id=main.id LEFT JOIN `shop_product_prices` `pp` ON main.id=pp.product_id AND pp.price_id='1' LEFT JOIN `shop_product_prices` `ppr` ON main.id=ppr.product_id AND ppr.price_id=1 LEFT JOIN `shop_product_store` `ps` ON main.id=ps.product_id LEFT JOIN (SELECT `p`.`id`, SUM(ps.quantity) AS `sum`, `sub_p`.`count` AS `order` FROM `shop_product` `p` LEFT JOIN `shop_product_store` `ps` ON p.id=ps.product_id LEFT JOIN (SELECT `p`.`id`, COUNT(w.id) AS `count` FROM `shop_product` `p` LEFT JOIN `shop_wishlist` `w` ON p.id=w.product_id WHERE (`p`.`visible`=1) AND (`p`.`id` IN ('169', '171', '226', '361', '585', '835', '999', '1013', '1049', '1079', '1111', '1151', '1217', '1245', '1247', '1259', '1646', '1651', '1660', '1678', '1692', '1703', '1726', '1733', '1742', '1753', '1757', '1783', '1806', '1813', '1844', '1846', '1871', '1873', '1933', '1978', '1982', '1995', '2020', '2026', '2105', '2108', '2124', '2159', '2176', '2215', '2222', '2226', '2230', '2239', '2255', '2257', '2311', '2324', '2358', '2527')) AND (`w`.`updated_at` BETWEEN 1750971600 AND 1751058000) GROUP BY `p`.`id`) AS sub_p ON sub_p.id=p.id WHERE (`p`.`visible`=1) AND (`p`.`id` IN ('169', '171', '226', '361', '585', '835', '999', '1013', '1049', '1079', '1111', '1151', '1217', '1245', '1247', '1259', '1646', '1651', '1660', '1678', '1692', '1703', '1726', '1733', '1742', '1753', '1757', '1783', '1806', '1813', '1844', '1846', '1871', '1873', '1933', '1978', '1982', '1995', '2020', '2026', '2105', '2108', '2124', '2159', '2176', '2215', '2222', '2226', '2230', '2239', '2255', '2257', '2311', '2324', '2358', '2527')) GROUP BY `p`.`id` HAVING `sum` >= 1) subProductQuery ON subProductQuery.id=main.id WHERE ((`main`.`visible`=1) AND (`lang`.`language`='uk') AND (`category_lang`.`language`='uk')) AND (main.id IN (subProductQuery.id)) GROUP BY `main`.`id` ORDER BY `storeCount` DESC) `sub`
12:50:46.7393.9 msyii\db\Command::querySELECT `main`.`id`, `main`.`article`, `main`.`sort_order`, `lang`.`title` AS `selectTitle`, `lang`.`description` AS `selectDescription`, `category_lang`.`owner_id` AS `selectCategoryId`, `category_lang`.`title` AS `selectCategoryTitle`, `main`.`created_at` AS `created_at`, `pp`.`value` AS `typePrice`, CASE WHEN SUM(ps.quantity) > 0 THEN 1 ELSE 0 END AS `storeCount` FROM `shop_product` `main` LEFT JOIN `category_lang` `category_lang` ON main.parent_id=category_lang.owner_id LEFT JOIN `shop_product_lang` `lang` ON lang.owner_id=main.id LEFT JOIN `shop_product_prices` `pp` ON main.id=pp.product_id AND pp.price_id='1' LEFT JOIN `shop_product_prices` `ppr` ON main.id=ppr.product_id AND ppr.price_id=1 LEFT JOIN `shop_product_store` `ps` ON main.id=ps.product_id LEFT JOIN (SELECT `p`.`id`, SUM(ps.quantity) AS `sum`, `sub_p`.`count` AS `order` FROM `shop_product` `p` LEFT JOIN `shop_product_store` `ps` ON p.id=ps.product_id LEFT JOIN (SELECT `p`.`id`, COUNT(w.id) AS `count` FROM `shop_product` `p` LEFT JOIN `shop_wishlist` `w` ON p.id=w.product_id WHERE (`p`.`visible`=1) AND (`p`.`id` IN ('169', '171', '226', '361', '585', '835', '999', '1013', '1049', '1079', '1111', '1151', '1217', '1245', '1247', '1259', '1646', '1651', '1660', '1678', '1692', '1703', '1726', '1733', '1742', '1753', '1757', '1783', '1806', '1813', '1844', '1846', '1871', '1873', '1933', '1978', '1982', '1995', '2020', '2026', '2105', '2108', '2124', '2159', '2176', '2215', '2222', '2226', '2230', '2239', '2255', '2257', '2311', '2324', '2358', '2527')) AND (`w`.`updated_at` BETWEEN 1750971600 AND 1751058000) GROUP BY `p`.`id`) AS sub_p ON sub_p.id=p.id WHERE (`p`.`visible`=1) AND (`p`.`id` IN ('169', '171', '226', '361', '585', '835', '999', '1013', '1049', '1079', '1111', '1151', '1217', '1245', '1247', '1259', '1646', '1651', '1660', '1678', '1692', '1703', '1726', '1733', '1742', '1753', '1757', '1783', '1806', '1813', '1844', '1846', '1871', '1873', '1933', '1978', '1982', '1995', '2020', '2026', '2105', '2108', '2124', '2159', '2176', '2215', '2222', '2226', '2230', '2239', '2255', '2257', '2311', '2324', '2358', '2527')) GROUP BY `p`.`id` HAVING `sum` >= 1) subProductQuery ON subProductQuery.id=main.id WHERE ((`main`.`visible`=1) AND (`lang`.`language`='uk') AND (`category_lang`.`language`='uk')) AND (main.id IN (subProductQuery.id)) GROUP BY `main`.`id` ORDER BY `storeCount` DESC, `sort_order` LIMIT 48
12:50:46.7301.1 msyii\db\Command::querySELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `source_message` `t1`, `message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='uk')
12:50:46.7210.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_construct_product`
12:50:46.7560.7 msyii\db\Command::querySELECT `shop_prices`.`percent`, `value`, `discount_value`, `product_id`, `shop_prices_lang`.`price_info`, `shop_prices_lang`.`title`, `shop_product`.`parent_id` FROM `shop_product_prices` LEFT JOIN `shop_prices` ON `shop_prices`.id=`shop_product_prices`.price_id LEFT JOIN `shop_prices_lang` ON `shop_prices`.id=`shop_prices_lang`.owner_id LEFT JOIN `shop_product` ON `shop_product`.id=`shop_product_prices`.product_id WHERE (`product_id` IN ('1846', '1079', '169', '1871', '2311', '1259', '585', '1692', '2324', '835')) AND (`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7520.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `promotions`
12:50:46.7110.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `redirects`
12:50:46.7570.7 msyii\db\Command::querySELECT `shop_prices`.`percent`, `value`, `discount_value`, `product_id`, `shop_prices_lang`.`price_info`, `shop_prices_lang`.`title`, `shop_product`.`parent_id` FROM `shop_product_prices` LEFT JOIN `shop_prices` ON `shop_prices`.id=`shop_product_prices`.price_id LEFT JOIN `shop_prices_lang` ON `shop_prices`.id=`shop_prices_lang`.owner_id LEFT JOIN `shop_product` ON `shop_product`.id=`shop_product_prices`.product_id WHERE (`product_id` IN ('1846', '1079', '169', '1871', '2311', '1259', '585', '1692', '2324', '835')) AND (`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7150.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_currency_lang`
12:50:46.7140.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_currency`
12:50:46.7100.6 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;port=3306;dbname=lurex
12:50:46.7180.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_tapes`
12:50:46.7230.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_construct_product_lang`
12:50:46.7270.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_product`
12:50:46.7290.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_product_lang`
12:50:46.7610.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_prices`
12:50:46.7540.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `promotions_lang`
12:50:46.7190.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_tapes_lang`
12:50:46.7490.4 msyii\db\Command::querySELECT `lang`.`mark`, `shc`.`color`, `shc`.`bgcolor`, `shc`.`stroke_color`, `main`.`product_id`, `main`.`showcase_id` FROM `shop_product_showcases` `main` INNER JOIN `shop_showcases` `shc` ON main.showcase_id=shc.id INNER JOIN `shop_showcases_lang` `lang` ON main.showcase_id=lang.owner_id WHERE (`language`='uk') AND (`main`.`product_id` IN ('1846', '1079', '169', '1871', '2311', '1259', '585', '1692', '2324', '835')) ORDER BY `shc`.`sort_order`
12:50:46.7620.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_prices_lang`
12:50:46.7910.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1692') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7200.4 msyii\db\Command::querySELECT * FROM `shop_tapes_lang` WHERE (`language`='uk') AND (`owner_id`=13)
12:50:46.7660.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1079') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7240.4 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_construct_product_lang' AND `kcu`.`TABLE_NAME` = 'shop_construct_product_lang'
12:50:46.7180.4 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_tapes' AND `kcu`.`TABLE_NAME` = 'shop_tapes'
12:50:46.7160.4 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_currency_lang' AND `kcu`.`TABLE_NAME` = 'shop_currency_lang'
12:50:46.7590.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1846') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7830.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1259') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7150.4 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_currency' AND `kcu`.`TABLE_NAME` = 'shop_currency'
12:50:46.8010.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='835') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7920.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1692') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7790.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='2311') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7740.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1871') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7700.4 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='169') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7280.4 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_product' AND `kcu`.`TABLE_NAME` = 'shop_product'
12:50:46.7220.4 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_construct_product' AND `kcu`.`TABLE_NAME` = 'shop_construct_product'
12:50:46.7660.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1079') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.8000.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='835') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7120.3 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'redirects' AND `kcu`.`TABLE_NAME` = 'redirects'
12:50:46.7710.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='169') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7870.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='585') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7870.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='585') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7530.3 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'promotions' AND `kcu`.`TABLE_NAME` = 'promotions'
12:50:46.7830.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1259') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7960.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='2324') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7290.3 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_product_lang' AND `kcu`.`TABLE_NAME` = 'shop_product_lang'
12:50:46.7590.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1846') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7960.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='2324') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7780.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='2311') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7540.3 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'promotions_lang' AND `kcu`.`TABLE_NAME` = 'promotions_lang'
12:50:46.7750.3 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1871') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7620.3 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_prices' AND `kcu`.`TABLE_NAME` = 'shop_prices'
12:50:46.7200.3 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_tapes_lang' AND `kcu`.`TABLE_NAME` = 'shop_tapes_lang'
12:50:46.7630.3 msyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'shop_prices_lang' AND `kcu`.`TABLE_NAME` = 'shop_prices_lang'
12:50:46.7250.2 msyii\db\Command::querySELECT * FROM `shop_construct_default_colors` WHERE `construct_id`=54
12:50:46.7210.2 msyii\db\Command::querySELECT * FROM `shop_construct_product` WHERE `id`=54
12:50:46.7240.1 msyii\db\Command::querySELECT * FROM `shop_construct_product_lang` WHERE (`language`='uk') AND (`owner_id`=54)
12:50:46.7800.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='2311') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7190.1 msyii\db\Command::querySELECT * FROM `shop_tapes` WHERE `id`=13
12:50:46.7630.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7260.1 msyii\db\Command::querySELECT `product_id` FROM `shop_construct_product_product` WHERE `construct_id`=54
12:50:46.7300.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7260.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `shop_construct_product_attribute` WHERE `construct_id`=54)
12:50:46.7930.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.8020.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='835') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7580.1 msyii\db\Command::querySELECT `main`.`field_key`, `mainL`.`field_value` FROM `shop_settings` `main` LEFT JOIN `shop_settings_lang` `mainL` ON mainL.owner_id=main.id WHERE `mainL`.`language`='uk'
12:50:46.7550.1 msyii\db\Command::querySELECT `promotions`.* FROM `promotions` LEFT JOIN `shop_document` ON `promotions`.`id` = `shop_document`.`promotion_id` WHERE (`shop_document`.`user_id` IS NULL) AND (`shop_document`.`id` IS NULL)
12:50:46.7910.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7430.1 msyii\db\Command::querySELECT `id` FROM `shop_stores` WHERE `defstore`=1 ORDER BY `sort_order`
12:50:46.7140.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7640.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7890.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.7970.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7810.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.8000.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7880.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='585') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7330.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7430.1 msyii\db\Command::querySELECT `aliases`.`primaryKey`, `aliases`.`alias` FROM `aliases` `aliases` WHERE ((`aliases`.`model`='app\\modules\\shop\\models\\Product') AND (`aliases`.`redirectID`=0)) AND (`aliases`.`primaryKey` IN ('1846', '1079', '169', '1871', '2311', '1259', '585', '1692', '2324', '835'))
12:50:46.7990.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.7600.1 msyii\db\Command::querySELECT `main`.`field_key`, `mainL`.`field_value` FROM `settings` `main` LEFT JOIN `settings_lang` `mainL` ON mainL.owner_id=main.id WHERE `mainL`.`language`='uk'
12:50:46.7990.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.8020.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7730.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7930.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7250.1 msyii\db\Command::querySELECT * FROM `shop_attributes_list` WHERE 0=1 ORDER BY `sort_order`
12:50:46.7550.1 msyii\db\Command::querySELECT * FROM `shop_document` WHERE `promotion_id`=1
12:50:46.7950.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.8020.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7930.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7980.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7820.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7690.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.7680.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.7820.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.7990.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.7700.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7860.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.7820.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7900.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.7730.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.7440.1 msyii\db\Command::querySELECT `img`.`product_id`, `img`.`id`, `img`.`path`, `img`.`process_updated_at`, `attr`.`attribute_id`, `attr`.`attribute_list_id`, `image_lang`.`alt`, `image_lang`.`title` FROM `shop_product_images` `img` LEFT JOIN `shop_product_images_attributes` `attr` ON attr.image_id = img.id LEFT JOIN `shop_product_images_lang` `image_lang` ON image_lang.owner_id = img.id WHERE (`img`.`product_id` IN ('1846', '1079', '169', '1871', '2311', '1259', '585', '1692', '2324', '835')) AND (`img`.`cover`=1)
12:50:46.7770.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.7790.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7950.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7970.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.8020.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='835') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7930.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1692') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.8000.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7770.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7510.1 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 139789) AND (`discount_conditions`.`quantity_to` >= 139789) AND (`discount_conditions`.`format`='moment') AND (`discount_status`.`type_user` IS NULL)
12:50:46.7520.1 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 0) AND (`discount_conditions`.`quantity_to` >= 0) AND (`discount_conditions`.`format`='previous_year') AND (`discount_status`.`type_user` IS NULL)
12:50:46.7850.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7430.1 msyii\db\Command::querySELECT SUM(quantity) AS `in_stock`, `product_id` FROM `shop_product_store` WHERE (`product_id` IN ('1846', '1079', '169', '1871', '2311', '1259', '585', '1692', '2324', '835')) AND (`store_id`='1') GROUP BY `product_id`
12:50:46.7680.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7710.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='169') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7760.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7260.1 msyii\db\Command::querySELECT `product_id` FROM `shop_construct_product_product` WHERE `construct_id`=54
12:50:46.7910.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7170.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7610.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1846') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7850.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7650.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.7760.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1871') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7100.1 msyii\db\Command::querySELECT * FROM languages WHERE visible=1 ORDER BY sort_order
12:50:46.7340.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7560.1 msyii\db\Command::querySELECT SUM(quantity) FROM `shop_document_content` INNER JOIN `shop_document` ON `shop_document_content`.document_id=`shop_document`.id WHERE (`shop_document`.`session_id`='locq8vq1cmdg51lc7a6a07jpkh') AND (`shop_document`.`state_id` IS NULL)
12:50:46.7900.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.8010.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7520.1 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 0) AND (`discount_conditions`.`quantity_to` >= 0) AND (`discount_conditions`.`format`='previous_month') AND (`discount_status`.`type_user` IS NULL)
12:50:46.7560.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7640.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7950.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.7970.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.8040.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.7580.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7840.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1259') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7610.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1846') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7660.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7780.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.7930.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1692') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7940.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.8030.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7760.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7840.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7960.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7610.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7700.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7590.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7840.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7980.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7600.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7610.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7680.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7860.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.7880.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7940.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7250.1 msyii\db\Command::querySELECT `id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7550.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7680.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7770.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.7880.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7500.1 msyii\db\Command::querySELECT SUM(quantity) FROM `shop_document_content` INNER JOIN `shop_document` ON `shop_document_content`.document_id=`shop_document`.id WHERE (`shop_document`.`user_id` IS NULL) AND (`shop_document`.`state_id` IS NULL)
12:50:46.7640.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.7670.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7720.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='169') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7800.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7870.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7940.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.8020.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7850.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.7600.1 msyii\db\Command::querySELECT `color`, `bgcolor`, `stroke_color` FROM `shop_showcases` `s` WHERE `id`=3
12:50:46.7710.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7760.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1871') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7880.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='585') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7670.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7670.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1079') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7740.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7840.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7510.1 msyii\db\Command::querySELECT `count_previous_month` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL
12:50:46.7690.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.7740.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7970.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='2324') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7170.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7550.1 msyii\db\Command::querySELECT * FROM `promotions_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7860.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7500.1 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 139789) AND (`discount_conditions`.`quantity_to` >= 139789) AND (`discount_conditions`.`format`='moment') AND (`discount_status`.`type_user` IS NULL)
12:50:46.8030.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=2)
12:50:46.7110.1 msyii\db\Command::querySELECT MAX(updated_at) FROM languages
12:50:46.7510.1 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 0) AND (`discount_conditions`.`quantity_to` >= 0) AND (`discount_conditions`.`format`='previous_year') AND (`discount_status`.`type_user` IS NULL)
12:50:46.7510.1 msyii\db\Command::querySELECT SUM(quantity) FROM `shop_document_content` INNER JOIN `shop_document` ON `shop_document_content`.document_id=`shop_document`.id WHERE (`shop_document`.`user_id` IS NULL) AND (`shop_document`.`state_id` IS NULL)
12:50:46.7650.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.7650.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7810.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7810.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.8040.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.7670.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1079') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='uk')
12:50:46.7890.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7970.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='2324') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7560.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7730.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3
12:50:46.7800.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7890.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7890.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2
12:50:46.7750.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7800.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='2311') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7840.1 msyii\db\Command::querySELECT * FROM `shop_product_prices` INNER JOIN `shop_prices` ON `shop_product_prices`.price_id=`shop_prices`.id INNER JOIN `shop_prices_lang` ON `shop_prices_lang`.owner_id=`shop_prices`.id WHERE (`shop_product_prices`.`product_id`='1259') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='uk')
12:50:46.7100.1 msyii\db\Command::querySELECT MAX(updated_at) FROM languages
12:50:46.7510.1 msyii\db\Command::querySELECT `count_previous_month` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL
12:50:46.7780.1 msyii\db\Command::querySELECT * FROM `shop_currency` WHERE `id`=1
12:50:46.7130.1 msyii\db\Command::querySELECT * FROM `redirects` WHERE `from`='/tape/index/13'
12:50:46.7720.1 msyii\db\Command::querySELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1
12:50:46.7740.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=3)
12:50:46.7500.1 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 0) AND (`discount_conditions`.`quantity_to` >= 0) AND (`discount_conditions`.`format`='previous_month') AND (`discount_status`.`type_user` IS NULL)
12:50:46.7790.1 msyii\db\Command::querySELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1
12:50:46.7510.1 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 0) AND (`discount_conditions`.`quantity_to` >= 0) AND (`discount_conditions`.`format`='previous_month') AND (`discount_status`.`type_user` IS NULL)
12:50:46.7720.1 msyii\db\Command::querySELECT * FROM `shop_prices_lang` WHERE (`language`='uk') AND (`owner_id`=1)
12:50:46.7760.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7500.1 msyii\db\Command::querySELECT `count_previous_month` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL
12:50:46.7710.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7510.1 msyii\db\Command::querySELECT `discount` FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id INNER JOIN `discount_status_lang` ON `discount_status_lang`.owner_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 139789) AND (`discount_conditions`.`quantity_to` >= 139789) AND (`discount_conditions`.`format`='moment') AND (`discount_status`.`type_user` IS NULL) AND (`discount_status_lang`.`language`='uk')
12:50:46.7520.1 msyii\db\Command::querySELECT `discount_type` FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id INNER JOIN `discount_status_lang` ON `discount_status_lang`.owner_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 139789) AND (`discount_conditions`.`quantity_to` >= 139789) AND (`discount_conditions`.`format`='moment') AND (`discount_status`.`type_user` IS NULL) AND (`discount_status_lang`.`language`='uk')
12:50:46.7780.1 msyii\db\Command::querySELECT * FROM `shop_currency_lang` WHERE `owner_id`=1
12:50:46.7520.1 msyii\db\Command::querySELECT `count_previous_twelve_months` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL
12:50:46.7500.1 msyii\db\Command::querySELECT SUM(quantity) FROM `shop_document_content` INNER JOIN `shop_document` ON `shop_document_content`.document_id=`shop_document`.id WHERE (`shop_document`.`user_id` IS NULL) AND (`shop_document`.`state_id` IS NULL)
12:50:46.7510.1 msyii\db\Command::querySELECT `count_previous_twelve_months` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL
12:50:46.7500.1 msyii\db\Command::querySELECT `id` FROM `shop_prices` WHERE `base_price`=1
12:50:46.7520.0 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 139789) AND (`discount_conditions`.`quantity_to` >= 139789) AND (`discount_conditions`.`format`='moment') AND (`discount_status`.`type_user` IS NULL)
12:50:46.7500.0 msyii\db\Command::querySELECT MAX(discount) FROM `discount_conditions` INNER JOIN `discount_status` ON `discount_conditions`.discount_status_id=`discount_status`.id WHERE (`discount_conditions`.`quantity_from` <= 0) AND (`discount_conditions`.`quantity_to` >= 0) AND (`discount_conditions`.`format`='previous_year') AND (`discount_status`.`type_user` IS NULL)
12:50:46.7500.0 msyii\db\Command::querySELECT `count_previous_twelve_months` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL