Total processing time: 124 ms; Peak memory: 8.854 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
08:13:22.516 | 3.6 ms | yii\db\Command::query | SELECT `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='ru' 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='ru' WHERE `store`.`product_id` IN ('3486', '2631', '3143', '2343', '2300', '2214', '2187', '2208', '1461', '1468', '1642', '1824') GROUP BY `opts`.`product_id`, `opts`.`attribute_id`, `opts`.`value`, `attr`.`type`, `listlang`.`title`, `list`.`color` ORDER BY `attr`.`sort_order`, `total_quantity` DESC |
08:13:22.508 | 2.7 ms | yii\db\Command::query | SELECT 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 `pv`.`product_id` AS `id`, `pv`.`created_at` AS `created_at` FROM `shop_product_views` `pv` WHERE `pv`.`session_id`='') subProductQuery ON subProductQuery.id=main.id WHERE ((`main`.`visible`=1) AND (`lang`.`language`='ru') AND (`category_lang`.`language`='ru')) AND (main.id IN (subProductQuery.id)) GROUP BY `main`.`id` ORDER BY `storeCount` DESC) `sub` |
08:13:22.511 | 2.0 ms | yii\db\Command::query | 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 `pv`.`product_id` AS `id`, `pv`.`created_at` AS `created_at` FROM `shop_product_views` `pv` WHERE `pv`.`session_id`='') subProductQuery ON subProductQuery.id=main.id WHERE ((`main`.`visible`=1) AND (`lang`.`language`='ru') AND (`category_lang`.`language`='ru')) AND (main.id IN (subProductQuery.id)) GROUP BY `main`.`id` ORDER BY `storeCount` DESC, `sort_order` LIMIT 12 |
08:13:22.591 | 1.0 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.505 | 0.9 ms | yii\db\Command::query | SELECT `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`='ru') |
08:13:22.594 | 0.8 ms | yii\db\Command::query | SELECT * 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`='1642') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.598 | 0.8 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.514 | 0.7 ms | yii\db\Command::query | SELECT `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 ('3486', '2631', '3143', '2343', '2300', '2214', '2187', '2208', '1461', '1468', '1642', '1824')) AND (`img`.`cover`=1) |
08:13:22.494 | 0.7 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;port=3306;dbname=lurex |
08:13:22.580 | 0.7 ms | yii\db\Command::query | SELECT * 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`='1461') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.528 | 0.6 ms | yii\db\Command::query | SELECT `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 ('3486', '2631', '3143', '2343', '2300', '2214', '2187', '2208', '1461', '1468', '1642', '1824')) AND (`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.573 | 0.6 ms | yii\db\Command::query | SELECT * 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`='2208') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.558 | 0.6 ms | yii\db\Command::query | SELECT * 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`='2300') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.546 | 0.6 ms | yii\db\Command::query | SELECT * 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`='3143') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.583 | 0.6 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.495 | 0.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `redirects` |
08:13:22.529 | 0.6 ms | yii\db\Command::query | SELECT `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 ('3486', '2631', '3143', '2343', '2300', '2214', '2187', '2208', '1461', '1468', '1642', '1824')) AND (`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.513 | 0.5 ms | yii\db\Command::query | SELECT SUM(quantity) AS `in_stock`, `product_id` FROM `shop_product_store` WHERE (`product_id` IN ('3486', '2631', '3143', '2343', '2300', '2214', '2187', '2208', '1461', '1468', '1642', '1824')) AND (`store_id`='1') GROUP BY `product_id` |
08:13:22.587 | 0.5 ms | yii\db\Command::query | SELECT * 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`='1468') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.502 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_product` |
08:13:22.563 | 0.5 ms | yii\db\Command::query | SELECT * 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`='2214') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.534 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_prices` |
08:13:22.520 | 0.5 ms | yii\db\Command::query | SELECT `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`='ru') AND (`main`.`product_id` IN ('3486', '2631', '3143', '2343', '2300', '2214', '2187', '2208', '1461', '1468', '1642', '1824')) ORDER BY `shc`.`sort_order` |
08:13:22.552 | 0.5 ms | yii\db\Command::query | SELECT * 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`='2343') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.524 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `promotions` |
08:13:22.540 | 0.5 ms | yii\db\Command::query | SELECT * 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`='2631') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.602 | 0.5 ms | yii\db\Command::query | SELECT * 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`='1824') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.547 | 0.4 ms | yii\db\Command::query | SELECT * 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`='3143') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.503 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_product_lang` |
08:13:22.576 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.602 | 0.4 ms | yii\db\Command::query | SELECT * 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`='1824') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.580 | 0.4 ms | yii\db\Command::query | SELECT * 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`='1461') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.574 | 0.4 ms | yii\db\Command::query | SELECT * 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`='2208') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.568 | 0.4 ms | yii\db\Command::query | SELECT * 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`='2187') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.535 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_prices_lang` |
08:13:22.558 | 0.4 ms | yii\db\Command::query | SELECT * 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`='2300') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.588 | 0.4 ms | yii\db\Command::query | SELECT * 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`='1468') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.525 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `promotions_lang` |
08:13:22.563 | 0.4 ms | yii\db\Command::query | SELECT * 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`='2214') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.497 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_currency` |
08:13:22.514 | 0.4 ms | yii\db\Command::query | SELECT `aliases`.`primaryKey`, `aliases`.`alias` FROM `aliases` `aliases` WHERE ((`aliases`.`model`='app\\modules\\shop\\models\\Product') AND (`aliases`.`redirectID`=0)) AND (`aliases`.`primaryKey` IN ('3486', '2631', '3143', '2343', '2300', '2214', '2187', '2208', '1461', '1468', '1642', '1824')) |
08:13:22.532 | 0.3 ms | yii\db\Command::query | SELECT * 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`='3486') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.568 | 0.3 ms | yii\db\Command::query | SELECT * 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`='2187') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.595 | 0.3 ms | yii\db\Command::query | SELECT * 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`='1642') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.553 | 0.3 ms | yii\db\Command::query | SELECT * 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`='2343') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.500 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_tapes` |
08:13:22.544 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.498 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_currency_lang` |
08:13:22.531 | 0.3 ms | yii\db\Command::query | SELECT * 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`='3486') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.501 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_tapes_lang` |
08:13:22.536 | 0.3 ms | yii\db\Command::query | SELECT `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' |
08:13:22.496 | 0.3 ms | yii\db\Command::query | SELECT `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' |
08:13:22.541 | 0.3 ms | yii\db\Command::query | SELECT * 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`='2631') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.524 | 0.3 ms | yii\db\Command::query | SELECT `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' |
08:13:22.525 | 0.3 ms | yii\db\Command::query | SELECT `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' |
08:13:22.535 | 0.3 ms | yii\db\Command::query | SELECT `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' |
08:13:22.584 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.496 | 0.3 ms | yii\db\Command::query | SELECT * FROM `redirects` WHERE `from`='/tape/index/1' |
08:13:22.503 | 0.2 ms | yii\db\Command::query | SELECT `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' |
08:13:22.589 | 0.2 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.498 | 0.2 ms | yii\db\Command::query | SELECT `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' |
08:13:22.502 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_tapes_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.500 | 0.2 ms | yii\db\Command::query | SELECT `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' |
08:13:22.504 | 0.2 ms | yii\db\Command::query | SELECT `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' |
08:13:22.499 | 0.2 ms | yii\db\Command::query | SELECT `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' |
08:13:22.604 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.501 | 0.2 ms | yii\db\Command::query | SELECT `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' |
08:13:22.545 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.584 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.605 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.501 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_tapes` WHERE `id`=1 |
08:13:22.603 | 0.2 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.575 | 0.2 ms | yii\db\Command::query | SELECT * 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`='2208') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.572 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.593 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.494 | 0.1 ms | yii\db\Command::query | SELECT * FROM languages WHERE visible=1 ORDER BY sort_order |
08:13:22.572 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.590 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.573 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.537 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.600 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.507 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.600 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.597 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.546 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.530 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.585 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.605 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.577 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.586 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.590 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.546 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.571 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.575 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2208') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.606 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.575 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.522 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.579 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.549 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.569 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2187') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.575 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.586 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.533 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.603 | 0.1 ms | yii\db\Command::query | SELECT * 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`='1824') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.561 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.572 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.577 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.543 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.593 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.589 | 0.1 ms | yii\db\Command::query | SELECT * 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`='1468') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.598 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.527 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.530 | 0.1 ms | yii\db\Command::query | SELECT `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`='ru' |
08:13:22.591 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.596 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.588 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.586 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.532 | 0.1 ms | yii\db\Command::query | SELECT `main`.`field_key`, `mainL`.`field_value` FROM `settings` `main` LEFT JOIN `settings_lang` `mainL` ON mainL.owner_id=main.id WHERE `mainL`.`language`='ru' |
08:13:22.594 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.504 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.526 | 0.1 ms | yii\db\Command::query | SELECT `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) |
08:13:22.531 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.548 | 0.1 ms | yii\db\Command::query | SELECT * 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`='3143') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.559 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.576 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.589 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.596 | 0.1 ms | yii\db\Command::query | SELECT * 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`='1642') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.539 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.538 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.552 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.596 | 0.1 ms | yii\db\Command::query | SELECT * 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`='1642') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.521 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.548 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.554 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.555 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.581 | 0.1 ms | yii\db\Command::query | SELECT * 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`='1461') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.582 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.527 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.597 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.598 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.549 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.554 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2343') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.587 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.603 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.550 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.578 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.578 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.606 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.526 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_document` WHERE `promotion_id`=1 |
08:13:22.560 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.596 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.534 | 0.1 ms | yii\db\Command::query | SELECT * 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`='3486') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.542 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.569 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2187') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.581 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.594 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.564 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.562 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.578 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.581 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.534 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.607 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.603 | 0.1 ms | yii\db\Command::query | SELECT * 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`='1824') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.550 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.554 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.566 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.541 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.508 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.536 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.594 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.513 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_stores` WHERE `defstore`=1 ORDER BY `sort_order` |
08:13:22.538 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.552 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.557 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.559 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.559 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2300') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.565 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.579 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.582 | 0.1 ms | yii\db\Command::query | SELECT * 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`='1461') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.551 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.554 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2343') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.557 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.531 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.564 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.570 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.551 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.560 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.548 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.552 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.564 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2214') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.566 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.582 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.531 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.550 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.565 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.589 | 0.1 ms | yii\db\Command::query | SELECT * 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`='1468') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.497 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.527 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.544 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.562 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.564 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2214') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.543 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=2 |
08:13:22.557 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.559 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2300') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.560 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.601 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.499 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.554 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.556 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.561 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.521 | 0.1 ms | yii\db\Command::query | SELECT `count_previous_month` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL |
08:13:22.555 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.556 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.565 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.570 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.569 | 0.1 ms | yii\db\Command::query | SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1 |
08:13:22.508 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.534 | 0.1 ms | yii\db\Command::query | SELECT * 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`='3486') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.538 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.542 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2631') AND (`shop_product_prices`.`price_id`='1') AND (`shop_prices_lang`.`language`='ru') |
08:13:22.562 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.601 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.548 | 0.1 ms | yii\db\Command::query | SELECT * 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`='3143') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.521 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.528 | 0.1 ms | yii\db\Command::query | SELECT SUM(quantity) FROM `shop_document_content` INNER JOIN `shop_document` ON `shop_document_content`.document_id=`shop_document`.id WHERE (`shop_document`.`session_id`='') AND (`shop_document`.`state_id` IS NULL) |
08:13:22.557 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.566 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.522 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.522 | 0.1 ms | yii\db\Command::query | SELECT `count_previous_twelve_months` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL |
08:13:22.539 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.542 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=1 |
08:13:22.601 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.521 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.527 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.561 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.563 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.540 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.541 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.542 | 0.1 ms | yii\db\Command::query | SELECT * 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`='2631') AND (`shop_product_prices`.`price_id`=1) AND (`shop_prices_lang`.`language`='ru') |
08:13:22.555 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.523 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.533 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.523 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.533 | 0.1 ms | yii\db\Command::query | SELECT `color`, `bgcolor`, `stroke_color` FROM `shop_showcases` `s` WHERE `id`=3 |
08:13:22.567 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main_in_shop`=1 |
08:13:22.570 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.507 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.526 | 0.1 ms | yii\db\Command::query | SELECT * FROM `promotions_lang` WHERE (`language`='ru') AND (`owner_id`=1) |
08:13:22.567 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.570 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=2) |
08:13:22.571 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices` WHERE `shop_prices`.`id`=3 |
08:13:22.528 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.537 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.544 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_prices_lang` WHERE (`language`='ru') AND (`owner_id`=3) |
08:13:22.579 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.540 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.523 | 0.1 ms | yii\db\Command::query | SELECT `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`='ru') |
08:13:22.567 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.567 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.499 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency` WHERE `main`=1 |
08:13:22.569 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.521 | 0.1 ms | yii\db\Command::query | SELECT `count_previous_twelve_months` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL |
08:13:22.523 | 0.1 ms | yii\db\Command::query | SELECT `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`='ru') |
08:13:22.495 | 0.1 ms | yii\db\Command::query | SELECT MAX(updated_at) FROM languages |
08:13:22.522 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.522 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.522 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.522 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.523 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.523 | 0.1 ms | yii\db\Command::query | SELECT 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) |
08:13:22.499 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1 |
08:13:22.522 | 0.1 ms | yii\db\Command::query | SELECT `count_previous_month` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL |
08:13:22.495 | 0.1 ms | yii\db\Command::query | SELECT MAX(updated_at) FROM languages |
08:13:22.500 | 0.1 ms | yii\db\Command::query | SELECT `id` FROM `shop_prices` WHERE `base_price`=1 |
08:13:22.523 | 0.0 ms | yii\db\Command::query | SELECT `count_previous_twelve_months` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL |
08:13:22.523 | 0.0 ms | yii\db\Command::query | SELECT `count_previous_month` FROM `custom_order_repository` WHERE `custom_order_repository`.`user_id` IS NULL |