GET http://chinchilldev.lufa.com/en/mcpRest/orders?user_id=428679&limit=3 at 2025-04-15 05:33:49 by 172.19.0.1
| Time | Level | Category | Message |
|---|---|---|---|
| 17:33:45.444 | trace | system.CModule |
Loading "log" application component
|
| 17:33:45.444 | trace | system.CModule |
Loading "debug" application component
|
| 17:33:45.444 | trace | system.CModule |
Loading "request" application component
|
| 17:33:45.445 | trace | system.CModule |
Loading "urlManager" application component
|
| 17:33:45.445 | trace | system.CModule |
Loading "cache" application component
|
| 17:33:45.445 | trace | system.caching.CApcCache |
Serving "Yii.CUrlManager.rules" from cache
|
| 17:33:45.445 | trace | system.CModule |
Loading "clientScript" application component
|
| 17:33:45.446 | trace | system.db.ar.CActiveRecord |
MarketingCustomUrl.findByAttributes()
|
| 17:33:45.446 | trace | system.CModule |
Loading "db" application component
|
| 17:33:45.446 | trace | system.db.CDbConnection |
Opening DB connection
|
| 17:33:45.456 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `marketing_custom_urls`
|
| 17:33:45.458 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `marketing_custom_urls`
|
| 17:33:45.459 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
|
| 17:33:45.461 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `marketing_campaign_referrals`
|
| 17:33:45.462 | 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='orders'
|
| 17:33:45.466 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `securelufacom`.`users`
|
| 17:33:45.470 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `securelufacom`.`users`
|
| 17:33:45.472 | trace | system.CModule |
Loading "messages" application component
|
| 17:33:45.473 | trace | system.db.ar.CActiveRecord |
Users.findByPk()
|
| 17:33:45.473 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
|
| 17:33:45.476 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `action_log`
|
| 17:33:45.484 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `action_log`
|
| 17:33:45.489 | trace | system.CModule |
Loading "user" application component
|
| 17:33:45.489 | trace | system.CModule |
Loading "session" application component
|
| 17:33:45.489 | trace | system.db.CDbCommand |
Querying SQL: SELECT `data`
FROM `user_session` WHERE expire>:expire AND id=:id. Bound with :expire=1744752825, :id='m4crdcn8f5ntj815d8iq6o5odk'
|
| 17:33:45.492 | trace | system.db.ar.CActiveRecord |
UserAgents.findByAttributes()
|
| 17:33:45.493 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `user_agents`
|
| 17:33:45.495 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `user_agents`
|
| 17:33:45.498 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`=:yp0 LIMIT 1. Bound with :yp0='python-httpx/0.28.1'
|
| 17:33:48.163 | trace | system.db.ar.CActiveRecord |
ActionLog.insert()
|
| 17:33:48.163 | trace | system.db.CDbCommand |
Executing SQL: INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7). Bound with :yp0=NULL, :yp1=618755, :yp2='Found user 618755 using auth token: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoiNjE4NzU1IiwiaWF0IjoxNzQyNDkxMjkwfQ.-3DpjedDNhWlREGC-f0Fkp4aK07DPED8mBW6uvREyUo', :yp3=10, :yp4='34.130.1.12', :yp5='343059', :yp6='17:33:45', :yp7='2025-04-15'
|
| 17:33:48.430 | trace | system.db.ar.CActiveRecord |
Users.findByAttributes()
|
| 17:33:48.430 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_email`=:yp0 LIMIT 1. Bound with :yp0='p.liang@lufa.com'
|
| 17:33:48.438 | trace | system.db.ar.CActiveRecord |
Users.findByAttributes()
|
| 17:33:48.438 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=:yp0 LIMIT 1. Bound with :yp0='618755'
|
| 17:33:48.456 | trace | system.db.ar.CActiveRecord |
Users.update()
|
| 17:33:48.456 | trace | system.db.ar.CActiveRecord |
Users.updateByPk()
|
| 17:33:48.456 | trace | system.db.CDbCommand |
Executing SQL: UPDATE `securelufacom`.`users` SET `user_id`=:yp0, `user_email`=:yp1, `user_pass`=:yp2, `first_name`=:yp3, `last_name`=:yp4, `coordinator_display_name`=:yp5, `language`=:yp6, `created`=:yp7, `status`=:yp8, `last_forgot_password_request`=:yp9, `credits`=:yp10, `address`=:yp11, `zip_code`=:yp12, `phone_home`=:yp13, `phone_work`=:yp14, `updated`=:yp15, `last_login_date`=:yp16, `warehouse_id`=:yp17, `city_name`=:yp18, `state_id`=:yp19, `apt`=:yp20, `plan_id`=:yp21, `open_alert`=:yp22, `closed_alert`=:yp23, `customer_profile_id`=:yp24, `charge_method`=:yp25, `free_credits`=:yp26, `card_type`=:yp27, `exp_month`=:yp28, `exp_year`=:yp29, `last_contacted_on`=:yp30, `next_contact_on`=:yp31, `never_call`=:yp32, `coupon_id`=:yp33, `notification_type`=:yp34, `supplier_id`=:yp35, `social_provider`=:yp36, `social_identifier`=:yp37, `social_info2`=:yp38, `social_info1`=:yp39, `gender`=:yp40, `birthday`=:yp41, `facebook_id`=:yp42, `facebook_access_token`=:yp43, `image_url`=:yp44, `vip`=:yp45, `how_did_you_hear`=:yp46, `how_did_you_hear_other`=:yp47, `pup_coordinator`=:yp48, `signup_source`=:yp49, `description`=:yp50, `beta_tester`=:yp51, `payment_gateway`=:yp52, `payment_token`=:yp53, `substitution`=:yp54, `activate_deposit`=:yp55, `deposit`=:yp56, `prefered_deposit_amount`=:yp57, `card_last4digits`=:yp58, `payment_profile_id`=:yp59, `notification_status`=:yp60, `nb_qa_required`=:yp61, `campaign_referral`=:yp62, `login_token`=:yp63, `seen_popup`=:yp64, `gift_preferences`=:yp65, `display_sold_out_products`=:yp66, `home_delivery_address`=:yp67, `home_delivery_apt`=:yp68, `home_delivery_zip_code`=:yp69, `home_delivery_city_name`=:yp70, `home_delivery_state_id`=:yp71, `home_delivery_comment`=:yp72, `home_delivery_leave_basket`=:yp73, `fraudulent_reasons_id`=:yp74, `signed_up_to_weekly_promotions`=:yp75, `cs_pref_communication_language`=:yp76, `in_bad_debt_since`=:yp77, `address_lat`=:yp78, `address_lng`=:yp79, `bonus_program`=:yp80, `employee_status`=:yp81, `employee_personal_email`=:yp82, `internal_employee_id`=:yp83, `employee_photo_url`=:yp84, `date_of_birth`=:yp85, `employee_lock`=:yp86, `community_representative_group_id`=:yp87, `coordinator_photo_url`=:yp88, `coordinator_description`=:yp89, `coordinator_availability`=:yp90, `max_rows`=:yp91, `primary_task_type_id`=:yp92, `company_id`=:yp93, `charitable_account`=:yp94, `family_size`=:yp95, `giveback_donation_percent`=:yp96, `order_donation`=:yp97, `ident_verified`=:yp98, `mask_donor_identity`=:yp99, `numb_children`=:yp100, `snipeit_userid`=:yp101, `job_title`=:yp102, `dg_coordinator_company_id`=:yp103, `guest`=:yp104, `badge_color`=:yp105, `internal_grouping_code`=:yp106, `bonus_program_version`=:yp107, `users_date_of_last_shipped_order`=:yp108, `tier_id`=:yp109, `last_updated_pass`=:yp110, `reset_password_token`=:yp111, `has_access_to_meal_planner`=:yp112 WHERE `securelufacom`.`users`.`user_id`=618755. Bound with :yp0=618755, :yp1='p.liang@lufa.com', :yp2='$2a$08$fsGI56Z5vfh314RhKRM7QelHe6tJ.90DCRKSc/SUBc11hPtBp1dwy', :yp3='Patrick', :yp4='Liang', :yp5=NULL, :yp6='en', :yp7='2025-03-14 00:00:00', :yp8=1, :yp9=NULL, :yp10=NULL, :yp11='', :yp12='', :yp13='', :yp14='', :yp15='2025-03-14 11:44:16', :yp16='2025-04-15 17:33:48', :yp17=NULL, :yp18='', :yp19=3, :yp20='', :yp21=4, :yp22=1, :yp23=1, :yp24=NULL, :yp25='manual', :yp26='0', :yp27=NULL, :yp28=NULL, :yp29=NULL, :yp30=NULL, :yp31=NULL, :yp32=0, :yp33=NULL, :yp34=2, :yp35=NULL, :yp36='Google', :yp37='108571032030637286732', :yp38='108571032030637286732', :yp39='p.liang@lufa.com', :yp40=NULL, :yp41=NULL, :yp42=NULL, :yp43=NULL, :yp44=NULL, :yp45=0, :yp46=NULL, :yp47=NULL, :yp48=0, :yp49=0, :yp50='', :yp51=0, :yp52=0, :yp53=NULL, :yp54=1, :yp55=0, :yp56=NULL, :yp57=0, :yp58=NULL, :yp59='0', :yp60=1, :yp61=0, :yp62=NULL, :yp63=NULL, :yp64=0, :yp65=1, :yp66=1, :yp67='', :yp68=NULL, :yp69='', :yp70='', :yp71=3, :yp72=NULL, :yp73=NULL, :yp74=NULL, :yp75=0, :yp76='', :yp77=NULL, :yp78=NULL, :yp79=NULL, :yp80=0, :yp81='Active', :yp82='patrick@chinchill.ai', :yp83=NULL, :yp84=NULL, :yp85=NULL, :yp86=0, :yp87=15, :yp88=NULL, :yp89=NULL, :yp90=NULL, :yp91=NULL, :yp92=0, :yp93=NULL, :yp94=0, :yp95=1, :yp96='0.00', :yp97='0.00', :yp98=0, :yp99=0, :yp100=0, :yp101=NULL, :yp102='Customer Service Manager', :yp103=NULL, :yp104=0, :yp105=NULL, :yp106=NULL, :yp107=1, :yp108=NULL, :yp109=4, :yp110='2025-03-14 11:52:50', :yp111=NULL, :yp112=0
|
| 17:33:48.495 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `active_record_logs`
|
| 17:33:48.501 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `active_record_logs`
|
| 17:33:48.506 | trace | system.db.ar.CActiveRecord |
ActiveRecordLogs.insert()
|
| 17:33:48.506 | trace | system.db.CDbCommand |
Executing SQL: INSERT INTO `active_record_logs` (`description`, `action`, `model`, `model_id`, `field`, `old_value`, `new_value`, `created_at`, `user_id`, `parent_model`, `parent_model_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, NOW(), :yp7, :yp8, :yp9). Bound with :yp0='User Guest changed last_login_date for Users[618755].', :yp1='CHANGE', :yp2='Users', :yp3='618755', :yp4='last_login_date', :yp5='2025-04-15 00:15:50', :yp6='2025-04-15 17:33:48', :yp7=2, :yp8='Users', :yp9='618755'
|
| 17:33:48.534 | trace | system.db.ar.CActiveRecord |
UsersLang.findAll()
|
| 17:33:48.534 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `usersLang`
|
| 17:33:48.537 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `usersLang`
|
| 17:33:48.538 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `usersLang` `t` WHERE user_id=:id. Bound with :id='618755'
|
| 17:33:48.548 | trace | system.db.ar.CActiveRecord |
UsersLang.update()
|
| 17:33:48.548 | trace | system.db.ar.CActiveRecord |
UsersLang.updateByPk()
|
| 17:33:48.548 | trace | system.db.CDbCommand |
Executing SQL: UPDATE `usersLang` SET `l_id`=:yp0, `user_id`=:yp1, `lang_id`=:yp2, `l_description`=:yp3, `l_coordinator_description`=:yp4, `l_coordinator_availability`=:yp5 WHERE `usersLang`.`l_id`=609580. Bound with :yp0=609580, :yp1=618755, :yp2='en', :yp3=NULL, :yp4=NULL, :yp5=NULL
|
| 17:33:48.551 | trace | system.CModule |
Loading "localtime" application component
|
| 17:33:48.552 | trace | system.CModule |
Loading "statePersister" application component
|
| 17:33:48.552 | trace | system.caching.CApcCache |
Serving "Yii.CStatePersister./var/www/protected/runtime/state.bin" from cache
|
| 17:33:48.552 | trace | system.db.CDbCommand |
Executing SQL: DELETE FROM `user_session` WHERE id=:id. Bound with :id='m4crdcn8f5ntj815d8iq6o5odk'
|
| 17:33:48.554 | trace | system.db.CDbCommand |
Querying SQL: SELECT `data`
FROM `user_session` WHERE expire>:expire AND id=:id. Bound with :expire=1744752828, :id='e43pgoj5tkdtotoob1kqfhjara'
|
| 17:33:48.556 | trace | system.db.CDbCommand |
Querying SQL: SELECT `id`
FROM `user_session` WHERE id=:id. Bound with :id='e43pgoj5tkdtotoob1kqfhjara'
|
| 17:33:48.557 | trace | system.db.CDbCommand |
Executing SQL: INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES (:id, :data, :expire). Bound with :id='e43pgoj5tkdtotoob1kqfhjara', :data='', :expire=1757972028
|
| 17:33:48.559 | trace | system.db.CDbCommand |
Querying SQL: SELECT `data`
FROM `user_session` WHERE expire>:expire AND id=:id. Bound with :expire=1744752828, :id='iiscuk35bgs8r60qduij9sbtet'
|
| 17:33:48.562 | trace | system.db.CDbCommand |
Querying SQL: SELECT *
FROM `user_session` WHERE id=:id. Bound with :id='e43pgoj5tkdtotoob1kqfhjara'
|
| 17:33:48.563 | trace | system.db.CDbCommand |
Executing SQL: UPDATE `user_session` SET `id`=:id WHERE id=:oldID. Bound with :oldID='e43pgoj5tkdtotoob1kqfhjara', :id='iiscuk35bgs8r60qduij9sbtet'
|
| 17:33:48.566 | trace | system.base.CModule |
Loading "rights" module
|
| 17:33:48.566 | trace | system.CModule |
Loading "authorizer" application component
|
| 17:33:48.566 | trace | system.CModule |
Loading "authManager" application component
|
| 17:33:48.566 | trace | system.db.CDbCommand |
Querying SQL: SELECT *
FROM `authassignment` WHERE userid=:userid. Bound with :userid='618755'
|
| 17:33:48.577 | trace | system.CModule |
Loading "redis" application component
|
| 17:33:48.579 | trace | system.db.ar.CActiveRecord |
Users.findByPk()
|
| 17:33:48.579 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
|
| 17:33:48.582 | trace | system.db.CDbCommand |
Querying SQL: SELECT LCASE(itemname) as itemname, ai.type, ai.name
FROM authassignment t1 LEFT JOIN authitem ai ON ai.name = t1.itemname where userid = 618755
|
| 17:33:48.587 | trace | system.db.CDbCommand |
Querying SQL: SELECT LCASE(parent) as parent,LCASE(child) as child, ai.name , ai.type
FROM authitemchild ac LEFT JOIN authitem ai ON ai.name = ac.child ORDER BY `ai`.`type` DESC
|
| 17:33:48.610 | trace | system.db.ar.CActiveRecord |
UserAgents.findByAttributes()
|
| 17:33:48.610 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`=:yp0 LIMIT 1. Bound with :yp0='python-httpx/0.28.1'
|
| 17:33:48.694 | trace | system.db.ar.CActiveRecord |
ActionLog.insert()
|
| 17:33:48.694 | trace | system.db.CDbCommand |
Executing SQL: INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7). Bound with :yp0=618755, :yp1=618755, :yp2='Logged in using login token: [m4crdcn8f5ntj815d8iq6o5odk | iiscuk35bgs8r60qduij9sbtet]', :yp3=10, :yp4='34.130.1.12', :yp5='343059', :yp6='17:33:48', :yp7='2025-04-15'
|
| 17:33:48.697 | trace | system.db.ar.CActiveRecord |
Users.findByPk()
|
| 17:33:48.697 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
|
| 17:33:48.700 | trace | ext.localeurls |
Detected language 'en'
|
| 17:33:48.704 | trace | system.db.ar.CActiveRecord |
Orders.findAll()
|
| 17:33:48.705 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `orders`
|
| 17:33:48.708 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `orders`
|
| 17:33:48.710 | trace | system.db.CDbCommand |
Querying SQL: SELECT * FROM `orders` `t` WHERE (user_id=:ycp0) AND (status=:ycp1) ORDER BY delivery_date DESC LIMIT 3. Bound with :ycp0='428679', :ycp1='4'
|
| 17:33:48.813 | trace | system.db.ar.CActiveRecord |
lazy loading Orders.orderdetails
|
| 17:33:48.813 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `order_details`
|
| 17:33:48.817 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `order_details`
|
| 17:33:48.825 | trace | system.db.CDbCommand |
Querying SQL: SELECT `orderdetails`.`order_details_id` AS `t1_c0`, `orderdetails`.`order_id` AS `t1_c1`, `orderdetails`.`status` AS `t1_c2`, `orderdetails`.`product_id` AS `t1_c3`, `orderdetails`.`qa_qty` AS `t1_c4`, `orderdetails`.`refunded_qty` AS `t1_c5`, `orderdetails`.`refunded_reason` AS `t1_c6`, `orderdetails`.`substituted_product_id` AS `t1_c7`, `orderdetails`.`product_details` AS `t1_c8`, `orderdetails`.`default_retail_price_per_unit` AS `t1_c9`, `orderdetails`.`default_weight_per_unit` AS `t1_c10`, `orderdetails`.`defined_retail_price_per_unit_for_default_weight` AS `t1_c11`, `orderdetails`.`paid_price_per_unit_for_default_weight` AS `t1_c12`, `orderdetails`.`national_tax_amount_per_unit_for_default_weight` AS `t1_c13`, `orderdetails`.`provincial_tax_amount_per_unit_for_default_weight` AS `t1_c14`, `orderdetails`.`purchase_price_per_unit` AS `t1_c15`, `orderdetails`.`real_weight` AS `t1_c16`, `orderdetails`.`refund_comment` AS `t1_c17`, `orderdetails`.`paid_price_for_real_weight` AS `t1_c18`, `orderdetails`.`national_tax_amount_for_real_weight` AS `t1_c19`, `orderdetails`.`provincial_tax_amount_for_real_weight` AS `t1_c20`, `orderdetails`.`picked_from_lot_id` AS `t1_c21`, `orderdetails`.`recipe_id` AS `t1_c22`, `orderdetails`.`consigne_amount` AS `t1_c23`, `orderdetails`.`temp_bundle_id` AS `t1_c24`, `orderdetails`.`refund_attachment` AS `t1_c25`, `orderdetails`.`mp_ai_kitchen_id` AS `t1_c26` FROM `order_details` `orderdetails` WHERE (`orderdetails`.`order_id`=:ypl0). Bound with :ypl0='22092049'
|
| 17:33:48.843 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.844 | trace | system.CModule |
Loading "Global" application component
|
| 17:33:48.845 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `securelufacom`.`products`
|
| 17:33:48.851 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `securelufacom`.`products`
|
| 17:33:48.858 | trace | system.db.CDbCommand |
Querying SQL: SHOW FULL COLUMNS FROM `securelufacom`.`productsLang`
|
| 17:33:48.860 | trace | system.db.CDbCommand |
Querying SQL: SHOW CREATE TABLE `securelufacom`.`productsLang`
|
| 17:33:48.861 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='12533'
|
| 17:33:48.876 | trace | system.CModule |
Loading "s3images" application component
|
| 17:33:48.876 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.878 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='12533'
|
| 17:33:48.883 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.884 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='12533'
|
| 17:33:48.889 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.890 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='12533'
|
| 17:33:48.894 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.895 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='12533'
|
| 17:33:48.901 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.901 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='3264'
|
| 17:33:48.913 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.914 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='18717'
|
| 17:33:48.919 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.920 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='12533'
|
| 17:33:48.925 | trace | system.db.ar.CActiveRecord |
lazy loading Orders.orderdetails
|
| 17:33:48.925 | trace | system.db.CDbCommand |
Querying SQL: SELECT `orderdetails`.`order_details_id` AS `t1_c0`, `orderdetails`.`order_id` AS `t1_c1`, `orderdetails`.`status` AS `t1_c2`, `orderdetails`.`product_id` AS `t1_c3`, `orderdetails`.`qa_qty` AS `t1_c4`, `orderdetails`.`refunded_qty` AS `t1_c5`, `orderdetails`.`refunded_reason` AS `t1_c6`, `orderdetails`.`substituted_product_id` AS `t1_c7`, `orderdetails`.`product_details` AS `t1_c8`, `orderdetails`.`default_retail_price_per_unit` AS `t1_c9`, `orderdetails`.`default_weight_per_unit` AS `t1_c10`, `orderdetails`.`defined_retail_price_per_unit_for_default_weight` AS `t1_c11`, `orderdetails`.`paid_price_per_unit_for_default_weight` AS `t1_c12`, `orderdetails`.`national_tax_amount_per_unit_for_default_weight` AS `t1_c13`, `orderdetails`.`provincial_tax_amount_per_unit_for_default_weight` AS `t1_c14`, `orderdetails`.`purchase_price_per_unit` AS `t1_c15`, `orderdetails`.`real_weight` AS `t1_c16`, `orderdetails`.`refund_comment` AS `t1_c17`, `orderdetails`.`paid_price_for_real_weight` AS `t1_c18`, `orderdetails`.`national_tax_amount_for_real_weight` AS `t1_c19`, `orderdetails`.`provincial_tax_amount_for_real_weight` AS `t1_c20`, `orderdetails`.`picked_from_lot_id` AS `t1_c21`, `orderdetails`.`recipe_id` AS `t1_c22`, `orderdetails`.`consigne_amount` AS `t1_c23`, `orderdetails`.`temp_bundle_id` AS `t1_c24`, `orderdetails`.`refund_attachment` AS `t1_c25`, `orderdetails`.`mp_ai_kitchen_id` AS `t1_c26` FROM `order_details` `orderdetails` WHERE (`orderdetails`.`order_id`=:ypl0). Bound with :ypl0='22098898'
|
| 17:33:48.939 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.940 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='19074'
|
| 17:33:48.945 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.946 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='15343'
|
| 17:33:48.953 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.953 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='19074'
|
| 17:33:48.959 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.959 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='19074'
|
| 17:33:48.965 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.966 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='16074'
|
| 17:33:48.970 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.971 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='18988'
|
| 17:33:48.977 | trace | system.db.ar.CActiveRecord |
lazy loading Orders.orderdetails
|
| 17:33:48.977 | trace | system.db.CDbCommand |
Querying SQL: SELECT `orderdetails`.`order_details_id` AS `t1_c0`, `orderdetails`.`order_id` AS `t1_c1`, `orderdetails`.`status` AS `t1_c2`, `orderdetails`.`product_id` AS `t1_c3`, `orderdetails`.`qa_qty` AS `t1_c4`, `orderdetails`.`refunded_qty` AS `t1_c5`, `orderdetails`.`refunded_reason` AS `t1_c6`, `orderdetails`.`substituted_product_id` AS `t1_c7`, `orderdetails`.`product_details` AS `t1_c8`, `orderdetails`.`default_retail_price_per_unit` AS `t1_c9`, `orderdetails`.`default_weight_per_unit` AS `t1_c10`, `orderdetails`.`defined_retail_price_per_unit_for_default_weight` AS `t1_c11`, `orderdetails`.`paid_price_per_unit_for_default_weight` AS `t1_c12`, `orderdetails`.`national_tax_amount_per_unit_for_default_weight` AS `t1_c13`, `orderdetails`.`provincial_tax_amount_per_unit_for_default_weight` AS `t1_c14`, `orderdetails`.`purchase_price_per_unit` AS `t1_c15`, `orderdetails`.`real_weight` AS `t1_c16`, `orderdetails`.`refund_comment` AS `t1_c17`, `orderdetails`.`paid_price_for_real_weight` AS `t1_c18`, `orderdetails`.`national_tax_amount_for_real_weight` AS `t1_c19`, `orderdetails`.`provincial_tax_amount_for_real_weight` AS `t1_c20`, `orderdetails`.`picked_from_lot_id` AS `t1_c21`, `orderdetails`.`recipe_id` AS `t1_c22`, `orderdetails`.`consigne_amount` AS `t1_c23`, `orderdetails`.`temp_bundle_id` AS `t1_c24`, `orderdetails`.`refund_attachment` AS `t1_c25`, `orderdetails`.`mp_ai_kitchen_id` AS `t1_c26` FROM `order_details` `orderdetails` WHERE (`orderdetails`.`order_id`=:ypl0). Bound with :ypl0='21964709'
|
| 17:33:48.992 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.993 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='17398'
|
| 17:33:48.998 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:48.999 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='12533'
|
| 17:33:49.004 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:49.005 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='17952'
|
| 17:33:49.011 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:49.012 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='3215'
|
| 17:33:49.017 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:49.018 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='14293'
|
| 17:33:49.023 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:49.024 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='3220'
|
| 17:33:49.030 | trace | system.db.ar.CActiveRecord |
lazy loading OrderDetails.products
|
| 17:33:49.030 | trace | system.db.CDbCommand |
Querying SQL: SELECT `products`.`product_id` AS `t1_c0`, `products`.`crop_id` AS `t1_c1`, `products`.`crop_variety_id` AS `t1_c2`, `products`.`supplier_id` AS `t1_c3`, `products`.`name` AS `t1_c4`, `products`.`units` AS `t1_c5`, `products`.`weight` AS `t1_c6`, `products`.`product_weight_with_packaging` AS `t1_c7`, `products`.`volume` AS `t1_c8`, `products`.`price` AS `t1_c9`, `products`.`packing_order` AS `t1_c10`, `products`.`image_url` AS `t1_c11`, `products`.`status` AS `t1_c12`, `products`.`seconds_needed_to_pack` AS `t1_c13`, `products`.`featured` AS `t1_c14`, `products`.`manipulation_needed` AS `t1_c15`, `products`.`manipulation_instructions` AS `t1_c16`, `products`.`gift` AS `t1_c17`, `products`.`unlocked_above` AS `t1_c18`, `products`.`automated_purchase` AS `t1_c19`, `products`.`refrigerated` AS `t1_c20`, `products`.`description` AS `t1_c21`, `products`.`lead_time` AS `t1_c22`, `products`.`gift_certificate` AS `t1_c23`, `products`.`product_barcode` AS `t1_c24`, `products`.`apply_provincial_tax` AS `t1_c25`, `products`.`apply_national_tax` AS `t1_c26`, `products`.`cc_pending_TODELETE` AS `t1_c27`, `products`.`flow_through` AS `t1_c28`, `products`.`location_header_id` AS `t1_c29`, `products`.`qty_ready_for_picking` AS `t1_c30`, `products`.`slug` AS `t1_c31`, `products`.`created` AS `t1_c32`, `products`.`updated` AS `t1_c33`, `products`.`user_id` AS `t1_c34`, `products`.`release_rate` AS `t1_c35`, `products`.`purchasing_price` AS `t1_c36`, `products`.`is_customizable` AS `t1_c37`, `products`.`conservation_mode_in_basket` AS `t1_c38`, `products`.`conservation_mode_in_warehouse` AS `t1_c39`, `products`.`supplier_product_name` AS `t1_c40`, `products`.`supplier_product_code` AS `t1_c41`, `products`.`lock_status` AS `t1_c42`, `products`.`unit_of_measure` AS `t1_c43`, `products`.`is_new` AS `t1_c44`, `products`.`created_by` AS `t1_c45`, `products`.`days_alert_before_expiry_date` AS `t1_c46`, `products`.`days_remove_before_expiry_date` AS `t1_c47`, `products`.`default_duration_days_minimum_expiration` AS `t1_c48`, `products`.`group_type` AS `t1_c49`, `products`.`visible_on_marketplace` AS `t1_c50`, `products`.`display_position_for_supplier` AS `t1_c51`, `products`.`lock_status_comment` AS `t1_c52`, `products`.`apply_provincial_tax_purchasing` AS `t1_c53`, `products`.`apply_national_tax_purchasing` AS `t1_c54`, `products`.`virtual` AS `t1_c55`, `products`.`delivery_service_fees` AS `t1_c56`, `products`.`charge_by_weight` AS `t1_c57`, `products`.`provenance_required_upon_reception` AS `t1_c58`, `products`.`weight_variance` AS `t1_c59`, `products`.`average_price_quantity` AS `t1_c60`, `products`.`average_price_unit_id` AS `t1_c61`, `products`.`restricted_to_lufa` AS `t1_c62`, `products`.`weight_published_and_always_same` AS `t1_c63`, `products`.`ingredient_list` AS `t1_c64`, `products`.`photo_reshoot_required` AS `t1_c65`, `products`.`reason_for_unpublishing` AS `t1_c66`, `products`.`is_charge_by_weight_capped` AS `t1_c67`, `products`.`max_percentage_of_surplus_charged_for_charge_by_weight_product` AS `t1_c68`, `products`.`is_gluten_free` AS `t1_c69`, `products`.`width` AS `t1_c70`, `products`.`height` AS `t1_c71`, `products`.`length` AS `t1_c72`, `products`.`units_per_box` AS `t1_c73`, `products`.`security_factor` AS `t1_c74`, `products`.`eligible_for_6_pack` AS `t1_c75`, `products`.`sub_sub_id` AS `t1_c76`, `products`.`number_of_items_per_package` AS `t1_c77`, `products`.`reception_type` AS `t1_c78`, `products`.`reception_weight` AS `t1_c79`, `products`.`reception_height` AS `t1_c80`, `products`.`reception_width` AS `t1_c81`, `products`.`reception_length` AS `t1_c82`, `products`.`reception_cost` AS `t1_c83`, `products`.`reception_tolerance` AS `t1_c84`, `products`.`may_drip_force_1st_level` AS `t1_c85`, `products`.`requires_light` AS `t1_c86`, `products`.`store_close_to_drain` AS `t1_c87`, `products`.`minimal_margin` AS `t1_c88`, `products`.`state` AS `t1_c89`, `products`.`state_comment` AS `t1_c90`, `products`.`initial_approval_date` AS `t1_c91`, `products`.`disabled_date` AS `t1_c92`, `products`.`average_price_flag` AS `t1_c93`, `products`.`internal_notes` AS `t1_c94`, `products`.`suggested_description` AS `t1_c95`, `products`.`suggested_name` AS `t1_c96`, `products`.`image` AS `t1_c97`, `products`.`existing_image_product_id` AS `t1_c98`, `products`.`biso_location` AS `t1_c99`, `products`.`manipulation_instructions_packer` AS `t1_c100`, `products`.`special_instructions_packer` AS `t1_c101`, `products`.`is_organic` AS `t1_c102`, `products`.`is_hermetically_sealed` AS `t1_c103`, `products`.`dynamic_pricing` AS `t1_c104`, `products`.`reception_instructions` AS `t1_c105`, `products`.`low_quantity_notification` AS `t1_c106`, `products`.`sample` AS `t1_c107`, `products`.`preference_restriction` AS `t1_c108`, `products`.`consigne_amount` AS `t1_c109`, `products`.`alcohol` AS `t1_c110`, `products`.`freezer_storage` AS `t1_c111`, `products`.`storage_format_in_wh` AS `t1_c112`, `products`.`tote_format_id` AS `t1_c113`, `products`.`units_per_tote` AS `t1_c114`, `products`.`display_nutritional_values` AS `t1_c115`, `products`.`nutritional_values_status` AS `t1_c116`, `products`.`nutritional_values_file` AS `t1_c117`, `products`.`nutritional_values_file_uploaded_at` AS `t1_c118`, `products`.`nutritional_values_file_uploaded_by` AS `t1_c119`, `products`.`quality_visible_to_packer` AS `t1_c120`, `products`.`received_in` AS `t1_c121`, `products`.`is_scs_certified` AS `t1_c122`, `products`.`portion_in_biso` AS `t1_c123`, `products`.`is_organic_USDA` AS `t1_c124`, `products`.`trial_product` AS `t1_c125`, `products`.`portioning_speed_group_id` AS `t1_c126`, `products`.`portioning_packaging_id` AS `t1_c127`, `products`.`purchaser_id` AS `t1_c128`, `products`.`category_manager_id` AS `t1_c129`, `products`.`products_sunday_bb_cap` AS `t1_c130`, `products`.`products_monday_bb_cap` AS `t1_c131`, `products`.`products_tuesday_bb_cap` AS `t1_c132`, `products`.`products_wednesday_bb_cap` AS `t1_c133`, `products`.`products_thursday_bb_cap` AS `t1_c134`, `products`.`products_friday_bb_cap` AS `t1_c135`, `products`.`products_saturday_bb_cap` AS `t1_c136`, `products`.`dp_minimal_price` AS `t1_c137`, `products`.`super_aubaines_image_url` AS `t1_c138`, `products`.`temperature_validation` AS `t1_c139`, `products`.`temperature_validation_min` AS `t1_c140`, `products`.`temperature_validation_max` AS `t1_c141`, `products`.`expiration_validation` AS `t1_c142`, `products`.`sample_weight_validation` AS `t1_c143`, `products`.`qtyoh_calc_validation` AS `t1_c144`, `products`.`temporary_exempt_of_national_tax` AS `t1_c145`, `products`.`create_with_forecast_tool` AS `t1_c146`, `products`.`apply_hst_tax` AS `t1_c147`, `products`.`packaging_weight` AS `t1_c148`, `i18nProducts`.`l_id` AS `t2_c0`, `i18nProducts`.`product_id` AS `t2_c1`, `i18nProducts`.`lang_id` AS `t2_c2`, `i18nProducts`.`l_name` AS `t2_c3`, `i18nProducts`.`l_units` AS `t2_c4`, `i18nProducts`.`l_description` AS `t2_c5`, `i18nProducts`.`l_slug` AS `t2_c6`, `i18nProducts`.`l_ingredient_list` AS `t2_c7`, `i18nProducts`.`l_suggested_description` AS `t2_c8`, `i18nProducts`.`l_suggested_name` AS `t2_c9`, `i18nProducts`.`l_manipulation_instructions` AS `t2_c10`, `i18nProducts`.`l_special_instructions_packer` AS `t2_c11`, `i18nProducts`.`l_reception_instructions` AS `t2_c12` FROM `securelufacom`.`products` `products` LEFT JOIN productSubSubCategories ssc ON ssc.sub_sub_id = products.sub_sub_id LEFT OUTER JOIN `securelufacom`.`productsLang` `i18nProducts` ON (`i18nProducts`.`product_id`=`products`.`product_id`) AND (i18nProducts.lang_id='en') WHERE (`products`.`product_id`=:ypl0) ORDER BY products.supplier_id ASC, ssc.subcategory_id, products.name. Bound with :ypl0='15146'
|
| 17:33:49.036 | 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='mcpRest/orders', :loading_time=3.593, :memory_used=7.92, :ip='34.130.1.12', :user_id='618755', :body='', :query_string='', :cookies='s:0:"";'
|
| 17:33:49.039 | trace | system.db.CDbCommand |
Executing SQL: UPDATE user_session SET user_id = :user_id WHERE id = :session_id AND user_id IS NULL. Bound with :user_id='618755', :session_id='iiscuk35bgs8r60qduij9sbtet'
|
| 17:33:49.049 | trace | application |
UPDATED 1 rows for user_id: 618755 and session_id: iiscuk35bgs8r60qduij9sbtet
|