Query Metrics
87
Database Queries
7
Different statements
45.23 ms
Query time
0
Invalid entities
91
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
38.32 ms (84.71%) |
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 ] |
||||||||||||||||||||||
|
3.71 ms (8.21%) |
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:
[
"XONE-43C"
]
|
||||||||||||||||||||||
|
1.22 ms (2.70%) |
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.61 ms (1.36%) |
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:
[ 1773 0 ]
|
||||||||||||||||||||||
|
0.55 ms (1.20%) |
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:
[ 1773 1 ]
|
||||||||||||||||||||||
|
0.44 ms (0.98%) |
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:
[ 1773 0 ]
|
||||||||||||||||||||||
|
0.38 ms (0.83%) |
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 | 82 |
| App\Entity\MgProductsImages | 4 |
| App\Entity\MgProducts | 1 |
| App\Entity\MgSuppliers | 1 |
| App\Entity\MgCarriers | 1 |
| App\Entity\MgTaxes | 1 |
| App\Entity\MgParameters | 1 |
Entities Mapping
| Class | Mapping 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\MgCategories | No errors. |
| App\Entity\MgParameters | No errors. |
| App\Entity\MgCarriersConfig | No errors. |
| App\Entity\MgOrdersCarriers | No errors. |
| App\Entity\MgTaxesLang | No errors. |
| App\Entity\MgOrdersTaxes | No errors. |
| App\Entity\MgProperties | No errors. |
| App\Entity\MgOrders | No errors. |
| App\Entity\MgGenders | No errors. |
| App\Entity\MgCustomers | No errors. |
| App\Entity\MgPosts | No errors. |
| App\Entity\MgPostsLang | No errors. |