GET https://www.cms-morgane.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CSearchController%253A%253Asearch

Response
200 OK
IP
216.73.216.174
Profiled on
Token
441a01

Query Metrics

565 Database Queries
12 Different statements
237.64 ms Query time
0 Invalid entities
624 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
197.50 ms
(83.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: 
[
  21
]
View formatted query    View runnable query    Explain query    View query backtrace
9.34 ms
(3.93%) 		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 (14, 24, 25, 29, 46, 47, 48, 49, 55, 78, 80, 82, 83, 84, 85, 86, 88, 89, 90, 93, 95, 106, 107, 139, 167, 175, 176, 178, 179, 180, 281, 282, 294, 296, 297, 298, 299, 307, 313, 318, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 337, 338, 339, 340, 341, 344, 353, 354, 356, 421, 422, 424, 425, 426, 427, 428, 429, 430, 431, 432, 436, 437, 438, 439, 440, 441, 442, 443, 445, 450, 458, 500, 628, 664, 665, 666, 667, 668, 669, 670, 671, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 716, 717, 719, 720, 728, 816, 876, 877, 878, 911, 912, 926, 927, 942, 943, 948, 949, 951, 952, 953, 954, 955, 1072, 1077, 1084, 1094, 1160, 1163, 1164, 1191, 1212, 1213, 1214, 1216, 1217, 1218, 1220, 1221, 1227, 1230, 1231, 1232, 1233, 1234, 1237, 1239, 1242, 1252, 1253, 1254, 1264, 1265, 1269, 1270, 1310, 1615, 1618, 1619, 1620, 1708, 1709, 1713, 1736, 1737, 1738, 1739, 1740, 1741, 1742, 1743, 1744, 1745, 1746, 1778, 1806, 1807, 1811, 1812, 1813, 1814, 1815, 1816, 1820, 1825, 1826, 1863, 1864, 1865, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1908, 1909, 1910, 1914, 1915, 1916, 1917, 1918, 1919, 1920, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1947, 1948, 1949, 1960, 1961, 1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1976, 1977, 1978, 2037, 2038, 2053, 2054, 2079, 2080, 2081, 2082) ORDER BY m0_.selling_price_all_taxes ASC
Parameters: 
[
  "2025-12-17 04:50:44"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.28 ms
(3.91%) 		12 
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: 
[
  282
]
View formatted query    View runnable query    Explain query    View query backtrace
6.48 ms
(2.73%) 		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: 
[
  21
]
View formatted query    View runnable query    Explain query    View query backtrace
5.86 ms
(2.47%) 		12 
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: 
[
  282
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2.84 ms
(1.19%) 		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 (14, 24, 25, 29, 46, 47, 48, 49, 55, 78, 80, 82, 83, 84, 85, 86, 88, 89, 90, 93, 95, 106, 107, 139, 167, 175, 176, 178, 179, 180, 281, 282, 294, 296, 297, 298, 299, 307, 313, 318, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 337, 338, 339, 340, 341, 344, 353, 354, 356, 421, 422, 424, 425, 426, 427, 428, 429, 430, 431, 432, 436, 437, 438, 439, 440, 441, 442, 443, 445, 450, 458, 500, 628, 664, 665, 666, 667, 668, 669, 670, 671, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 716, 717, 719, 720, 728, 816, 876, 877, 878, 911, 912, 926, 927, 942, 943, 948, 949, 951, 952, 953, 954, 955, 1072, 1077, 1084, 1094, 1160, 1163, 1164, 1191, 1212, 1213, 1214, 1216, 1217, 1218, 1220, 1221, 1227, 1230, 1231, 1232, 1233, 1234, 1237, 1239, 1242, 1252, 1253, 1254, 1264, 1265, 1269, 1270, 1310, 1615, 1618, 1619, 1620, 1708, 1709, 1713, 1736, 1737, 1738, 1739, 1740, 1741, 1742, 1743, 1744, 1745, 1746, 1778, 1806, 1807, 1811, 1812, 1813, 1814, 1815, 1816, 1820, 1825, 1826, 1863, 1864, 1865, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1908, 1909, 1910, 1914, 1915, 1916, 1917, 1918, 1919, 1920, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1947, 1948, 1949, 1960, 1961, 1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1976, 1977, 1978, 2037, 2038, 2053, 2054, 2079, 2080, 2081, 2082) ORDER BY m0_.selling_price_all_taxes ASC LIMIT 12 OFFSET 12
Parameters: 
[
  "2025-12-17 04:50:44"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.00 ms
(0.84%) 		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: 
[
  "Enceintes-et-accessoires"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.12 ms
(0.47%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(0.44%) 		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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(0.37%) 		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"
  21
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(0.29%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(0.25%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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 292
App\Entity\MgCategories 266
App\Entity\MgSuppliers 47
App\Entity\MgProductsImages 12
App\Entity\MgGammes 2
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.