Query Metrics
22
Database Queries
14
Different statements
95.22 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.68 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.date_created AS date_created_13, t0.first_name AS first_name_14, t0.display_name AS display_name_15, t0.last_name AS last_name_16, t0.phone AS phone_17, t0.lang AS lang_18, t0.settings_receive_message_notification AS settings_receive_message_notification_19, t0.facebook_id AS facebook_id_20, t0.google_id AS google_id_21, t0.linkedin_id AS linkedin_id_22, t0.terms_acceptance_date AS terms_acceptance_date_23, t0.terms_acceptance_ip AS terms_acceptance_ip_24, t0.stripe_account_id AS stripe_account_id_25, t0.is_beta_tester AS is_beta_tester_26, t0.payment_last4digits AS payment_last4digits_27, t0.is_arecruiter AS is_arecruiter_28, t0.is_hri AS is_hri_29, t0.is_allowed_to_make_groups AS is_allowed_to_make_groups_30, t0.make_group_name AS make_group_name_31, t0.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_32, t0.has_reusable_box AS has_reusable_box_33, t0.reminder_coupon_sent AS reminder_coupon_sent_34, t0.next_user_survey_time AS next_user_survey_time_35, t0.dont_show_survey AS dont_show_survey_36, t0.user_subscription_maturin AS user_subscription_maturin_37, t0.date_log_subscription_maturin AS date_log_subscription_maturin_38, t0.subscription_stripe_id AS subscription_stripe_id_39, t0.profile_image_id AS profile_image_id_40, t0.referred_by_id AS referred_by_id_41, t0.make_company_for_association_id AS make_company_for_association_id_42, t43.id AS id_44, t43.diets AS diets_45, t43.allergy AS allergy_46, t43.nb_personnes AS nb_personnes_47, t43.grocery_budget AS grocery_budget_48, t43.handicap AS handicap_49, t43.age_category AS age_category_50, t43.user_id AS user_id_51 FROM app_users t0 LEFT JOIN user_survey t43 ON t43.user_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
8589
]
|
| 2 | 1.03 ms |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.stripe_token AS stripe_token_3, t0.stripe_response AS stripe_response_4, t0.is_paid AS is_paid_5, t0.solex_order_id AS solex_order_id_6, t0.date_payment AS date_payment_7, t0.shipping_estimation_raw AS shipping_estimation_raw_8, t0.shipping_maturin_cost AS shipping_maturin_cost_9, t0.shipping_maturin_carrier_name AS shipping_maturin_carrier_name_10, t0.shipping_maturin_service_name AS shipping_maturin_service_name_11, t0.shipping_maturin_estimated_date AS shipping_maturin_estimated_date_12, t0.picking_and_packing_fee AS picking_and_packing_fee_13, t0.payment_fee AS payment_fee_14, t0.maturin_fee AS maturin_fee_15, t0.taxes_products AS taxes_products_16, t0.taxes_maturin AS taxes_maturin_17, t0.taxes_shipping_maturin AS taxes_shipping_maturin_18, t0.taxes_shipping_company AS taxes_shipping_company_19, t0.taxes_packing AS taxes_packing_20, t0.shipping_maturin_service_id AS shipping_maturin_service_id_21, t0.solex_order_raw AS solex_order_raw_22, t0.maturin_tracking_info AS maturin_tracking_info_23, t0.order_no AS order_no_24, t0.is_on_hold AS is_on_hold_25, t0.just_in_time_email_sent AS just_in_time_email_sent_26, t0.reminder_sent AS reminder_sent_27, t0.raw_distributor_billing AS raw_distributor_billing_28, t0.taxes_products_calculations AS taxes_products_calculations_29, t0.taxes_shipping_maturin_calculations AS taxes_shipping_maturin_calculations_30, t0.taxes_shipping_company_calculations AS taxes_shipping_company_calculations_31, t0.taxes_packing_calculations AS taxes_packing_calculations_32, t0.amount_saved_by_coupon AS amount_saved_by_coupon_33, t0.shipping_signature_required AS shipping_signature_required_34, t0.signature_mandatory AS signature_mandatory_35, t0.extra_priority_points AS extra_priority_points_36, t0.warehouse_group_id AS warehouse_group_id_37, t0.is_refunded AS is_refunded_38, t0.refund_stripe_response AS refund_stripe_response_39, t0.note_from_buyer AS note_from_buyer_40, t0.is_bulk_order AS is_bulk_order_41, t0.track_link AS track_link_42, t0.track_pod_status_id AS track_pod_status_id_43, t0.delivery_choice_date AS delivery_choice_date_44, t0.pre_order AS pre_order_45, t0.pre_order_now AS pre_order_now_46, t0.shipping_address_id AS shipping_address_id_47, t0.user_id AS user_id_48, t0.used_coupon_id AS used_coupon_id_49, t0.logistic_invoice_id AS logistic_invoice_id_50, t0.send_with_subscription_id AS send_with_subscription_id_51, t0.from_subscription_id AS from_subscription_id_52 FROM cart t0 WHERE (((t0.is_paid = ? AND t0.is_refunded = ?) AND t0.is_bulk_order = ?) AND t0.user_id = ?)
Parameters:
[ 0 0 0 8589 ] |
| 3 | 0.81 ms |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.is_active AS is_active_3, t0.unit AS unit_4, t0.value AS value_5, t0.user_id AS user_id_6, t0.cart_id AS cart_id_7 FROM recurring_order t0 WHERE t0.cart_id = ?
Parameters:
[
4316353
]
|
| 4 | 0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.mrc AS mrc_3, t0.delivery_price AS delivery_price_4, t0.province AS province_5, t0.region_id AS region_id_6 FROM city t0 WHERE t0.name = ?
Parameters:
[
"Ste-Madeleine "
]
|
| 5 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.province AS province_3, t0.country AS country_4 FROM region t0 WHERE t0.name = ?
Parameters:
[
"defaut"
]
|
| 6 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 1.23 ms |
INSERT INTO city (name, mrc, delivery_price, province, region_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => "Ste-Madeleine" 2 => "Ste-Madeleine" 3 => null 4 => "QC" 5 => 68 ] |
| 8 | 0.73 ms |
UPDATE app_users SET stripe_account_id = ? WHERE id = ?
Parameters:
[ "zmjWjZu8c5fOd026s5b1OD39vYuWJB8QlWsuHZrwA8spLdlfxs3Y1gAHAFvhjN9W<ENC>" 8589 ] |
| 9 | 1.29 ms |
"COMMIT"
Parameters:
[] |
| 10 | 33.36 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.date_created AS date_created_13, t0.first_name AS first_name_14, t0.display_name AS display_name_15, t0.last_name AS last_name_16, t0.phone AS phone_17, t0.lang AS lang_18, t0.settings_receive_message_notification AS settings_receive_message_notification_19, t0.facebook_id AS facebook_id_20, t0.google_id AS google_id_21, t0.linkedin_id AS linkedin_id_22, t0.terms_acceptance_date AS terms_acceptance_date_23, t0.terms_acceptance_ip AS terms_acceptance_ip_24, t0.stripe_account_id AS stripe_account_id_25, t0.is_beta_tester AS is_beta_tester_26, t0.payment_last4digits AS payment_last4digits_27, t0.is_arecruiter AS is_arecruiter_28, t0.is_hri AS is_hri_29, t0.is_allowed_to_make_groups AS is_allowed_to_make_groups_30, t0.make_group_name AS make_group_name_31, t0.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_32, t0.has_reusable_box AS has_reusable_box_33, t0.reminder_coupon_sent AS reminder_coupon_sent_34, t0.next_user_survey_time AS next_user_survey_time_35, t0.dont_show_survey AS dont_show_survey_36, t0.user_subscription_maturin AS user_subscription_maturin_37, t0.date_log_subscription_maturin AS date_log_subscription_maturin_38, t0.subscription_stripe_id AS subscription_stripe_id_39, t0.profile_image_id AS profile_image_id_40, t0.referred_by_id AS referred_by_id_41, t0.make_company_for_association_id AS make_company_for_association_id_42, t43.id AS id_44, t43.diets AS diets_45, t43.allergy AS allergy_46, t43.nb_personnes AS nb_personnes_47, t43.grocery_budget AS grocery_budget_48, t43.handicap AS handicap_49, t43.age_category AS age_category_50, t43.user_id AS user_id_51 FROM app_users t0 LEFT JOIN user_survey t43 ON t43.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
"charlie@maturin.ca"
]
|
| 11 | 35.40 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.date_created AS date_created_13, t0.first_name AS first_name_14, t0.display_name AS display_name_15, t0.last_name AS last_name_16, t0.phone AS phone_17, t0.lang AS lang_18, t0.settings_receive_message_notification AS settings_receive_message_notification_19, t0.facebook_id AS facebook_id_20, t0.google_id AS google_id_21, t0.linkedin_id AS linkedin_id_22, t0.terms_acceptance_date AS terms_acceptance_date_23, t0.terms_acceptance_ip AS terms_acceptance_ip_24, t0.stripe_account_id AS stripe_account_id_25, t0.is_beta_tester AS is_beta_tester_26, t0.payment_last4digits AS payment_last4digits_27, t0.is_arecruiter AS is_arecruiter_28, t0.is_hri AS is_hri_29, t0.is_allowed_to_make_groups AS is_allowed_to_make_groups_30, t0.make_group_name AS make_group_name_31, t0.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_32, t0.has_reusable_box AS has_reusable_box_33, t0.reminder_coupon_sent AS reminder_coupon_sent_34, t0.next_user_survey_time AS next_user_survey_time_35, t0.dont_show_survey AS dont_show_survey_36, t0.user_subscription_maturin AS user_subscription_maturin_37, t0.date_log_subscription_maturin AS date_log_subscription_maturin_38, t0.subscription_stripe_id AS subscription_stripe_id_39, t0.profile_image_id AS profile_image_id_40, t0.referred_by_id AS referred_by_id_41, t0.make_company_for_association_id AS make_company_for_association_id_42, t43.id AS id_44, t43.diets AS diets_45, t43.allergy AS allergy_46, t43.nb_personnes AS nb_personnes_47, t43.grocery_budget AS grocery_budget_48, t43.handicap AS handicap_49, t43.age_category AS age_category_50, t43.user_id AS user_id_51 FROM app_users t0 LEFT JOIN user_survey t43 ON t43.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
"charlie@maturin.ca"
]
|
| 12 | 0.22 ms |
"START TRANSACTION"
Parameters:
[] |
| 13 | 8.50 ms |
INSERT INTO email_sent (date_created, sent_to, sent_from, subject, body_html, body_text, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "2026-09-15 16:56:32" 2 => "charlie@maturin.ca" 3 => "reply-message@maturin.ca" 4 => "Une nouvelle ville a été ajouté" 5 => "<p>La ville ,Ste-Madeleine a été ajouté dans la base de données</p>" 6 => null 7 => 14055 ] |
| 14 | 0.82 ms |
UPDATE app_users SET stripe_account_id = ? WHERE id = ?
Parameters:
[ "Pv87myA+uDLeEQxNrwFVXQHDLMrCSJUrtiYQTMRDJygwMHYNLOKxg7GGxtMSmwpU<ENC>" 8589 ] |
| 15 | 0.55 ms |
UPDATE app_users SET stripe_account_id = ?, subscription_stripe_id = ? WHERE id = ?
Parameters:
[ "M5v1Pg+hA8r8xJ4nfD5o8e+W1DztKGpmcuiGZpfYfh3eG7zLbZxnVbzAx4p9CEq3<ENC>" "v2yqlOjcjfSTr6FbkTmL1sTwGXRn84Lcj5lGr8xxRSVCOGYJmw7AjgkMCBJrw+1d<ENC>" 14055 ] |
| 16 | 2.23 ms |
"COMMIT"
Parameters:
[] |
| 17 | 0.18 ms |
"START TRANSACTION"
Parameters:
[] |
| 18 | 1.10 ms |
INSERT INTO user_shipping_location (civic_number, street_name, city, zip_code, province, country, name, phone, unit, note, email, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "3466" 2 => "rue des Hêtres" 3 => "Ste-Madeleine " 4 => "J0H 1S0" 5 => "QC" 6 => "CA" 7 => "Josée Auclair" 8 => "(514) 707-9604" 9 => "" 10 => null 11 => "joseeauclair@gmail.com" 12 => 8589 ] |
| 19 | 0.54 ms |
UPDATE app_users SET stripe_account_id = ? WHERE id = ?
Parameters:
[ "Qoos5Oo4ZK8b/4DX/y7Hro2VkyuDEOE3V/M2AQnMukXkPBOKBcZ8Ss863wYYP9eI<ENC>" 8589 ] |
| 20 | 0.39 ms |
UPDATE app_users SET stripe_account_id = ?, subscription_stripe_id = ? WHERE id = ?
Parameters:
[ "RwZKBOTCfLFVwPHkZlRBwXrDmnvDeh6ISvGkT408oa1n69hUlxXL5PzR+ZQuzz21<ENC>" "HlXoBqFZVVPbS2z8/vB7IEF05vvX90flKdhXXUGRYmSM4XyyLohQ47uMJvxO5baK<ENC>" 14055 ] |
| 21 | 0.89 ms |
UPDATE cart SET shipping_address_id = ? WHERE id = ?
Parameters:
[ 11608 4316353 ] |
| 22 | 3.03 ms |
"COMMIT"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\CompanyAssociation | No errors. |
| App\Entity\UserSurvey | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\UserVariables | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\UserShippingLocation | No errors. |
| App\Entity\UserSearch | No errors. |
| App\Entity\UserViewedProduct | No errors. |
| App\Entity\FinancialLog | No errors. |
| App\Entity\UserFavorite | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\CartCoupon | No errors. |
| App\Entity\RecurringOrder | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\EmailSent | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\CartProduct | No errors. |
| App\Entity\CustomOrder | No errors. |
| App\Entity\MaturinOrder | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\CompanyLocation | No errors. |
| App\Entity\DeliveryRoute | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Conservation | No errors. |
| App\Entity\Corporative | No errors. |