Query Metrics
9
Database Queries
6
Different statements
13.62 ms
Query time
0
Invalid entities
2763
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.19 ms (74.84%) |
2 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = ?
Parameters:
[
"front"
]
|
|
1.21 ms (8.87%) |
1 |
SELECT c0_.id AS id_0 FROM chronique c1_ LEFT JOIN contact c0_ ON c1_.contact_id = c0_.id WHERE c0_.id IS NOT NULL GROUP BY c0_.id
Parameters:
[] |
|
0.73 ms (5.37%) |
2 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = ? AND t0.is_actif = ?
Parameters:
[ "front_metier" 1 ] |
|
0.65 ms (4.79%) |
2 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_electre AS nom_electre_3, t0.couleur AS couleur_4, t0.ordre AS ordre_5, t0.slug AS slug_6, t0.old_id AS old_id_7, t0.color1 AS color1_8, t0.color2 AS color2_9, t0.parent_id AS parent_id_10 FROM genre t0 ORDER BY t0.ordre ASC
Parameters:
[] |
|
0.50 ms (3.69%) |
1 |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.prenom AS prenom_2, c0_.telephone AS telephone_3, c0_.code_abomarque AS code_abomarque_4, c0_.commentaire AS commentaire_5, c0_.facebook AS facebook_6, c0_.twitter AS twitter_7, c0_.email AS email_8, c0_.old_id AS old_id_9, c0_.civilite AS civilite_10, c0_.old_userid AS old_userid_11, c0_.actif AS actif_12, c0_.bio AS bio_13, c0_.has_photo AS has_photo_14, c0_.is_referent AS is_referent_15, c0_.date_creation AS date_creation_16, c0_.receive_nmardi AS receive_nmardi_17, c0_.receive_nvendredi AS receive_nvendredi_18, c0_.receive_ireseau AS receive_ireseau_19, c0_.structure_id AS structure_id_20, c0_.adresse_id AS adresse_id_21, c0_.utilisateur_id AS utilisateur_id_22, c0_.news_contact_id AS news_contact_id_23 FROM contact c0_ LEFT JOIN chronique c1_ ON c0_.id = c1_.contact_id LEFT JOIN vie_libraire v2_ ON c0_.id = v2_.contact_id WHERE c0_.id IN (11, 12, 14, 35, 46, 47, 48, 51, 60, 62, 66, 69, 70, 75, 82, 86, 89, 93, 94, 95, 101, 108, 109, 113, 114, 120, 129, 130, 135, 136, 140, 144, 146, 148, 153, 154, 157, 164, 165, 176, 178, 179, 180, 182, 184, 185, 186, 189, 190, 191, 194, 199, 201, 208, 209, 210, 211, 212, 215, 219, 221, 222, 223, 224, 226, 227, 228, 229, 232, 233, 241, 250, 251, 252, 254, 260, 264, 265, 267, 270, 275, 277, 284, 285, 286, 291, 298, 299, 300, 301, 302, 303, 304, 305, 309, 311, 312, 318, 321, 324, 327, 328, 329, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 350, 355, 359, 365, 366, 374, 381, 382, 383, 388, 389, 390, 391, 396, 401, 407, 413, 414, 417, 420, 421, 426, 430, 432, 434, 436, 437, 438, 444, 445, 447, 453, 454, 460, 463, 465, 469, 475, 476, 484, 485, 489, 490, 492, 495, 496, 498, 499, 507, 516, 518, 522, 525, 527, 528, 530, 539, 547, 550, 551, 553, 558, 562, 564, 565, 571, 572, 573, 574, 587, 596, 598, 601, 604, 605, 606, 613, 622, 633, 639, 648, 672, 674, 676, 677, 679, 682, 684, 685, 686, 708, 828, 869, 902, 976, 1065, 1069, 1086, 1087, 1088, 1094, 1095, 1098, 1099, 1112, 1114, 1117, 1123, 1124, 1125, 1126, 1127, 1130, 1134, 1136, 1142, 1145, 1157, 1158, 1159, 1177, 1192, 1193, 1200, 1201, 1205, 1206, 1207, 1210, 1211, 1218, 1225, 1228, 1262, 1264, 1270, 1271, 1272, 1273, 1275, 1276, 1277, 1285, 1300, 1319, 1395, 1408, 1411, 1417, 1420, 1422, 1528, 1543, 1544, 1581, 1587, 1593, 1595, 1597, 1609, 1610, 1611, 1612, 1613, 1614, 1615, 1617, 1634, 1637, 1638, 1639, 1642, 1643, 1646, 1647, 1668, 1684, 1685, 1699, 1700, 1715, 1730, 1731, 1735, 1736, 1740, 1742, 1743, 1774, 1777, 1780, 1781, 1793, 1794, 1796, 1798, 1799, 1800, 1802, 1803, 1805, 1810, 1811, 1812, 1813, 1818, 1821, 1823, 1825, 1831, 1832, 1833, 1840, 1855, 1860, 1863, 1878, 1882, 1889, 1896, 1905, 1911, 1913, 1914, 1934, 1939, 1940, 1949, 1950, 1963, 1966, 1968, 2006, 2023, 2049, 2051, 2052, 2057, 2065, 2066, 2067, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2083, 2091, 2092, 2098, 2099, 2120, 2137, 2145, 2150, 2151, 2156, 2161, 2162, 2175, 2185, 2201, 2209, 2213, 2217, 2218, 2224, 2225, 2226, 2231, 2238, 2249, 2250, 2252, 2254, 2257, 2267, 2271, 2281, 2282, 2286, 2287, 2289, 2292, 2302, 2304, 2315, 2369, 2385, 2418, 2419, 2422, 2441, 2777, 2779, 2808, 2816, 2825, 2827, 2830, 2835, 2840, 2842, 2855, 2856, 2864, 2867, 2869, 2871, 2876, 2885, 2888, 2890, 2891, 2895, 2900, 2905, 2906, 2907, 2912, 2915, 2919, 2931, 2932, 2939, 2940, 2941, 2943, 2954, 2960, 2966, 2980, 2991, 2992, 2998, 3010, 3051, 3060, 3081, 3083, 3158, 3218, 3263, 3264, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3287, 3291, 3292, 3294, 3296, 3310, 3311, 3312, 3313, 3314, 3327, 3333, 3334, 3344, 3359, 3360, 3361, 3362, 3372, 3376, 3379, 3384, 3398, 3399, 3405, 3409, 3410, 3411, 3412, 3413, 3415, 3445, 3453, 3482, 3526, 3537, 3642, 3644, 3661, 3667, 3668, 3687, 3694, 3701, 3702, 3705, 3707, 3709, 3710, 3718, 3719, 3726, 3729, 3747, 3753, 3755, 3756, 3759, 3760, 3762, 3763, 3764, 3765, 3767, 3768, 3778, 3788, 3792, 3795, 3797, 3833, 3837, 3843, 3879, 3922, 3938, 3965, 3972, 3976, 3983, 4005, 4007, 4030, 4089, 4128, 4141, 4182, 4183, 4185, 4192, 4193, 4194, 4195, 4200, 4202, 4204, 4205, 4207, 4228, 4232, 4235, 4237, 4239, 4242, 4243, 4252, 4254, 4255, 4257, 4258, 4260, 4277, 4294, 4295, 4327, 4364, 4369, 4382, 4389, 4391, 4422, 4440, 4441, 4471, 4474, 4475, 4476, 4626, 4666, 4667, 4668, 4676, 4684, 4686, 4692, 4694, 4697, 4698, 4701, 4713, 4714, 4716, 4717, 4718, 4719, 4721, 4722, 4723, 4724, 4725, 4731, 4732, 4734, 4788, 4791, 4802, 4812, 4813, 4875, 4876, 4877, 4882, 4888, 4892, 4923, 4929, 4999, 5009, 5019, 5021, 5022, 5028, 5029, 5031, 5035, 5042, 5044, 5067, 5098, 5102, 5103, 5104, 5110, 5112, 5113, 5131, 5144, 5145, 5148, 5150, 5152, 5153, 5162, 5165, 5166, 5167, 5172, 5210, 5255, 5260, 5270, 5274, 5302, 5327, 5335, 5336, 5347, 5379, 5393, 5394, 5396, 5397, 5398, 5401, 5402, 5417, 5418, 5419, 5421, 5422, 5424, 5431, 5432, 5437, 5438, 5439, 5441, 5442, 5448, 5449, 5451, 5452, 5453, 5464, 5466, 5480, 5483, 5486, 5487, 5498, 5540, 5549, 5557, 5567, 5571, 5586, 5602, 5614, 5620, 5704, 5705, 5713, 5773, 5785, 5808, 5809, 5813, 5827, 5830, 5840, 5853, 5854, 5858, 5859, 5864, 5868, 5871, 5876, 5878, 5881, 5887, 5889, 5909, 5915, 5919, 5938, 5939, 5940, 5941, 5942, 5945, 5959, 5979, 5980, 6003, 6005, 6006, 6017, 6019, 6045, 6047, 6057, 6058, 6075, 6081, 6085, 6106, 6108, 6112, 6121, 6124, 6127, 6128, 6156, 6164, 6171, 6204, 6275, 6280, 6299, 6321, 6322, 6323, 6327, 6335, 6336, 6338, 6344, 6367, 6376, 6427, 6428, 6437, 6439, 6446, 6460, 6467, 6470, 6477, 6486, 6490, 6503, 6513, 6535, 6590, 6615, 6623, 6740, 6742, 6788, 6813, 6814, 6816, 6819, 6825, 6831, 6861, 6969, 7050, 7224, 7286, 7294, 7295, 7298, 7337, 7343, 7344, 7345, 7365, 7388, 7390, 7431, 7432, 7440, 7593, 7673, 7755, 7935, 7975, 7989, 7995, 8011, 8012, 8019, 8065, 8085, 8110, 8186, 8311, 8368, 8669, 8670) GROUP BY c0_.id ORDER BY count(v2_.id) DESC, count(c1_.id) DESC
Parameters:
[] |
|
0.33 ms (2.45%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.code AS code_4, t0.est_publie AS est_publie_5, t0.est_metier AS est_metier_6 FROM front_page t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"list-libraire"
]
|
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\Contact | 859 |
| App\Entity\NewsContact | 599 |
| App\Entity\User | 598 |
| App\Entity\Structure | 454 |
| App\Entity\Page | 227 |
| App\Entity\Adresse | 17 |
| App\Entity\Genre | 8 |
| App\Entity\FrontPage | 1 |