Query Metrics
641
Database Queries
14
Different statements
265.75 ms
Query time
0
Invalid entities
351
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.89 ms (80.11%) |
532 |
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 = ? LIMIT 1
Parameters:
[
3
]
|
||||||||||||||||||||||||||||
|
31.91 ms (12.01%) |
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 ] |
||||||||||||||||||||||||||||
|
6.30 ms (2.37%) |
9 |
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 = ? LIMIT 1
Parameters:
[
1260
]
|
||||||||||||||||||||||||||||
|
4.25 ms (1.60%) |
9 |
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:
[ 1260 1 ]
|
||||||||||||||||||||||||||||
|
2.19 ms (0.82%) |
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 INNER JOIN mg_products_mg_categories ON t0.id = mg_products_mg_categories.mg_products_id WHERE mg_products_mg_categories.mg_categories_id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||
|
1.72 ms (0.65%) |
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:
[] |
||||||||||||||||||||||||||||
|
1.48 ms (0.56%) |
1 |
SELECT m0_.id AS id_0, m0_.reference AS reference_1, m0_.purshasing_price AS purshasing_price_2, m0_.selling_price AS selling_price_3, m0_.selling_price_all_taxes AS selling_price_all_taxes_4, m0_.sales_unit AS sales_unit_5, m0_.min_quantity AS min_quantity_6, m0_.max_quantity AS max_quantity_7, m0_.bulk_quantity AS bulk_quantity_8, m0_.discount AS discount_9, m0_.discount_type AS discount_type_10, m0_.discount_on_taxe AS discount_on_taxe_11, m0_.stock_management AS stock_management_12, m0_.quantity AS quantity_13, m0_.sell_out_of_stock AS sell_out_of_stock_14, m0_.stock_alert AS stock_alert_15, m0_.pre_order AS pre_order_16, m0_.available_date AS available_date_17, m0_.date_publish AS date_publish_18, m0_.offline AS offline_19, m0_.type AS type_20, m0_.date_add AS date_add_21, m0_.date_up AS date_up_22, m0_.additionnal_shipping_cost AS additionnal_shipping_cost_23, m0_.width AS width_24, m0_.height AS height_25, m0_.depth AS depth_26, m0_.weight AS weight_27, m0_.name AS name_28, m0_.summary AS summary_29, m0_.slug AS slug_30, m0_.description AS description_31, m1_.id AS id_32, m1_.supplier_name AS supplier_name_33, m1_.supplier_address AS supplier_address_34, m1_.supplier_zipcode AS supplier_zipcode_35, m1_.supplier_town AS supplier_town_36, m1_.supplier_phone AS supplier_phone_37, m1_.supplier_email AS supplier_email_38, m1_.supplier_web AS supplier_web_39, m1_.supplier_logo AS supplier_logo_40, m1_.suppliers_notes AS suppliers_notes_41, m2_.id AS id_42, m2_.taxe_rate AS taxe_rate_43, m2_.taxe_active AS taxe_active_44, m0_.supplier_id AS supplier_id_45, m0_.gamme_id AS gamme_id_46, m0_.carrier_id AS carrier_id_47, m0_.parent_id AS parent_id_48, m0_.taxe_id AS taxe_id_49 FROM mg_products m0_ LEFT JOIN mg_suppliers m1_ ON m0_.supplier_id = m1_.id INNER JOIN mg_taxes m2_ ON m0_.taxe_id = m2_.id WHERE m0_.offline = 0 AND m0_.date_publish <= ? AND m0_.id IN (303, 312, 335, 336, 342, 814, 874, 875, 1168, 1240, 1241, 1243, 1244, 1245, 1255, 1256, 1257, 1258, 1259, 1260, 1802, 1817, 1818, 1819) ORDER BY m0_.selling_price_all_taxes ASC
Parameters:
[
"2025-12-15 03:41:34"
]
|
||||||||||||||||||||||||||||
|
1.16 ms (0.44%) |
1 |
SELECT m0_.id AS id_0, m0_.reference AS reference_1, m0_.purshasing_price AS purshasing_price_2, m0_.selling_price AS selling_price_3, m0_.selling_price_all_taxes AS selling_price_all_taxes_4, m0_.sales_unit AS sales_unit_5, m0_.min_quantity AS min_quantity_6, m0_.max_quantity AS max_quantity_7, m0_.bulk_quantity AS bulk_quantity_8, m0_.discount AS discount_9, m0_.discount_type AS discount_type_10, m0_.discount_on_taxe AS discount_on_taxe_11, m0_.stock_management AS stock_management_12, m0_.quantity AS quantity_13, m0_.sell_out_of_stock AS sell_out_of_stock_14, m0_.stock_alert AS stock_alert_15, m0_.pre_order AS pre_order_16, m0_.available_date AS available_date_17, m0_.date_publish AS date_publish_18, m0_.offline AS offline_19, m0_.type AS type_20, m0_.date_add AS date_add_21, m0_.date_up AS date_up_22, m0_.additionnal_shipping_cost AS additionnal_shipping_cost_23, m0_.width AS width_24, m0_.height AS height_25, m0_.depth AS depth_26, m0_.weight AS weight_27, m0_.name AS name_28, m0_.summary AS summary_29, m0_.slug AS slug_30, m0_.description AS description_31, m1_.id AS id_32, m1_.supplier_name AS supplier_name_33, m1_.supplier_address AS supplier_address_34, m1_.supplier_zipcode AS supplier_zipcode_35, m1_.supplier_town AS supplier_town_36, m1_.supplier_phone AS supplier_phone_37, m1_.supplier_email AS supplier_email_38, m1_.supplier_web AS supplier_web_39, m1_.supplier_logo AS supplier_logo_40, m1_.suppliers_notes AS suppliers_notes_41, m2_.id AS id_42, m2_.taxe_rate AS taxe_rate_43, m2_.taxe_active AS taxe_active_44, m0_.supplier_id AS supplier_id_45, m0_.gamme_id AS gamme_id_46, m0_.carrier_id AS carrier_id_47, m0_.parent_id AS parent_id_48, m0_.taxe_id AS taxe_id_49 FROM mg_products m0_ LEFT JOIN mg_suppliers m1_ ON m0_.supplier_id = m1_.id INNER JOIN mg_taxes m2_ ON m0_.taxe_id = m2_.id WHERE m0_.offline = 0 AND m0_.date_publish <= ? AND m0_.id IN (303, 312, 335, 336, 342, 814, 874, 875, 1168, 1240, 1241, 1243, 1244, 1245, 1255, 1256, 1257, 1258, 1259, 1260, 1802, 1817, 1818, 1819) ORDER BY m0_.selling_price_all_taxes ASC LIMIT 12 OFFSET 12
Parameters:
[
"2025-12-15 03:41:34"
]
|
||||||||||||||||||||||||||||
|
1.13 ms (0.43%) |
1 |
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.type = ?
Parameters:
[
"product"
]
|
||||||||||||||||||||||||||||
|
0.78 ms (0.30%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"Amplificateurs"
]
|
||||||||||||||||||||||||||||
|
0.56 ms (0.21%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.48 ms (0.18%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.position AS position_3, t0.name AS name_4, t0.slug AS slug_5 FROM mg_properties t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.46 ms (0.17%) |
1 |
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.type = ? AND t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[ "product" 3 ]
|
||||||||||||||||||||||||||||
|
0.42 ms (0.16%) |
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
]
|
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 | 266 |
| App\Entity\MgSuppliers | 47 |
| App\Entity\MgProducts | 24 |
| App\Entity\MgProductsImages | 9 |
| App\Entity\MgProperties | 2 |
| App\Entity\MgCarriers | 1 |
| App\Entity\MgTaxes | 1 |
| App\Entity\MgParameters | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\MgCategories | No errors. |
| App\Entity\MgPosts | No errors. |
| App\Entity\MgProducts | No errors. |
| App\Entity\MgSuppliers | No errors. |
| App\Entity\MgGammes | No errors. |
| App\Entity\MgCarriers | No errors. |
| App\Entity\MgTaxes | No errors. |
| App\Entity\MgProductsImages | No errors. |
| App\Entity\MgProductsNumerical | No errors. |
| App\Entity\MgPropertiesContents | No errors. |
| App\Entity\MgMovementsStocks | No errors. |
| App\Entity\MgAuthors | No errors. |
| App\Entity\MgOrdersContent | No errors. |
| App\Entity\MgUsers | No errors. |
| App\Entity\MgTaxesLang | No errors. |
| App\Entity\MgCarriersConfig | No errors. |
| App\Entity\MgOrdersTaxes | No errors. |
| App\Entity\MgProperties | No errors. |
| App\Entity\MgParameters | No errors. |
| App\Entity\MgPostsLang | No errors. |
| App\Entity\MgOrdersCarriers | No errors. |
| App\Entity\MgOrders | No errors. |
| App\Entity\MgGenders | No errors. |
| App\Entity\MgCustomers | No errors. |
| App\Entity\MgLanguages | No errors. |
| App\Entity\MgCarriersSteps | No errors. |
| App\Entity\MgCarriersAmount | No errors. |