GET http://chinchilldev.lufa.com/fr/superMarket/getAllProducts (AJAX) at 2025-04-11 03:56:48 by 172.19.0.1
| Time | Level | Category | Message |
|---|---|---|---|
| 15:56:45.479 | trace | system.CModule |
Loading "log" application component
|
| 15:56:45.479 | trace | system.CModule |
Loading "debug" application component
|
| 15:56:45.479 | trace | system.CModule |
Loading "request" application component
|
| 15:56:45.479 | trace | system.CModule |
Loading "urlManager" application component
|
| 15:56:45.479 | trace | system.CModule |
Loading "cache" application component
|
| 15:56:45.480 | trace | system.caching.CApcCache |
Serving "Yii.CUrlManager.rules" from cache
|
| 15:56:45.480 | trace | system.CModule |
Loading "clientScript" application component
|
| 15:56:45.481 | trace | system.db.ar.CActiveRecord |
MarketingCustomUrl.findByAttributes()
|
| 15:56:45.481 | trace | system.CModule |
Loading "db" application component
|
| 15:56:45.481 | trace | system.db.CDbConnection |
Opening DB connection
|
| 15:56:45.489 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `marketing_custom_urls`
|
| 15:56:45.491 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `marketing_custom_urls`
|
| 15:56:45.492 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
|
| 15:56:45.494 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `marketing_campaign_referrals`
|
| 15:56:45.495 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`marketing_custom_url_id` AS `t0_c0`, `t`.`marketing_campaign_referral_id` AS `t0_c1`, `t`.`url` AS `t0_c2`, `t`.`target_url` AS `t0_c3`, `campaign_referral`.`marketing_campaign_referral_id` AS `t1_c0`, `campaign_referral`.`name` AS `t1_c1` FROM `marketing_custom_urls` `t` LEFT OUTER JOIN `marketing_campaign_referrals` `campaign_referral` ON (`campaign_referral`.`marketing_campaign_referral_id`=`t`.`marketing_custom_url_id`) WHERE (`t`.`url`=:yp0). Bound with :yp0='getallproducts'
|
| 15:56:45.495 | trace | system.CModule |
Loading "user" application component
|
| 15:56:45.496 | trace | system.CModule |
Loading "session" application component
|
| 15:56:45.496 | trace | system.db.CDbCommand |
Querying SQL: SELECT `data`
FROM `user_session` WHERE expire>:expire AND id=:id. Bound with :expire=1744401405, :id='j1pgdt1s23fu8bm56imgsupqln'
|
| 15:56:45.497 | trace | ext.localeurls |
Detected language 'fr'
|
| 15:56:45.497 | trace | system.CModule |
Loading "messages" application component
|
| 15:56:45.498 | trace | system.CModule |
Loading "redis" application component
|
| 15:56:45.499 | trace | system.db.CDbCommand |
Querying SQL: SELECT
q.user_notification_message_queue_id, q.session_clicks, n.notification_messages_id, n.start_date, n.end_date, n.created_at, n.status, IF (:lang = "fr", n.desktop_collapsed_message, n_l.l_desktop_collapsed_message) as desktop_collapsed_message, IF (:lang = "fr", n.mobile_collapsed_message, n_l.l_mobile_collapsed_message) as mobile_collapsed_message, IF (:lang = "fr", n.title, n_l.l_title) as title, IF (:lang = "fr", n.content, n_l.content) as content, CONCAT("/images/notificationMessages/", n.icon) as icon, :lang as lang, 0 as :session_id FROM user_notification_message_queue q INNER JOIN notification_messages n ON n.notification_messages_id = q.notification_messages_id INNER JOIN notification_messages_lang n_l ON n_l.notification_messages_id = n.notification_messages_id WHERE q.user_id = :user_id AND n.status = :STATUS_LIVE AND q.session_clicks < 2. Bound with :user_id=NULL, :STATUS_LIVE=2, :lang='fr', :session_id='j1pgdt1s23fu8bm56imgsupqln'
|
| 15:56:45.500 | trace | system.web.filters.CFilterChain |
Running filter SuperMarketController.filterHttpsOnly()
|
| 15:56:45.502 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `securelufacom`.`users`
|
| 15:56:45.506 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `securelufacom`.`users`
|
| 15:56:45.509 | trace | system.db.ar.CActiveRecord |
Users.findByPk()
|
| 15:56:45.509 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
|
| 15:56:45.510 | trace | system.db.CDbCommand |
Querying SQL: SELECT child
FROM authitemchild WHERE parent = 'default_guest'
|
| 15:56:45.511 | trace | system.db.ar.CActiveRecord |
Orders.findByPk()
|
| 15:56:45.511 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `orders`
|
| 15:56:45.514 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `orders`
|
| 15:56:45.516 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `orders` `t` WHERE `t`.`order_id`=0 LIMIT 1
|
| 15:56:45.517 | trace | system.db.CDbCommand |
Querying SQL: SELECT DISTINCT(hd_product_id) FROM droppoints WHERE hd_product_id IS NOT NULL
|
| 15:56:45.517 | trace | system.CModule |
Loading "OrderHelper" application component
|
| 15:56:45.517 | trace | system.db.CDbCommand |
Querying SQL: SELECT p.* FROM products p, marketplace_gifts_settings mgs WHERE mgs.delivery_date = :date AND mgs.gift_preferences_id = :gpid AND p.product_id = mgs.product_id AND p.gift = 1 AND p.unlocked_above > 0. Bound with :date='2025-04-12', :gpid=-1
|
| 15:56:45.519 | trace | system.db.CDbCommand |
Querying SQL: SELECT
pul.*, c.product_id AS coupon_free_product_id FROM promo_users_log pul LEFT JOIN coupons c ON (c.coupon_id = pul.coupon_id) WHERE pul.user_id = :user_id ORDER BY pul.promo_users_log_id DESC LIMIT 1. Bound with :user_id=0
|
| 15:56:45.520 | trace | system.db.ar.CActiveRecord |
Users.findByPk()
|
| 15:56:45.520 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=-1 LIMIT 1
|
| 15:56:45.521 | trace | system.CModule |
Loading "rodb" application component
|
| 15:56:45.521 | trace | system.db.CDbConnection |
Opening DB connection
|
| 15:56:45.529 | trace | system.db.CDbCommand |
Querying SQL: SELECT
p.product_id as p_id, p.gift, p.alcohol, p.status as product_status, p.portion_in_biso, SUM(IF(p.is_organic = 1 AND sc.certification_id = :is_organic, 1, 0)) as is_organic, SUM(IF(p.is_organic_USDA = 1 AND sc.certification_id = :is_organic_USDA, 1, 0)) as is_organic_USDA, SUM(IF(p.is_scs_certified = 1 AND sc.certification_id = :is_scs_certified, 1, 0)) as is_scs_certified, p.conservation_mode_in_basket as b_con, p.visible_on_marketplace as vis, CONVERT(TRUNCATE(pi.default_price, 2 ),DECIMAL(7,2)) as price, /* pi.default_price as price, */ p.units, p.unit_of_measure as unit, IF(p.trial_product = 0, pi.is_new, 0) as is_new, pi.is_featured AS featured, pi.super_featured, pi.products_inventory_is_top_new AS is_top_new, p.trial_product as is_trial_product, IF(p.product_id = :TOTE OR p.product_id = :SUPER_TOTE, 1, 0) AS is_free_tote, IF(p.nutritional_values_status = :nutrional_status_published, 1, IF(p_n_v_g_b_a.product_id IS NOT NULL, 2, NULL)) AS nutrional_status_published, p.name AS p_name, sub.name AS sub_na, cat.name AS cat_na, sp.name AS s_name, pdr.description as d_des, IFNULL(mpt.marketplace_product_tag_card_label_fr, "") AS card_tag, p.supplier_id as s_id, p.image_url AS image_url, IF(pi.super_featured = 1 AND p.super_aubaines_image_url IS NOT NULL, p.super_aubaines_image_url, 0) AS super_aubaines_image_url, attributes.attr, IFNULL(his_favorites.favorite, 0) AS favorite_product, IF(in_his_basket.defined_retail_price_per_unit_for_default_weight = 0 OR in_his_basket.defined_retail_price_per_unit_for_default_weight IS NULL, CONVERT(TRUNCATE(pi.current_price, 2 ),DECIMAL(7,2)), CONVERT(TRUNCATE(in_his_basket.defined_retail_price_per_unit_for_default_weight, 2), DECIMAL(7,2)) ) AS current_price, p.weight, p.is_customizable, p.charge_by_weight as c_wei, IF(cat.category_id IN (272, 270) AND p.conservation_mode_in_basket IN (0,1), 1, 0) as rinse, p.group_type, cat.category_id, sub.subcategory_id, IFNULL(mp.average, sp.average) as avg_r, IFNULL(mcom.comment_count, scom.comment_count) as c_cou,ROUND(p.average_price_quantity/p.weight*IFNULL(in_his_basket.defined_retail_price_per_unit_for_default_weight,pi.current_price),2) as avg_p_p, /* ROUND(p.average_price_quantity/p.weight*IFNULL(in_his_basket.defined_retail_price_per_unit_for_default_weight,pi.current_price),2) as avg_p_p, */ ROUND(p.average_price_quantity/p.weight*p.price,2) as avg_p_p_r, p.average_price_quantity as avg_p_q, apu.average_price_unit as avg_p_u, COUNT(DISTINCT in_his_basket.order_details_id) as nbr_in_basket, product_families.families AS t1, supplier_families.families AS t2, subcategory_families.families AS t3, category_families.families AS t4, Concat(false) AS inBasket, child.sub_products, base.default_quantity, CASE WHEN r_prod.recipe_id IS NOT NULL THEN 1 ELSE 0 END AS bool_is_in_recipe FROM products AS p LEFT JOIN suppliers_certifications sc ON sc.supplier_id = p.supplier_id AND sc.status = :STATUS_ACTIVE LEFT JOIN ( SELECT od.product_id, od.defined_retail_price_per_unit_for_default_weight, od.order_details_id FROM order_details od WHERE od.order_id = :order_id GROUP BY od.product_id ) in_his_basket ON (in_his_basket.product_id = p.product_id) LEFT JOIN ( SELECT product_id FROM products_nutritional_values_generated_by_ai GROUP BY product_id ) p_n_v_g_b_a ON (p_n_v_g_b_a.product_id = p.product_id) LEFT JOIN ( SELECT recipeIngredients.recipe_id, recipeIngredients.product_id FROM recipeIngredients INNER JOIN products ON (products.product_id = recipeIngredients.product_id AND products.status = 1) WHERE recipe_id IN (SELECT recipe_id FROM recipes WHERE status = 1) ) as r_prod ON r_prod.product_id = p.product_id INNER JOIN suppliers AS sp ON p.supplier_id = sp.supplier_id INNER JOIN products_inventory AS pi ON (pi.product_id = p.product_id AND pi.inventory_date = :date AND (pi.quantity > 0 OR p.group_type = 1 OR in_his_basket.product_id > 0 OR r_prod.recipe_id > 0 OR p.product_id IN (3210,3211,11177,12218,12219,12220,12221,12222,12223,12224,12225,12226,12227,12228,12233,12234,12235,12237,12238,12241,12242,12243,12244,12245,12246,13078,15659,16517,16518,16519,16974,16975,16976,19121, :gift, :promo_gift))) LEFT JOIN product_discount_reasons pdr ON pdr.product_discount_reason_id = pi.product_discount_reason_id LEFT JOIN productSubSubCategories subsub ON subsub.sub_sub_id = p.sub_sub_id LEFT JOIN productSubCategories sub ON sub.subcategory_id = subsub.subcategory_id LEFT JOIN product_categories cat ON cat.category_id = sub.category_id LEFT JOIN average_price_units apu ON apu.average_price_unit_id = p.average_price_unit_id LEFT OUTER JOIN productsLang AS pl ON p.product_id = pl.product_id LEFT JOIN productSubCategoriesLang subLang ON subLang.subcategory_id = sub.subcategory_id LEFT JOIN productCategoriesLang catLang ON catLang.category_id = cat.category_id INNER JOIN suppliersLang AS spLang ON sp.supplier_id = spLang.supplier_id LEFT JOIN product_discount_reasonsLang pdrl ON pdrl.product_discount_reason_id = pdr.product_discount_reason_id AND pdrl.lang_id = :lang LEFT JOIN ( SELECT product_id, if('fr' = :lang,GROUP_CONCAT(mf.title separator ';'),GROUP_CONCAT(mfLang.l_title separator ';')) AS families FROM marketplace_family_product mfp LEFT JOIN marketplace_families mf ON mf.marketplace_family_id = mfp.marketplace_family_id AND mf.title != '' LEFT JOIN marketplace_families_lang mfLang ON mf.marketplace_family_id = mfLang.marketplace_family_id WHERE mf.status = 1 GROUP BY mfp.product_id ) product_families ON product_families.product_id = p.product_id LEFT JOIN ( SELECT supplier_id, if('fr' = :lang,GROUP_CONCAT(mf.title separator ';'),GROUP_CONCAT(mfLang.l_title separator ';')) as families FROM marketplace_family_supplier mfs LEFT JOIN marketplace_families mf ON mf.marketplace_family_id = mfs.marketplace_family_id AND mf.title != '' LEFT JOIN marketplace_families_lang mfLang ON mf.marketplace_family_id = mfLang.marketplace_family_id WHERE mf.status = 1 GROUP BY mfs.supplier_id ) supplier_families ON supplier_families.supplier_id = p.supplier_id LEFT JOIN ( SELECT subcategory_id, if('fr' = :lang,GROUP_CONCAT(mf.title separator ';'),GROUP_CONCAT(mfLang.l_title separator ';')) AS families FROM marketplace_family_subcategory mfsc LEFT JOIN marketplace_families mf ON mf.marketplace_family_id = mfsc.marketplace_family_id AND mf.title != '' LEFT JOIN marketplace_families_lang mfLang ON mf.marketplace_family_id = mfLang.marketplace_family_id WHERE mf.status = 1 GROUP BY mfsc.subcategory_id ) subcategory_families ON subcategory_families.subcategory_id = subsub.subcategory_id LEFT JOIN ( SELECT category_id, if('fr' = :lang,GROUP_CONCAT(mf.title separator ';'),GROUP_CONCAT(mfLang.l_title separator ';')) AS families FROM marketplace_family_category mfc LEFT JOIN marketplace_families mf ON mf.marketplace_family_id = mfc.marketplace_family_id AND mf.title != '' LEFT JOIN marketplace_families_lang mfLang ON mf.marketplace_family_id = mfLang.marketplace_family_id WHERE mf.status = 1 GROUP BY mfc.category_id ) category_families ON category_families.category_id = sub.category_id LEFT JOIN ( SELECT product_id, 1 AS favorite FROM favorites WHERE user_id = :user_id ) as his_favorites ON his_favorites.product_id = p.product_id LEFT JOIN (SELECT product_id, ROUND(AVG(rating),0) AS average FROM product_user_ratings pur INNER JOIN (SELECT owner_id, user_id, status, parent_comment_id FROM user_comments) uc ON (pur.user_id = uc.user_id AND pur.product_id = uc.owner_id) WHERE pur.updated_at >= SUBDATE(CURDATE(), INTERVAL 180 DAY) AND uc.status = 1 AND IFNULL(uc.parent_comment_id, 0) = 0 GROUP BY product_id ) sp ON (sp.product_id = p.product_id) LEFT JOIN (SELECT product_group_relations.parent_id, ROUND(AVG(rating),0) AS average FROM (SELECT pur.*, uc.status, uc.parent_comment_id FROM product_user_ratings pur INNER JOIN (SELECT owner_id, user_id, status, parent_comment_id FROM user_comments) uc ON (pur.user_id = uc.user_id AND pur.product_id = uc.owner_id)) inter JOIN product_group_relations ON (product_group_relations.child_id = inter.product_id) WHERE inter.updated_at >= SUBDATE(CURDATE(), INTERVAL 180 DAY) AND inter.status = 1 AND IFNULL(inter.parent_comment_id, 0) = 0 GROUP BY product_group_relations.parent_id ) mp ON (mp.parent_id = p.product_id) LEFT JOIN (SELECT owner_id, COUNT(*) AS comment_count FROM user_comments WHERE `owner_name` = 'Product' AND status = 1 GROUP BY owner_id ) scom ON (scom.owner_id = p.product_id) LEFT JOIN (SELECT product_group_relations.parent_id, GROUP_CONCAT(product_group_relations.child_id ORDER BY CAST(sortedchildrenbyweight.weight AS unsigned), sortedchildrenbyweight.name separator ';') AS sub_products FROM product_group_relations LEFT JOIN (SELECT product_id, weight, name FROM products ORDER BY weight ASC) AS sortedchildrenbyweight ON (sortedchildrenbyweight.product_id = product_group_relations.child_id) GROUP BY product_group_relations.parent_id ) as child ON child.parent_id = p.product_id LEFT JOIN (SELECT product_group_relations.parent_id, COUNT(*) AS comment_count FROM user_comments JOIN product_group_relations ON product_group_relations.child_id = user_comments.owner_id WHERE `owner_name` = 'Product' AND status = 1 GROUP BY product_group_relations.parent_id ) mcom ON (mcom.parent_id = p.product_id) LEFT JOIN marketplace_product_tag mpt ON (mpt.marketplace_product_tag_product_id = p.product_id AND :date BETWEEN mpt.marketplace_product_tag_start_date AND mpt.marketplace_product_tag_end_date) LEFT JOIN ( SELECT product_id, default_quantity, basket_design_id FROM basket_design_product_availability WHERE basket_design_id IN (SELECT basket_design_id FROM orders WHERE order_id = :order_id) AND default_quantity > 0 ) base ON base.product_id = p.product_id LEFT JOIN basket_designs bs ON bs.basket_design_id = base.basket_design_id LEFT JOIN (SELECT product_id,GROUP_CONCAT(attribute_value,'##',attribute_name separator '|') AS attr FROM product_attributes pa GROUP by product_id ) as attributes ON attributes.product_id = p.product_id WHERE (p.trial_product = 0 OR bs.basket_id = :TRIAL_BASKETS_ID) AND p.preference_restriction IN (:no_restrict,:user_restrict) AND p.restricted_to_lufa IN (0) AND (p.status = 1 OR (p.status = 0 AND p.gift = 1)) OR in_his_basket.product_id > 0 OR r_prod.recipe_id > 0 OR p.product_id IN (3210,3211,11177,12218,12219,12220,12221,12222,12223,12224,12225,12226,12227,12228,12233,12234,12235,12237,12238,12241,12242,12243,12244,12245,12246,13078,15659,16517,16518,16519,16974,16975,16976,19121, :gift, :promo_gift) GROUP BY p.product_id ORDER BY cat.weight ASC, sub.weight ASC, subsub.weight ASC,sp.weight DESC, p.name. Bound with :user_id=-1, :no_restrict='All markets', :user_restrict='Vegan', :lang='fr', :date='2025-04-12', :order_id=0, :gift=0, :promo_gift=0, :veg_cat=272, :is_organic=1, :is_organic_USDA=2, :is_scs_certified=3, :fruit_cat=270, :nutrional_status_published=4, :TOTE=7386, :SUPER_TOTE=12230, :STATUS_ACTIVE=1, :TRIAL_BASKETS_ID=10
|
| 15:56:46.728 | trace | system.CModule |
Loading "s3images" application component
|
| 15:56:46.728 | trace | system.CModule |
Loading "Global" application component
|
| 15:56:46.728 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `securelufacom`.`products`
|
| 15:56:46.734 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `securelufacom`.`products`
|
| 15:56:46.859 | trace | system.db.CDbCommand |
Querying SQL: SELECT
s.supplier_id, if('fr' = :lang,s.name, sLang.l_name) as name, if('fr' = :lang,s.description, sLang.l_description) as description, re.*, IFNULL(si.images, '80_supplier-placeholder-2018.png') AS image_url, supplier_rating.rating AS suppl_rating FROM suppliers s LEFT JOIN regions re ON (re.region_id = s.region_id) LEFT JOIN suppliersLang sLang ON sLang.supplier_id = s.supplier_id LEFT JOIN (SELECT supplier_id, GROUP_CONCAT(image_url) as images FROM supplier_images GROUP BY supplier_id) si ON (si.supplier_id = s.supplier_id) LEFT JOIN ( SELECT ROUND(AVG(rating), 0) rating, p.supplier_id FROM (SELECT pur.*, uc.status, uc.parent_comment_id FROM product_user_ratings pur INNER JOIN (SELECT owner_id, user_id, status, parent_comment_id FROM user_comments) uc ON (pur.user_id = uc.user_id AND pur.product_id = uc.owner_id)) inter INNER JOIN products p ON inter.product_id = p.product_id WHERE p.status = 1 AND inter.updated_at BETWEEN SUBDATE(NOW(), INTERVAL :period DAY) AND NOW() AND inter.status = 1 AND IFNULL(inter.parent_comment_id, 0) = 0 GROUP BY p.supplier_id ) AS supplier_rating ON (supplier_rating.supplier_id = s.supplier_id) WHERE s.supplier_id IN (376, 972, 597, 737, 326, 525, 113, 893, 956, 58, 594, 823, 689, 922, 177, 1, 587, 1018, 284, 277, 61, 40, 70, 625, 297, 659, 1033, 1032, 400, 445, 616, 875, 963, 555, 426, 274, 622, 76, 334, 859, 860, 920, 729, 181, 155, 695, 979, 75, 54, 116, 701, 904, 987, 1037, 1035, 977, 971, 974, 1014, 736, 790, 957, 504, 927, 905, 879, 682, 469, 700, 495, 999, 453, 458, 487, 499, 481, 611, 352, 347, 510, 500, 292, 969, 324, 207, 861, 772, 886, 603, 665, 257, 776, 789, 895, 873, 712, 883, 745, 602, 220, 409, 563, 621, 890, 423, 1015, 766, 764, 342, 1041, 670, 765, 143, 627, 147, 660, 569, 661, 1028, 502, 548, 222, 939, 536, 290, 959, 259, 961, 393, 223, 512, 967, 731, 947, 983, 986, 1025, 644, 609, 728, 243, 229, 1039, 450, 578, 788, 677, 511, 540, 244, 851, 330, 1038, 227, 554, 630, 1044, 325, 262, 596, 824, 279, 586, 1019, 626, 600, 725, 615, 218, 234, 1010, 524, 658, 945, 1023, 1034, 898, 888, 230, 918, 1017, 278, 247, 575, 673, 878, 521, 129, 553, 265, 339, 199, 925, 329, 432, 1045, 498, 133, 441, 579, 849, 657, 48, 1027, 149, 533, 1043, 858, 560, 165, 1048, 1022, 710, 576, 1026, 179, 248, 249, 338, 795, 938, 496, 507, 604, 868, 196, 566, 943, 976, 857, 368, 305, 866, 272, 693, 706, 72, 1016, 718, 537, 428, 709, 877, 585, 962, 286, 154, 194, 629, 847, 412, 740, 584, 639, 652, 643, 1011, 641, 773, 651, 1012, 1002, 1009, 1030, 988, 676, 647, 856, 708, 719, 842, 808, 648, 965, 680, 739, 529, 735, 948, 1020, 769, 928, 1029, 1021, 923, 505, 448, 942, 926, 996, 558, 144, 800, 852, 985, 478, 799, 802, 980, 567, 1013, 591, 1036, 490, 702, 699, 946, 688, 543, 599, 559, 492, 1008, 964, 990, 1007, 460, 876, 978, 515, 724, 534, 255, 863, 65, 771, 975, 887, 993, 590, 240, 703, 572, 698, 197, 574, 583, 997, 516, 825, 981, 891, 506, 960, 550, 989, 440, 913, 253, 750, 994, 96, 405, 541, 402, 1040, 417, 398, 394, 1047, 944, 475, 872) . Bound with :lang='fr', :period=180
|
| 15:56:47.002 | trace | system.db.CDbCommand |
Querying SQL: SELECT
Calendar_Date d FROM Dim_Date WHERE Calendar_Date BETWEEN SUBDATE(:today, INTERVAL 2 DAY) AND DATE_ADD(:today, INTERVAL 6 DAY) GROUP BY Calendar_Date. Bound with :today='2025-04-11'
|
| 15:56:47.004 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `baskets`
|
| 15:56:47.008 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `baskets`
|
| 15:56:47.010 | trace | system.db.CDbCommand |
Querying SQL: SELECT
basket_id FROM baskets WHERE in_use = 1
|
| 15:56:47.011 | trace | system.db.CDbCommand |
Querying SQL: SELECT
p.product_id, p.release_rate, p.gift_certificate, p.gift, p.alcohol, p.weight, p.conservation_mode_in_basket, p.purchasing_price, (ROUND(((p.price-p.purchasing_price)/p.price)*100, 2)) AS margin, p.price, p.volume, p.units, p.apply_national_tax, p.apply_provincial_tax, p.name, pl.l_name as name_en, p.supplier_id, ssc.subcategory_id, ssc.sub_sub_id, ssc.name AS sub_sub_name, p.group_type, sc.name as subcategory_name_fr, scl.l_name as subcategory_name_en, sc.category_id, p.image_url, IFNULL(slang.l_name,s.name) as supplier_name, p.trial_product, pi.is_dp_disabled, p.dynamic_pricing, p.supplier_product_name FROM products as p LEFT OUTER JOIN productsLang as pl ON p.product_id = pl.product_id AND pl.lang_id = "en" LEFT OUTER JOIN productSubSubCategories as ssc ON ssc.sub_sub_id = p.sub_sub_id LEFT OUTER JOIN productSubCategories as sc ON ssc.subcategory_id = sc.subcategory_id LEFT OUTER JOIN productSubCategoriesLang as scl ON sc.subcategory_id = scl.subcategory_id LEFT JOIN (SELECT product_id, is_dp_disabled FROM products_inventory WHERE inventory_date = :date) AS pi ON pi.product_id = p.product_id INNER JOIN suppliers s ON s.supplier_id = p.supplier_id LEFT JOIN suppliersLang slang ON slang.supplier_id = s.supplier_id AND slang.lang_id = "fr" WHERE 1=1 AND p.product_id IN (18979,18976,18975,17401,17435,17399,17402,18516,18597,19236,19257,19255,17396,17433,13762,19258,19253,19237,19259,19256,9264,14701,17823,17856,13761,13758,13759,17398,17436,9723,17092,16636,16041,18475,18499,17951,16656,18476,18498,18921,18922,16627,18079,18080,18254,18293,18341,16035,16036,16037,16034,17682,17775,17683,17773,18342,17830,17831,17832,17827,17858,17835,16038,17834,16033,18515,18997,18138,18996,19022,5964,17112,18580,5966,18953,18247,18746,18775,18536,18918,18757,18782,18774,18831,18830,18807,18992,17502,18779,18811,18781,18784,15586,16132,6010,16662,54,17943,14442,15453,18958,18833,18748,17008,17161,18686,16810,16378,17614,16811,18917,18309,18581,18640,18174,18633,13262,16743,5609,9409,15559,15585,16020,16835,1114,19231,18703,18706,18705,17153,17360,17359,5776,17445,17444,13563,17472,17216,17701,17699,17700,6788,17447,17446,15398,17814,19016,19017,2061,19014,19015,15747,15748,11646,16257,16837,16836,6801,19012,19013,11226,13279,18304,19123,13791,19072,19130,19073,7140,19286,15156,11995,17199,11994,1945,17250,17252,18281,12289,18187,12983,12296,17921,18188,12293,18211,12292,12290,17922,18189,12067,18190,12294,12291,18212,19029,18213,18214,18282,14306,2060,14223,17601,14662,18994,15102,7428,12104,18943,6897,18941,18942,1204,2526,12105,17799,18525,17820,17821,18816,18356,9546,11825,12109,11940,11192,13097,19011,5791,18892,18256,17186,13275,17992,18634,15752,16302,13251,15751,13299,9658,11344,13450,2695,2181,2738,7923,16932,18981,18450,19077,15520,16814,18579,17018,11300,17743,17741,10414,10413,3725,18875,18876,19281,11753,19282,18915,18913,18914,13497,17744,17742,11301,15336,17739,10410,15335,10409,6569,6677,14219,14220,12395,17051,9650,6654,11508,16981,18345,9525,11424,15802,18559,9435,16865,16965,13703,5712,935,6042,17854,19003,12103,12154,7995,17255,7994,18359,235,3485,12102,16957,19008,5960,3669,5696,19007,7177,3668,18952,18956,11908,17654,244,12094,7354,11259,12531,18360,18361,18362,50,12176,40,11894,16355,48,18608,17565,6288,18595,17697,18684,7444,7047,17365,43,17836,17941,12260,17944,12962,12961,17948,17942,12963,17939,13772,12538,12640,12988,14064,12537,13879,12536,12964,18379,17940,12965,12966,18365,13921,17945,12990,12775,17946,2597,8853,4675,304,6109,9686,11990,9892,4413,301,4414,544,18963,18960,18962,914,4605,915,920,9712,7122,15542,15526,15549,15550,15546,15545,15547,16299,19044,14762,16477,17859,17860,16476,6729,1427,12850,17863,13833,15428,7880,14360,15430,5841,11563,15315,13834,15292,5793,8072,15365,15437,18605,13998,13854,15431,9800,18646,16322,5843,11706,10562,17034,6803,17016,10560,9579,12002,11784,15764,10559,13835,15314,15459,17253,7877,11786,17240,17817,12959,12960,17756,18126,18128,19140,19175,19141,19143,17865,18758,17844,17926,18186,17721,17871,18881,18965,18999,19066,18730,18823,18985,14760,18181,18182,18183,18185,18177,18178,18179,18180,18766,18512,17738,18032,18314,8925,17796,8922,8928,8926,19189,19078,18988,19182,16884,17344,17718,18731,19174,19173,16883,17346,16443,17345,18959,17461,14293,18839,18840,13881,18925,19138,17670,18763,18968,18034,18035,18251,18275,18277,18546,18276,13756,18837,14213,17672,18877,18897,17671,13757,18838,13882,18842,14294,14291,19241,18545,17841,17843,17900,17901,17902,17904,17906,18511,14327,14071,15300,3690,13995,3692,9736,18794,9737,13794,6599,14212,13929,15907,12719,8413,14841,17923,8820,18557,18601,18556,7753,7679,8575,15064,18632,8998,13073,10084,16706,10235,14825,14824,19169,14044,14045,14046,13507,5237,14987,12198,10464,14409,11142,8326,9093,10156,10693,10613,12000,11985,12967,5194,16755,5376,5239,12004,16391,16854,16852,16423,8690,9699,5604,17224,16949,8687,12184,18860,9700,7750,10920,10918,9893,11869,9895,16896,16705,16824,16827,17640,17641,4206,19254,17635,15939,11478,10745,4203,4204,16958,15623,14400,16086,17931,11124,17688,12399,15619,17883,12553,17882,11479,4231,15639,17885,17884,12500,12502,15607,17879,17880,17932,17693,10746,4211,4228,17997,17689,10749,9966,17710,17692,17711,17733,10748,4278,4288,17894,17898,17430,11315,17998,17806,17808,17748,17145,17747,4339,17895,17896,17280,15621,15720,15620,12185,17746,11601,4335,15622,11815,14159,17881,11276,17675,10254,4282,11092,16747,12100,14167,17897,6362,13626,17996,18099,18102,16645,17429,18059,18058,18057,12743,17600,10917,4289,4285,11204,14363,9960,13766,9959,15289,14356,15957,17508,3501,3502,3499,3500,16961,16967,2231,5693,4685,2331,2093,18023,18335,18338,18334,18328,19179,18768,17012,17509,16563,19180,17011,16142,16141,19181,16710,15769,10056,9956,17994,17993,17995,16140,17048,15592,15593,4437,14461,18240,18239,15981,15977,16513,14611,16096,3498,13368,13712,13681,13844,13409,14528,18850,17899,5039,13765,17233,7818,16418,13813,7128,16426,13812,7820,11834,11840,11871,16850,17428,7129,5043,5047,11776,11777,11870,5171,18517,5157,16422,7822,13853,7130,17178,17510,16412,9487,12644,13814,7136,13410,16415,5164,7137,13852,5168,17886,13851,7138,5207,5208,5205,5240,16216,18003,11243,15631,18004,16398,16265,16215,16218,5294,5213,5219,17180,17181,17182,12532,19252,18219,4321,13333,13334,17084,12927,13736,13745,17557,10770,6122,12929,16676,18347,19170,18422,10771,14719,18111,17628,17624,18955,13619,13624,12614,18348,18350,13424,15947,18351,19057,13423,4322,13622,18786,18867,18920,8004,8005,8006,8007,7308,7279,7281,17387,17384,7309,7307,15061,7310,7280,11409,17659,17664,18750,15972,15975,15976,17610,16694,17642,15982,18554,10747,4325,4363,4361,4367,11091,4320,13323,13324,18025,17677,17143,17144,4346,12503,17142,14146,14147,15569,16555,2369,13676,18614,11353,2288,18966,2153,14530,13172,16137,14717,17809,14713,14715,16129,13181,16393,13674,18615,11354,16553,14460,18949,15669,16509,16128,15560,15556,15558,14786,2094,7530,17391,15561,14718,13965,15694,16002,13190,16101,13189,13187,13188,14716,13184,13297,13911,11270,11268,11272,11269,18002,18001,19178,14180,14826,14527,17668,16450,15221,13193,13191,15223,15219,18593,18216,15984,13194,15199,17075,13195,13196,13815,15973,19229,19223,19225,19227,19226,19228,19224,17230,17231,17228,14725,15821,14729,14728,14349,13691,14337,18407,18409,14348,14727,18406,17236,17234,12393,1744,14986,1743,1431,15573,14439,14437,10580,10578,10575,10572,10579,10573,4486,9772,7353,15554,15551,15555,10577,10576,14023,10586,3052,4539,1525,16457,8356,13818,12439,13378,13718,13722,5071,19053,2563,16109,10583,10582,4743,19054,9145,10584,10585,15548,5922,10332,13739,15562,7357,6021,6089,16235,16690,10337,10849,13485,13331,19006,19009,19010,19069,14079,16599,10202,11357,11360,10203,11358,11363,10204,11359,11364,16250,16100,16251,12270,12271,12274,12190,12269,12272,12191,12273,13829,12192,2355,2356,5631,2353,2354,4520,2351,2352,4521,2349,2350,5630,17091,17293,10398,12283,10201,4261,4262,12810,2357,2370,5632,13996,18528,18532,18529,10400,12282,12504,12505,12809,18533,18534,13675,13015,18930,11952,9012,17554,5688,13803,2917,17928,5540,4450,9921,8788,6223,9924,9923,11593,8733,11592,6797,5547,3617,6799,13355,13359,6798,2364,2363,18531,18530,4449,9918,8674,8673,8789,11171,11170,10119,17608,17607,16252,16644,17949,13707,13708,15517,13741,18535,17282,17290,17285,17952,17954,17956,18061,17284,17286,17953,17955,17957,18062,2362,13354,13357,13358,10205,3622,3623,17493,14333,10206,2358,2359,5633,17451,17450,17452,19065,12120,18541,18540,11220,14197,12009,18542,15366,12010,19148,9908,9909,9910,12722,16941,16971,6873,12307,12308,17969,19149,18523,19150,17960,17970,17973,10704,17971,17961,17974,12442,17962,10705,19151,16486,4583,12475,10706,16485,9911,9914,17983,18991,16504,17964,10943,18967,6877,12558,12559,17958,17968,16313,17168,17416,9578,13182,17963,17972,17975,17980,17981,10074,11215,11216,12999,10510,14332,17130,15407,14706,14705,10938,15404,15405,15403,16491,16492,12721,16481,16487,12720,16483,10941,16489,10940,16484,16490,12676,16482,16488,4533,4584,4589,9120,9119,15090,2697,4529,17988,17976,11217,10939,10942,17965,17966,17967,17990,17959,19128,19127,19129,17169,17170,9121,17412,9577,8341,2406,10396,10397,11729,13709,13754,13602,13710,10700,10701,19238,19162,7774,12313,12319,17350,18271,7775,10177,10207,17492,9118,4386,4387,17987,17977,2982,9135,4332,9134,4379,15989,9129,15058,15067,15053,13050,16587,13087,13085,10987,15101,16643,9117,3587,17606,3590,9116,3209,10895,8945,10609,13183,13228,18957,11903,11665,11551,11664,12608,11475,12426,14006,13403,19068,15589,11413,15516,17424,15515,2381,14136,5831,2439,18815,18818,2440,18780,18449,17172,12356,13827,16653,13845,17225,17223,17226,15382,13706,13599,19026,19027,19025,14420,16016,13719,18448,14189,12894,13601,10124,10736,14078,12112,10053,16019,19206,19207,19212,14135,17342,14132,17171,14137,17408,16114,16115,17341,14872,16064,17495,13627,16097,16099,16123,16122,2380,18950,17117,16821,15992,16899,17033,3794,3792,2573,2572,15968,16738,15954,16897,16820,14005,18443,18440,18715,18710,18423,18714,18709,18424,18713,18708,4373,11853,4371,4375,17366,5215,19145,16247,16248,6200,11640,6198,6196,13641,6880,18312,18372,11529,13915,13763,17622,19144,18924,16291,13689,18373,6265,16110,16111,17339,16112,17340,17190,17189,17449,17046,16802,3215,10522,14456,3323,3216,10668,3220,3222,3243,5646,3237,3318,3322,2714,2711,3336,3236,2709,3231,3313,2710,3230,3385,3235,3329,3240,12345,3309,3241,3239,3326,3335,14190,17177,16691,14191,16692,15503,8420,14192,19168,15507,16332,12585,17348,15498,17485,12746,12338,16671,3352,12353,12337,9227,3351,12748,17487,10667,12471,1121,11027,11028,1140,8669,1120,17022,8670,1139,12326,1122,2427,8445,12491,10834,11280,10275,12871,17581,17577,17578,17576,17060,3002,11279,10274,12767,5707,11029,2755,4226,16238,2754,11339,6151,2026,18400,6150,6121,16408,16402,16410,18446,6074,16399,16411,16414,16944,16406,16239,2756,2939,6072,18751,10662,10663,10664,10848,14491,7337,5185,15148,16673,4455,17488,10759,10137,9149,9448,7439,9416,3264,9436,9417,8708,9150,7447,3262,9449,9438,9439,8710,12533,15895,12445,3386,11024,15901,12444,3387,16124,11025,17244,16125,3253,13414,3373,18313,3374,19167,19165,19166,7397,13775,13781,13860,19267,19266,10158,18771,6374,10160,10174,14170,13483,14149,14484,11026,10763,14463,2510,19071,10180,16934,17385,7487,15824,18889,12465,15958,15956,3254,10189,15450,11332,12306,13692,11643,13730,15853,13082,13695,3377,14812,14188,19153,19156,19155,6565,19157,18834,15882,19042,9741,8055,19171,8054,19191,17063,15079,17062,15130,16568,12082,16145,16058,4476,4475,11330,11329,19240,12079,16613,11328,19192,17243,10143,4471,4496,10133,16697,16090,17486,16092,16060,12586,3266,8695,10424,19239,15796,15797,15147,12374,247,19051,19050,12369,19049,2596,2156,16336,1364,1365,1367,1362,8312,19125,19122,19124,1371,10728,19218,19220,19221,10727,10295,8738,8736,8737,1370,14452,14451,19215,10731,10734,19214,19217,10735,10293,19213,13584,15508,10456,4478,18237,10288,19295,19294,10290,10289,10292,10291,18233,19222,18375,13883,15277,10457,11410,11411,15275,4555,4556,15846,15272,15889,13558,8995,8993,19116,4933,4932,1778,10665,10666,1776,1777,2778,7812,7814,7813,2910,8988,8991,8990,8992,8989,11095,14775,14774,6985,16874,16875,16876,7431,4692,5750,4691,4693,15340,17778,10852,8236,13419,10208,11127,11128,14304,9796,9065,9067,9068,9064,9066,18674,4694,15712,15711,8239,15341,15342,17115,17555,10097,9057,9055,8514,8513,9056,12738,12737,12735,19034,19033,8848,9820,9159,18862,2013,2012,12322,10652,15038,17929,17777,17768,19232,10273,8997,17272,10123,8996,11239,10186,14795,17418,17077,16371,15529,16372,17069,16370,19120,19119,19117,13916,16863,18562,18564,19115,19035,19036,5763,5764,16898,17281,15036,17227,17235,19114,18717,19112,19113,18797,18798,19110,19111,18898,18899,18616,18617,18847,18848,18928,18929,19183,19185,19188,15535,15534,15413,10096,16925,16924,16552,15663,15668,16524,16736,16734,16554,15673,15675,15677,16525,6048,6830,6043,6046,6047,12822,14270,13043,18101,6805,2743,18912,18911,16737,13646,14396,13381,13379,13647,14397,14265,14241,9997,10776,9998,9951,14926,10774,14690,19210,19208,19209,14749,19211,19205,16733,14745,16315,14693,17014,15417,18118,15817,18109,18902,18108,18901,18116,18904,15862,18903,18117,18906,15818,18905,16893,18115,16254,16666,16665,16135,15870,15874,15875,11032,11031,12299,11063,18589,18590,18587,12542,9219,9222,16859,14316,18455,18452,14318,18456,18451,14317,18453,16213,1417,1501,1500,18459,6194,1418,18454,15117,15124,4592,1419,1423,1421,18457,1420,18458,1422,9148,16851,16853,13040,15921,15910,15497,15170,15168,15176,15478,15175,8971,8898,8907,15165,8900,8894,15173,15912,15919,15909,15911,15916,15920,15502,15495,15501,15190,15169,15189,15193,15166,15177,15192,15479,15174,15475,15184,15163,15180,15194,8899,17481,15191,15171,7094,7095,13801,7093,13808,13806,7107,7113,17263,17264,17268,17267,17266,17270,16855,15112,15127,15107,16858,11770,18096,13874,13873,16385,16386,18042,18038,18041,18039,18040,17068,17066,17649,17650,15902,16998,12766,18741,12132,14417,12216,16979,16996,16982,16995,18712,12136,16144,13890,12125,12127,12133,18742,12126,12130,18743,13032,12134,14820,14027,12119,12111,14482,13552,12131,12302,14691,12782,18711,12779,13820,12129,12567,12747,13942,14541,12213,12958,15017,15693,12206,18836,18832,18522,18926,18524,18683,18682,19061,18120,18123,18121,18119,12616,16548,16547,17847,15590,17158,14900,13486,14641,13091,15591,19126,14388,15760,16711,16303,14845,16278,17592,17589,17591,17590,17059,14901,18071,18193,18132,18129,14428,16368,13856,17515,17530,13950,17514,17527,13951,17512,17528,13952,18803,18802,13750,15344,15343,16074,17198,17372,19060,18125,17371,17373,17368,19000,19002,19001,17374,18948,18946,18947,4249,10862,10145,10147,19131,10148,10144,16466,16469,18241,16467,16468,19059,19056,19058,16679,18974,18973,18972,16335,10853,18024,18026,18027,18028,14796,15402,11534,17625,9076,17157,17155,17156,16434,18045,18870,18046,16437,16435,16436,18869,16441,18865,16438,18866,16439,18868,16440,15128,15484,15119,15778,14322,14320,16338,14323,18383,18384,18393,18385,18391,18392,18386,18388,18398,18389,18390,18396,16367,15082,14185,15083,16785,2770,8780,2772,2771,8980,1287,12932,12843,14186,15084,15085,18236,18093,14808,18091,18088,18089,18090,17141,17148,17147,17146,18098,15449,18134,18113,18560,14819,14834,6835,6834,11496,6837,12857,14854,12856,18827,14856,18828,18100,18253,18092,18084,18082,18064,10546,19154,18853,18851,19159,18854,18252,10455,10976,11580,11581,14406,18704,19096,19097,19095,19090,19091,19089,19099,19100,19098,19087,19088,19086,19084,19085,19083,19093,19094,19092,19106,19107,19105,19104,19136,19135,19102,19103,19101,17212,19273,19272,19271,19109,17673,17674,17669,18199,19063,19062,19076,18086,17903,17909,17912,17907,17795,17913,17914,18402,18403,18404,17613,12741,12472,11106,18021,18016,18429,18428,18022,18017,17355,17356,17354,17358,17357,17351,17352,17353,18135,18235,8024,18401,8723,15729,18772,18753,18773,18734,18735,9896,18346,18822,18371,18824,18370,18367,18666,18369,17562,17561,17619,17617,17558,17559,17560,17563,18663,18661,18662,18665,18664,14243,14247,17338,14831,14249,14723,17201,19020,19019,19018,14285,14276,14230,14239,17729,17154,17152,17788,17789,17790,17441,11820,17037,14797,12263,12264,17080,17612,17073,17019,17680,15903,17025,1299,15763,17042,17045,10651,11367,11370,10851,17254,17838,10446,19028,17802,17750,10863,11060,17657,10037,10411,17127,11587,11588,11589,10038,17616,19067,10122,10407,17704,18789,17660,10034,10864,11918,17658,15635,17661,18143,16242,18142,17770,17769,16241,16243,18752,18846,17545,17543,14410,17691,14411,17690,18433,18431,18432,14408,18986,15845,15848,17766,17930,15932,15933,15931,13512,15222,19074,8845,19075,14405,14381,7260,2918,2905,2906,2907,18891,18890,17586,17585,17587,18331,18330,18332,18329,17763,18164,17764,447,9238,11011,9237,9239,9236,9235,9253,18940,10557,10649,17251,17248,17249,2644,8886,2640,14076,14627,18162,13060,17765,11567,11565,12853,10643,10644,13269,2020,2018,14370,13266,13264,13265,13268,19269,19268,13062,13054,19284,12818,19283,13053,18220,18464,18465,18466,18467,18315,18316,18317,18399,136,18018,18019,18020,10907,10906,17566,12466,10909,11609,10912,10910,13595,10904,10902,10903,10905,10908,17567,17467,17468,10680,13931,13932,18131,18130,17466,18583,17864,18318,17875,17873,17876,17874,17893,17891,17892,18224,18221,11688,11689,19164,19158,19160,19163,11782,18754,18736,9095,18701,18695,18697,18696,18698,18700,18699,18728,18729,17504,17505,10260,19278,19277,19279,19274,19280,19275,19276,18171,18170,18172,8625,8622,7602,8621,8627,8624,10766,18158,18155,18044,8600,7479,18653,8529,7480,14376,18156,18157,18159,8597,8546,18651,8598,14094,18585,16227,16228,18982,18932,14103,16025,14093,8602,18933,8549,12239,8591,7482,8608,18647,14101,12018,14100,14098,7597,7598,14099,8614,18648,14097,14096,18649,7483,18650,14374,18652,8634,8630,8632,8565,8628,14095,8635,8555,12019,14092,12101,8577,7490,18654,8557,8556,16026,7601,12240,8558,8606,12020,18656,12236,14090,12021,8550,8618,7595,12016,7491,7489,14581,14578,14579,16478,14580,12727,12483,2796,14556,14554,18655,18657,18841,19161,15468,18643,18161,18154,18160,18166,18644,18584,18439,7528,16230,18173,10234,14088,18645,17213,8761,8762,18047,18048,8752,8754,10794,16931,14001,8759,18588,8768,8769,8756,8757,8758,11452,12974,16913,12984,12986,16511,16790,16512,16508,16789,16505,16788,16499,16787,16503,15786,10767,8760,16831,9144,16459,16401,16404,16400,16392,16397,16405,16420,16416,16424,7025,7022,7027,16430,7020,16431,16428,16425,11022,516,9832,513,512,8767,10392,10388,17621,17583,17380,13630,10390,17623,17584,10394,16580,16792,16581,10389,17620,17582,16582,16793,16583,2679,2675,2681,17819,13897,14813,16304,12979,13896,17126,10059,10058,10062,10063,10060,12980,16909,6991,16903,14343,14344,18110,18094,17818,18783,8030,19196,17378,17379,13628,13629,17382,17015,19194,19195,19197,19198,9036,7157,7158,9510,8201,9128,18368,18726,6856,6855,17017,17273,17209,9126,6808,6840,6807,19265,19261,17205,19264,17013,13697,17245,14885,6889,17211,17265,15776,18445,9799,8275,8248,8274,7362,13958,8405,8404,17389,18087,18069,18070,18068,18065,18067,18066,17526,18438,18441,18442,18437,15759,17637,17524,17878,17332,17210,18112) . Bound with :date='2025-04-12'
|
| 15:56:47.154 | trace | system.db.CDbCommand |
Querying SQL: SELECT
product_id, SUM(number_of_units_available) qtyonhand FROM inventory WHERE product_id IN (40, 43, 48, 50, 54, 136, 235, 244, 247, 301, 304, 447, 512, 513, 516, 544, 914, 915, 920, 935, 1114, 1120, 1121, 1122, 1139, 1140, 1204, 1287, 1299, 1362, 1364, 1365, 1367, 1370, 1371, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1427, 1431, 1500, 1501, 1525, 1743, 1744, 1776, 1777, 1778, 1945, 2012, 2013, 2018, 2020, 2026, 2060, 2061, 2093, 2094, 2153, 2156, 2181, 2231, 2288, 2331, 2349, 2350, 2351, 2352, 2353, 2354, 2355, 2356, 2357, 2358, 2359, 2362, 2363, 2364, 2369, 2370, 2380, 2381, 2406, 2427, 2439, 2440, 2510, 2526, 2563, 2572, 2573, 2596, 2597, 2640, 2644, 2675, 2679, 2681, 2695, 2697, 2709, 2710, 2711, 2714, 2738, 2743, 2754, 2755, 2756, 2770, 2771, 2772, 2778, 2796, 2905, 2906, 2907, 2910, 2917, 2918, 2939, 2982, 3002, 3052, 3209, 3215, 3216, 3220, 3222, 3230, 3231, 3235, 3236, 3237, 3239, 3240, 3241, 3243, 3253, 3254, 3262, 3264, 3266, 3309, 3313, 3318, 3322, 3323, 3326, 3329, 3335, 3336, 3351, 3352, 3373, 3374, 3377, 3385, 3386, 3387, 3485, 3498, 3499, 3500, 3501, 3502, 3587, 3590, 3617, 3622, 3623, 3668, 3669, 3690, 3692, 3725, 3792, 3794, 4203, 4204, 4206, 4211, 4226, 4228, 4231, 4249, 4261, 4262, 4278, 4282, 4285, 4288, 4289, 4320, 4321, 4322, 4325, 4332, 4335, 4339, 4346, 4361, 4363, 4367, 4371, 4373, 4375, 4379, 4386, 4387, 4413, 4414, 4437, 4449, 4450, 4455, 4471, 4475, 4476, 4478, 4486, 4496, 4520, 4521, 4529, 4533, 4539, 4555, 4556, 4583, 4584, 4589, 4592, 4605, 4675, 4685, 4691, 4692, 4693, 4694, 4743, 4932, 4933, 5039, 5043, 5047, 5071, 5157, 5164, 5168, 5171, 5185, 5194, 5205, 5207, 5208, 5213, 5215, 5219, 5237, 5239, 5240, 5294, 5376, 5540, 5547, 5604, 5609, 5630, 5631, 5632, 5633, 5646, 5688, 5693, 5696, 5707, 5712, 5750, 5763, 5764, 5776, 5791, 5793, 5831, 5841, 5843, 5922, 5960, 5964, 5966, 6010, 6021, 6042, 6043, 6046, 6047, 6048, 6072, 6074, 6089, 6109, 6121, 6122, 6150, 6151, 6194, 6196, 6198, 6200, 6223, 6265, 6288, 6362, 6374, 6565, 6569, 6599, 6654, 6677, 6729, 6788, 6797, 6798, 6799, 6801, 6803, 6805, 6807, 6808, 6830, 6834, 6835, 6837, 6840, 6855, 6856, 6873, 6877, 6880, 6889, 6897, 6985, 6991, 7020, 7022, 7025, 7027, 7047, 7093, 7094, 7095, 7107, 7113, 7122, 7128, 7129, 7130, 7136, 7137, 7138, 7140, 7157, 7158, 7177, 7260, 7279, 7280, 7281, 7307, 7308, 7309, 7310, 7337, 7353, 7354, 7357, 7362, 7397, 7428, 7431, 7439, 7444, 7447, 7479, 7480, 7482, 7483, 7487, 7489, 7490, 7491, 7528, 7530, 7595, 7597, 7598, 7601, 7602, 7679, 7750, 7753, 7774, 7775, 7812, 7813, 7814, 7818, 7820, 7822, 7877, 7880, 7923, 7994, 7995, 8004, 8005, 8006, 8007, 8024, 8030, 8054, 8055, 8072, 8201, 8236, 8239, 8248, 8274, 8275, 8312, 8326, 8341, 8356, 8404, 8405, 8413, 8420, 8445, 8513, 8514, 8529, 8546, 8549, 8550, 8555, 8556, 8557, 8558, 8565, 8575, 8577, 8591, 8597, 8598, 8600, 8602, 8606, 8608, 8614, 8618, 8621, 8622, 8624, 8625, 8627, 8628, 8630, 8632, 8634, 8635, 8669, 8670, 8673, 8674, 8687, 8690, 8695, 8708, 8710, 8723, 8733, 8736, 8737, 8738, 8752, 8754, 8756, 8757, 8758, 8759, 8760, 8761, 8762, 8767, 8768, 8769, 8780, 8788, 8789, 8820, 8845, 8848, 8853, 8886, 8894, 8898, 8899, 8900, 8907, 8922, 8925, 8926, 8928, 8945, 8971, 8980, 8988, 8989, 8990, 8991, 8992, 8993, 8995, 8996, 8997, 8998, 9012, 9036, 9055, 9056, 9057, 9064, 9065, 9066, 9067, 9068, 9076, 9093, 9095, 9116, 9117, 9118, 9119, 9120, 9121, 9126, 9128, 9129, 9134, 9135, 9144, 9145, 9148, 9149, 9150, 9159, 9219, 9222, 9227, 9235, 9236, 9237, 9238, 9239, 9253, 9264, 9409, 9416, 9417, 9435, 9436, 9438, 9439, 9448, 9449, 9487, 9510, 9525, 9546, 9577, 9578, 9579, 9650, 9658, 9686, 9699, 9700, 9712, 9723, 9736, 9737, 9741, 9772, 9796, 9799, 9800, 9820, 9832, 9892, 9893, 9895, 9896, 9908, 9909, 9910, 9911, 9914, 9918, 9921, 9923, 9924, 9951, 9956, 9959, 9960, 9966, 9997, 9998, 10034, 10037, 10038, 10053, 10056, 10058, 10059, 10060, 10062, 10063, 10074, 10084, 10096, 10097, 10119, 10122, 10123, 10124, 10133, 10137, 10143, 10144, 10145, 10147, 10148, 10156, 10158, 10160, 10174, 10177, 10180, 10186, 10189, 10201, 10202, 10203, 10204, 10205, 10206, 10207, 10208, 10234, 10235, 10254, 10260, 10273, 10274, 10275, 10288, 10289, 10290, 10291, 10292, 10293, 10295, 10332, 10337, 10388, 10389, 10390, 10392, 10394, 10396, 10397, 10398, 10400, 10407, 10409, 10410, 10411, 10413, 10414, 10424, 10446, 10455, 10456, 10457, 10464, 10510, 10522, 10546, 10557, 10559, 10560, 10562, 10572, 10573, 10575, 10576, 10577, 10578, 10579, 10580, 10582, 10583, 10584, 10585, 10586, 10609, 10613, 10643, 10644, 10649, 10651, 10652, 10662, 10663, 10664, 10665, 10666, 10667, 10668, 10680, 10693, 10700, 10701, 10704, 10705, 10706, 10727, 10728, 10731, 10734, 10735, 10736, 10745, 10746, 10747, 10748, 10749, 10759, 10763, 10766, 10767, 10770, 10771, 10774, 10776, 10794, 10834, 10848, 10849, 10851, 10852, 10853, 10862, 10863, 10864, 10895, 10902, 10903, 10904, 10905, 10906, 10907, 10908, 10909, 10910, 10912, 10917, 10918, 10920, 10938, 10939, 10940, 10941, 10942, 10943, 10976, 10987, 11011, 11022, 11024, 11025, 11026, 11027, 11028, 11029, 11031, 11032, 11060, 11063, 11091, 11092, 11095, 11106, 11124, 11127, 11128, 11142, 11170, 11171, 11192, 11204, 11215, 11216, 11217, 11220, 11226, 11239, 11243, 11259, 11268, 11269, 11270, 11272, 11276, 11279, 11280, 11300, 11301, 11315, 11328, 11329, 11330, 11332, 11339, 11344, 11353, 11354, 11357, 11358, 11359, 11360, 11363, 11364, 11367, 11370, 11409, 11410, 11411, 11413, 11424, 11452, 11475, 11478, 11479, 11496, 11508, 11529, 11534, 11551, 11563, 11565, 11567, 11580, 11581, 11587, 11588, 11589, 11592, 11593, 11601, 11609, 11640, 11643, 11646, 11664, 11665, 11688, 11689, 11706, 11729, 11753, 11770, 11776, 11777, 11782, 11784, 11786, 11815, 11820, 11825, 11834, 11840, 11853, 11869, 11870, 11871, 11894, 11903, 11908, 11918, 11940, 11952, 11985, 11990, 11994, 11995, 12000, 12002, 12004, 12009, 12010, 12016, 12018, 12019, 12020, 12021, 12067, 12079, 12082, 12094, 12100, 12101, 12102, 12103, 12104, 12105, 12109, 12111, 12112, 12119, 12120, 12125, 12126, 12127, 12129, 12130, 12131, 12132, 12133, 12134, 12136, 12154, 12176, 12184, 12185, 12190, 12191, 12192, 12198, 12206, 12213, 12216, 12236, 12239, 12240, 12260, 12263, 12264, 12269, 12270, 12271, 12272, 12273, 12274, 12282, 12283, 12289, 12290, 12291, 12292, 12293, 12294, 12296, 12299, 12302, 12306, 12307, 12308, 12313, 12319, 12322, 12326, 12337, 12338, 12345, 12353, 12356, 12369, 12374, 12393, 12395, 12399, 12426, 12439, 12442, 12444, 12445, 12465, 12466, 12471, 12472, 12475, 12483, 12491, 12500, 12502, 12503, 12504, 12505, 12531, 12532, 12533, 12536, 12537, 12538, 12542, 12553, 12558, 12559, 12567, 12585, 12586, 12608, 12614, 12616, 12640, 12644, 12676, 12719, 12720, 12721, 12722, 12727, 12735, 12737, 12738, 12741, 12743, 12746, 12747, 12748, 12766, 12767, 12775, 12779, 12782, 12809, 12810, 12818, 12822, 12843, 12850, 12853, 12856, 12857, 12871, 12894, 12927, 12929, 12932, 12958, 12959, 12960, 12961, 12962, 12963, 12964, 12965, 12966, 12967, 12974, 12979, 12980, 12983, 12984, 12986, 12988, 12990, 12999, 13015, 13032, 13040, 13043, 13050, 13053, 13054, 13060, 13062, 13073, 13082, 13085, 13087, 13091, 13097, 13172, 13181, 13182, 13183, 13184, 13187, 13188, 13189, 13190, 13191, 13193, 13194, 13195, 13196, 13228, 13251, 13262, 13264, 13265, 13266, 13268, 13269, 13275, 13279, 13297, 13299, 13323, 13324, 13331, 13333, 13334, 13354, 13355, 13357, 13358, 13359, 13368, 13378, 13379, 13381, 13403, 13409, 13410, 13414, 13419, 13423, 13424, 13450, 13483, 13485, 13486, 13497, 13507, 13512, 13552, 13558, 13563, 13584, 13595, 13599, 13601, 13602, 13619, 13622, 13624, 13626, 13627, 13628, 13629, 13630, 13641, 13646, 13647, 13674, 13675, 13676, 13681, 13689, 13691, 13692, 13695, 13697, 13703, 13706, 13707, 13708, 13709, 13710, 13712, 13718, 13719, 13722, 13730, 13736, 13739, 13741, 13745, 13750, 13754, 13756, 13757, 13758, 13759, 13761, 13762, 13763, 13765, 13766, 13772, 13775, 13781, 13791, 13794, 13801, 13803, 13806, 13808, 13812, 13813, 13814, 13815, 13818, 13820, 13827, 13829, 13833, 13834, 13835, 13844, 13845, 13851, 13852, 13853, 13854, 13856, 13860, 13873, 13874, 13879, 13881, 13882, 13883, 13890, 13896, 13897, 13911, 13915, 13916, 13921, 13929, 13931, 13932, 13942, 13950, 13951, 13952, 13958, 13965, 13995, 13996, 13998, 14001, 14005, 14006, 14023, 14027, 14044, 14045, 14046, 14064, 14071, 14076, 14078, 14079, 14088, 14090, 14092, 14093, 14094, 14095, 14096, 14097, 14098, 14099, 14100, 14101, 14103, 14132, 14135, 14136, 14137, 14146, 14147, 14149, 14159, 14167, 14170, 14180, 14185, 14186, 14188, 14189, 14190, 14191, 14192, 14197, 14212, 14213, 14219, 14220, 14223, 14230, 14239, 14241, 14243, 14247, 14249, 14265, 14270, 14276, 14285, 14291, 14293, 14294, 14304, 14306, 14316, 14317, 14318, 14320, 14322, 14323, 14327, 14332, 14333, 14337, 14343, 14344, 14348, 14349, 14356, 14360, 14363, 14370, 14374, 14376, 14381, 14388, 14396, 14397, 14400, 14405, 14406, 14408, 14409, 14410, 14411, 14417, 14420, 14428, 14437, 14439, 14442, 14451, 14452, 14456, 14460, 14461, 14463, 14482, 14484, 14491, 14527, 14528, 14530, 14541, 14554, 14556, 14578, 14579, 14580, 14581, 14611, 14627, 14641, 14662, 14690, 14691, 14693, 14701, 14705, 14706, 14713, 14715, 14716, 14717, 14718, 14719, 14723, 14725, 14727, 14728, 14729, 14745, 14749, 14760, 14762, 14774, 14775, 14786, 14795, 14796, 14797, 14808, 14812, 14813, 14819, 14820, 14824, 14825, 14826, 14831, 14834, 14841, 14845, 14854, 14856, 14872, 14885, 14900, 14901, 14926, 14986, 14987, 15017, 15036, 15038, 15053, 15058, 15061, 15064, 15067, 15079, 15082, 15083, 15084, 15085, 15090, 15101, 15102, 15107, 15112, 15117, 15119, 15124, 15127, 15128, 15130, 15147, 15148, 15156, 15163, 15165, 15166, 15168, 15169, 15170, 15171, 15173, 15174, 15175, 15176, 15177, 15180, 15184, 15189, 15190, 15191, 15192, 15193, 15194, 15199, 15219, 15221, 15222, 15223, 15272, 15275, 15277, 15289, 15292, 15300, 15314, 15315, 15335, 15336, 15340, 15341, 15342, 15343, 15344, 15365, 15366, 15382, 15398, 15402, 15403, 15404, 15405, 15407, 15413, 15417, 15428, 15430, 15431, 15437, 15449, 15450, 15453, 15459, 15468, 15475, 15478, 15479, 15484, 15495, 15497, 15498, 15501, 15502, 15503, 15507, 15508, 15515, 15516, 15517, 15520, 15526, 15529, 15534, 15535, 15542, 15545, 15546, 15547, 15548, 15549, 15550, 15551, 15554, 15555, 15556, 15558, 15559, 15560, 15561, 15562, 15569, 15573, 15585, 15586, 15589, 15590, 15591, 15592, 15593, 15607, 15619, 15620, 15621, 15622, 15623, 15631, 15635, 15639, 15663, 15668, 15669, 15673, 15675, 15677, 15693, 15694, 15711, 15712, 15720, 15729, 15747, 15748, 15751, 15752, 15759, 15760, 15763, 15764, 15769, 15776, 15778, 15786, 15796, 15797, 15802, 15817, 15818, 15821, 15824, 15845, 15846, 15848, 15853, 15862, 15870, 15874, 15875, 15882, 15889, 15895, 15901, 15902, 15903, 15907, 15909, 15910, 15911, 15912, 15916, 15919, 15920, 15921, 15931, 15932, 15933, 15939, 15947, 15954, 15956, 15957, 15958, 15968, 15972, 15973, 15975, 15976, 15977, 15981, 15982, 15984, 15989, 15992, 16002, 16016, 16019, 16020, 16025, 16026, 16033, 16034, 16035, 16036, 16037, 16038, 16041, 16058, 16060, 16064, 16074, 16086, 16090, 16092, 16096, 16097, 16099, 16100, 16101, 16109, 16110, 16111, 16112, 16114, 16115, 16122, 16123, 16124, 16125, 16128, 16129, 16132, 16135, 16137, 16140, 16141, 16142, 16144, 16145, 16213, 16215, 16216, 16218, 16227, 16228, 16230, 16235, 16238, 16239, 16241, 16242, 16243, 16247, 16248, 16250, 16251, 16252, 16254, 16257, 16265, 16278, 16291, 16299, 16302, 16303, 16304, 16313, 16315, 16322, 16332, 16335, 16336, 16338, 16355, 16367, 16368, 16370, 16371, 16372, 16378, 16385, 16386, 16391, 16392, 16393, 16397, 16398, 16399, 16400, 16401, 16402, 16404, 16405, 16406, 16408, 16410, 16411, 16412, 16414, 16415, 16416, 16418, 16420, 16422, 16423, 16424, 16425, 16426, 16428, 16430, 16431, 16434, 16435, 16436, 16437, 16438, 16439, 16440, 16441, 16443, 16450, 16457, 16459, 16466, 16467, 16468, 16469, 16476, 16477, 16478, 16481, 16482, 16483, 16484, 16485, 16486, 16487, 16488, 16489, 16490, 16491, 16492, 16499, 16503, 16504, 16505, 16508, 16509, 16511, 16512, 16513, 16524, 16525, 16547, 16548, 16552, 16553, 16554, 16555, 16563, 16568, 16580, 16581, 16582, 16583, 16587, 16599, 16613, 16627, 16636, 16643, 16644, 16645, 16653, 16656, 16662, 16665, 16666, 16671, 16673, 16676, 16679, 16690, 16691, 16692, 16694, 16697, 16705, 16706, 16710, 16711, 16733, 16734, 16736, 16737, 16738, 16743, 16747, 16755, 16785, 16787, 16788, 16789, 16790, 16792, 16793, 16802, 16810, 16811, 16814, 16820, 16821, 16824, 16827, 16831, 16835, 16836, 16837, 16850, 16851, 16852, 16853, 16854, 16855, 16858, 16859, 16863, 16865, 16874, 16875, 16876, 16883, 16884, 16893, 16896, 16897, 16898, 16899, 16903, 16909, 16913, 16924, 16925, 16931, 16932, 16934, 16941, 16944, 16949, 16957, 16958, 16961, 16965, 16967, 16971, 16979, 16981, 16982, 16995, 16996, 16998, 17008, 17011, 17012, 17013, 17014, 17015, 17016, 17017, 17018, 17019, 17022, 17025, 17033, 17034, 17037, 17042, 17045, 17046, 17048, 17051, 17059, 17060, 17062, 17063, 17066, 17068, 17069, 17073, 17075, 17077, 17080, 17084, 17091, 17092, 17112, 17115, 17117, 17126, 17127, 17130, 17141, 17142, 17143, 17144, 17145, 17146, 17147, 17148, 17152, 17153, 17154, 17155, 17156, 17157, 17158, 17161, 17168, 17169, 17170, 17171, 17172, 17177, 17178, 17180, 17181, 17182, 17186, 17189, 17190, 17198, 17199, 17201, 17205, 17209, 17210, 17211, 17212, 17213, 17216, 17223, 17224, 17225, 17226, 17227, 17228, 17230, 17231, 17233, 17234, 17235, 17236, 17240, 17243, 17244, 17245, 17248, 17249, 17250, 17251, 17252, 17253, 17254, 17255, 17263, 17264, 17265, 17266, 17267, 17268, 17270, 17272, 17273, 17280, 17281, 17282, 17284, 17285, 17286, 17290, 17293, 17332, 17338, 17339, 17340, 17341, 17342, 17344, 17345, 17346, 17348, 17350, 17351, 17352, 17353, 17354, 17355, 17356, 17357, 17358, 17359, 17360, 17365, 17366, 17368, 17371, 17372, 17373, 17374, 17378, 17379, 17380, 17382, 17384, 17385, 17387, 17389, 17391, 17396, 17398, 17399, 17401, 17402, 17408, 17412, 17416, 17418, 17424, 17428, 17429, 17430, 17433, 17435, 17436, 17441, 17444, 17445, 17446, 17447, 17449, 17450, 17451, 17452, 17461, 17466, 17467, 17468, 17472, 17481, 17485, 17486, 17487, 17488, 17492, 17493, 17495, 17502, 17504, 17505, 17508, 17509, 17510, 17512, 17514, 17515, 17524, 17526, 17527, 17528, 17530, 17543, 17545, 17554, 17555, 17557, 17558, 17559, 17560, 17561, 17562, 17563, 17565, 17566, 17567, 17576, 17577, 17578, 17581, 17582, 17583, 17584, 17585, 17586, 17587, 17589, 17590, 17591, 17592, 17600, 17601, 17606, 17607, 17608, 17610, 17612, 17613, 17614, 17616, 17617, 17619, 17620, 17621, 17622, 17623, 17624, 17625, 17628, 17635, 17637, 17640, 17641, 17642, 17649, 17650, 17654, 17657, 17658, 17659, 17660, 17661, 17664, 17668, 17669, 17670, 17671, 17672, 17673, 17674, 17675, 17677, 17680, 17682, 17683, 17688, 17689, 17690, 17691, 17692, 17693, 17697, 17699, 17700, 17701, 17704, 17710, 17711, 17718, 17721, 17729, 17733, 17738, 17739, 17741, 17742, 17743, 17744, 17746, 17747, 17748, 17750, 17756, 17763, 17764, 17765, 17766, 17768, 17769, 17770, 17773, 17775, 17777, 17778, 17788, 17789, 17790, 17795, 17796, 17799, 17802, 17806, 17808, 17809, 17814, 17817, 17818, 17819, 17820, 17821, 17823, 17827, 17830, 17831, 17832, 17834, 17835, 17836, 17838, 17841, 17843, 17844, 17847, 17854, 17856, 17858, 17859, 17860, 17863, 17864, 17865, 17871, 17873, 17874, 17875, 17876, 17878, 17879, 17880, 17881, 17882, 17883, 17884, 17885, 17886, 17891, 17892, 17893, 17894, 17895, 17896, 17897, 17898, 17899, 17900, 17901, 17902, 17903, 17904, 17906, 17907, 17909, 17912, 17913, 17914, 17921, 17922, 17923, 17926, 17928, 17929, 17930, 17931, 17932, 17939, 17940, 17941, 17942, 17943, 17944, 17945, 17946, 17948, 17949, 17951, 17952, 17953, 17954, 17955, 17956, 17957, 17958, 17959, 17960, 17961, 17962, 17963, 17964, 17965, 17966, 17967, 17968, 17969, 17970, 17971, 17972, 17973, 17974, 17975, 17976, 17977, 17980, 17981, 17983, 17987, 17988, 17990, 17992, 17993, 17994, 17995, 17996, 17997, 17998, 18001, 18002, 18003, 18004, 18016, 18017, 18018, 18019, 18020, 18021, 18022, 18023, 18024, 18025, 18026, 18027, 18028, 18032, 18034, 18035, 18038, 18039, 18040, 18041, 18042, 18044, 18045, 18046, 18047, 18048, 18057, 18058, 18059, 18061, 18062, 18064, 18065, 18066, 18067, 18068, 18069, 18070, 18071, 18079, 18080, 18082, 18084, 18086, 18087, 18088, 18089, 18090, 18091, 18092, 18093, 18094, 18096, 18098, 18099, 18100, 18101, 18102, 18108, 18109, 18110, 18111, 18112, 18113, 18115, 18116, 18117, 18118, 18119, 18120, 18121, 18123, 18125, 18126, 18128, 18129, 18130, 18131, 18132, 18134, 18135, 18138, 18142, 18143, 18154, 18155, 18156, 18157, 18158, 18159, 18160, 18161, 18162, 18164, 18166, 18170, 18171, 18172, 18173, 18174, 18177, 18178, 18179, 18180, 18181, 18182, 18183, 18185, 18186, 18187, 18188, 18189, 18190, 18193, 18199, 18211, 18212, 18213, 18214, 18216, 18219, 18220, 18221, 18224, 18233, 18235, 18236, 18237, 18239, 18240, 18241, 18247, 18251, 18252, 18253, 18254, 18256, 18271, 18275, 18276, 18277, 18281, 18282, 18293, 18304, 18309, 18312, 18313, 18314, 18315, 18316, 18317, 18318, 18328, 18329, 18330, 18331, 18332, 18334, 18335, 18338, 18341, 18342, 18345, 18346, 18347, 18348, 18350, 18351, 18356, 18359, 18360, 18361, 18362, 18365, 18367, 18368, 18369, 18370, 18371, 18372, 18373, 18375, 18379, 18383, 18384, 18385, 18386, 18388, 18389, 18390, 18391, 18392, 18393, 18396, 18398, 18399, 18400, 18401, 18402, 18403, 18404, 18406, 18407, 18409, 18422, 18423, 18424, 18428, 18429, 18431, 18432, 18433, 18437, 18438, 18439, 18440, 18441, 18442, 18443, 18445, 18446, 18448, 18449, 18450, 18451, 18452, 18453, 18454, 18455, 18456, 18457, 18458, 18459, 18464, 18465, 18466, 18467, 18475, 18476, 18498, 18499, 18511, 18512, 18515, 18516, 18517, 18522, 18523, 18524, 18525, 18528, 18529, 18530, 18531, 18532, 18533, 18534, 18535, 18536, 18540, 18541, 18542, 18545, 18546, 18554, 18556, 18557, 18559, 18560, 18562, 18564, 18579, 18580, 18581, 18583, 18584, 18585, 18587, 18588, 18589, 18590, 18593, 18595, 18597, 18601, 18605, 18608, 18614, 18615, 18616, 18617, 18632, 18633, 18634, 18640, 18643, 18644, 18645, 18646, 18647, 18648, 18649, 18650, 18651, 18652, 18653, 18654, 18655, 18656, 18657, 18661, 18662, 18663, 18664, 18665, 18666, 18674, 18682, 18683, 18684, 18686, 18695, 18696, 18697, 18698, 18699, 18700, 18701, 18703, 18704, 18705, 18706, 18708, 18709, 18710, 18711, 18712, 18713, 18714, 18715, 18717, 18726, 18728, 18729, 18730, 18731, 18734, 18735, 18736, 18741, 18742, 18743, 18746, 18748, 18750, 18751, 18752, 18753, 18754, 18757, 18758, 18763, 18766, 18768, 18771, 18772, 18773, 18774, 18775, 18779, 18780, 18781, 18782, 18783, 18784, 18786, 18789, 18794, 18797, 18798, 18802, 18803, 18807, 18811, 18815, 18816, 18818, 18822, 18823, 18824, 18827, 18828, 18830, 18831, 18832, 18833, 18834, 18836, 18837, 18838, 18839, 18840, 18841, 18842, 18846, 18847, 18848, 18850, 18851, 18853, 18854, 18860, 18862, 18865, 18866, 18867, 18868, 18869, 18870, 18875, 18876, 18877, 18881, 18889, 18890, 18891, 18892, 18897, 18898, 18899, 18901, 18902, 18903, 18904, 18905, 18906, 18911, 18912, 18913, 18914, 18915, 18917, 18918, 18920, 18921, 18922, 18924, 18925, 18926, 18928, 18929, 18930, 18932, 18933, 18940, 18941, 18942, 18943, 18946, 18947, 18948, 18949, 18950, 18952, 18953, 18955, 18956, 18957, 18958, 18959, 18960, 18962, 18963, 18965, 18966, 18967, 18968, 18972, 18973, 18974, 18975, 18976, 18979, 18981, 18982, 18985, 18986, 18988, 18991, 18992, 18994, 18996, 18997, 18999, 19000, 19001, 19002, 19003, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19015, 19016, 19017, 19018, 19019, 19020, 19022, 19025, 19026, 19027, 19028, 19029, 19033, 19034, 19035, 19036, 19042, 19044, 19049, 19050, 19051, 19053, 19054, 19056, 19057, 19058, 19059, 19060, 19061, 19062, 19063, 19065, 19066, 19067, 19068, 19069, 19071, 19072, 19073, 19074, 19075, 19076, 19077, 19078, 19083, 19084, 19085, 19086, 19087, 19088, 19089, 19090, 19091, 19092, 19093, 19094, 19095, 19096, 19097, 19098, 19099, 19100, 19101, 19102, 19103, 19104, 19105, 19106, 19107, 19109, 19110, 19111, 19112, 19113, 19114, 19115, 19116, 19117, 19119, 19120, 19122, 19123, 19124, 19125, 19126, 19127, 19128, 19129, 19130, 19131, 19135, 19136, 19138, 19140, 19141, 19143, 19144, 19145, 19148, 19149, 19150, 19151, 19153, 19154, 19155, 19156, 19157, 19158, 19159, 19160, 19161, 19162, 19163, 19164, 19165, 19166, 19167, 19168, 19169, 19170, 19171, 19173, 19174, 19175, 19178, 19179, 19180, 19181, 19182, 19183, 19185, 19188, 19189, 19191, 19192, 19194, 19195, 19196, 19197, 19198, 19205, 19206, 19207, 19208, 19209, 19210, 19211, 19212, 19213, 19214, 19215, 19217, 19218, 19220, 19221, 19222, 19223, 19224, 19225, 19226, 19227, 19228, 19229, 19231, 19232, 19236, 19237, 19238, 19239, 19240, 19241, 19252, 19253, 19254, 19255, 19256, 19257, 19258, 19259, 19261, 19264, 19265, 19266, 19267, 19268, 19269, 19271, 19272, 19273, 19274, 19275, 19276, 19277, 19278, 19279, 19280, 19281, 19282, 19283, 19284, 19286, 19294, 19295) AND `number_of_units_available` > 0 GROUP BY product_id;
|
| 15:56:47.177 | trace | system.db.CDbCommand |
Querying SQL: SELECT
s.product_id, SUM(s.number_of_units_ordered * IF(s.reception_type = 4, floor(s.reception_weight/p.weight), 1)) nb FROM supplier_forecast_orders s LEFT JOIN products p ON (p.product_id = s.product_id) WHERE s.start_selling_on_date <= :date AND s.status IN (3, 14) AND s.instant_in_out = 0 AND s.product_id IN (40,43,48,50,54,136,235,244,247,301,304,447,512,513,516,544,914,915,920,935,1114,1120,1121,1122,1139,1140,1204,1287,1299,1362,1364,1365,1367,1370,1371,1417,1418,1419,1420,1421,1422,1423,1427,1431,1500,1501,1525,1743,1744,1776,1777,1778,1945,2012,2013,2018,2020,2026,2060,2061,2093,2094,2153,2156,2181,2231,2288,2331,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2362,2363,2364,2369,2370,2380,2381,2406,2427,2439,2440,2510,2526,2563,2572,2573,2596,2597,2640,2644,2675,2679,2681,2695,2697,2709,2710,2711,2714,2738,2743,2754,2755,2756,2770,2771,2772,2778,2796,2905,2906,2907,2910,2917,2918,2939,2982,3002,3052,3209,3215,3216,3220,3222,3230,3231,3235,3236,3237,3239,3240,3241,3243,3253,3254,3262,3264,3266,3309,3313,3318,3322,3323,3326,3329,3335,3336,3351,3352,3373,3374,3377,3385,3386,3387,3485,3498,3499,3500,3501,3502,3587,3590,3617,3622,3623,3668,3669,3690,3692,3725,3792,3794,4203,4204,4206,4211,4226,4228,4231,4249,4261,4262,4278,4282,4285,4288,4289,4320,4321,4322,4325,4332,4335,4339,4346,4361,4363,4367,4371,4373,4375,4379,4386,4387,4413,4414,4437,4449,4450,4455,4471,4475,4476,4478,4486,4496,4520,4521,4529,4533,4539,4555,4556,4583,4584,4589,4592,4605,4675,4685,4691,4692,4693,4694,4743,4932,4933,5039,5043,5047,5071,5157,5164,5168,5171,5185,5194,5205,5207,5208,5213,5215,5219,5237,5239,5240,5294,5376,5540,5547,5604,5609,5630,5631,5632,5633,5646,5688,5693,5696,5707,5712,5750,5763,5764,5776,5791,5793,5831,5841,5843,5922,5960,5964,5966,6010,6021,6042,6043,6046,6047,6048,6072,6074,6089,6109,6121,6122,6150,6151,6194,6196,6198,6200,6223,6265,6288,6362,6374,6565,6569,6599,6654,6677,6729,6788,6797,6798,6799,6801,6803,6805,6807,6808,6830,6834,6835,6837,6840,6855,6856,6873,6877,6880,6889,6897,6985,6991,7020,7022,7025,7027,7047,7093,7094,7095,7107,7113,7122,7128,7129,7130,7136,7137,7138,7140,7157,7158,7177,7260,7279,7280,7281,7307,7308,7309,7310,7337,7353,7354,7357,7362,7397,7428,7431,7439,7444,7447,7479,7480,7482,7483,7487,7489,7490,7491,7528,7530,7595,7597,7598,7601,7602,7679,7750,7753,7774,7775,7812,7813,7814,7818,7820,7822,7877,7880,7923,7994,7995,8004,8005,8006,8007,8024,8030,8054,8055,8072,8201,8236,8239,8248,8274,8275,8312,8326,8341,8356,8404,8405,8413,8420,8445,8513,8514,8529,8546,8549,8550,8555,8556,8557,8558,8565,8575,8577,8591,8597,8598,8600,8602,8606,8608,8614,8618,8621,8622,8624,8625,8627,8628,8630,8632,8634,8635,8669,8670,8673,8674,8687,8690,8695,8708,8710,8723,8733,8736,8737,8738,8752,8754,8756,8757,8758,8759,8760,8761,8762,8767,8768,8769,8780,8788,8789,8820,8845,8848,8853,8886,8894,8898,8899,8900,8907,8922,8925,8926,8928,8945,8971,8980,8988,8989,8990,8991,8992,8993,8995,8996,8997,8998,9012,9036,9055,9056,9057,9064,9065,9066,9067,9068,9076,9093,9095,9116,9117,9118,9119,9120,9121,9126,9128,9129,9134,9135,9144,9145,9148,9149,9150,9159,9219,9222,9227,9235,9236,9237,9238,9239,9253,9264,9409,9416,9417,9435,9436,9438,9439,9448,9449,9487,9510,9525,9546,9577,9578,9579,9650,9658,9686,9699,9700,9712,9723,9736,9737,9741,9772,9796,9799,9800,9820,9832,9892,9893,9895,9896,9908,9909,9910,9911,9914,9918,9921,9923,9924,9951,9956,9959,9960,9966,9997,9998,10034,10037,10038,10053,10056,10058,10059,10060,10062,10063,10074,10084,10096,10097,10119,10122,10123,10124,10133,10137,10143,10144,10145,10147,10148,10156,10158,10160,10174,10177,10180,10186,10189,10201,10202,10203,10204,10205,10206,10207,10208,10234,10235,10254,10260,10273,10274,10275,10288,10289,10290,10291,10292,10293,10295,10332,10337,10388,10389,10390,10392,10394,10396,10397,10398,10400,10407,10409,10410,10411,10413,10414,10424,10446,10455,10456,10457,10464,10510,10522,10546,10557,10559,10560,10562,10572,10573,10575,10576,10577,10578,10579,10580,10582,10583,10584,10585,10586,10609,10613,10643,10644,10649,10651,10652,10662,10663,10664,10665,10666,10667,10668,10680,10693,10700,10701,10704,10705,10706,10727,10728,10731,10734,10735,10736,10745,10746,10747,10748,10749,10759,10763,10766,10767,10770,10771,10774,10776,10794,10834,10848,10849,10851,10852,10853,10862,10863,10864,10895,10902,10903,10904,10905,10906,10907,10908,10909,10910,10912,10917,10918,10920,10938,10939,10940,10941,10942,10943,10976,10987,11011,11022,11024,11025,11026,11027,11028,11029,11031,11032,11060,11063,11091,11092,11095,11106,11124,11127,11128,11142,11170,11171,11192,11204,11215,11216,11217,11220,11226,11239,11243,11259,11268,11269,11270,11272,11276,11279,11280,11300,11301,11315,11328,11329,11330,11332,11339,11344,11353,11354,11357,11358,11359,11360,11363,11364,11367,11370,11409,11410,11411,11413,11424,11452,11475,11478,11479,11496,11508,11529,11534,11551,11563,11565,11567,11580,11581,11587,11588,11589,11592,11593,11601,11609,11640,11643,11646,11664,11665,11688,11689,11706,11729,11753,11770,11776,11777,11782,11784,11786,11815,11820,11825,11834,11840,11853,11869,11870,11871,11894,11903,11908,11918,11940,11952,11985,11990,11994,11995,12000,12002,12004,12009,12010,12016,12018,12019,12020,12021,12067,12079,12082,12094,12100,12101,12102,12103,12104,12105,12109,12111,12112,12119,12120,12125,12126,12127,12129,12130,12131,12132,12133,12134,12136,12154,12176,12184,12185,12190,12191,12192,12198,12206,12213,12216,12236,12239,12240,12260,12263,12264,12269,12270,12271,12272,12273,12274,12282,12283,12289,12290,12291,12292,12293,12294,12296,12299,12302,12306,12307,12308,12313,12319,12322,12326,12337,12338,12345,12353,12356,12369,12374,12393,12395,12399,12426,12439,12442,12444,12445,12465,12466,12471,12472,12475,12483,12491,12500,12502,12503,12504,12505,12531,12532,12533,12536,12537,12538,12542,12553,12558,12559,12567,12585,12586,12608,12614,12616,12640,12644,12676,12719,12720,12721,12722,12727,12735,12737,12738,12741,12743,12746,12747,12748,12766,12767,12775,12779,12782,12809,12810,12818,12822,12843,12850,12853,12856,12857,12871,12894,12927,12929,12932,12958,12959,12960,12961,12962,12963,12964,12965,12966,12967,12974,12979,12980,12983,12984,12986,12988,12990,12999,13015,13032,13040,13043,13050,13053,13054,13060,13062,13073,13082,13085,13087,13091,13097,13172,13181,13182,13183,13184,13187,13188,13189,13190,13191,13193,13194,13195,13196,13228,13251,13262,13264,13265,13266,13268,13269,13275,13279,13297,13299,13323,13324,13331,13333,13334,13354,13355,13357,13358,13359,13368,13378,13379,13381,13403,13409,13410,13414,13419,13423,13424,13450,13483,13485,13486,13497,13507,13512,13552,13558,13563,13584,13595,13599,13601,13602,13619,13622,13624,13626,13627,13628,13629,13630,13641,13646,13647,13674,13675,13676,13681,13689,13691,13692,13695,13697,13703,13706,13707,13708,13709,13710,13712,13718,13719,13722,13730,13736,13739,13741,13745,13750,13754,13756,13757,13758,13759,13761,13762,13763,13765,13766,13772,13775,13781,13791,13794,13801,13803,13806,13808,13812,13813,13814,13815,13818,13820,13827,13829,13833,13834,13835,13844,13845,13851,13852,13853,13854,13856,13860,13873,13874,13879,13881,13882,13883,13890,13896,13897,13911,13915,13916,13921,13929,13931,13932,13942,13950,13951,13952,13958,13965,13995,13996,13998,14001,14005,14006,14023,14027,14044,14045,14046,14064,14071,14076,14078,14079,14088,14090,14092,14093,14094,14095,14096,14097,14098,14099,14100,14101,14103,14132,14135,14136,14137,14146,14147,14149,14159,14167,14170,14180,14185,14186,14188,14189,14190,14191,14192,14197,14212,14213,14219,14220,14223,14230,14239,14241,14243,14247,14249,14265,14270,14276,14285,14291,14293,14294,14304,14306,14316,14317,14318,14320,14322,14323,14327,14332,14333,14337,14343,14344,14348,14349,14356,14360,14363,14370,14374,14376,14381,14388,14396,14397,14400,14405,14406,14408,14409,14410,14411,14417,14420,14428,14437,14439,14442,14451,14452,14456,14460,14461,14463,14482,14484,14491,14527,14528,14530,14541,14554,14556,14578,14579,14580,14581,14611,14627,14641,14662,14690,14691,14693,14701,14705,14706,14713,14715,14716,14717,14718,14719,14723,14725,14727,14728,14729,14745,14749,14760,14762,14774,14775,14786,14795,14796,14797,14808,14812,14813,14819,14820,14824,14825,14826,14831,14834,14841,14845,14854,14856,14872,14885,14900,14901,14926,14986,14987,15017,15036,15038,15053,15058,15061,15064,15067,15079,15082,15083,15084,15085,15090,15101,15102,15107,15112,15117,15119,15124,15127,15128,15130,15147,15148,15156,15163,15165,15166,15168,15169,15170,15171,15173,15174,15175,15176,15177,15180,15184,15189,15190,15191,15192,15193,15194,15199,15219,15221,15222,15223,15272,15275,15277,15289,15292,15300,15314,15315,15335,15336,15340,15341,15342,15343,15344,15365,15366,15382,15398,15402,15403,15404,15405,15407,15413,15417,15428,15430,15431,15437,15449,15450,15453,15459,15468,15475,15478,15479,15484,15495,15497,15498,15501,15502,15503,15507,15508,15515,15516,15517,15520,15526,15529,15534,15535,15542,15545,15546,15547,15548,15549,15550,15551,15554,15555,15556,15558,15559,15560,15561,15562,15569,15573,15585,15586,15589,15590,15591,15592,15593,15607,15619,15620,15621,15622,15623,15631,15635,15639,15663,15668,15669,15673,15675,15677,15693,15694,15711,15712,15720,15729,15747,15748,15751,15752,15759,15760,15763,15764,15769,15776,15778,15786,15796,15797,15802,15817,15818,15821,15824,15845,15846,15848,15853,15862,15870,15874,15875,15882,15889,15895,15901,15902,15903,15907,15909,15910,15911,15912,15916,15919,15920,15921,15931,15932,15933,15939,15947,15954,15956,15957,15958,15968,15972,15973,15975,15976,15977,15981,15982,15984,15989,15992,16002,16016,16019,16020,16025,16026,16033,16034,16035,16036,16037,16038,16041,16058,16060,16064,16074,16086,16090,16092,16096,16097,16099,16100,16101,16109,16110,16111,16112,16114,16115,16122,16123,16124,16125,16128,16129,16132,16135,16137,16140,16141,16142,16144,16145,16213,16215,16216,16218,16227,16228,16230,16235,16238,16239,16241,16242,16243,16247,16248,16250,16251,16252,16254,16257,16265,16278,16291,16299,16302,16303,16304,16313,16315,16322,16332,16335,16336,16338,16355,16367,16368,16370,16371,16372,16378,16385,16386,16391,16392,16393,16397,16398,16399,16400,16401,16402,16404,16405,16406,16408,16410,16411,16412,16414,16415,16416,16418,16420,16422,16423,16424,16425,16426,16428,16430,16431,16434,16435,16436,16437,16438,16439,16440,16441,16443,16450,16457,16459,16466,16467,16468,16469,16476,16477,16478,16481,16482,16483,16484,16485,16486,16487,16488,16489,16490,16491,16492,16499,16503,16504,16505,16508,16509,16511,16512,16513,16524,16525,16547,16548,16552,16553,16554,16555,16563,16568,16580,16581,16582,16583,16587,16599,16613,16627,16636,16643,16644,16645,16653,16656,16662,16665,16666,16671,16673,16676,16679,16690,16691,16692,16694,16697,16705,16706,16710,16711,16733,16734,16736,16737,16738,16743,16747,16755,16785,16787,16788,16789,16790,16792,16793,16802,16810,16811,16814,16820,16821,16824,16827,16831,16835,16836,16837,16850,16851,16852,16853,16854,16855,16858,16859,16863,16865,16874,16875,16876,16883,16884,16893,16896,16897,16898,16899,16903,16909,16913,16924,16925,16931,16932,16934,16941,16944,16949,16957,16958,16961,16965,16967,16971,16979,16981,16982,16995,16996,16998,17008,17011,17012,17013,17014,17015,17016,17017,17018,17019,17022,17025,17033,17034,17037,17042,17045,17046,17048,17051,17059,17060,17062,17063,17066,17068,17069,17073,17075,17077,17080,17084,17091,17092,17112,17115,17117,17126,17127,17130,17141,17142,17143,17144,17145,17146,17147,17148,17152,17153,17154,17155,17156,17157,17158,17161,17168,17169,17170,17171,17172,17177,17178,17180,17181,17182,17186,17189,17190,17198,17199,17201,17205,17209,17210,17211,17212,17213,17216,17223,17224,17225,17226,17227,17228,17230,17231,17233,17234,17235,17236,17240,17243,17244,17245,17248,17249,17250,17251,17252,17253,17254,17255,17263,17264,17265,17266,17267,17268,17270,17272,17273,17280,17281,17282,17284,17285,17286,17290,17293,17332,17338,17339,17340,17341,17342,17344,17345,17346,17348,17350,17351,17352,17353,17354,17355,17356,17357,17358,17359,17360,17365,17366,17368,17371,17372,17373,17374,17378,17379,17380,17382,17384,17385,17387,17389,17391,17396,17398,17399,17401,17402,17408,17412,17416,17418,17424,17428,17429,17430,17433,17435,17436,17441,17444,17445,17446,17447,17449,17450,17451,17452,17461,17466,17467,17468,17472,17481,17485,17486,17487,17488,17492,17493,17495,17502,17504,17505,17508,17509,17510,17512,17514,17515,17524,17526,17527,17528,17530,17543,17545,17554,17555,17557,17558,17559,17560,17561,17562,17563,17565,17566,17567,17576,17577,17578,17581,17582,17583,17584,17585,17586,17587,17589,17590,17591,17592,17600,17601,17606,17607,17608,17610,17612,17613,17614,17616,17617,17619,17620,17621,17622,17623,17624,17625,17628,17635,17637,17640,17641,17642,17649,17650,17654,17657,17658,17659,17660,17661,17664,17668,17669,17670,17671,17672,17673,17674,17675,17677,17680,17682,17683,17688,17689,17690,17691,17692,17693,17697,17699,17700,17701,17704,17710,17711,17718,17721,17729,17733,17738,17739,17741,17742,17743,17744,17746,17747,17748,17750,17756,17763,17764,17765,17766,17768,17769,17770,17773,17775,17777,17778,17788,17789,17790,17795,17796,17799,17802,17806,17808,17809,17814,17817,17818,17819,17820,17821,17823,17827,17830,17831,17832,17834,17835,17836,17838,17841,17843,17844,17847,17854,17856,17858,17859,17860,17863,17864,17865,17871,17873,17874,17875,17876,17878,17879,17880,17881,17882,17883,17884,17885,17886,17891,17892,17893,17894,17895,17896,17897,17898,17899,17900,17901,17902,17903,17904,17906,17907,17909,17912,17913,17914,17921,17922,17923,17926,17928,17929,17930,17931,17932,17939,17940,17941,17942,17943,17944,17945,17946,17948,17949,17951,17952,17953,17954,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17968,17969,17970,17971,17972,17973,17974,17975,17976,17977,17980,17981,17983,17987,17988,17990,17992,17993,17994,17995,17996,17997,17998,18001,18002,18003,18004,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,18027,18028,18032,18034,18035,18038,18039,18040,18041,18042,18044,18045,18046,18047,18048,18057,18058,18059,18061,18062,18064,18065,18066,18067,18068,18069,18070,18071,18079,18080,18082,18084,18086,18087,18088,18089,18090,18091,18092,18093,18094,18096,18098,18099,18100,18101,18102,18108,18109,18110,18111,18112,18113,18115,18116,18117,18118,18119,18120,18121,18123,18125,18126,18128,18129,18130,18131,18132,18134,18135,18138,18142,18143,18154,18155,18156,18157,18158,18159,18160,18161,18162,18164,18166,18170,18171,18172,18173,18174,18177,18178,18179,18180,18181,18182,18183,18185,18186,18187,18188,18189,18190,18193,18199,18211,18212,18213,18214,18216,18219,18220,18221,18224,18233,18235,18236,18237,18239,18240,18241,18247,18251,18252,18253,18254,18256,18271,18275,18276,18277,18281,18282,18293,18304,18309,18312,18313,18314,18315,18316,18317,18318,18328,18329,18330,18331,18332,18334,18335,18338,18341,18342,18345,18346,18347,18348,18350,18351,18356,18359,18360,18361,18362,18365,18367,18368,18369,18370,18371,18372,18373,18375,18379,18383,18384,18385,18386,18388,18389,18390,18391,18392,18393,18396,18398,18399,18400,18401,18402,18403,18404,18406,18407,18409,18422,18423,18424,18428,18429,18431,18432,18433,18437,18438,18439,18440,18441,18442,18443,18445,18446,18448,18449,18450,18451,18452,18453,18454,18455,18456,18457,18458,18459,18464,18465,18466,18467,18475,18476,18498,18499,18511,18512,18515,18516,18517,18522,18523,18524,18525,18528,18529,18530,18531,18532,18533,18534,18535,18536,18540,18541,18542,18545,18546,18554,18556,18557,18559,18560,18562,18564,18579,18580,18581,18583,18584,18585,18587,18588,18589,18590,18593,18595,18597,18601,18605,18608,18614,18615,18616,18617,18632,18633,18634,18640,18643,18644,18645,18646,18647,18648,18649,18650,18651,18652,18653,18654,18655,18656,18657,18661,18662,18663,18664,18665,18666,18674,18682,18683,18684,18686,18695,18696,18697,18698,18699,18700,18701,18703,18704,18705,18706,18708,18709,18710,18711,18712,18713,18714,18715,18717,18726,18728,18729,18730,18731,18734,18735,18736,18741,18742,18743,18746,18748,18750,18751,18752,18753,18754,18757,18758,18763,18766,18768,18771,18772,18773,18774,18775,18779,18780,18781,18782,18783,18784,18786,18789,18794,18797,18798,18802,18803,18807,18811,18815,18816,18818,18822,18823,18824,18827,18828,18830,18831,18832,18833,18834,18836,18837,18838,18839,18840,18841,18842,18846,18847,18848,18850,18851,18853,18854,18860,18862,18865,18866,18867,18868,18869,18870,18875,18876,18877,18881,18889,18890,18891,18892,18897,18898,18899,18901,18902,18903,18904,18905,18906,18911,18912,18913,18914,18915,18917,18918,18920,18921,18922,18924,18925,18926,18928,18929,18930,18932,18933,18940,18941,18942,18943,18946,18947,18948,18949,18950,18952,18953,18955,18956,18957,18958,18959,18960,18962,18963,18965,18966,18967,18968,18972,18973,18974,18975,18976,18979,18981,18982,18985,18986,18988,18991,18992,18994,18996,18997,18999,19000,19001,19002,19003,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19022,19025,19026,19027,19028,19029,19033,19034,19035,19036,19042,19044,19049,19050,19051,19053,19054,19056,19057,19058,19059,19060,19061,19062,19063,19065,19066,19067,19068,19069,19071,19072,19073,19074,19075,19076,19077,19078,19083,19084,19085,19086,19087,19088,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19109,19110,19111,19112,19113,19114,19115,19116,19117,19119,19120,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19135,19136,19138,19140,19141,19143,19144,19145,19148,19149,19150,19151,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19173,19174,19175,19178,19179,19180,19181,19182,19183,19185,19188,19189,19191,19192,19194,19195,19196,19197,19198,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19217,19218,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19231,19232,19236,19237,19238,19239,19240,19241,19252,19253,19254,19255,19256,19257,19258,19259,19261,19264,19265,19266,19267,19268,19269,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19286,19294,19295) GROUP BY product_id;. Bound with :date='2025-04-09'
|
| 15:56:47.188 | trace | system.db.CDbCommand |
Querying SQL: SELECT
s.product_id, s.start_selling_on_date AS d, SUM(s.number_of_units_ordered * IF(s.reception_type = 4, floor(s.reception_weight/p.weight), 1)) AS nb FROM supplier_forecast_orders s LEFT JOIN products p ON (p.product_id = s.product_id) WHERE s.start_selling_on_date BETWEEN DATE_ADD(:start, INTERVAL 1 DAY) AND :end AND s.status IN (3, 14) AND s.instant_in_out = 0 AND s.product_id IN (40,43,48,50,54,136,235,244,247,301,304,447,512,513,516,544,914,915,920,935,1114,1120,1121,1122,1139,1140,1204,1287,1299,1362,1364,1365,1367,1370,1371,1417,1418,1419,1420,1421,1422,1423,1427,1431,1500,1501,1525,1743,1744,1776,1777,1778,1945,2012,2013,2018,2020,2026,2060,2061,2093,2094,2153,2156,2181,2231,2288,2331,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2362,2363,2364,2369,2370,2380,2381,2406,2427,2439,2440,2510,2526,2563,2572,2573,2596,2597,2640,2644,2675,2679,2681,2695,2697,2709,2710,2711,2714,2738,2743,2754,2755,2756,2770,2771,2772,2778,2796,2905,2906,2907,2910,2917,2918,2939,2982,3002,3052,3209,3215,3216,3220,3222,3230,3231,3235,3236,3237,3239,3240,3241,3243,3253,3254,3262,3264,3266,3309,3313,3318,3322,3323,3326,3329,3335,3336,3351,3352,3373,3374,3377,3385,3386,3387,3485,3498,3499,3500,3501,3502,3587,3590,3617,3622,3623,3668,3669,3690,3692,3725,3792,3794,4203,4204,4206,4211,4226,4228,4231,4249,4261,4262,4278,4282,4285,4288,4289,4320,4321,4322,4325,4332,4335,4339,4346,4361,4363,4367,4371,4373,4375,4379,4386,4387,4413,4414,4437,4449,4450,4455,4471,4475,4476,4478,4486,4496,4520,4521,4529,4533,4539,4555,4556,4583,4584,4589,4592,4605,4675,4685,4691,4692,4693,4694,4743,4932,4933,5039,5043,5047,5071,5157,5164,5168,5171,5185,5194,5205,5207,5208,5213,5215,5219,5237,5239,5240,5294,5376,5540,5547,5604,5609,5630,5631,5632,5633,5646,5688,5693,5696,5707,5712,5750,5763,5764,5776,5791,5793,5831,5841,5843,5922,5960,5964,5966,6010,6021,6042,6043,6046,6047,6048,6072,6074,6089,6109,6121,6122,6150,6151,6194,6196,6198,6200,6223,6265,6288,6362,6374,6565,6569,6599,6654,6677,6729,6788,6797,6798,6799,6801,6803,6805,6807,6808,6830,6834,6835,6837,6840,6855,6856,6873,6877,6880,6889,6897,6985,6991,7020,7022,7025,7027,7047,7093,7094,7095,7107,7113,7122,7128,7129,7130,7136,7137,7138,7140,7157,7158,7177,7260,7279,7280,7281,7307,7308,7309,7310,7337,7353,7354,7357,7362,7397,7428,7431,7439,7444,7447,7479,7480,7482,7483,7487,7489,7490,7491,7528,7530,7595,7597,7598,7601,7602,7679,7750,7753,7774,7775,7812,7813,7814,7818,7820,7822,7877,7880,7923,7994,7995,8004,8005,8006,8007,8024,8030,8054,8055,8072,8201,8236,8239,8248,8274,8275,8312,8326,8341,8356,8404,8405,8413,8420,8445,8513,8514,8529,8546,8549,8550,8555,8556,8557,8558,8565,8575,8577,8591,8597,8598,8600,8602,8606,8608,8614,8618,8621,8622,8624,8625,8627,8628,8630,8632,8634,8635,8669,8670,8673,8674,8687,8690,8695,8708,8710,8723,8733,8736,8737,8738,8752,8754,8756,8757,8758,8759,8760,8761,8762,8767,8768,8769,8780,8788,8789,8820,8845,8848,8853,8886,8894,8898,8899,8900,8907,8922,8925,8926,8928,8945,8971,8980,8988,8989,8990,8991,8992,8993,8995,8996,8997,8998,9012,9036,9055,9056,9057,9064,9065,9066,9067,9068,9076,9093,9095,9116,9117,9118,9119,9120,9121,9126,9128,9129,9134,9135,9144,9145,9148,9149,9150,9159,9219,9222,9227,9235,9236,9237,9238,9239,9253,9264,9409,9416,9417,9435,9436,9438,9439,9448,9449,9487,9510,9525,9546,9577,9578,9579,9650,9658,9686,9699,9700,9712,9723,9736,9737,9741,9772,9796,9799,9800,9820,9832,9892,9893,9895,9896,9908,9909,9910,9911,9914,9918,9921,9923,9924,9951,9956,9959,9960,9966,9997,9998,10034,10037,10038,10053,10056,10058,10059,10060,10062,10063,10074,10084,10096,10097,10119,10122,10123,10124,10133,10137,10143,10144,10145,10147,10148,10156,10158,10160,10174,10177,10180,10186,10189,10201,10202,10203,10204,10205,10206,10207,10208,10234,10235,10254,10260,10273,10274,10275,10288,10289,10290,10291,10292,10293,10295,10332,10337,10388,10389,10390,10392,10394,10396,10397,10398,10400,10407,10409,10410,10411,10413,10414,10424,10446,10455,10456,10457,10464,10510,10522,10546,10557,10559,10560,10562,10572,10573,10575,10576,10577,10578,10579,10580,10582,10583,10584,10585,10586,10609,10613,10643,10644,10649,10651,10652,10662,10663,10664,10665,10666,10667,10668,10680,10693,10700,10701,10704,10705,10706,10727,10728,10731,10734,10735,10736,10745,10746,10747,10748,10749,10759,10763,10766,10767,10770,10771,10774,10776,10794,10834,10848,10849,10851,10852,10853,10862,10863,10864,10895,10902,10903,10904,10905,10906,10907,10908,10909,10910,10912,10917,10918,10920,10938,10939,10940,10941,10942,10943,10976,10987,11011,11022,11024,11025,11026,11027,11028,11029,11031,11032,11060,11063,11091,11092,11095,11106,11124,11127,11128,11142,11170,11171,11192,11204,11215,11216,11217,11220,11226,11239,11243,11259,11268,11269,11270,11272,11276,11279,11280,11300,11301,11315,11328,11329,11330,11332,11339,11344,11353,11354,11357,11358,11359,11360,11363,11364,11367,11370,11409,11410,11411,11413,11424,11452,11475,11478,11479,11496,11508,11529,11534,11551,11563,11565,11567,11580,11581,11587,11588,11589,11592,11593,11601,11609,11640,11643,11646,11664,11665,11688,11689,11706,11729,11753,11770,11776,11777,11782,11784,11786,11815,11820,11825,11834,11840,11853,11869,11870,11871,11894,11903,11908,11918,11940,11952,11985,11990,11994,11995,12000,12002,12004,12009,12010,12016,12018,12019,12020,12021,12067,12079,12082,12094,12100,12101,12102,12103,12104,12105,12109,12111,12112,12119,12120,12125,12126,12127,12129,12130,12131,12132,12133,12134,12136,12154,12176,12184,12185,12190,12191,12192,12198,12206,12213,12216,12236,12239,12240,12260,12263,12264,12269,12270,12271,12272,12273,12274,12282,12283,12289,12290,12291,12292,12293,12294,12296,12299,12302,12306,12307,12308,12313,12319,12322,12326,12337,12338,12345,12353,12356,12369,12374,12393,12395,12399,12426,12439,12442,12444,12445,12465,12466,12471,12472,12475,12483,12491,12500,12502,12503,12504,12505,12531,12532,12533,12536,12537,12538,12542,12553,12558,12559,12567,12585,12586,12608,12614,12616,12640,12644,12676,12719,12720,12721,12722,12727,12735,12737,12738,12741,12743,12746,12747,12748,12766,12767,12775,12779,12782,12809,12810,12818,12822,12843,12850,12853,12856,12857,12871,12894,12927,12929,12932,12958,12959,12960,12961,12962,12963,12964,12965,12966,12967,12974,12979,12980,12983,12984,12986,12988,12990,12999,13015,13032,13040,13043,13050,13053,13054,13060,13062,13073,13082,13085,13087,13091,13097,13172,13181,13182,13183,13184,13187,13188,13189,13190,13191,13193,13194,13195,13196,13228,13251,13262,13264,13265,13266,13268,13269,13275,13279,13297,13299,13323,13324,13331,13333,13334,13354,13355,13357,13358,13359,13368,13378,13379,13381,13403,13409,13410,13414,13419,13423,13424,13450,13483,13485,13486,13497,13507,13512,13552,13558,13563,13584,13595,13599,13601,13602,13619,13622,13624,13626,13627,13628,13629,13630,13641,13646,13647,13674,13675,13676,13681,13689,13691,13692,13695,13697,13703,13706,13707,13708,13709,13710,13712,13718,13719,13722,13730,13736,13739,13741,13745,13750,13754,13756,13757,13758,13759,13761,13762,13763,13765,13766,13772,13775,13781,13791,13794,13801,13803,13806,13808,13812,13813,13814,13815,13818,13820,13827,13829,13833,13834,13835,13844,13845,13851,13852,13853,13854,13856,13860,13873,13874,13879,13881,13882,13883,13890,13896,13897,13911,13915,13916,13921,13929,13931,13932,13942,13950,13951,13952,13958,13965,13995,13996,13998,14001,14005,14006,14023,14027,14044,14045,14046,14064,14071,14076,14078,14079,14088,14090,14092,14093,14094,14095,14096,14097,14098,14099,14100,14101,14103,14132,14135,14136,14137,14146,14147,14149,14159,14167,14170,14180,14185,14186,14188,14189,14190,14191,14192,14197,14212,14213,14219,14220,14223,14230,14239,14241,14243,14247,14249,14265,14270,14276,14285,14291,14293,14294,14304,14306,14316,14317,14318,14320,14322,14323,14327,14332,14333,14337,14343,14344,14348,14349,14356,14360,14363,14370,14374,14376,14381,14388,14396,14397,14400,14405,14406,14408,14409,14410,14411,14417,14420,14428,14437,14439,14442,14451,14452,14456,14460,14461,14463,14482,14484,14491,14527,14528,14530,14541,14554,14556,14578,14579,14580,14581,14611,14627,14641,14662,14690,14691,14693,14701,14705,14706,14713,14715,14716,14717,14718,14719,14723,14725,14727,14728,14729,14745,14749,14760,14762,14774,14775,14786,14795,14796,14797,14808,14812,14813,14819,14820,14824,14825,14826,14831,14834,14841,14845,14854,14856,14872,14885,14900,14901,14926,14986,14987,15017,15036,15038,15053,15058,15061,15064,15067,15079,15082,15083,15084,15085,15090,15101,15102,15107,15112,15117,15119,15124,15127,15128,15130,15147,15148,15156,15163,15165,15166,15168,15169,15170,15171,15173,15174,15175,15176,15177,15180,15184,15189,15190,15191,15192,15193,15194,15199,15219,15221,15222,15223,15272,15275,15277,15289,15292,15300,15314,15315,15335,15336,15340,15341,15342,15343,15344,15365,15366,15382,15398,15402,15403,15404,15405,15407,15413,15417,15428,15430,15431,15437,15449,15450,15453,15459,15468,15475,15478,15479,15484,15495,15497,15498,15501,15502,15503,15507,15508,15515,15516,15517,15520,15526,15529,15534,15535,15542,15545,15546,15547,15548,15549,15550,15551,15554,15555,15556,15558,15559,15560,15561,15562,15569,15573,15585,15586,15589,15590,15591,15592,15593,15607,15619,15620,15621,15622,15623,15631,15635,15639,15663,15668,15669,15673,15675,15677,15693,15694,15711,15712,15720,15729,15747,15748,15751,15752,15759,15760,15763,15764,15769,15776,15778,15786,15796,15797,15802,15817,15818,15821,15824,15845,15846,15848,15853,15862,15870,15874,15875,15882,15889,15895,15901,15902,15903,15907,15909,15910,15911,15912,15916,15919,15920,15921,15931,15932,15933,15939,15947,15954,15956,15957,15958,15968,15972,15973,15975,15976,15977,15981,15982,15984,15989,15992,16002,16016,16019,16020,16025,16026,16033,16034,16035,16036,16037,16038,16041,16058,16060,16064,16074,16086,16090,16092,16096,16097,16099,16100,16101,16109,16110,16111,16112,16114,16115,16122,16123,16124,16125,16128,16129,16132,16135,16137,16140,16141,16142,16144,16145,16213,16215,16216,16218,16227,16228,16230,16235,16238,16239,16241,16242,16243,16247,16248,16250,16251,16252,16254,16257,16265,16278,16291,16299,16302,16303,16304,16313,16315,16322,16332,16335,16336,16338,16355,16367,16368,16370,16371,16372,16378,16385,16386,16391,16392,16393,16397,16398,16399,16400,16401,16402,16404,16405,16406,16408,16410,16411,16412,16414,16415,16416,16418,16420,16422,16423,16424,16425,16426,16428,16430,16431,16434,16435,16436,16437,16438,16439,16440,16441,16443,16450,16457,16459,16466,16467,16468,16469,16476,16477,16478,16481,16482,16483,16484,16485,16486,16487,16488,16489,16490,16491,16492,16499,16503,16504,16505,16508,16509,16511,16512,16513,16524,16525,16547,16548,16552,16553,16554,16555,16563,16568,16580,16581,16582,16583,16587,16599,16613,16627,16636,16643,16644,16645,16653,16656,16662,16665,16666,16671,16673,16676,16679,16690,16691,16692,16694,16697,16705,16706,16710,16711,16733,16734,16736,16737,16738,16743,16747,16755,16785,16787,16788,16789,16790,16792,16793,16802,16810,16811,16814,16820,16821,16824,16827,16831,16835,16836,16837,16850,16851,16852,16853,16854,16855,16858,16859,16863,16865,16874,16875,16876,16883,16884,16893,16896,16897,16898,16899,16903,16909,16913,16924,16925,16931,16932,16934,16941,16944,16949,16957,16958,16961,16965,16967,16971,16979,16981,16982,16995,16996,16998,17008,17011,17012,17013,17014,17015,17016,17017,17018,17019,17022,17025,17033,17034,17037,17042,17045,17046,17048,17051,17059,17060,17062,17063,17066,17068,17069,17073,17075,17077,17080,17084,17091,17092,17112,17115,17117,17126,17127,17130,17141,17142,17143,17144,17145,17146,17147,17148,17152,17153,17154,17155,17156,17157,17158,17161,17168,17169,17170,17171,17172,17177,17178,17180,17181,17182,17186,17189,17190,17198,17199,17201,17205,17209,17210,17211,17212,17213,17216,17223,17224,17225,17226,17227,17228,17230,17231,17233,17234,17235,17236,17240,17243,17244,17245,17248,17249,17250,17251,17252,17253,17254,17255,17263,17264,17265,17266,17267,17268,17270,17272,17273,17280,17281,17282,17284,17285,17286,17290,17293,17332,17338,17339,17340,17341,17342,17344,17345,17346,17348,17350,17351,17352,17353,17354,17355,17356,17357,17358,17359,17360,17365,17366,17368,17371,17372,17373,17374,17378,17379,17380,17382,17384,17385,17387,17389,17391,17396,17398,17399,17401,17402,17408,17412,17416,17418,17424,17428,17429,17430,17433,17435,17436,17441,17444,17445,17446,17447,17449,17450,17451,17452,17461,17466,17467,17468,17472,17481,17485,17486,17487,17488,17492,17493,17495,17502,17504,17505,17508,17509,17510,17512,17514,17515,17524,17526,17527,17528,17530,17543,17545,17554,17555,17557,17558,17559,17560,17561,17562,17563,17565,17566,17567,17576,17577,17578,17581,17582,17583,17584,17585,17586,17587,17589,17590,17591,17592,17600,17601,17606,17607,17608,17610,17612,17613,17614,17616,17617,17619,17620,17621,17622,17623,17624,17625,17628,17635,17637,17640,17641,17642,17649,17650,17654,17657,17658,17659,17660,17661,17664,17668,17669,17670,17671,17672,17673,17674,17675,17677,17680,17682,17683,17688,17689,17690,17691,17692,17693,17697,17699,17700,17701,17704,17710,17711,17718,17721,17729,17733,17738,17739,17741,17742,17743,17744,17746,17747,17748,17750,17756,17763,17764,17765,17766,17768,17769,17770,17773,17775,17777,17778,17788,17789,17790,17795,17796,17799,17802,17806,17808,17809,17814,17817,17818,17819,17820,17821,17823,17827,17830,17831,17832,17834,17835,17836,17838,17841,17843,17844,17847,17854,17856,17858,17859,17860,17863,17864,17865,17871,17873,17874,17875,17876,17878,17879,17880,17881,17882,17883,17884,17885,17886,17891,17892,17893,17894,17895,17896,17897,17898,17899,17900,17901,17902,17903,17904,17906,17907,17909,17912,17913,17914,17921,17922,17923,17926,17928,17929,17930,17931,17932,17939,17940,17941,17942,17943,17944,17945,17946,17948,17949,17951,17952,17953,17954,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17968,17969,17970,17971,17972,17973,17974,17975,17976,17977,17980,17981,17983,17987,17988,17990,17992,17993,17994,17995,17996,17997,17998,18001,18002,18003,18004,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,18027,18028,18032,18034,18035,18038,18039,18040,18041,18042,18044,18045,18046,18047,18048,18057,18058,18059,18061,18062,18064,18065,18066,18067,18068,18069,18070,18071,18079,18080,18082,18084,18086,18087,18088,18089,18090,18091,18092,18093,18094,18096,18098,18099,18100,18101,18102,18108,18109,18110,18111,18112,18113,18115,18116,18117,18118,18119,18120,18121,18123,18125,18126,18128,18129,18130,18131,18132,18134,18135,18138,18142,18143,18154,18155,18156,18157,18158,18159,18160,18161,18162,18164,18166,18170,18171,18172,18173,18174,18177,18178,18179,18180,18181,18182,18183,18185,18186,18187,18188,18189,18190,18193,18199,18211,18212,18213,18214,18216,18219,18220,18221,18224,18233,18235,18236,18237,18239,18240,18241,18247,18251,18252,18253,18254,18256,18271,18275,18276,18277,18281,18282,18293,18304,18309,18312,18313,18314,18315,18316,18317,18318,18328,18329,18330,18331,18332,18334,18335,18338,18341,18342,18345,18346,18347,18348,18350,18351,18356,18359,18360,18361,18362,18365,18367,18368,18369,18370,18371,18372,18373,18375,18379,18383,18384,18385,18386,18388,18389,18390,18391,18392,18393,18396,18398,18399,18400,18401,18402,18403,18404,18406,18407,18409,18422,18423,18424,18428,18429,18431,18432,18433,18437,18438,18439,18440,18441,18442,18443,18445,18446,18448,18449,18450,18451,18452,18453,18454,18455,18456,18457,18458,18459,18464,18465,18466,18467,18475,18476,18498,18499,18511,18512,18515,18516,18517,18522,18523,18524,18525,18528,18529,18530,18531,18532,18533,18534,18535,18536,18540,18541,18542,18545,18546,18554,18556,18557,18559,18560,18562,18564,18579,18580,18581,18583,18584,18585,18587,18588,18589,18590,18593,18595,18597,18601,18605,18608,18614,18615,18616,18617,18632,18633,18634,18640,18643,18644,18645,18646,18647,18648,18649,18650,18651,18652,18653,18654,18655,18656,18657,18661,18662,18663,18664,18665,18666,18674,18682,18683,18684,18686,18695,18696,18697,18698,18699,18700,18701,18703,18704,18705,18706,18708,18709,18710,18711,18712,18713,18714,18715,18717,18726,18728,18729,18730,18731,18734,18735,18736,18741,18742,18743,18746,18748,18750,18751,18752,18753,18754,18757,18758,18763,18766,18768,18771,18772,18773,18774,18775,18779,18780,18781,18782,18783,18784,18786,18789,18794,18797,18798,18802,18803,18807,18811,18815,18816,18818,18822,18823,18824,18827,18828,18830,18831,18832,18833,18834,18836,18837,18838,18839,18840,18841,18842,18846,18847,18848,18850,18851,18853,18854,18860,18862,18865,18866,18867,18868,18869,18870,18875,18876,18877,18881,18889,18890,18891,18892,18897,18898,18899,18901,18902,18903,18904,18905,18906,18911,18912,18913,18914,18915,18917,18918,18920,18921,18922,18924,18925,18926,18928,18929,18930,18932,18933,18940,18941,18942,18943,18946,18947,18948,18949,18950,18952,18953,18955,18956,18957,18958,18959,18960,18962,18963,18965,18966,18967,18968,18972,18973,18974,18975,18976,18979,18981,18982,18985,18986,18988,18991,18992,18994,18996,18997,18999,19000,19001,19002,19003,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19022,19025,19026,19027,19028,19029,19033,19034,19035,19036,19042,19044,19049,19050,19051,19053,19054,19056,19057,19058,19059,19060,19061,19062,19063,19065,19066,19067,19068,19069,19071,19072,19073,19074,19075,19076,19077,19078,19083,19084,19085,19086,19087,19088,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19109,19110,19111,19112,19113,19114,19115,19116,19117,19119,19120,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19135,19136,19138,19140,19141,19143,19144,19145,19148,19149,19150,19151,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19173,19174,19175,19178,19179,19180,19181,19182,19183,19185,19188,19189,19191,19192,19194,19195,19196,19197,19198,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19217,19218,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19231,19232,19236,19237,19238,19239,19240,19241,19252,19253,19254,19255,19256,19257,19258,19259,19261,19264,19265,19266,19267,19268,19269,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19286,19294,19295) GROUP BY product_id, start_selling_on_date;. Bound with :start='2025-04-09', :end='2025-04-17'
|
| 15:56:47.203 | trace | system.db.CDbCommand |
Querying SQL:
SELECT od.product_id, o.delivery_date AS d, COUNT(od.order_details_id) AS qty FROM order_details od IGNORE INDEX (idx_product_id) INNER JOIN ( SELECT order_id, delivery_date FROM orders WHERE delivery_date BETWEEN :start AND :end AND status IN (1,2,3,4) AND delivery_date NOT IN ( SELECT DATE(`date`) FROM inventory_uptodate_flags WHERE `date` BETWEEN :start AND :end ) ) as o ON o.order_id = od.order_id WHERE od.product_id IN (40,43,48,50,54,136,235,244,247,301,304,447,512,513,516,544,914,915,920,935,1114,1120,1121,1122,1139,1140,1204,1287,1299,1362,1364,1365,1367,1370,1371,1417,1418,1419,1420,1421,1422,1423,1427,1431,1500,1501,1525,1743,1744,1776,1777,1778,1945,2012,2013,2018,2020,2026,2060,2061,2093,2094,2153,2156,2181,2231,2288,2331,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2362,2363,2364,2369,2370,2380,2381,2406,2427,2439,2440,2510,2526,2563,2572,2573,2596,2597,2640,2644,2675,2679,2681,2695,2697,2709,2710,2711,2714,2738,2743,2754,2755,2756,2770,2771,2772,2778,2796,2905,2906,2907,2910,2917,2918,2939,2982,3002,3052,3209,3215,3216,3220,3222,3230,3231,3235,3236,3237,3239,3240,3241,3243,3253,3254,3262,3264,3266,3309,3313,3318,3322,3323,3326,3329,3335,3336,3351,3352,3373,3374,3377,3385,3386,3387,3485,3498,3499,3500,3501,3502,3587,3590,3617,3622,3623,3668,3669,3690,3692,3725,3792,3794,4203,4204,4206,4211,4226,4228,4231,4249,4261,4262,4278,4282,4285,4288,4289,4320,4321,4322,4325,4332,4335,4339,4346,4361,4363,4367,4371,4373,4375,4379,4386,4387,4413,4414,4437,4449,4450,4455,4471,4475,4476,4478,4486,4496,4520,4521,4529,4533,4539,4555,4556,4583,4584,4589,4592,4605,4675,4685,4691,4692,4693,4694,4743,4932,4933,5039,5043,5047,5071,5157,5164,5168,5171,5185,5194,5205,5207,5208,5213,5215,5219,5237,5239,5240,5294,5376,5540,5547,5604,5609,5630,5631,5632,5633,5646,5688,5693,5696,5707,5712,5750,5763,5764,5776,5791,5793,5831,5841,5843,5922,5960,5964,5966,6010,6021,6042,6043,6046,6047,6048,6072,6074,6089,6109,6121,6122,6150,6151,6194,6196,6198,6200,6223,6265,6288,6362,6374,6565,6569,6599,6654,6677,6729,6788,6797,6798,6799,6801,6803,6805,6807,6808,6830,6834,6835,6837,6840,6855,6856,6873,6877,6880,6889,6897,6985,6991,7020,7022,7025,7027,7047,7093,7094,7095,7107,7113,7122,7128,7129,7130,7136,7137,7138,7140,7157,7158,7177,7260,7279,7280,7281,7307,7308,7309,7310,7337,7353,7354,7357,7362,7397,7428,7431,7439,7444,7447,7479,7480,7482,7483,7487,7489,7490,7491,7528,7530,7595,7597,7598,7601,7602,7679,7750,7753,7774,7775,7812,7813,7814,7818,7820,7822,7877,7880,7923,7994,7995,8004,8005,8006,8007,8024,8030,8054,8055,8072,8201,8236,8239,8248,8274,8275,8312,8326,8341,8356,8404,8405,8413,8420,8445,8513,8514,8529,8546,8549,8550,8555,8556,8557,8558,8565,8575,8577,8591,8597,8598,8600,8602,8606,8608,8614,8618,8621,8622,8624,8625,8627,8628,8630,8632,8634,8635,8669,8670,8673,8674,8687,8690,8695,8708,8710,8723,8733,8736,8737,8738,8752,8754,8756,8757,8758,8759,8760,8761,8762,8767,8768,8769,8780,8788,8789,8820,8845,8848,8853,8886,8894,8898,8899,8900,8907,8922,8925,8926,8928,8945,8971,8980,8988,8989,8990,8991,8992,8993,8995,8996,8997,8998,9012,9036,9055,9056,9057,9064,9065,9066,9067,9068,9076,9093,9095,9116,9117,9118,9119,9120,9121,9126,9128,9129,9134,9135,9144,9145,9148,9149,9150,9159,9219,9222,9227,9235,9236,9237,9238,9239,9253,9264,9409,9416,9417,9435,9436,9438,9439,9448,9449,9487,9510,9525,9546,9577,9578,9579,9650,9658,9686,9699,9700,9712,9723,9736,9737,9741,9772,9796,9799,9800,9820,9832,9892,9893,9895,9896,9908,9909,9910,9911,9914,9918,9921,9923,9924,9951,9956,9959,9960,9966,9997,9998,10034,10037,10038,10053,10056,10058,10059,10060,10062,10063,10074,10084,10096,10097,10119,10122,10123,10124,10133,10137,10143,10144,10145,10147,10148,10156,10158,10160,10174,10177,10180,10186,10189,10201,10202,10203,10204,10205,10206,10207,10208,10234,10235,10254,10260,10273,10274,10275,10288,10289,10290,10291,10292,10293,10295,10332,10337,10388,10389,10390,10392,10394,10396,10397,10398,10400,10407,10409,10410,10411,10413,10414,10424,10446,10455,10456,10457,10464,10510,10522,10546,10557,10559,10560,10562,10572,10573,10575,10576,10577,10578,10579,10580,10582,10583,10584,10585,10586,10609,10613,10643,10644,10649,10651,10652,10662,10663,10664,10665,10666,10667,10668,10680,10693,10700,10701,10704,10705,10706,10727,10728,10731,10734,10735,10736,10745,10746,10747,10748,10749,10759,10763,10766,10767,10770,10771,10774,10776,10794,10834,10848,10849,10851,10852,10853,10862,10863,10864,10895,10902,10903,10904,10905,10906,10907,10908,10909,10910,10912,10917,10918,10920,10938,10939,10940,10941,10942,10943,10976,10987,11011,11022,11024,11025,11026,11027,11028,11029,11031,11032,11060,11063,11091,11092,11095,11106,11124,11127,11128,11142,11170,11171,11192,11204,11215,11216,11217,11220,11226,11239,11243,11259,11268,11269,11270,11272,11276,11279,11280,11300,11301,11315,11328,11329,11330,11332,11339,11344,11353,11354,11357,11358,11359,11360,11363,11364,11367,11370,11409,11410,11411,11413,11424,11452,11475,11478,11479,11496,11508,11529,11534,11551,11563,11565,11567,11580,11581,11587,11588,11589,11592,11593,11601,11609,11640,11643,11646,11664,11665,11688,11689,11706,11729,11753,11770,11776,11777,11782,11784,11786,11815,11820,11825,11834,11840,11853,11869,11870,11871,11894,11903,11908,11918,11940,11952,11985,11990,11994,11995,12000,12002,12004,12009,12010,12016,12018,12019,12020,12021,12067,12079,12082,12094,12100,12101,12102,12103,12104,12105,12109,12111,12112,12119,12120,12125,12126,12127,12129,12130,12131,12132,12133,12134,12136,12154,12176,12184,12185,12190,12191,12192,12198,12206,12213,12216,12236,12239,12240,12260,12263,12264,12269,12270,12271,12272,12273,12274,12282,12283,12289,12290,12291,12292,12293,12294,12296,12299,12302,12306,12307,12308,12313,12319,12322,12326,12337,12338,12345,12353,12356,12369,12374,12393,12395,12399,12426,12439,12442,12444,12445,12465,12466,12471,12472,12475,12483,12491,12500,12502,12503,12504,12505,12531,12532,12533,12536,12537,12538,12542,12553,12558,12559,12567,12585,12586,12608,12614,12616,12640,12644,12676,12719,12720,12721,12722,12727,12735,12737,12738,12741,12743,12746,12747,12748,12766,12767,12775,12779,12782,12809,12810,12818,12822,12843,12850,12853,12856,12857,12871,12894,12927,12929,12932,12958,12959,12960,12961,12962,12963,12964,12965,12966,12967,12974,12979,12980,12983,12984,12986,12988,12990,12999,13015,13032,13040,13043,13050,13053,13054,13060,13062,13073,13082,13085,13087,13091,13097,13172,13181,13182,13183,13184,13187,13188,13189,13190,13191,13193,13194,13195,13196,13228,13251,13262,13264,13265,13266,13268,13269,13275,13279,13297,13299,13323,13324,13331,13333,13334,13354,13355,13357,13358,13359,13368,13378,13379,13381,13403,13409,13410,13414,13419,13423,13424,13450,13483,13485,13486,13497,13507,13512,13552,13558,13563,13584,13595,13599,13601,13602,13619,13622,13624,13626,13627,13628,13629,13630,13641,13646,13647,13674,13675,13676,13681,13689,13691,13692,13695,13697,13703,13706,13707,13708,13709,13710,13712,13718,13719,13722,13730,13736,13739,13741,13745,13750,13754,13756,13757,13758,13759,13761,13762,13763,13765,13766,13772,13775,13781,13791,13794,13801,13803,13806,13808,13812,13813,13814,13815,13818,13820,13827,13829,13833,13834,13835,13844,13845,13851,13852,13853,13854,13856,13860,13873,13874,13879,13881,13882,13883,13890,13896,13897,13911,13915,13916,13921,13929,13931,13932,13942,13950,13951,13952,13958,13965,13995,13996,13998,14001,14005,14006,14023,14027,14044,14045,14046,14064,14071,14076,14078,14079,14088,14090,14092,14093,14094,14095,14096,14097,14098,14099,14100,14101,14103,14132,14135,14136,14137,14146,14147,14149,14159,14167,14170,14180,14185,14186,14188,14189,14190,14191,14192,14197,14212,14213,14219,14220,14223,14230,14239,14241,14243,14247,14249,14265,14270,14276,14285,14291,14293,14294,14304,14306,14316,14317,14318,14320,14322,14323,14327,14332,14333,14337,14343,14344,14348,14349,14356,14360,14363,14370,14374,14376,14381,14388,14396,14397,14400,14405,14406,14408,14409,14410,14411,14417,14420,14428,14437,14439,14442,14451,14452,14456,14460,14461,14463,14482,14484,14491,14527,14528,14530,14541,14554,14556,14578,14579,14580,14581,14611,14627,14641,14662,14690,14691,14693,14701,14705,14706,14713,14715,14716,14717,14718,14719,14723,14725,14727,14728,14729,14745,14749,14760,14762,14774,14775,14786,14795,14796,14797,14808,14812,14813,14819,14820,14824,14825,14826,14831,14834,14841,14845,14854,14856,14872,14885,14900,14901,14926,14986,14987,15017,15036,15038,15053,15058,15061,15064,15067,15079,15082,15083,15084,15085,15090,15101,15102,15107,15112,15117,15119,15124,15127,15128,15130,15147,15148,15156,15163,15165,15166,15168,15169,15170,15171,15173,15174,15175,15176,15177,15180,15184,15189,15190,15191,15192,15193,15194,15199,15219,15221,15222,15223,15272,15275,15277,15289,15292,15300,15314,15315,15335,15336,15340,15341,15342,15343,15344,15365,15366,15382,15398,15402,15403,15404,15405,15407,15413,15417,15428,15430,15431,15437,15449,15450,15453,15459,15468,15475,15478,15479,15484,15495,15497,15498,15501,15502,15503,15507,15508,15515,15516,15517,15520,15526,15529,15534,15535,15542,15545,15546,15547,15548,15549,15550,15551,15554,15555,15556,15558,15559,15560,15561,15562,15569,15573,15585,15586,15589,15590,15591,15592,15593,15607,15619,15620,15621,15622,15623,15631,15635,15639,15663,15668,15669,15673,15675,15677,15693,15694,15711,15712,15720,15729,15747,15748,15751,15752,15759,15760,15763,15764,15769,15776,15778,15786,15796,15797,15802,15817,15818,15821,15824,15845,15846,15848,15853,15862,15870,15874,15875,15882,15889,15895,15901,15902,15903,15907,15909,15910,15911,15912,15916,15919,15920,15921,15931,15932,15933,15939,15947,15954,15956,15957,15958,15968,15972,15973,15975,15976,15977,15981,15982,15984,15989,15992,16002,16016,16019,16020,16025,16026,16033,16034,16035,16036,16037,16038,16041,16058,16060,16064,16074,16086,16090,16092,16096,16097,16099,16100,16101,16109,16110,16111,16112,16114,16115,16122,16123,16124,16125,16128,16129,16132,16135,16137,16140,16141,16142,16144,16145,16213,16215,16216,16218,16227,16228,16230,16235,16238,16239,16241,16242,16243,16247,16248,16250,16251,16252,16254,16257,16265,16278,16291,16299,16302,16303,16304,16313,16315,16322,16332,16335,16336,16338,16355,16367,16368,16370,16371,16372,16378,16385,16386,16391,16392,16393,16397,16398,16399,16400,16401,16402,16404,16405,16406,16408,16410,16411,16412,16414,16415,16416,16418,16420,16422,16423,16424,16425,16426,16428,16430,16431,16434,16435,16436,16437,16438,16439,16440,16441,16443,16450,16457,16459,16466,16467,16468,16469,16476,16477,16478,16481,16482,16483,16484,16485,16486,16487,16488,16489,16490,16491,16492,16499,16503,16504,16505,16508,16509,16511,16512,16513,16524,16525,16547,16548,16552,16553,16554,16555,16563,16568,16580,16581,16582,16583,16587,16599,16613,16627,16636,16643,16644,16645,16653,16656,16662,16665,16666,16671,16673,16676,16679,16690,16691,16692,16694,16697,16705,16706,16710,16711,16733,16734,16736,16737,16738,16743,16747,16755,16785,16787,16788,16789,16790,16792,16793,16802,16810,16811,16814,16820,16821,16824,16827,16831,16835,16836,16837,16850,16851,16852,16853,16854,16855,16858,16859,16863,16865,16874,16875,16876,16883,16884,16893,16896,16897,16898,16899,16903,16909,16913,16924,16925,16931,16932,16934,16941,16944,16949,16957,16958,16961,16965,16967,16971,16979,16981,16982,16995,16996,16998,17008,17011,17012,17013,17014,17015,17016,17017,17018,17019,17022,17025,17033,17034,17037,17042,17045,17046,17048,17051,17059,17060,17062,17063,17066,17068,17069,17073,17075,17077,17080,17084,17091,17092,17112,17115,17117,17126,17127,17130,17141,17142,17143,17144,17145,17146,17147,17148,17152,17153,17154,17155,17156,17157,17158,17161,17168,17169,17170,17171,17172,17177,17178,17180,17181,17182,17186,17189,17190,17198,17199,17201,17205,17209,17210,17211,17212,17213,17216,17223,17224,17225,17226,17227,17228,17230,17231,17233,17234,17235,17236,17240,17243,17244,17245,17248,17249,17250,17251,17252,17253,17254,17255,17263,17264,17265,17266,17267,17268,17270,17272,17273,17280,17281,17282,17284,17285,17286,17290,17293,17332,17338,17339,17340,17341,17342,17344,17345,17346,17348,17350,17351,17352,17353,17354,17355,17356,17357,17358,17359,17360,17365,17366,17368,17371,17372,17373,17374,17378,17379,17380,17382,17384,17385,17387,17389,17391,17396,17398,17399,17401,17402,17408,17412,17416,17418,17424,17428,17429,17430,17433,17435,17436,17441,17444,17445,17446,17447,17449,17450,17451,17452,17461,17466,17467,17468,17472,17481,17485,17486,17487,17488,17492,17493,17495,17502,17504,17505,17508,17509,17510,17512,17514,17515,17524,17526,17527,17528,17530,17543,17545,17554,17555,17557,17558,17559,17560,17561,17562,17563,17565,17566,17567,17576,17577,17578,17581,17582,17583,17584,17585,17586,17587,17589,17590,17591,17592,17600,17601,17606,17607,17608,17610,17612,17613,17614,17616,17617,17619,17620,17621,17622,17623,17624,17625,17628,17635,17637,17640,17641,17642,17649,17650,17654,17657,17658,17659,17660,17661,17664,17668,17669,17670,17671,17672,17673,17674,17675,17677,17680,17682,17683,17688,17689,17690,17691,17692,17693,17697,17699,17700,17701,17704,17710,17711,17718,17721,17729,17733,17738,17739,17741,17742,17743,17744,17746,17747,17748,17750,17756,17763,17764,17765,17766,17768,17769,17770,17773,17775,17777,17778,17788,17789,17790,17795,17796,17799,17802,17806,17808,17809,17814,17817,17818,17819,17820,17821,17823,17827,17830,17831,17832,17834,17835,17836,17838,17841,17843,17844,17847,17854,17856,17858,17859,17860,17863,17864,17865,17871,17873,17874,17875,17876,17878,17879,17880,17881,17882,17883,17884,17885,17886,17891,17892,17893,17894,17895,17896,17897,17898,17899,17900,17901,17902,17903,17904,17906,17907,17909,17912,17913,17914,17921,17922,17923,17926,17928,17929,17930,17931,17932,17939,17940,17941,17942,17943,17944,17945,17946,17948,17949,17951,17952,17953,17954,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17968,17969,17970,17971,17972,17973,17974,17975,17976,17977,17980,17981,17983,17987,17988,17990,17992,17993,17994,17995,17996,17997,17998,18001,18002,18003,18004,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,18027,18028,18032,18034,18035,18038,18039,18040,18041,18042,18044,18045,18046,18047,18048,18057,18058,18059,18061,18062,18064,18065,18066,18067,18068,18069,18070,18071,18079,18080,18082,18084,18086,18087,18088,18089,18090,18091,18092,18093,18094,18096,18098,18099,18100,18101,18102,18108,18109,18110,18111,18112,18113,18115,18116,18117,18118,18119,18120,18121,18123,18125,18126,18128,18129,18130,18131,18132,18134,18135,18138,18142,18143,18154,18155,18156,18157,18158,18159,18160,18161,18162,18164,18166,18170,18171,18172,18173,18174,18177,18178,18179,18180,18181,18182,18183,18185,18186,18187,18188,18189,18190,18193,18199,18211,18212,18213,18214,18216,18219,18220,18221,18224,18233,18235,18236,18237,18239,18240,18241,18247,18251,18252,18253,18254,18256,18271,18275,18276,18277,18281,18282,18293,18304,18309,18312,18313,18314,18315,18316,18317,18318,18328,18329,18330,18331,18332,18334,18335,18338,18341,18342,18345,18346,18347,18348,18350,18351,18356,18359,18360,18361,18362,18365,18367,18368,18369,18370,18371,18372,18373,18375,18379,18383,18384,18385,18386,18388,18389,18390,18391,18392,18393,18396,18398,18399,18400,18401,18402,18403,18404,18406,18407,18409,18422,18423,18424,18428,18429,18431,18432,18433,18437,18438,18439,18440,18441,18442,18443,18445,18446,18448,18449,18450,18451,18452,18453,18454,18455,18456,18457,18458,18459,18464,18465,18466,18467,18475,18476,18498,18499,18511,18512,18515,18516,18517,18522,18523,18524,18525,18528,18529,18530,18531,18532,18533,18534,18535,18536,18540,18541,18542,18545,18546,18554,18556,18557,18559,18560,18562,18564,18579,18580,18581,18583,18584,18585,18587,18588,18589,18590,18593,18595,18597,18601,18605,18608,18614,18615,18616,18617,18632,18633,18634,18640,18643,18644,18645,18646,18647,18648,18649,18650,18651,18652,18653,18654,18655,18656,18657,18661,18662,18663,18664,18665,18666,18674,18682,18683,18684,18686,18695,18696,18697,18698,18699,18700,18701,18703,18704,18705,18706,18708,18709,18710,18711,18712,18713,18714,18715,18717,18726,18728,18729,18730,18731,18734,18735,18736,18741,18742,18743,18746,18748,18750,18751,18752,18753,18754,18757,18758,18763,18766,18768,18771,18772,18773,18774,18775,18779,18780,18781,18782,18783,18784,18786,18789,18794,18797,18798,18802,18803,18807,18811,18815,18816,18818,18822,18823,18824,18827,18828,18830,18831,18832,18833,18834,18836,18837,18838,18839,18840,18841,18842,18846,18847,18848,18850,18851,18853,18854,18860,18862,18865,18866,18867,18868,18869,18870,18875,18876,18877,18881,18889,18890,18891,18892,18897,18898,18899,18901,18902,18903,18904,18905,18906,18911,18912,18913,18914,18915,18917,18918,18920,18921,18922,18924,18925,18926,18928,18929,18930,18932,18933,18940,18941,18942,18943,18946,18947,18948,18949,18950,18952,18953,18955,18956,18957,18958,18959,18960,18962,18963,18965,18966,18967,18968,18972,18973,18974,18975,18976,18979,18981,18982,18985,18986,18988,18991,18992,18994,18996,18997,18999,19000,19001,19002,19003,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19022,19025,19026,19027,19028,19029,19033,19034,19035,19036,19042,19044,19049,19050,19051,19053,19054,19056,19057,19058,19059,19060,19061,19062,19063,19065,19066,19067,19068,19069,19071,19072,19073,19074,19075,19076,19077,19078,19083,19084,19085,19086,19087,19088,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19109,19110,19111,19112,19113,19114,19115,19116,19117,19119,19120,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19135,19136,19138,19140,19141,19143,19144,19145,19148,19149,19150,19151,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19173,19174,19175,19178,19179,19180,19181,19182,19183,19185,19188,19189,19191,19192,19194,19195,19196,19197,19198,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19217,19218,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19231,19232,19236,19237,19238,19239,19240,19241,19252,19253,19254,19255,19256,19257,19258,19259,19261,19264,19265,19266,19267,19268,19269,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19286,19294,19295) GROUP BY od.product_id, o.delivery_date;. Bound with :start='2025-04-09', :end='2025-04-17'
|
| 15:56:47.623 | trace | system.db.CDbCommand |
Querying SQL:
SELECT product_id, quantity, default_price, current_price, is_featured, super_featured, products_inventory_is_top_new, is_new, product_discount_reason_id, exclude_from_random_base_basket_content FROM products_inventory WHERE inventory_date = :date_of_order AND product_id IN (40,43,48,50,54,136,235,244,247,301,304,447,512,513,516,544,914,915,920,935,1114,1120,1121,1122,1139,1140,1204,1287,1299,1362,1364,1365,1367,1370,1371,1417,1418,1419,1420,1421,1422,1423,1427,1431,1500,1501,1525,1743,1744,1776,1777,1778,1945,2012,2013,2018,2020,2026,2060,2061,2093,2094,2153,2156,2181,2231,2288,2331,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2362,2363,2364,2369,2370,2380,2381,2406,2427,2439,2440,2510,2526,2563,2572,2573,2596,2597,2640,2644,2675,2679,2681,2695,2697,2709,2710,2711,2714,2738,2743,2754,2755,2756,2770,2771,2772,2778,2796,2905,2906,2907,2910,2917,2918,2939,2982,3002,3052,3209,3215,3216,3220,3222,3230,3231,3235,3236,3237,3239,3240,3241,3243,3253,3254,3262,3264,3266,3309,3313,3318,3322,3323,3326,3329,3335,3336,3351,3352,3373,3374,3377,3385,3386,3387,3485,3498,3499,3500,3501,3502,3587,3590,3617,3622,3623,3668,3669,3690,3692,3725,3792,3794,4203,4204,4206,4211,4226,4228,4231,4249,4261,4262,4278,4282,4285,4288,4289,4320,4321,4322,4325,4332,4335,4339,4346,4361,4363,4367,4371,4373,4375,4379,4386,4387,4413,4414,4437,4449,4450,4455,4471,4475,4476,4478,4486,4496,4520,4521,4529,4533,4539,4555,4556,4583,4584,4589,4592,4605,4675,4685,4691,4692,4693,4694,4743,4932,4933,5039,5043,5047,5071,5157,5164,5168,5171,5185,5194,5205,5207,5208,5213,5215,5219,5237,5239,5240,5294,5376,5540,5547,5604,5609,5630,5631,5632,5633,5646,5688,5693,5696,5707,5712,5750,5763,5764,5776,5791,5793,5831,5841,5843,5922,5960,5964,5966,6010,6021,6042,6043,6046,6047,6048,6072,6074,6089,6109,6121,6122,6150,6151,6194,6196,6198,6200,6223,6265,6288,6362,6374,6565,6569,6599,6654,6677,6729,6788,6797,6798,6799,6801,6803,6805,6807,6808,6830,6834,6835,6837,6840,6855,6856,6873,6877,6880,6889,6897,6985,6991,7020,7022,7025,7027,7047,7093,7094,7095,7107,7113,7122,7128,7129,7130,7136,7137,7138,7140,7157,7158,7177,7260,7279,7280,7281,7307,7308,7309,7310,7337,7353,7354,7357,7362,7397,7428,7431,7439,7444,7447,7479,7480,7482,7483,7487,7489,7490,7491,7528,7530,7595,7597,7598,7601,7602,7679,7750,7753,7774,7775,7812,7813,7814,7818,7820,7822,7877,7880,7923,7994,7995,8004,8005,8006,8007,8024,8030,8054,8055,8072,8201,8236,8239,8248,8274,8275,8312,8326,8341,8356,8404,8405,8413,8420,8445,8513,8514,8529,8546,8549,8550,8555,8556,8557,8558,8565,8575,8577,8591,8597,8598,8600,8602,8606,8608,8614,8618,8621,8622,8624,8625,8627,8628,8630,8632,8634,8635,8669,8670,8673,8674,8687,8690,8695,8708,8710,8723,8733,8736,8737,8738,8752,8754,8756,8757,8758,8759,8760,8761,8762,8767,8768,8769,8780,8788,8789,8820,8845,8848,8853,8886,8894,8898,8899,8900,8907,8922,8925,8926,8928,8945,8971,8980,8988,8989,8990,8991,8992,8993,8995,8996,8997,8998,9012,9036,9055,9056,9057,9064,9065,9066,9067,9068,9076,9093,9095,9116,9117,9118,9119,9120,9121,9126,9128,9129,9134,9135,9144,9145,9148,9149,9150,9159,9219,9222,9227,9235,9236,9237,9238,9239,9253,9264,9409,9416,9417,9435,9436,9438,9439,9448,9449,9487,9510,9525,9546,9577,9578,9579,9650,9658,9686,9699,9700,9712,9723,9736,9737,9741,9772,9796,9799,9800,9820,9832,9892,9893,9895,9896,9908,9909,9910,9911,9914,9918,9921,9923,9924,9951,9956,9959,9960,9966,9997,9998,10034,10037,10038,10053,10056,10058,10059,10060,10062,10063,10074,10084,10096,10097,10119,10122,10123,10124,10133,10137,10143,10144,10145,10147,10148,10156,10158,10160,10174,10177,10180,10186,10189,10201,10202,10203,10204,10205,10206,10207,10208,10234,10235,10254,10260,10273,10274,10275,10288,10289,10290,10291,10292,10293,10295,10332,10337,10388,10389,10390,10392,10394,10396,10397,10398,10400,10407,10409,10410,10411,10413,10414,10424,10446,10455,10456,10457,10464,10510,10522,10546,10557,10559,10560,10562,10572,10573,10575,10576,10577,10578,10579,10580,10582,10583,10584,10585,10586,10609,10613,10643,10644,10649,10651,10652,10662,10663,10664,10665,10666,10667,10668,10680,10693,10700,10701,10704,10705,10706,10727,10728,10731,10734,10735,10736,10745,10746,10747,10748,10749,10759,10763,10766,10767,10770,10771,10774,10776,10794,10834,10848,10849,10851,10852,10853,10862,10863,10864,10895,10902,10903,10904,10905,10906,10907,10908,10909,10910,10912,10917,10918,10920,10938,10939,10940,10941,10942,10943,10976,10987,11011,11022,11024,11025,11026,11027,11028,11029,11031,11032,11060,11063,11091,11092,11095,11106,11124,11127,11128,11142,11170,11171,11192,11204,11215,11216,11217,11220,11226,11239,11243,11259,11268,11269,11270,11272,11276,11279,11280,11300,11301,11315,11328,11329,11330,11332,11339,11344,11353,11354,11357,11358,11359,11360,11363,11364,11367,11370,11409,11410,11411,11413,11424,11452,11475,11478,11479,11496,11508,11529,11534,11551,11563,11565,11567,11580,11581,11587,11588,11589,11592,11593,11601,11609,11640,11643,11646,11664,11665,11688,11689,11706,11729,11753,11770,11776,11777,11782,11784,11786,11815,11820,11825,11834,11840,11853,11869,11870,11871,11894,11903,11908,11918,11940,11952,11985,11990,11994,11995,12000,12002,12004,12009,12010,12016,12018,12019,12020,12021,12067,12079,12082,12094,12100,12101,12102,12103,12104,12105,12109,12111,12112,12119,12120,12125,12126,12127,12129,12130,12131,12132,12133,12134,12136,12154,12176,12184,12185,12190,12191,12192,12198,12206,12213,12216,12236,12239,12240,12260,12263,12264,12269,12270,12271,12272,12273,12274,12282,12283,12289,12290,12291,12292,12293,12294,12296,12299,12302,12306,12307,12308,12313,12319,12322,12326,12337,12338,12345,12353,12356,12369,12374,12393,12395,12399,12426,12439,12442,12444,12445,12465,12466,12471,12472,12475,12483,12491,12500,12502,12503,12504,12505,12531,12532,12533,12536,12537,12538,12542,12553,12558,12559,12567,12585,12586,12608,12614,12616,12640,12644,12676,12719,12720,12721,12722,12727,12735,12737,12738,12741,12743,12746,12747,12748,12766,12767,12775,12779,12782,12809,12810,12818,12822,12843,12850,12853,12856,12857,12871,12894,12927,12929,12932,12958,12959,12960,12961,12962,12963,12964,12965,12966,12967,12974,12979,12980,12983,12984,12986,12988,12990,12999,13015,13032,13040,13043,13050,13053,13054,13060,13062,13073,13082,13085,13087,13091,13097,13172,13181,13182,13183,13184,13187,13188,13189,13190,13191,13193,13194,13195,13196,13228,13251,13262,13264,13265,13266,13268,13269,13275,13279,13297,13299,13323,13324,13331,13333,13334,13354,13355,13357,13358,13359,13368,13378,13379,13381,13403,13409,13410,13414,13419,13423,13424,13450,13483,13485,13486,13497,13507,13512,13552,13558,13563,13584,13595,13599,13601,13602,13619,13622,13624,13626,13627,13628,13629,13630,13641,13646,13647,13674,13675,13676,13681,13689,13691,13692,13695,13697,13703,13706,13707,13708,13709,13710,13712,13718,13719,13722,13730,13736,13739,13741,13745,13750,13754,13756,13757,13758,13759,13761,13762,13763,13765,13766,13772,13775,13781,13791,13794,13801,13803,13806,13808,13812,13813,13814,13815,13818,13820,13827,13829,13833,13834,13835,13844,13845,13851,13852,13853,13854,13856,13860,13873,13874,13879,13881,13882,13883,13890,13896,13897,13911,13915,13916,13921,13929,13931,13932,13942,13950,13951,13952,13958,13965,13995,13996,13998,14001,14005,14006,14023,14027,14044,14045,14046,14064,14071,14076,14078,14079,14088,14090,14092,14093,14094,14095,14096,14097,14098,14099,14100,14101,14103,14132,14135,14136,14137,14146,14147,14149,14159,14167,14170,14180,14185,14186,14188,14189,14190,14191,14192,14197,14212,14213,14219,14220,14223,14230,14239,14241,14243,14247,14249,14265,14270,14276,14285,14291,14293,14294,14304,14306,14316,14317,14318,14320,14322,14323,14327,14332,14333,14337,14343,14344,14348,14349,14356,14360,14363,14370,14374,14376,14381,14388,14396,14397,14400,14405,14406,14408,14409,14410,14411,14417,14420,14428,14437,14439,14442,14451,14452,14456,14460,14461,14463,14482,14484,14491,14527,14528,14530,14541,14554,14556,14578,14579,14580,14581,14611,14627,14641,14662,14690,14691,14693,14701,14705,14706,14713,14715,14716,14717,14718,14719,14723,14725,14727,14728,14729,14745,14749,14760,14762,14774,14775,14786,14795,14796,14797,14808,14812,14813,14819,14820,14824,14825,14826,14831,14834,14841,14845,14854,14856,14872,14885,14900,14901,14926,14986,14987,15017,15036,15038,15053,15058,15061,15064,15067,15079,15082,15083,15084,15085,15090,15101,15102,15107,15112,15117,15119,15124,15127,15128,15130,15147,15148,15156,15163,15165,15166,15168,15169,15170,15171,15173,15174,15175,15176,15177,15180,15184,15189,15190,15191,15192,15193,15194,15199,15219,15221,15222,15223,15272,15275,15277,15289,15292,15300,15314,15315,15335,15336,15340,15341,15342,15343,15344,15365,15366,15382,15398,15402,15403,15404,15405,15407,15413,15417,15428,15430,15431,15437,15449,15450,15453,15459,15468,15475,15478,15479,15484,15495,15497,15498,15501,15502,15503,15507,15508,15515,15516,15517,15520,15526,15529,15534,15535,15542,15545,15546,15547,15548,15549,15550,15551,15554,15555,15556,15558,15559,15560,15561,15562,15569,15573,15585,15586,15589,15590,15591,15592,15593,15607,15619,15620,15621,15622,15623,15631,15635,15639,15663,15668,15669,15673,15675,15677,15693,15694,15711,15712,15720,15729,15747,15748,15751,15752,15759,15760,15763,15764,15769,15776,15778,15786,15796,15797,15802,15817,15818,15821,15824,15845,15846,15848,15853,15862,15870,15874,15875,15882,15889,15895,15901,15902,15903,15907,15909,15910,15911,15912,15916,15919,15920,15921,15931,15932,15933,15939,15947,15954,15956,15957,15958,15968,15972,15973,15975,15976,15977,15981,15982,15984,15989,15992,16002,16016,16019,16020,16025,16026,16033,16034,16035,16036,16037,16038,16041,16058,16060,16064,16074,16086,16090,16092,16096,16097,16099,16100,16101,16109,16110,16111,16112,16114,16115,16122,16123,16124,16125,16128,16129,16132,16135,16137,16140,16141,16142,16144,16145,16213,16215,16216,16218,16227,16228,16230,16235,16238,16239,16241,16242,16243,16247,16248,16250,16251,16252,16254,16257,16265,16278,16291,16299,16302,16303,16304,16313,16315,16322,16332,16335,16336,16338,16355,16367,16368,16370,16371,16372,16378,16385,16386,16391,16392,16393,16397,16398,16399,16400,16401,16402,16404,16405,16406,16408,16410,16411,16412,16414,16415,16416,16418,16420,16422,16423,16424,16425,16426,16428,16430,16431,16434,16435,16436,16437,16438,16439,16440,16441,16443,16450,16457,16459,16466,16467,16468,16469,16476,16477,16478,16481,16482,16483,16484,16485,16486,16487,16488,16489,16490,16491,16492,16499,16503,16504,16505,16508,16509,16511,16512,16513,16524,16525,16547,16548,16552,16553,16554,16555,16563,16568,16580,16581,16582,16583,16587,16599,16613,16627,16636,16643,16644,16645,16653,16656,16662,16665,16666,16671,16673,16676,16679,16690,16691,16692,16694,16697,16705,16706,16710,16711,16733,16734,16736,16737,16738,16743,16747,16755,16785,16787,16788,16789,16790,16792,16793,16802,16810,16811,16814,16820,16821,16824,16827,16831,16835,16836,16837,16850,16851,16852,16853,16854,16855,16858,16859,16863,16865,16874,16875,16876,16883,16884,16893,16896,16897,16898,16899,16903,16909,16913,16924,16925,16931,16932,16934,16941,16944,16949,16957,16958,16961,16965,16967,16971,16979,16981,16982,16995,16996,16998,17008,17011,17012,17013,17014,17015,17016,17017,17018,17019,17022,17025,17033,17034,17037,17042,17045,17046,17048,17051,17059,17060,17062,17063,17066,17068,17069,17073,17075,17077,17080,17084,17091,17092,17112,17115,17117,17126,17127,17130,17141,17142,17143,17144,17145,17146,17147,17148,17152,17153,17154,17155,17156,17157,17158,17161,17168,17169,17170,17171,17172,17177,17178,17180,17181,17182,17186,17189,17190,17198,17199,17201,17205,17209,17210,17211,17212,17213,17216,17223,17224,17225,17226,17227,17228,17230,17231,17233,17234,17235,17236,17240,17243,17244,17245,17248,17249,17250,17251,17252,17253,17254,17255,17263,17264,17265,17266,17267,17268,17270,17272,17273,17280,17281,17282,17284,17285,17286,17290,17293,17332,17338,17339,17340,17341,17342,17344,17345,17346,17348,17350,17351,17352,17353,17354,17355,17356,17357,17358,17359,17360,17365,17366,17368,17371,17372,17373,17374,17378,17379,17380,17382,17384,17385,17387,17389,17391,17396,17398,17399,17401,17402,17408,17412,17416,17418,17424,17428,17429,17430,17433,17435,17436,17441,17444,17445,17446,17447,17449,17450,17451,17452,17461,17466,17467,17468,17472,17481,17485,17486,17487,17488,17492,17493,17495,17502,17504,17505,17508,17509,17510,17512,17514,17515,17524,17526,17527,17528,17530,17543,17545,17554,17555,17557,17558,17559,17560,17561,17562,17563,17565,17566,17567,17576,17577,17578,17581,17582,17583,17584,17585,17586,17587,17589,17590,17591,17592,17600,17601,17606,17607,17608,17610,17612,17613,17614,17616,17617,17619,17620,17621,17622,17623,17624,17625,17628,17635,17637,17640,17641,17642,17649,17650,17654,17657,17658,17659,17660,17661,17664,17668,17669,17670,17671,17672,17673,17674,17675,17677,17680,17682,17683,17688,17689,17690,17691,17692,17693,17697,17699,17700,17701,17704,17710,17711,17718,17721,17729,17733,17738,17739,17741,17742,17743,17744,17746,17747,17748,17750,17756,17763,17764,17765,17766,17768,17769,17770,17773,17775,17777,17778,17788,17789,17790,17795,17796,17799,17802,17806,17808,17809,17814,17817,17818,17819,17820,17821,17823,17827,17830,17831,17832,17834,17835,17836,17838,17841,17843,17844,17847,17854,17856,17858,17859,17860,17863,17864,17865,17871,17873,17874,17875,17876,17878,17879,17880,17881,17882,17883,17884,17885,17886,17891,17892,17893,17894,17895,17896,17897,17898,17899,17900,17901,17902,17903,17904,17906,17907,17909,17912,17913,17914,17921,17922,17923,17926,17928,17929,17930,17931,17932,17939,17940,17941,17942,17943,17944,17945,17946,17948,17949,17951,17952,17953,17954,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17968,17969,17970,17971,17972,17973,17974,17975,17976,17977,17980,17981,17983,17987,17988,17990,17992,17993,17994,17995,17996,17997,17998,18001,18002,18003,18004,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,18027,18028,18032,18034,18035,18038,18039,18040,18041,18042,18044,18045,18046,18047,18048,18057,18058,18059,18061,18062,18064,18065,18066,18067,18068,18069,18070,18071,18079,18080,18082,18084,18086,18087,18088,18089,18090,18091,18092,18093,18094,18096,18098,18099,18100,18101,18102,18108,18109,18110,18111,18112,18113,18115,18116,18117,18118,18119,18120,18121,18123,18125,18126,18128,18129,18130,18131,18132,18134,18135,18138,18142,18143,18154,18155,18156,18157,18158,18159,18160,18161,18162,18164,18166,18170,18171,18172,18173,18174,18177,18178,18179,18180,18181,18182,18183,18185,18186,18187,18188,18189,18190,18193,18199,18211,18212,18213,18214,18216,18219,18220,18221,18224,18233,18235,18236,18237,18239,18240,18241,18247,18251,18252,18253,18254,18256,18271,18275,18276,18277,18281,18282,18293,18304,18309,18312,18313,18314,18315,18316,18317,18318,18328,18329,18330,18331,18332,18334,18335,18338,18341,18342,18345,18346,18347,18348,18350,18351,18356,18359,18360,18361,18362,18365,18367,18368,18369,18370,18371,18372,18373,18375,18379,18383,18384,18385,18386,18388,18389,18390,18391,18392,18393,18396,18398,18399,18400,18401,18402,18403,18404,18406,18407,18409,18422,18423,18424,18428,18429,18431,18432,18433,18437,18438,18439,18440,18441,18442,18443,18445,18446,18448,18449,18450,18451,18452,18453,18454,18455,18456,18457,18458,18459,18464,18465,18466,18467,18475,18476,18498,18499,18511,18512,18515,18516,18517,18522,18523,18524,18525,18528,18529,18530,18531,18532,18533,18534,18535,18536,18540,18541,18542,18545,18546,18554,18556,18557,18559,18560,18562,18564,18579,18580,18581,18583,18584,18585,18587,18588,18589,18590,18593,18595,18597,18601,18605,18608,18614,18615,18616,18617,18632,18633,18634,18640,18643,18644,18645,18646,18647,18648,18649,18650,18651,18652,18653,18654,18655,18656,18657,18661,18662,18663,18664,18665,18666,18674,18682,18683,18684,18686,18695,18696,18697,18698,18699,18700,18701,18703,18704,18705,18706,18708,18709,18710,18711,18712,18713,18714,18715,18717,18726,18728,18729,18730,18731,18734,18735,18736,18741,18742,18743,18746,18748,18750,18751,18752,18753,18754,18757,18758,18763,18766,18768,18771,18772,18773,18774,18775,18779,18780,18781,18782,18783,18784,18786,18789,18794,18797,18798,18802,18803,18807,18811,18815,18816,18818,18822,18823,18824,18827,18828,18830,18831,18832,18833,18834,18836,18837,18838,18839,18840,18841,18842,18846,18847,18848,18850,18851,18853,18854,18860,18862,18865,18866,18867,18868,18869,18870,18875,18876,18877,18881,18889,18890,18891,18892,18897,18898,18899,18901,18902,18903,18904,18905,18906,18911,18912,18913,18914,18915,18917,18918,18920,18921,18922,18924,18925,18926,18928,18929,18930,18932,18933,18940,18941,18942,18943,18946,18947,18948,18949,18950,18952,18953,18955,18956,18957,18958,18959,18960,18962,18963,18965,18966,18967,18968,18972,18973,18974,18975,18976,18979,18981,18982,18985,18986,18988,18991,18992,18994,18996,18997,18999,19000,19001,19002,19003,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19022,19025,19026,19027,19028,19029,19033,19034,19035,19036,19042,19044,19049,19050,19051,19053,19054,19056,19057,19058,19059,19060,19061,19062,19063,19065,19066,19067,19068,19069,19071,19072,19073,19074,19075,19076,19077,19078,19083,19084,19085,19086,19087,19088,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19109,19110,19111,19112,19113,19114,19115,19116,19117,19119,19120,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19135,19136,19138,19140,19141,19143,19144,19145,19148,19149,19150,19151,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19173,19174,19175,19178,19179,19180,19181,19182,19183,19185,19188,19189,19191,19192,19194,19195,19196,19197,19198,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19217,19218,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19231,19232,19236,19237,19238,19239,19240,19241,19252,19253,19254,19255,19256,19257,19258,19259,19261,19264,19265,19266,19267,19268,19269,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19286,19294,19295). Bound with :date_of_order='2025-04-12'
|
| 15:56:47.690 | trace | system.db.CDbCommand |
Querying SQL: SELECT basket_design_id, basket_id FROM basket_designs WHERE close_date = :date_of_order. Bound with :date_of_order='2025-04-12'
|
| 15:56:47.692 | trace | system.db.CDbCommand |
Querying SQL: SELECT product_id, basket_design_id, default_quantity, min_quantity, max_quantity
FROM basket_design_product_availability WHERE basket_design_id IN (0,16414,16415,16416,16417,16418) AND product_id IN (40,43,48,50,54,136,235,244,247,301,304,447,512,513,516,544,914,915,920,935,1114,1120,1121,1122,1139,1140,1204,1287,1299,1362,1364,1365,1367,1370,1371,1417,1418,1419,1420,1421,1422,1423,1427,1431,1500,1501,1525,1743,1744,1776,1777,1778,1945,2012,2013,2018,2020,2026,2060,2061,2093,2094,2153,2156,2181,2231,2288,2331,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2362,2363,2364,2369,2370,2380,2381,2406,2427,2439,2440,2510,2526,2563,2572,2573,2596,2597,2640,2644,2675,2679,2681,2695,2697,2709,2710,2711,2714,2738,2743,2754,2755,2756,2770,2771,2772,2778,2796,2905,2906,2907,2910,2917,2918,2939,2982,3002,3052,3209,3215,3216,3220,3222,3230,3231,3235,3236,3237,3239,3240,3241,3243,3253,3254,3262,3264,3266,3309,3313,3318,3322,3323,3326,3329,3335,3336,3351,3352,3373,3374,3377,3385,3386,3387,3485,3498,3499,3500,3501,3502,3587,3590,3617,3622,3623,3668,3669,3690,3692,3725,3792,3794,4203,4204,4206,4211,4226,4228,4231,4249,4261,4262,4278,4282,4285,4288,4289,4320,4321,4322,4325,4332,4335,4339,4346,4361,4363,4367,4371,4373,4375,4379,4386,4387,4413,4414,4437,4449,4450,4455,4471,4475,4476,4478,4486,4496,4520,4521,4529,4533,4539,4555,4556,4583,4584,4589,4592,4605,4675,4685,4691,4692,4693,4694,4743,4932,4933,5039,5043,5047,5071,5157,5164,5168,5171,5185,5194,5205,5207,5208,5213,5215,5219,5237,5239,5240,5294,5376,5540,5547,5604,5609,5630,5631,5632,5633,5646,5688,5693,5696,5707,5712,5750,5763,5764,5776,5791,5793,5831,5841,5843,5922,5960,5964,5966,6010,6021,6042,6043,6046,6047,6048,6072,6074,6089,6109,6121,6122,6150,6151,6194,6196,6198,6200,6223,6265,6288,6362,6374,6565,6569,6599,6654,6677,6729,6788,6797,6798,6799,6801,6803,6805,6807,6808,6830,6834,6835,6837,6840,6855,6856,6873,6877,6880,6889,6897,6985,6991,7020,7022,7025,7027,7047,7093,7094,7095,7107,7113,7122,7128,7129,7130,7136,7137,7138,7140,7157,7158,7177,7260,7279,7280,7281,7307,7308,7309,7310,7337,7353,7354,7357,7362,7397,7428,7431,7439,7444,7447,7479,7480,7482,7483,7487,7489,7490,7491,7528,7530,7595,7597,7598,7601,7602,7679,7750,7753,7774,7775,7812,7813,7814,7818,7820,7822,7877,7880,7923,7994,7995,8004,8005,8006,8007,8024,8030,8054,8055,8072,8201,8236,8239,8248,8274,8275,8312,8326,8341,8356,8404,8405,8413,8420,8445,8513,8514,8529,8546,8549,8550,8555,8556,8557,8558,8565,8575,8577,8591,8597,8598,8600,8602,8606,8608,8614,8618,8621,8622,8624,8625,8627,8628,8630,8632,8634,8635,8669,8670,8673,8674,8687,8690,8695,8708,8710,8723,8733,8736,8737,8738,8752,8754,8756,8757,8758,8759,8760,8761,8762,8767,8768,8769,8780,8788,8789,8820,8845,8848,8853,8886,8894,8898,8899,8900,8907,8922,8925,8926,8928,8945,8971,8980,8988,8989,8990,8991,8992,8993,8995,8996,8997,8998,9012,9036,9055,9056,9057,9064,9065,9066,9067,9068,9076,9093,9095,9116,9117,9118,9119,9120,9121,9126,9128,9129,9134,9135,9144,9145,9148,9149,9150,9159,9219,9222,9227,9235,9236,9237,9238,9239,9253,9264,9409,9416,9417,9435,9436,9438,9439,9448,9449,9487,9510,9525,9546,9577,9578,9579,9650,9658,9686,9699,9700,9712,9723,9736,9737,9741,9772,9796,9799,9800,9820,9832,9892,9893,9895,9896,9908,9909,9910,9911,9914,9918,9921,9923,9924,9951,9956,9959,9960,9966,9997,9998,10034,10037,10038,10053,10056,10058,10059,10060,10062,10063,10074,10084,10096,10097,10119,10122,10123,10124,10133,10137,10143,10144,10145,10147,10148,10156,10158,10160,10174,10177,10180,10186,10189,10201,10202,10203,10204,10205,10206,10207,10208,10234,10235,10254,10260,10273,10274,10275,10288,10289,10290,10291,10292,10293,10295,10332,10337,10388,10389,10390,10392,10394,10396,10397,10398,10400,10407,10409,10410,10411,10413,10414,10424,10446,10455,10456,10457,10464,10510,10522,10546,10557,10559,10560,10562,10572,10573,10575,10576,10577,10578,10579,10580,10582,10583,10584,10585,10586,10609,10613,10643,10644,10649,10651,10652,10662,10663,10664,10665,10666,10667,10668,10680,10693,10700,10701,10704,10705,10706,10727,10728,10731,10734,10735,10736,10745,10746,10747,10748,10749,10759,10763,10766,10767,10770,10771,10774,10776,10794,10834,10848,10849,10851,10852,10853,10862,10863,10864,10895,10902,10903,10904,10905,10906,10907,10908,10909,10910,10912,10917,10918,10920,10938,10939,10940,10941,10942,10943,10976,10987,11011,11022,11024,11025,11026,11027,11028,11029,11031,11032,11060,11063,11091,11092,11095,11106,11124,11127,11128,11142,11170,11171,11192,11204,11215,11216,11217,11220,11226,11239,11243,11259,11268,11269,11270,11272,11276,11279,11280,11300,11301,11315,11328,11329,11330,11332,11339,11344,11353,11354,11357,11358,11359,11360,11363,11364,11367,11370,11409,11410,11411,11413,11424,11452,11475,11478,11479,11496,11508,11529,11534,11551,11563,11565,11567,11580,11581,11587,11588,11589,11592,11593,11601,11609,11640,11643,11646,11664,11665,11688,11689,11706,11729,11753,11770,11776,11777,11782,11784,11786,11815,11820,11825,11834,11840,11853,11869,11870,11871,11894,11903,11908,11918,11940,11952,11985,11990,11994,11995,12000,12002,12004,12009,12010,12016,12018,12019,12020,12021,12067,12079,12082,12094,12100,12101,12102,12103,12104,12105,12109,12111,12112,12119,12120,12125,12126,12127,12129,12130,12131,12132,12133,12134,12136,12154,12176,12184,12185,12190,12191,12192,12198,12206,12213,12216,12236,12239,12240,12260,12263,12264,12269,12270,12271,12272,12273,12274,12282,12283,12289,12290,12291,12292,12293,12294,12296,12299,12302,12306,12307,12308,12313,12319,12322,12326,12337,12338,12345,12353,12356,12369,12374,12393,12395,12399,12426,12439,12442,12444,12445,12465,12466,12471,12472,12475,12483,12491,12500,12502,12503,12504,12505,12531,12532,12533,12536,12537,12538,12542,12553,12558,12559,12567,12585,12586,12608,12614,12616,12640,12644,12676,12719,12720,12721,12722,12727,12735,12737,12738,12741,12743,12746,12747,12748,12766,12767,12775,12779,12782,12809,12810,12818,12822,12843,12850,12853,12856,12857,12871,12894,12927,12929,12932,12958,12959,12960,12961,12962,12963,12964,12965,12966,12967,12974,12979,12980,12983,12984,12986,12988,12990,12999,13015,13032,13040,13043,13050,13053,13054,13060,13062,13073,13082,13085,13087,13091,13097,13172,13181,13182,13183,13184,13187,13188,13189,13190,13191,13193,13194,13195,13196,13228,13251,13262,13264,13265,13266,13268,13269,13275,13279,13297,13299,13323,13324,13331,13333,13334,13354,13355,13357,13358,13359,13368,13378,13379,13381,13403,13409,13410,13414,13419,13423,13424,13450,13483,13485,13486,13497,13507,13512,13552,13558,13563,13584,13595,13599,13601,13602,13619,13622,13624,13626,13627,13628,13629,13630,13641,13646,13647,13674,13675,13676,13681,13689,13691,13692,13695,13697,13703,13706,13707,13708,13709,13710,13712,13718,13719,13722,13730,13736,13739,13741,13745,13750,13754,13756,13757,13758,13759,13761,13762,13763,13765,13766,13772,13775,13781,13791,13794,13801,13803,13806,13808,13812,13813,13814,13815,13818,13820,13827,13829,13833,13834,13835,13844,13845,13851,13852,13853,13854,13856,13860,13873,13874,13879,13881,13882,13883,13890,13896,13897,13911,13915,13916,13921,13929,13931,13932,13942,13950,13951,13952,13958,13965,13995,13996,13998,14001,14005,14006,14023,14027,14044,14045,14046,14064,14071,14076,14078,14079,14088,14090,14092,14093,14094,14095,14096,14097,14098,14099,14100,14101,14103,14132,14135,14136,14137,14146,14147,14149,14159,14167,14170,14180,14185,14186,14188,14189,14190,14191,14192,14197,14212,14213,14219,14220,14223,14230,14239,14241,14243,14247,14249,14265,14270,14276,14285,14291,14293,14294,14304,14306,14316,14317,14318,14320,14322,14323,14327,14332,14333,14337,14343,14344,14348,14349,14356,14360,14363,14370,14374,14376,14381,14388,14396,14397,14400,14405,14406,14408,14409,14410,14411,14417,14420,14428,14437,14439,14442,14451,14452,14456,14460,14461,14463,14482,14484,14491,14527,14528,14530,14541,14554,14556,14578,14579,14580,14581,14611,14627,14641,14662,14690,14691,14693,14701,14705,14706,14713,14715,14716,14717,14718,14719,14723,14725,14727,14728,14729,14745,14749,14760,14762,14774,14775,14786,14795,14796,14797,14808,14812,14813,14819,14820,14824,14825,14826,14831,14834,14841,14845,14854,14856,14872,14885,14900,14901,14926,14986,14987,15017,15036,15038,15053,15058,15061,15064,15067,15079,15082,15083,15084,15085,15090,15101,15102,15107,15112,15117,15119,15124,15127,15128,15130,15147,15148,15156,15163,15165,15166,15168,15169,15170,15171,15173,15174,15175,15176,15177,15180,15184,15189,15190,15191,15192,15193,15194,15199,15219,15221,15222,15223,15272,15275,15277,15289,15292,15300,15314,15315,15335,15336,15340,15341,15342,15343,15344,15365,15366,15382,15398,15402,15403,15404,15405,15407,15413,15417,15428,15430,15431,15437,15449,15450,15453,15459,15468,15475,15478,15479,15484,15495,15497,15498,15501,15502,15503,15507,15508,15515,15516,15517,15520,15526,15529,15534,15535,15542,15545,15546,15547,15548,15549,15550,15551,15554,15555,15556,15558,15559,15560,15561,15562,15569,15573,15585,15586,15589,15590,15591,15592,15593,15607,15619,15620,15621,15622,15623,15631,15635,15639,15663,15668,15669,15673,15675,15677,15693,15694,15711,15712,15720,15729,15747,15748,15751,15752,15759,15760,15763,15764,15769,15776,15778,15786,15796,15797,15802,15817,15818,15821,15824,15845,15846,15848,15853,15862,15870,15874,15875,15882,15889,15895,15901,15902,15903,15907,15909,15910,15911,15912,15916,15919,15920,15921,15931,15932,15933,15939,15947,15954,15956,15957,15958,15968,15972,15973,15975,15976,15977,15981,15982,15984,15989,15992,16002,16016,16019,16020,16025,16026,16033,16034,16035,16036,16037,16038,16041,16058,16060,16064,16074,16086,16090,16092,16096,16097,16099,16100,16101,16109,16110,16111,16112,16114,16115,16122,16123,16124,16125,16128,16129,16132,16135,16137,16140,16141,16142,16144,16145,16213,16215,16216,16218,16227,16228,16230,16235,16238,16239,16241,16242,16243,16247,16248,16250,16251,16252,16254,16257,16265,16278,16291,16299,16302,16303,16304,16313,16315,16322,16332,16335,16336,16338,16355,16367,16368,16370,16371,16372,16378,16385,16386,16391,16392,16393,16397,16398,16399,16400,16401,16402,16404,16405,16406,16408,16410,16411,16412,16414,16415,16416,16418,16420,16422,16423,16424,16425,16426,16428,16430,16431,16434,16435,16436,16437,16438,16439,16440,16441,16443,16450,16457,16459,16466,16467,16468,16469,16476,16477,16478,16481,16482,16483,16484,16485,16486,16487,16488,16489,16490,16491,16492,16499,16503,16504,16505,16508,16509,16511,16512,16513,16524,16525,16547,16548,16552,16553,16554,16555,16563,16568,16580,16581,16582,16583,16587,16599,16613,16627,16636,16643,16644,16645,16653,16656,16662,16665,16666,16671,16673,16676,16679,16690,16691,16692,16694,16697,16705,16706,16710,16711,16733,16734,16736,16737,16738,16743,16747,16755,16785,16787,16788,16789,16790,16792,16793,16802,16810,16811,16814,16820,16821,16824,16827,16831,16835,16836,16837,16850,16851,16852,16853,16854,16855,16858,16859,16863,16865,16874,16875,16876,16883,16884,16893,16896,16897,16898,16899,16903,16909,16913,16924,16925,16931,16932,16934,16941,16944,16949,16957,16958,16961,16965,16967,16971,16979,16981,16982,16995,16996,16998,17008,17011,17012,17013,17014,17015,17016,17017,17018,17019,17022,17025,17033,17034,17037,17042,17045,17046,17048,17051,17059,17060,17062,17063,17066,17068,17069,17073,17075,17077,17080,17084,17091,17092,17112,17115,17117,17126,17127,17130,17141,17142,17143,17144,17145,17146,17147,17148,17152,17153,17154,17155,17156,17157,17158,17161,17168,17169,17170,17171,17172,17177,17178,17180,17181,17182,17186,17189,17190,17198,17199,17201,17205,17209,17210,17211,17212,17213,17216,17223,17224,17225,17226,17227,17228,17230,17231,17233,17234,17235,17236,17240,17243,17244,17245,17248,17249,17250,17251,17252,17253,17254,17255,17263,17264,17265,17266,17267,17268,17270,17272,17273,17280,17281,17282,17284,17285,17286,17290,17293,17332,17338,17339,17340,17341,17342,17344,17345,17346,17348,17350,17351,17352,17353,17354,17355,17356,17357,17358,17359,17360,17365,17366,17368,17371,17372,17373,17374,17378,17379,17380,17382,17384,17385,17387,17389,17391,17396,17398,17399,17401,17402,17408,17412,17416,17418,17424,17428,17429,17430,17433,17435,17436,17441,17444,17445,17446,17447,17449,17450,17451,17452,17461,17466,17467,17468,17472,17481,17485,17486,17487,17488,17492,17493,17495,17502,17504,17505,17508,17509,17510,17512,17514,17515,17524,17526,17527,17528,17530,17543,17545,17554,17555,17557,17558,17559,17560,17561,17562,17563,17565,17566,17567,17576,17577,17578,17581,17582,17583,17584,17585,17586,17587,17589,17590,17591,17592,17600,17601,17606,17607,17608,17610,17612,17613,17614,17616,17617,17619,17620,17621,17622,17623,17624,17625,17628,17635,17637,17640,17641,17642,17649,17650,17654,17657,17658,17659,17660,17661,17664,17668,17669,17670,17671,17672,17673,17674,17675,17677,17680,17682,17683,17688,17689,17690,17691,17692,17693,17697,17699,17700,17701,17704,17710,17711,17718,17721,17729,17733,17738,17739,17741,17742,17743,17744,17746,17747,17748,17750,17756,17763,17764,17765,17766,17768,17769,17770,17773,17775,17777,17778,17788,17789,17790,17795,17796,17799,17802,17806,17808,17809,17814,17817,17818,17819,17820,17821,17823,17827,17830,17831,17832,17834,17835,17836,17838,17841,17843,17844,17847,17854,17856,17858,17859,17860,17863,17864,17865,17871,17873,17874,17875,17876,17878,17879,17880,17881,17882,17883,17884,17885,17886,17891,17892,17893,17894,17895,17896,17897,17898,17899,17900,17901,17902,17903,17904,17906,17907,17909,17912,17913,17914,17921,17922,17923,17926,17928,17929,17930,17931,17932,17939,17940,17941,17942,17943,17944,17945,17946,17948,17949,17951,17952,17953,17954,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17968,17969,17970,17971,17972,17973,17974,17975,17976,17977,17980,17981,17983,17987,17988,17990,17992,17993,17994,17995,17996,17997,17998,18001,18002,18003,18004,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,18027,18028,18032,18034,18035,18038,18039,18040,18041,18042,18044,18045,18046,18047,18048,18057,18058,18059,18061,18062,18064,18065,18066,18067,18068,18069,18070,18071,18079,18080,18082,18084,18086,18087,18088,18089,18090,18091,18092,18093,18094,18096,18098,18099,18100,18101,18102,18108,18109,18110,18111,18112,18113,18115,18116,18117,18118,18119,18120,18121,18123,18125,18126,18128,18129,18130,18131,18132,18134,18135,18138,18142,18143,18154,18155,18156,18157,18158,18159,18160,18161,18162,18164,18166,18170,18171,18172,18173,18174,18177,18178,18179,18180,18181,18182,18183,18185,18186,18187,18188,18189,18190,18193,18199,18211,18212,18213,18214,18216,18219,18220,18221,18224,18233,18235,18236,18237,18239,18240,18241,18247,18251,18252,18253,18254,18256,18271,18275,18276,18277,18281,18282,18293,18304,18309,18312,18313,18314,18315,18316,18317,18318,18328,18329,18330,18331,18332,18334,18335,18338,18341,18342,18345,18346,18347,18348,18350,18351,18356,18359,18360,18361,18362,18365,18367,18368,18369,18370,18371,18372,18373,18375,18379,18383,18384,18385,18386,18388,18389,18390,18391,18392,18393,18396,18398,18399,18400,18401,18402,18403,18404,18406,18407,18409,18422,18423,18424,18428,18429,18431,18432,18433,18437,18438,18439,18440,18441,18442,18443,18445,18446,18448,18449,18450,18451,18452,18453,18454,18455,18456,18457,18458,18459,18464,18465,18466,18467,18475,18476,18498,18499,18511,18512,18515,18516,18517,18522,18523,18524,18525,18528,18529,18530,18531,18532,18533,18534,18535,18536,18540,18541,18542,18545,18546,18554,18556,18557,18559,18560,18562,18564,18579,18580,18581,18583,18584,18585,18587,18588,18589,18590,18593,18595,18597,18601,18605,18608,18614,18615,18616,18617,18632,18633,18634,18640,18643,18644,18645,18646,18647,18648,18649,18650,18651,18652,18653,18654,18655,18656,18657,18661,18662,18663,18664,18665,18666,18674,18682,18683,18684,18686,18695,18696,18697,18698,18699,18700,18701,18703,18704,18705,18706,18708,18709,18710,18711,18712,18713,18714,18715,18717,18726,18728,18729,18730,18731,18734,18735,18736,18741,18742,18743,18746,18748,18750,18751,18752,18753,18754,18757,18758,18763,18766,18768,18771,18772,18773,18774,18775,18779,18780,18781,18782,18783,18784,18786,18789,18794,18797,18798,18802,18803,18807,18811,18815,18816,18818,18822,18823,18824,18827,18828,18830,18831,18832,18833,18834,18836,18837,18838,18839,18840,18841,18842,18846,18847,18848,18850,18851,18853,18854,18860,18862,18865,18866,18867,18868,18869,18870,18875,18876,18877,18881,18889,18890,18891,18892,18897,18898,18899,18901,18902,18903,18904,18905,18906,18911,18912,18913,18914,18915,18917,18918,18920,18921,18922,18924,18925,18926,18928,18929,18930,18932,18933,18940,18941,18942,18943,18946,18947,18948,18949,18950,18952,18953,18955,18956,18957,18958,18959,18960,18962,18963,18965,18966,18967,18968,18972,18973,18974,18975,18976,18979,18981,18982,18985,18986,18988,18991,18992,18994,18996,18997,18999,19000,19001,19002,19003,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19022,19025,19026,19027,19028,19029,19033,19034,19035,19036,19042,19044,19049,19050,19051,19053,19054,19056,19057,19058,19059,19060,19061,19062,19063,19065,19066,19067,19068,19069,19071,19072,19073,19074,19075,19076,19077,19078,19083,19084,19085,19086,19087,19088,19089,19090,19091,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19109,19110,19111,19112,19113,19114,19115,19116,19117,19119,19120,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19135,19136,19138,19140,19141,19143,19144,19145,19148,19149,19150,19151,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19173,19174,19175,19178,19179,19180,19181,19182,19183,19185,19188,19189,19191,19192,19194,19195,19196,19197,19198,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19217,19218,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19231,19232,19236,19237,19238,19239,19240,19241,19252,19253,19254,19255,19256,19257,19258,19259,19261,19264,19265,19266,19267,19268,19269,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19282,19283,19284,19286,19294,19295)
|
| 15:56:47.875 | trace | system.db.CDbCommand |
Querying SQL: SELECT
DISTINCT recipeIngredients.product_id FROM recipeIngredients INNER JOIN recipes ON (recipes.recipe_id=recipeIngredients.recipe_id AND recipes.status=1) WHERE recipeIngredients.common IN (0,1)
|
| 15:56:47.895 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `product_categories`
|
| 15:56:47.898 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `product_categories`
|
| 15:56:47.899 | trace | system.db.ar.CActiveRecord |
ProductCategories.findByPk()
|
| 15:56:47.899 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `productCategoriesLang`
|
| 15:56:47.901 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `productCategoriesLang`
|
| 15:56:47.902 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`category_id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`weight` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`slug` AS `t0_c4`, `t`.`product_categories_netsuite_id` AS `t0_c5`, `i18nProductCategories`.`l_id` AS `t1_c0`, `i18nProductCategories`.`category_id` AS `t1_c1`, `i18nProductCategories`.`lang_id` AS `t1_c2`, `i18nProductCategories`.`l_name` AS `t1_c3`, `i18nProductCategories`.`l_slug` AS `t1_c4` FROM `product_categories` `t` LEFT OUTER JOIN `productCategoriesLang` `i18nProductCategories` ON (`i18nProductCategories`.`category_id`=`t`.`category_id`) AND (i18nProductCategories.lang_id='fr') WHERE (`t`.`category_id`=272)
|
| 15:56:47.904 | trace | system.db.ar.CActiveRecord |
ProductCategories.findByPk()
|
| 15:56:47.904 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`category_id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`weight` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`slug` AS `t0_c4`, `t`.`product_categories_netsuite_id` AS `t0_c5`, `i18nProductCategories`.`l_id` AS `t1_c0`, `i18nProductCategories`.`category_id` AS `t1_c1`, `i18nProductCategories`.`lang_id` AS `t1_c2`, `i18nProductCategories`.`l_name` AS `t1_c3`, `i18nProductCategories`.`l_slug` AS `t1_c4` FROM `product_categories` `t` LEFT OUTER JOIN `productCategoriesLang` `i18nProductCategories` ON (`i18nProductCategories`.`category_id`=`t`.`category_id`) AND (i18nProductCategories.lang_id='fr') WHERE (`t`.`category_id`=270)
|
| 15:56:47.906 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `marketplace_families`
|
| 15:56:47.908 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `marketplace_families`
|
| 15:56:47.909 | trace | system.db.ar.CActiveRecord |
MarketplaceFamilies.findByPk()
|
| 15:56:47.910 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `marketplace_families_lang`
|
| 15:56:47.911 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `marketplace_families_lang`
|
| 15:56:47.913 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`marketplace_family_id` AS `t0_c0`, `t`.`title` AS `t0_c1`, `t`.`description` AS `t0_c2`, `t`.`image_url` AS `t0_c3`, `t`.`weight` AS `t0_c4`, `t`.`status` AS `t0_c5`, `t`.`is_new` AS `t0_c6`, `t`.`slug` AS `t0_c7`, `t`.`nosub` AS `t0_c8`, `t`.`nosub_title` AS `t0_c9`, `t`.`special_feature_text` AS `t0_c10`, `t`.`special_feature_title` AS `t0_c11`, `t`.`special` AS `t0_c12`, `t`.`featured_card_title` AS `t0_c13`, `i18nMarketplaceFamilies`.`l_id` AS `t1_c0`, `i18nMarketplaceFamilies`.`marketplace_family_id` AS `t1_c1`, `i18nMarketplaceFamilies`.`lang_id` AS `t1_c2`, `i18nMarketplaceFamilies`.`l_title` AS `t1_c3`, `i18nMarketplaceFamilies`.`l_description` AS `t1_c4`, `i18nMarketplaceFamilies`.`l_slug` AS `t1_c5`, `i18nMarketplaceFamilies`.`l_nosub_title` AS `t1_c6`, `i18nMarketplaceFamilies`.`l_special_feature_text` AS `t1_c7`, `i18nMarketplaceFamilies`.`l_special_feature_title` AS `t1_c8`, `i18nMarketplaceFamilies`.`l_featured_card_title` AS `t1_c9`, `multilangMarketplaceFamilies`.`l_id` AS `t2_c0`, `multilangMarketplaceFamilies`.`marketplace_family_id` AS `t2_c1`, `multilangMarketplaceFamilies`.`lang_id` AS `t2_c2`, `multilangMarketplaceFamilies`.`l_title` AS `t2_c3`, `multilangMarketplaceFamilies`.`l_description` AS `t2_c4`, `multilangMarketplaceFamilies`.`l_slug` AS `t2_c5`, `multilangMarketplaceFamilies`.`l_nosub_title` AS `t2_c6`, `multilangMarketplaceFamilies`.`l_special_feature_text` AS `t2_c7`, `multilangMarketplaceFamilies`.`l_special_feature_title` AS `t2_c8`, `multilangMarketplaceFamilies`.`l_featured_card_title` AS `t2_c9` FROM `marketplace_families` `t` LEFT OUTER JOIN `marketplace_families_lang` `i18nMarketplaceFamilies` ON (`i18nMarketplaceFamilies`.`marketplace_family_id`=`t`.`marketplace_family_id`) AND (i18nMarketplaceFamilies.lang_id='fr') LEFT OUTER JOIN `marketplace_families_lang` `multilangMarketplaceFamilies` ON (`multilangMarketplaceFamilies`.`marketplace_family_id`=`t`.`marketplace_family_id`) WHERE (`t`.`marketplace_family_id`=87)
|
| 15:56:47.983 | trace | system.db.CDbCommand |
Querying SQL: SELECT
od.product_id, SUM(IF(o.delivery_date BETWEEN SUBDATE(CURDATE(), INTERVAL 1 YEAR) AND CURDATE(), 1, 0)) AS nb_purchases_since_last_year, COUNT(od.order_details_id) AS nb_purchases_since_begining FROM `order_details` od INNER JOIN orders o ON (o.order_id = od.order_id AND o.status = 4 AND o.user_id = :user_id) INNER JOIN products p ON (od.product_id = p.product_id AND p.status = 1) WHERE od.`defined_retail_price_per_unit_for_default_weight` > 0 AND od.product_id NOT IN (SELECT DISTINCT hd_product_id FROM droppoints WHERE hd_product_id IS NOT NULL) GROUP BY od.product_id ORDER BY SUM(IF(o.delivery_date BETWEEN SUBDATE(CURDATE(), INTERVAL 1 YEAR) AND CURDATE(), 1, 0)) DESC. Bound with :user_id=-1
|
| 15:56:47.985 | trace | system.db.CDbCommand |
Querying SQL: SELECT
mf.nosub, if(mf.nosub = 1,if('fr' = :lang,mf.nosub_title,mflang.l_nosub_title),null) as nosub_title, if('fr' = :lang,mf.title,mflang.l_title) as title, if('fr' = :lang,mf.description,mflang.l_description) as tweet, if(special = 1 ,if('fr' = :lang,fft.special_feature_title, fftl.l_special_feature_title), '') as s_ti, if(special = 1 ,if('fr' = :lang,fft.special_feature_text, fftl.l_special_feature_text), '') as s_t, if('fr' = :lang, fft.featured_card_title, fftl.l_featured_card_title) as featured_cart_title, IFNULL(fft.image_url,mf.image_url) as image_url, fft.theme_color, if('fr' = :lang, fft.title, fftl.l_title) as featured_text_title, weight, mf.marketplace_family_id FROM marketplace_families mf LEFT JOIN marketplace_families_lang as mflang ON mflang.marketplace_family_id = mf.marketplace_family_id LEFT JOIN family_featured_texts as fft ON fft.marketplace_family_id = mf.marketplace_family_id AND :date BETWEEN fft.start_date AND fft.end_date LEFT JOIN family_featured_texts_lang as fftl ON fft.family_featured_id = fftl.family_featured_id AND :lang = fftl.lang_id WHERE status = 1 ORDER BY mf.weight ASC. Bound with :lang='fr', :date='2025-04-12'
|
| 15:56:47.990 | trace | system.db.CDbCommand |
Querying SQL: SELECT
products.product_id FROM products INNER JOIN products_inventory ON (products.product_id = products_inventory.product_id AND products_inventory.inventory_date = :date) WHERE products.product_id IN (18640,3725,17721,18955,12722,-1) ORDER BY (products_inventory.default_price-products_inventory.current_price) DESC. Bound with :date='2025-04-12'
|
| 15:56:47.992 | trace | system.db.CDbCommand |
Querying SQL: SELECT recipe_id FROM recipeOrders WHERE order_id = :order_id. Bound with :order_id=0
|
| 15:56:47.994 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `recipes`
|
| 15:56:47.996 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `recipes`
|
| 15:56:47.997 | trace | system.db.ar.CActiveRecord |
Recipe.findAll()
|
| 15:56:47.998 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `recipesLang`
|
| 15:56:47.999 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `recipesLang`
|
| 15:56:48.000 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `recipeIngredients`
|
| 15:56:48.002 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `recipeIngredients`
|
| 15:56:48.004 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `recipeIngredientsNotIncluded`
|
| 15:56:48.005 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `recipeIngredientsNotIncluded`
|
| 15:56:48.007 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `recipe_user_ratings`
|
| 15:56:48.008 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `recipe_user_ratings`
|
| 15:56:48.009 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `user_comments`
|
| 15:56:48.011 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `user_comments`
|
| 15:56:48.012 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `productSubCategories`
|
| 15:56:48.014 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `productSubCategories`
|
| 15:56:48.015 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `productSubCategoriesLang`
|
| 15:56:48.017 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `productSubCategoriesLang`
|
| 15:56:48.019 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`recipe_id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`prep_time` AS `t0_c2`, `t`.`cook_time` AS `t0_c3`, `t`.`total_time` AS `t0_c4`, `t`.`image_url` AS `t0_c5`, `t`.`description` AS `t0_c6`, `t`.`steps` AS `t0_c7`, `t`.`extra_ingredients` AS `t0_c8`, `t`.`created_at_date` AS `t0_c9`, `t`.`created_at_time` AS `t0_c10`, `t`.`updated_at_date` AS `t0_c11`, `t`.`updated_at_time` AS `t0_c12`, `t`.`status` AS `t0_c13`, `t`.`portions` AS `t0_c14`, `t`.`instructions_list_product_id` AS `t0_c15`, `t`.`subcategory_id` AS `t0_c16`, `t`.`featured` AS `t0_c17`, `t`.`pdf_url` AS `t0_c18`, `t`.`is_bundle` AS `t0_c19`, `t`.`is_new` AS `t0_c20`, `t`.`first_published_at_date` AS `t0_c21`, `t`.`marketplace_family_id` AS `t0_c22`, `recipesLang`.`recipe_id` AS `t1_c0`, `recipesLang`.`l_name` AS `t1_c1`, `recipesLang`.`l_description` AS `t1_c2`, `recipesLang`.`l_steps` AS `t1_c3`, `recipesLang`.`l_extra_ingredients` AS `t1_c4`, `recipesLang`.`lang_id` AS `t1_c5`, `recipesLang`.`l_pdf_url` AS `t1_c6`, `sub_category`.`subcategory_id` AS `t7_c0`, `sub_category`.`category_id` AS `t7_c1`, `sub_category`.`name` AS `t7_c2`, `sub_category`.`weight` AS `t7_c3`, `sub_category`.`linked_subcategory_id` AS `t7_c4`, `i18nProductSubCategories`.`l_id` AS `t8_c0`, `i18nProductSubCategories`.`subcategory_id` AS `t8_c1`, `i18nProductSubCategories`.`lang_id` AS `t8_c2`, `i18nProductSubCategories`.`l_name` AS `t8_c3` FROM `recipes` `t` LEFT OUTER JOIN `recipesLang` `recipesLang` ON (`recipesLang`.`recipe_id`=`t`.`recipe_id`) AND (recipesLang.lang_id='fr') LEFT OUTER JOIN `productSubCategories` `sub_category` ON (`t`.`subcategory_id`=`sub_category`.`subcategory_id`) LEFT OUTER JOIN `productSubCategoriesLang` `i18nProductSubCategories` ON (`i18nProductSubCategories`.`subcategory_id`=`sub_category`.`subcategory_id`) AND (i18nProductSubCategories.lang_id='fr') WHERE (t.status = 1 OR t.recipe_id IN (0) ) ORDER BY t.name ASC
|
| 15:56:48.123 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`recipe_id` AS `t0_c0`, `ingredients`.`ingredients_id` AS `t2_c0`, `ingredients`.`recipe_id` AS `t2_c1`, `ingredients`.`product_id` AS `t2_c2`, `ingredients`.`quantity` AS `t2_c3`, `ingredients`.`option` AS `t2_c4`, `ingredients`.`priority` AS `t2_c5`, `ingredients`.`common` AS `t2_c6`, `ingredients`.`cup_conversion` AS `t2_c7`, `ingredients`.`alternate_name` AS `t2_c8` FROM `recipes` `t` LEFT OUTER JOIN `recipeIngredients` `ingredients` ON (`ingredients`.`recipe_id`=`t`.`recipe_id`) WHERE (`t`.`recipe_id` IN (385, 433, 426, 403, 332, 331, 366, 388, 375, 391, 414, 382, 325, 513, 520, 368, 507, 453, 460, 501, 455, 341, 514, 457, 400, 491, 291, 458, 522, 235, 413, 423, 365, 386, 480, 390, 469, 373, 528, 335, 78, 393, 415, 328, 399, 529, 273, 482, 483, 359, 358, 497, 346, 494, 498, 495, 496, 347, 350, 353, 352, 349, 407, 475, 84, 383, 256, 77, 479, 340, 509, 463, 323, 83, 342, 506, 405, 477, 392, 523, 369, 526, 450, 362, 419, 478, 344, 336, 439, 402, 456, 521, 527, 406, 436, 334, 364, 517, 500, 504, 459, 337, 508, 363, 467, 468, 516, 443, 228, 481, 408, 511, 360, 387, 448, 395, 409, 427, 489, 380, 492, 416, 462, 343, 499, 401, 404, 422, 441, 452, 464, 429, 371, 370, 476, 449, 377, 466, 389, 338, 438, 473, 461, 134, 447, 267, 396, 488, 339, 411, 487, 372, 329, 502, 525, 322, 424, 510, 345, 505, 418, 428, 431, 470, 333, 327, 512, 421, 515, 379, 321, 398, 374, 493, 425, 490, 378)) ORDER BY `ingredients`.priority ASC, `ingredients`.option ASC
|
| 15:56:48.245 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`recipe_id` AS `t0_c0`, `not_ingredients`.`ingredients_id` AS `t3_c0`, `not_ingredients`.`recipe_id` AS `t3_c1`, `not_ingredients`.`quantity` AS `t3_c2`, `not_ingredients`.`cup_conversion` AS `t3_c3`, `not_ingredients`.`price_per_portion` AS `t3_c4`, `not_ingredients`.`name` AS `t3_c5`, `not_ingredients`.`name_en` AS `t3_c6` FROM `recipes` `t` LEFT OUTER JOIN `recipeIngredientsNotIncluded` `not_ingredients` ON (`not_ingredients`.`recipe_id`=`t`.`recipe_id`) WHERE (`t`.`recipe_id` IN (385, 433, 426, 403, 332, 331, 366, 388, 375, 391, 414, 382, 325, 513, 520, 368, 507, 453, 460, 501, 455, 341, 514, 457, 400, 491, 291, 458, 522, 235, 413, 423, 365, 386, 480, 390, 469, 373, 528, 335, 78, 393, 415, 328, 399, 529, 273, 482, 483, 359, 358, 497, 346, 494, 498, 495, 496, 347, 350, 353, 352, 349, 407, 475, 84, 383, 256, 77, 479, 340, 509, 463, 323, 83, 342, 506, 405, 477, 392, 523, 369, 526, 450, 362, 419, 478, 344, 336, 439, 402, 456, 521, 527, 406, 436, 334, 364, 517, 500, 504, 459, 337, 508, 363, 467, 468, 516, 443, 228, 481, 408, 511, 360, 387, 448, 395, 409, 427, 489, 380, 492, 416, 462, 343, 499, 401, 404, 422, 441, 452, 464, 429, 371, 370, 476, 449, 377, 466, 389, 338, 438, 473, 461, 134, 447, 267, 396, 488, 339, 411, 487, 372, 329, 502, 525, 322, 424, 510, 345, 505, 418, 428, 431, 470, 333, 327, 512, 421, 515, 379, 321, 398, 374, 493, 425, 490, 378))
|
| 15:56:48.251 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`recipe_id` AS `t0_c0`, AVG(ratings.rating) as avgrating, `ratings`.`recipe_user_ratings` AS `t4_c0` FROM `recipes` `t` LEFT OUTER JOIN `recipe_user_ratings` `ratings` ON (`ratings`.`recipe_id`=`t`.`recipe_id`) WHERE (`t`.`recipe_id` IN (385, 433, 426, 403, 332, 331, 366, 388, 375, 391, 414, 382, 325, 513, 520, 368, 507, 453, 460, 501, 455, 341, 514, 457, 400, 491, 291, 458, 522, 235, 413, 423, 365, 386, 480, 390, 469, 373, 528, 335, 78, 393, 415, 328, 399, 529, 273, 482, 483, 359, 358, 497, 346, 494, 498, 495, 496, 347, 350, 353, 352, 349, 407, 475, 84, 383, 256, 77, 479, 340, 509, 463, 323, 83, 342, 506, 405, 477, 392, 523, 369, 526, 450, 362, 419, 478, 344, 336, 439, 402, 456, 521, 527, 406, 436, 334, 364, 517, 500, 504, 459, 337, 508, 363, 467, 468, 516, 443, 228, 481, 408, 511, 360, 387, 448, 395, 409, 427, 489, 380, 492, 416, 462, 343, 499, 401, 404, 422, 441, 452, 464, 429, 371, 370, 476, 449, 377, 466, 389, 338, 438, 473, 461, 134, 447, 267, 396, 488, 339, 411, 487, 372, 329, 502, 525, 322, 424, 510, 345, 505, 418, 428, 431, 470, 333, 327, 512, 421, 515, 379, 321, 398, 374, 493, 425, 490, 378)) GROUP BY t.recipe_id
|
| 15:56:48.256 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`recipe_id` AS `t0_c0`, AVG(activeRatings.rating) as avgrating, `activeRatings`.`recipe_user_ratings` AS `t5_c0` FROM `recipes` `t` LEFT OUTER JOIN `recipe_user_ratings` `activeRatings` ON (`activeRatings`.`recipe_id`=`t`.`recipe_id`) INNER JOIN user_comments uc ON activeRatings.user_id = uc.user_id AND activeRatings.recipe_id = uc.owner_id AND uc.status = 1 AND IFNULL(uc.parent_comment_id, 0) = 0 WHERE (`t`.`recipe_id` IN (385, 433, 426, 403, 332, 331, 366, 388, 375, 391, 414, 382, 325, 513, 520, 368, 507, 453, 460, 501, 455, 341, 514, 457, 400, 491, 291, 458, 522, 235, 413, 423, 365, 386, 480, 390, 469, 373, 528, 335, 78, 393, 415, 328, 399, 529, 273, 482, 483, 359, 358, 497, 346, 494, 498, 495, 496, 347, 350, 353, 352, 349, 407, 475, 84, 383, 256, 77, 479, 340, 509, 463, 323, 83, 342, 506, 405, 477, 392, 523, 369, 526, 450, 362, 419, 478, 344, 336, 439, 402, 456, 521, 527, 406, 436, 334, 364, 517, 500, 504, 459, 337, 508, 363, 467, 468, 516, 443, 228, 481, 408, 511, 360, 387, 448, 395, 409, 427, 489, 380, 492, 416, 462, 343, 499, 401, 404, 422, 441, 452, 464, 429, 371, 370, 476, 449, 377, 466, 389, 338, 438, 473, 461, 134, 447, 267, 396, 488, 339, 411, 487, 372, 329, 502, 525, 322, 424, 510, 345, 505, 418, 428, 431, 470, 333, 327, 512, 421, 515, 379, 321, 398, 374, 493, 425, 490, 378)) AND (activeRatings.updated_at >= SUBDATE(CURDATE(), INTERVAL 270 DAY)) GROUP BY t.recipe_id
|
| 15:56:48.270 | trace | system.db.CDbCommand |
Querying SQL: SELECT `t`.`recipe_id` AS `t0_c0`, count(distinct comments.comment_id) as commentCount, `comments`.`comment_id` AS `t6_c0` FROM `recipes` `t` LEFT OUTER JOIN `user_comments` `comments` ON (`comments`.`owner_id`=`t`.`recipe_id`) WHERE (`t`.`recipe_id` IN (385, 433, 426, 403, 332, 331, 366, 388, 375, 391, 414, 382, 325, 513, 520, 368, 507, 453, 460, 501, 455, 341, 514, 457, 400, 491, 291, 458, 522, 235, 413, 423, 365, 386, 480, 390, 469, 373, 528, 335, 78, 393, 415, 328, 399, 529, 273, 482, 483, 359, 358, 497, 346, 494, 498, 495, 496, 347, 350, 353, 352, 349, 407, 475, 84, 383, 256, 77, 479, 340, 509, 463, 323, 83, 342, 506, 405, 477, 392, 523, 369, 526, 450, 362, 419, 478, 344, 336, 439, 402, 456, 521, 527, 406, 436, 334, 364, 517, 500, 504, 459, 337, 508, 363, 467, 468, 516, 443, 228, 481, 408, 511, 360, 387, 448, 395, 409, 427, 489, 380, 492, 416, 462, 343, 499, 401, 404, 422, 441, 452, 464, 429, 371, 370, 476, 449, 377, 466, 389, 338, 438, 473, 461, 134, 447, 267, 396, 488, 339, 411, 487, 372, 329, 502, 525, 322, 424, 510, 345, 505, 418, 428, 431, 470, 333, 327, 512, 421, 515, 379, 321, 398, 374, 493, 425, 490, 378)) AND (comments.owner_name like "Recipe" AND comments.status = 1 AND comments.updated_at >= SUBDATE(CURDATE(), INTERVAL 270 DAY)) GROUP BY t.recipe_id
|
| 15:56:48.673 | trace | system.db.CDbCommand |
Executing SQL:
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES (:url, :memory_used, :loading_time, :ip, :user_id, :body, :query_string, :cookies); . Bound with :url='superMarket/getAllProducts', :loading_time=3.195, :memory_used=11.61, :ip='66.249.64.173', :user_id=NULL, :body='', :query_string='', :cookies='s:0:"";'
|