Query Metrics

14 Database Queries
3 Different statements
11.64 ms Query time
0 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 3.12 ms
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_ INNER 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_.type = ? AND m0_.gamme_id IS NOT NULL ORDER BY m0_.date_publish DESC LIMIT 12
Parameters:
[
  "2025-12-15 01:33:40"
  "master"
]
2 0.67 ms
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:
[
  1994
  1
]
3 0.43 ms
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:
[
  1990
  1
]
4 1.07 ms
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:
[
  1813
  1
]
5 0.75 ms
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:
[
  1778
  1
]
6 0.55 ms
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:
[
  1499
  1
]
7 0.54 ms
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:
[
  1292
  1
]
8 0.53 ms
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:
[
  1274
  1
]
9 0.52 ms
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:
[
  1207
  1
]
10 0.73 ms
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:
[
  1187
  1
]
11 0.65 ms
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:
[
  1186
  1
]
12 0.75 ms
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:
[
  818
  1
]
13 0.67 ms
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:
[
  452
  1
]
14 0.64 ms
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\MgProducts 12
App\Entity\MgProductsImages 12
App\Entity\MgSuppliers 7
App\Entity\MgGammes 3
App\Entity\MgCarriers 1
App\Entity\MgTaxes 1
App\Entity\MgParameters 1