Query Metrics
436
Database Queries
13
Different statements
269.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
245.72 ms (91.34%) |
419 |
SELECT count(p0_.id) AS sclr_0 FROM product p0_ WHERE (p0_.categories_id IN (?) OR p0_.sub_category_id IN (?)) AND p0_.draft <> 1 AND p0_.available = 1 AND p0_.main_image_id IS NOT NULL
Parameters:
[ 355 [ 355 false ] ] |
|
14.19 ms (5.28%) |
3 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.placement AS placement_2, c0_.title AS title_3, c0_.description AS description_4, c0_.tier1maturin_fees_pc AS tier1maturin_fees_pc_5, c0_.tier2maturin_fees_pc AS tier2maturin_fees_pc_6, c0_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_7, c0_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_8, c0_.packing_fees_amount AS packing_fees_amount_9, c0_.packing_supplies_fees_amount AS packing_supplies_fees_amount_10, c0_.meta_description AS meta_description_11, c0_.is_displayed_for_buyer AS is_displayed_for_buyer_12, c1_.id AS id_13, c1_.name AS name_14, c1_.placement AS placement_15, c1_.title AS title_16, c1_.description AS description_17, c1_.tier1maturin_fees_pc AS tier1maturin_fees_pc_18, c1_.tier2maturin_fees_pc AS tier2maturin_fees_pc_19, c1_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_20, c1_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_21, c1_.packing_fees_amount AS packing_fees_amount_22, c1_.packing_supplies_fees_amount AS packing_supplies_fees_amount_23, c1_.meta_description AS meta_description_24, c1_.is_displayed_for_buyer AS is_displayed_for_buyer_25, c2_.id AS id_26, c2_.name AS name_27, c2_.placement AS placement_28, c2_.title AS title_29, c2_.description AS description_30, c2_.tier1maturin_fees_pc AS tier1maturin_fees_pc_31, c2_.tier2maturin_fees_pc AS tier2maturin_fees_pc_32, c2_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_33, c2_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_34, c2_.packing_fees_amount AS packing_fees_amount_35, c2_.packing_supplies_fees_amount AS packing_supplies_fees_amount_36, c2_.meta_description AS meta_description_37, c2_.is_displayed_for_buyer AS is_displayed_for_buyer_38, c3_.id AS id_39, c3_.name AS name_40, c3_.placement AS placement_41, c3_.title AS title_42, c3_.description AS description_43, c3_.tier1maturin_fees_pc AS tier1maturin_fees_pc_44, c3_.tier2maturin_fees_pc AS tier2maturin_fees_pc_45, c3_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_46, c3_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_47, c3_.packing_fees_amount AS packing_fees_amount_48, c3_.packing_supplies_fees_amount AS packing_supplies_fees_amount_49, c3_.meta_description AS meta_description_50, c3_.is_displayed_for_buyer AS is_displayed_for_buyer_51, c4_.id AS id_52, c4_.name AS name_53, c4_.placement AS placement_54, c4_.title AS title_55, c4_.description AS description_56, c4_.tier1maturin_fees_pc AS tier1maturin_fees_pc_57, c4_.tier2maturin_fees_pc AS tier2maturin_fees_pc_58, c4_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_59, c4_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_60, c4_.packing_fees_amount AS packing_fees_amount_61, c4_.packing_supplies_fees_amount AS packing_supplies_fees_amount_62, c4_.meta_description AS meta_description_63, c4_.is_displayed_for_buyer AS is_displayed_for_buyer_64, c5_.id AS id_65, c5_.name AS name_66, c5_.placement AS placement_67, c5_.title AS title_68, c5_.description AS description_69, c5_.tier1maturin_fees_pc AS tier1maturin_fees_pc_70, c5_.tier2maturin_fees_pc AS tier2maturin_fees_pc_71, c5_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_72, c5_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_73, c5_.packing_fees_amount AS packing_fees_amount_74, c5_.packing_supplies_fees_amount AS packing_supplies_fees_amount_75, c5_.meta_description AS meta_description_76, c5_.is_displayed_for_buyer AS is_displayed_for_buyer_77, c6_.id AS id_78, c6_.name AS name_79, c6_.placement AS placement_80, c6_.title AS title_81, c6_.description AS description_82, c6_.tier1maturin_fees_pc AS tier1maturin_fees_pc_83, c6_.tier2maturin_fees_pc AS tier2maturin_fees_pc_84, c6_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_85, c6_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_86, c6_.packing_fees_amount AS packing_fees_amount_87, c6_.packing_supplies_fees_amount AS packing_supplies_fees_amount_88, c6_.meta_description AS meta_description_89, c6_.is_displayed_for_buyer AS is_displayed_for_buyer_90, c7_.id AS id_91, c7_.name AS name_92, c7_.placement AS placement_93, c7_.title AS title_94, c7_.description AS description_95, c7_.tier1maturin_fees_pc AS tier1maturin_fees_pc_96, c7_.tier2maturin_fees_pc AS tier2maturin_fees_pc_97, c7_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_98, c7_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_99, c7_.packing_fees_amount AS packing_fees_amount_100, c7_.packing_supplies_fees_amount AS packing_supplies_fees_amount_101, c7_.meta_description AS meta_description_102, c7_.is_displayed_for_buyer AS is_displayed_for_buyer_103, c8_.id AS id_104, c8_.name AS name_105, c8_.placement AS placement_106, c8_.title AS title_107, c8_.description AS description_108, c8_.tier1maturin_fees_pc AS tier1maturin_fees_pc_109, c8_.tier2maturin_fees_pc AS tier2maturin_fees_pc_110, c8_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_111, c8_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_112, c8_.packing_fees_amount AS packing_fees_amount_113, c8_.packing_supplies_fees_amount AS packing_supplies_fees_amount_114, c8_.meta_description AS meta_description_115, c8_.is_displayed_for_buyer AS is_displayed_for_buyer_116, c9_.id AS id_117, c9_.name AS name_118, c9_.placement AS placement_119, c9_.title AS title_120, c9_.description AS description_121, c9_.tier1maturin_fees_pc AS tier1maturin_fees_pc_122, c9_.tier2maturin_fees_pc AS tier2maturin_fees_pc_123, c9_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_124, c9_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_125, c9_.packing_fees_amount AS packing_fees_amount_126, c9_.packing_supplies_fees_amount AS packing_supplies_fees_amount_127, c9_.meta_description AS meta_description_128, c9_.is_displayed_for_buyer AS is_displayed_for_buyer_129, c10_.id AS id_130, c10_.name AS name_131, c10_.placement AS placement_132, c10_.title AS title_133, c10_.description AS description_134, c10_.tier1maturin_fees_pc AS tier1maturin_fees_pc_135, c10_.tier2maturin_fees_pc AS tier2maturin_fees_pc_136, c10_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_137, c10_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_138, c10_.packing_fees_amount AS packing_fees_amount_139, c10_.packing_supplies_fees_amount AS packing_supplies_fees_amount_140, c10_.meta_description AS meta_description_141, c10_.is_displayed_for_buyer AS is_displayed_for_buyer_142, c11_.id AS id_143, c11_.name AS name_144, c11_.placement AS placement_145, c11_.title AS title_146, c11_.description AS description_147, c11_.tier1maturin_fees_pc AS tier1maturin_fees_pc_148, c11_.tier2maturin_fees_pc AS tier2maturin_fees_pc_149, c11_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_150, c11_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_151, c11_.packing_fees_amount AS packing_fees_amount_152, c11_.packing_supplies_fees_amount AS packing_supplies_fees_amount_153, c11_.meta_description AS meta_description_154, c11_.is_displayed_for_buyer AS is_displayed_for_buyer_155, c12_.id AS id_156, c12_.name AS name_157, c12_.placement AS placement_158, c12_.title AS title_159, c12_.description AS description_160, c12_.tier1maturin_fees_pc AS tier1maturin_fees_pc_161, c12_.tier2maturin_fees_pc AS tier2maturin_fees_pc_162, c12_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_163, c12_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_164, c12_.packing_fees_amount AS packing_fees_amount_165, c12_.packing_supplies_fees_amount AS packing_supplies_fees_amount_166, c12_.meta_description AS meta_description_167, c12_.is_displayed_for_buyer AS is_displayed_for_buyer_168, c13_.id AS id_169, c13_.name AS name_170, c13_.placement AS placement_171, c13_.title AS title_172, c13_.description AS description_173, c13_.tier1maturin_fees_pc AS tier1maturin_fees_pc_174, c13_.tier2maturin_fees_pc AS tier2maturin_fees_pc_175, c13_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_176, c13_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_177, c13_.packing_fees_amount AS packing_fees_amount_178, c13_.packing_supplies_fees_amount AS packing_supplies_fees_amount_179, c13_.meta_description AS meta_description_180, c13_.is_displayed_for_buyer AS is_displayed_for_buyer_181, c14_.id AS id_182, c14_.name AS name_183, c14_.placement AS placement_184, c14_.title AS title_185, c14_.description AS description_186, c14_.tier1maturin_fees_pc AS tier1maturin_fees_pc_187, c14_.tier2maturin_fees_pc AS tier2maturin_fees_pc_188, c14_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_189, c14_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_190, c14_.packing_fees_amount AS packing_fees_amount_191, c14_.packing_supplies_fees_amount AS packing_supplies_fees_amount_192, c14_.meta_description AS meta_description_193, c14_.is_displayed_for_buyer AS is_displayed_for_buyer_194, c15_.id AS id_195, c15_.name AS name_196, c15_.placement AS placement_197, c15_.title AS title_198, c15_.description AS description_199, c15_.tier1maturin_fees_pc AS tier1maturin_fees_pc_200, c15_.tier2maturin_fees_pc AS tier2maturin_fees_pc_201, c15_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_202, c15_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_203, c15_.packing_fees_amount AS packing_fees_amount_204, c15_.packing_supplies_fees_amount AS packing_supplies_fees_amount_205, c15_.meta_description AS meta_description_206, c15_.is_displayed_for_buyer AS is_displayed_for_buyer_207, c16_.id AS id_208, c16_.name AS name_209, c16_.placement AS placement_210, c16_.title AS title_211, c16_.description AS description_212, c16_.tier1maturin_fees_pc AS tier1maturin_fees_pc_213, c16_.tier2maturin_fees_pc AS tier2maturin_fees_pc_214, c16_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_215, c16_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_216, c16_.packing_fees_amount AS packing_fees_amount_217, c16_.packing_supplies_fees_amount AS packing_supplies_fees_amount_218, c16_.meta_description AS meta_description_219, c16_.is_displayed_for_buyer AS is_displayed_for_buyer_220, c0_.sub_category_id AS sub_category_id_221, c0_.image_id AS image_id_222, c0_.banner_id AS banner_id_223, c1_.sub_category_id AS sub_category_id_224, c1_.image_id AS image_id_225, c1_.banner_id AS banner_id_226, c2_.sub_category_id AS sub_category_id_227, c2_.image_id AS image_id_228, c2_.banner_id AS banner_id_229, c3_.sub_category_id AS sub_category_id_230, c3_.image_id AS image_id_231, c3_.banner_id AS banner_id_232, c4_.sub_category_id AS sub_category_id_233, c4_.image_id AS image_id_234, c4_.banner_id AS banner_id_235, c5_.sub_category_id AS sub_category_id_236, c5_.image_id AS image_id_237, c5_.banner_id AS banner_id_238, c6_.sub_category_id AS sub_category_id_239, c6_.image_id AS image_id_240, c6_.banner_id AS banner_id_241, c7_.sub_category_id AS sub_category_id_242, c7_.image_id AS image_id_243, c7_.banner_id AS banner_id_244, c8_.sub_category_id AS sub_category_id_245, c8_.image_id AS image_id_246, c8_.banner_id AS banner_id_247, c9_.sub_category_id AS sub_category_id_248, c9_.image_id AS image_id_249, c9_.banner_id AS banner_id_250, c10_.sub_category_id AS sub_category_id_251, c10_.image_id AS image_id_252, c10_.banner_id AS banner_id_253, c11_.sub_category_id AS sub_category_id_254, c11_.image_id AS image_id_255, c11_.banner_id AS banner_id_256, c12_.sub_category_id AS sub_category_id_257, c12_.image_id AS image_id_258, c12_.banner_id AS banner_id_259, c13_.sub_category_id AS sub_category_id_260, c13_.image_id AS image_id_261, c13_.banner_id AS banner_id_262, c14_.sub_category_id AS sub_category_id_263, c14_.image_id AS image_id_264, c14_.banner_id AS banner_id_265, c15_.sub_category_id AS sub_category_id_266, c15_.image_id AS image_id_267, c15_.banner_id AS banner_id_268, c16_.sub_category_id AS sub_category_id_269, c16_.image_id AS image_id_270, c16_.banner_id AS banner_id_271 FROM category c0_ LEFT JOIN category c1_ ON c0_.sub_category_id = c1_.id LEFT JOIN category c2_ ON c1_.sub_category_id = c2_.id LEFT JOIN category c3_ ON c2_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN category c5_ ON c1_.id = c5_.sub_category_id LEFT JOIN category c6_ ON c5_.id = c6_.sub_category_id LEFT JOIN category c7_ ON c6_.id = c7_.sub_category_id LEFT JOIN category c8_ ON c7_.id = c8_.sub_category_id LEFT JOIN category c9_ ON c8_.id = c9_.sub_category_id LEFT JOIN category c10_ ON c0_.id = c10_.sub_category_id LEFT JOIN category c11_ ON c10_.id = c11_.sub_category_id LEFT JOIN category c12_ ON c11_.id = c12_.sub_category_id LEFT JOIN category c13_ ON c12_.id = c13_.sub_category_id LEFT JOIN category c14_ ON c13_.id = c14_.sub_category_id LEFT JOIN category c15_ ON c14_.id = c15_.sub_category_id LEFT JOIN category c16_ ON c10_.sub_category_id = c16_.id WHERE c0_.sub_category_id IS NULL ORDER BY c0_.placement ASC
Parameters:
[] |
|
2.05 ms (0.76%) |
1 |
SELECT p0_.id AS id_0, c1_.id AS id_1, (SELECT COUNT(*) FROM cart_product c2_ WHERE c2_.product_id = p0_.id) AS sclr_2, c3_.id AS id_3, c3_.placement AS placement_4, c3_.name AS name_5, c4_.placement AS placement_6, c4_.name AS name_7 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_id WHERE (p0_.categories_id = ? OR p0_.sub_category_id = ? OR p0_.sub_category_id IN (?)) AND p0_.draft <> 1 AND p0_.main_image_id IS NOT NULL AND p0_.available = 1 AND p0_.is_displayed_in_association_only = 0 AND c3_.placement > 0 AND c4_.placement > 0 AND p0_.is_hri = 0 AND p0_.is_consumer = 1 AND c1_.show_publicly = 1 AND p0_.qty_ready_to_ship > 0 AND c7_.url_name = ? ORDER BY p0_.creation_date DESC
Parameters:
[ 317 317 [ 90 326 ] "Brome-Missisquoi" ] |
|
1.60 ms (0.59%) |
2 |
SELECT p0_.id AS id_0, p0_.from_date AS from_date_1, p0_.to_date AS to_date_2, p0_.active AS active_3, p0_.is_in_modal AS is_in_modal_4, p0_.product_id AS product_id_5, p0_.custom_image_id AS custom_image_id_6 FROM product_sponsored p0_ WHERE p0_.active = 1 AND p0_.from_date <= ? AND p0_.to_date >= ? AND p0_.is_in_modal = 1 ORDER BY RAND() ASC LIMIT 15
Parameters:
[ "2025-08-02 13:01:32" "2025-08-02 13:01:32" ] |
|
1.42 ms (0.53%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"condiments et garnitures"
]
|
|
0.88 ms (0.33%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
317
]
|
|
0.67 ms (0.25%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.lang AS lang_3, t0.javascript AS javascript_4, t0.stylesheet AS stylesheet_5, t0.template AS template_6, t0.content AS content_7, t0.main_content AS main_content_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10 FROM omelo_page t0 WHERE t0.template = ?
Parameters:
[
"footer.html.twig"
]
|
|
0.59 ms (0.22%) |
1 |
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.id = ?
Parameters:
[
15950756
]
|
|
0.53 ms (0.20%) |
1 |
SELECT c0_.id AS id_0, c0_.placement AS placement_1, c0_.name AS name_2 FROM category c0_ WHERE c0_.sub_category_id = ? AND c0_.placement > 0 ORDER BY c0_.placement ASC
Parameters:
[
317
]
|
|
0.51 ms (0.19%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.quantity AS quantity_3, t0.is_shipped AS is_shipped_4, t0.price_paid_shipping AS price_paid_shipping_5, t0.price_paid_product AS price_paid_product_6, t0.has_combined_shipping AS has_combined_shipping_7, t0.pricings_used AS pricings_used_8, t0.carrier_name AS carrier_name_9, t0.carrier_trackings AS carrier_trackings_10, t0.for_invoicing_only AS for_invoicing_only_11, t0.is_recurring_one_time_only AS is_recurring_one_time_only_12, t0.recurring_frequency AS recurring_frequency_13, t0.overwrite_subscription AS overwrite_subscription_14, t0.qty_missing_in_shipment AS qty_missing_in_shipment_15, t0.cart_id AS cart_id_16, t0.product_id AS product_id_17, t0.pricing_id AS pricing_id_18, t0.company_delivery_method_id AS company_delivery_method_id_19, t0.custom_order_id AS custom_order_id_20, t0.maturin_order_id AS maturin_order_id_21, t0.invoicing_cart_id AS invoicing_cart_id_22, t0.added_when_being_in_association_id AS added_when_being_in_association_id_23 FROM cart_product t0 WHERE t0.cart_id = ?
Parameters:
[
15950756
]
|
|
0.37 ms (0.14%) |
1 |
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.province = ?
Parameters:
[
"Qc"
]
|
|
0.26 ms (0.10%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.name AS name_3, t0.url_name AS url_name_4, t0.description AS description_5, t0.logo_id AS logo_id_6, t0.banner_id AS banner_id_7 FROM company_association t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3
]
|
|
0.25 ms (0.09%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.maturin_fees_pc AS maturin_fees_pc_4, t0.packing_fees_amount AS packing_fees_amount_5, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_6 FROM conservation t0
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\Product | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\CompanyAssociation | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Variable | No errors. |
| App\Entity\CartProduct | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\CompanyLocation | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Conservation | No errors. |
| App\Entity\UserShippingLocation | No errors. |
| App\Entity\CartCoupon | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\FinancialLog | No errors. |
| App\Entity\CustomOrder | No errors. |
| App\Entity\MaturinOrder | No errors. |
| App\Entity\RecurringOrder | No errors. |
| App\Entity\Pricing | No errors. |
| App\Entity\DeliveryMethod | No errors. |
| App\Entity\OmeloPage | No errors. |
| App\Entity\ProductSponsored | No errors. |
| App\Entity\ProductSponsoredCategory | No errors. |