Query Metrics
10
Database Queries
7
Different statements
33.11 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.31 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"VV"
]
|
| 2 | 29.70 ms |
SELECT p0_.products_id AS products_id_0, p0_.products_quantity AS products_quantity_1, p0_.products_model AS products_model_2, p0_.products_model_sap AS products_model_sap_3, p0_.products_ean AS products_ean_4, p0_.products_image AS products_image_5, p0_.products_image_med AS products_image_med_6, p0_.products_image_lrg AS products_image_lrg_7, p0_.products_image_sm_1 AS products_image_sm_1_8, p0_.products_image_xl_1 AS products_image_xl_1_9, p0_.products_image_sm_2 AS products_image_sm_2_10, p0_.products_image_xl_2 AS products_image_xl_2_11, p0_.products_image_sm_3 AS products_image_sm_3_12, p0_.products_image_xl_3 AS products_image_xl_3_13, p0_.products_image_sm_4 AS products_image_sm_4_14, p0_.products_image_xl_4 AS products_image_xl_4_15, p0_.products_image_sm_5 AS products_image_sm_5_16, p0_.products_image_xl_5 AS products_image_xl_5_17, p0_.products_image_sm_6 AS products_image_sm_6_18, p0_.products_image_xl_6 AS products_image_xl_6_19, p0_.products_price AS products_price_20, p0_.products_ecotax AS products_ecotax_21, p0_.products_date_added AS products_date_added_22, p0_.products_last_modified AS products_last_modified_23, p0_.products_date_available AS products_date_available_24, p0_.products_weight AS products_weight_25, p0_.products_status AS products_status_26, p0_.products_ordered AS products_ordered_27, p0_.products_price1 AS products_price1_28, p0_.products_price2 AS products_price2_29, p0_.products_price3 AS products_price3_30, p0_.products_price4 AS products_price4_31, p0_.products_price5 AS products_price5_32, p0_.products_price6 AS products_price6_33, p0_.products_price7 AS products_price7_34, p0_.products_price8 AS products_price8_35, p0_.products_price9 AS products_price9_36, p0_.products_price10 AS products_price10_37, p0_.products_price11 AS products_price11_38, p0_.products_price1_qty AS products_price1_qty_39, p0_.products_price2_qty AS products_price2_qty_40, p0_.products_price3_qty AS products_price3_qty_41, p0_.products_price4_qty AS products_price4_qty_42, p0_.products_price5_qty AS products_price5_qty_43, p0_.products_price6_qty AS products_price6_qty_44, p0_.products_price7_qty AS products_price7_qty_45, p0_.products_price8_qty AS products_price8_qty_46, p0_.products_price9_qty AS products_price9_qty_47, p0_.products_price10_qty AS products_price10_qty_48, p0_.products_price11_qty AS products_price11_qty_49, p0_.products_qty_blocks AS products_qty_blocks_50, p0_.products_soleil AS products_soleil_51, p0_.products_limite_panier AS products_limite_panier_52, p0_.products_page AS products_page_53, p0_.products_garantie AS products_garantie_54, p0_.products_cat AS products_cat_55, p0_.products_index AS products_index_56, p0_.products_mvente AS products_mvente_57, p0_.products_strategique AS products_strategique_58, p0_.products_reappro_non AS products_reappro_non_59, p0_.products_multiple AS products_multiple_60, p0_.products_origin AS products_origin_61, p0_.products_gift AS products_gift_62, p0_.products_type AS products_type_63, p0_.products_welcome AS products_welcome_64, p0_.products_parent_id AS products_parent_id_65, p0_.manufacturers_id AS manufacturers_id_66, p0_.products_tax_class_id AS products_tax_class_id_67 FROM products p0_ WHERE p0_.products_status = 1 AND p0_.products_gift = 1
Parameters:
[] |
| 3 | 0.25 ms |
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
1068
]
|
| 4 | 0.16 ms |
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
468
]
|
| 5 | 0.27 ms |
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id IN (NULL) AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters:
[ "2025-12-06 07:22:06" "2025-12-06 07:22:06" ] |
| 6 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 0.34 ms |
INSERT INTO carts (shipping_infos, COMMENT, created_at, updated_at, customer_id, price_group_id, shipping_address_id, billing_address_id, carrier_id, payment_mean_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null "2025-12-06 07:22:06" null null 1 null null null null ] |
| 8 | 1.48 ms |
"COMMIT"
Parameters:
[] |
| 9 | 0.33 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"VV"
]
|
| 10 | 0.16 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"VV"
]
|
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\PriceGroup | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Manufacturer | No errors. |
| App\Entity\TaxClass | No errors. |
| App\Entity\ProductAttribute | No errors. |
| App\Entity\ProductDescription | No errors. |
| App\Entity\Picture | No errors. |
| App\Entity\PictureProduct | No errors. |
| App\Entity\ProductCountryRestriction | No errors. |
| App\Entity\ProductToProductExtraField | No errors. |
| App\Entity\ProductPrice | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\CategoryDescription | No errors. |
| App\Entity\CategoryToExtraField | No errors. |
| App\Entity\PictureCategory | No errors. |
| App\Entity\MarketingRule | No errors. |
| App\Entity\MarketingRuleProductDiscounted | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\CartItem | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Carrier | No errors. |
| App\Entity\PaymentMean | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\CustomerGroup | No errors. |
| App\Entity\ManufacturerDescription | No errors. |
| App\Entity\ManufacturerCountry | No errors. |
| App\Entity\TaxRate | No errors. |
| App\Entity\ProductOption | No errors. |
| App\Entity\ProductOptionValue | No errors. |
| App\Entity\PictureDescription | No errors. |
| App\Entity\ProductExtraField | No errors. |
| App\Entity\MarketingRuleDescription | No errors. |
| App\Entity\MarketingRuleProductRequested | No errors. |
| App\Entity\Coupon | No errors. |
| App\Entity\MarketingRuleCustomer | No errors. |
| App\Entity\CustomerPriceGroup | No errors. |