GET https://www.cms-morgane.fr/p/CONCORDE-MKII-TWIN-SCRATCH

Query Metrics

93 Database Queries
12 Different statements
33.76 ms Query time
0 Invalid entities
94 Managed entities

Grouped Statements

Show all queries

Time Count Info
22.29 ms
(66.03%)
81
SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.id = ? AND t0.active = ?
Parameters:
[
  2
  1
]
5.20 ms
(15.40%)
1
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "CONCORDE-MKII-TWIN-SCRATCH"
]
1.13 ms
(3.34%)
1
SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = ? AND t0.cover = ? LIMIT 1
Parameters:
[
  2071
  1
]
1.05 ms
(3.12%)
1
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.active AS active_2, m0_.force_display AS force_display_3, m0_.type AS type_4, m0_.date_add AS date_add_5, m0_.date_up AS date_up_6, m0_.level AS level_7, m0_.name AS name_8, m0_.description AS description_9, m0_.slug AS slug_10, m0_.parent_id AS parent_id_11 FROM mg_categories m0_ WHERE m0_.active = 1 AND m0_.id <> 1 AND m0_.level < 3 ORDER BY m0_.position ASC
Parameters:
[]
0.97 ms
(2.86%)
1
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.parent_id = ? AND t0.offline = ? LIMIT 1
Parameters:
[
  2071
  0
]
0.70 ms
(2.07%)
2
SELECT t0.id AS id_1, t0.address_title AS address_title_2, t0.parameter_address_id AS parameter_address_id_3, t0.lang_id AS lang_id_4 FROM mg_parameters_addresses_title t0 WHERE t0.parameter_address_id = ?
Parameters:
[
  1
]
0.58 ms
(1.71%)
1
SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = ? AND t0.cover = ?
Parameters:
[
  2071
  0
]
0.49 ms
(1.46%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.40 ms
(1.18%)
1
SELECT t0.id AS id_1, t0.supplier_name AS supplier_name_2, t0.supplier_address AS supplier_address_3, t0.supplier_zipcode AS supplier_zipcode_4, t0.supplier_town AS supplier_town_5, t0.supplier_phone AS supplier_phone_6, t0.supplier_email AS supplier_email_7, t0.supplier_web AS supplier_web_8, t0.supplier_logo AS supplier_logo_9, t0.suppliers_notes AS suppliers_notes_10 FROM mg_suppliers t0 WHERE t0.id = ?
Parameters:
[
  36
]
0.36 ms
(1.07%)
1
SELECT t0.id AS id_1, t0.value AS value_2, t0.property_id AS property_id_3, t4.id AS id_5, t4.type AS type_6, t4.position AS position_7, t4.name AS name_8, t4.slug AS slug_9, t0.product_id AS product_id_10 FROM mg_properties_contents t0 INNER JOIN mg_properties t4 ON t0.property_id = t4.id WHERE t0.product_id = ?
Parameters:
[
  2071
]
0.33 ms
(0.97%)
1
SELECT t0.id AS id_1, t0.address AS address_2, t0.zipcode AS zipcode_3, t0.town AS town_4, t0.phone AS phone_5, t0.mobile AS mobile_6, t0.email AS email_7, t0.map AS map_8, t0.opening_time AS opening_time_9 FROM mg_parameters_addresses t0
Parameters:
[]
0.27 ms
(0.81%)
1
SELECT t0.id AS id_1, t0.taxe_rate AS taxe_rate_2, t0.taxe_active AS taxe_active_3 FROM mg_taxes t0 WHERE t0.id = ?
Parameters:
[
  3
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MgCategories 82
App\Entity\MgProductsImages 2
App\Entity\MgParametersAddresses 2
App\Entity\MgParametersAddressesTitle 2
App\Entity\MgProducts 1
App\Entity\MgSuppliers 1
App\Entity\MgCarriers 1
App\Entity\MgTaxes 1
App\Entity\MgParameters 1
App\Entity\MgLanguages 1