https://preprod.theatre-contemporain.net/educ/spectacles/type/prochains/area?idtypestructure=SN&path=educ%2Fspectacles%2Ftype%2Fprochains%2Farea%2F

Method
GET
HTTP Status
200
IP
3.145.17.46
Profiled on
Token
2e7763

Query Metrics

7 Database Queries
7 Different statements
456.10 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 51.41 ms 
SELECT s.`idspectacle` FROM spectacles s
                    JOIN object_content oc  ON oc.`idobject`=s.`idspectacle`
                    JOIN contents c ON c.`idcontent`=oc.`idcontent`
                    JOIN content_classification cc ON cc.`idcontent`=c.`idcontent`
                WHERE c.publish=1
                    AND oc.object='spectacles'
                    AND cc.idclassification=125
                    AND s.`publish`=1 AND s.`valid`=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 373.47 ms 
SELECT schedules.`date`, YEAR(schedules.`date`) as annee
                FROM schedules, spectacles
                WHERE schedules.`idspectacle`=spectacles.`idspectacle`
                AND spectacles.`publish`=1
                AND schedules.`idspectacle` IN (2840,4074,378,3033,3441,4073,4057,4055,4010,3536,4279,4396,3301,2822,3993,4546,4491,4493,4488,4541,4357,4524,5082,4855,4596,3960,5103,5022,6906,7021,6154,6068,6251,5530,7164,5470,7717,6456,5140,7683,8074,2168,8229,8326,5303,5119,7673,9007,8245,1778,9477,11,6561,4281,9034,8193,2884,1783,5379,8331,9887,8355,8828,8515,8375,5149,8336,8100,8415,9329,9333,8102,7713,7450,7429,7298,7251,6702,7038,7094,6994,5896,5310,5407,5615,5229,6023,5099,7656,4713,4280,4221,4320,3577,4209,4061,4070,3704,3816,3896,3700,4322,3210,3809,3712,3601,3788,3795,3198,2767,849,3543,3706,3581,3464,3653,3589,3484,3485,3486,3482,3466,3747,3260,2468,1753,36,2819,2872,2590,2575,2403,2427,2270,1773,1315,1139,3,896,2139,678,1765,748,8507,9252,1073,8559,5092,6316,8248,8431,10479,9843,7416,9733,10449,10347,2163,10345,10536,10548,10565,10574,10580,9727,7576,5206,10772,8421,10866,9522,9521,7333,9884,6195,6424,10870,8250,10710,3774,3773,3772,10918,4235,10919,10921,10929,10930,4870,5194,10931,4072,10932,10935,10939,10940,2283,10299,10945,10949,10950,5361,10952,10953,10955,10956,10974,10976,10980,10981,10982,10984,10986,3034,10990,10991,10999,11003,11004,5369,11015,11025,11027,2173,3241,10865,4542,9561,5426,9917,6631,11164,5710,9269,9200,8572,7502,9474,10300,10425,8374,10429,4485,4532,4528,6660,3790,2831,6168,3781,10150,11465,11502,10751,8084,6916,7609,11761,9881,12334,12943,8388,4673,7418,8608,3903,13092,12507,6922,12524,11859,12127,8358,11572,11570,13559,13611,4823,11850,13656,13663,13774,13741,13737,11719,11597,9337,11598,14496,11321,14609,14322,15101,15102,15114,15118,14783,14973,14010,14238,15138,3983,14895,13047,15154,11316,15697,13009,8419,14397,15290,14947,16192,15079,8536,7951,13156,12777,11862,14879,15130,14900,11511,15135,15125,14648,15056,16598,16008,15128,15137,14886,16025,16741,15568,10747,15561,11194,14903,11376,14954,15155,14718,14727,1970,15273,15925,4523,16588,15144,17192,10155,16139,9693,17293,15122,1243,17431,16253,17511,16337,17656,17647,3308,17988,18400,18831,11684,18282,17742,18283,18354,18272,14344,17657,19712,17560,18306,18260,18304,17814,17305,15803,17231,19339,17568,18308,2994,18184,21720,17227,16719,2189,20528,21666,21632,20746,20912,20743,20917,18302,21113,6714,14829,22535,21412,21070,22031,20699,23042,21069,23328,23686,23699,23570,23681,21491,23999,23998,23991,24814,23997,21071,24003,15292,23871,23126,21398,25347,23993,23828,24792,24000,23886,23996,24176,22636,25497,23963,12577,25012,23931,21442,24010,13942,25223,6174,22560,26495,26181,26530,26524,26139,10413,26476,24011,25362,24153,27710,26875,26439,25641,26568,27340,27716,27719,24114,6963,11581,27346,28317,28442,26833,26906,26628,26829,27592,26537,28114,11393,15360,28732,8427,24375,28260,27728,28646,21497,29244,29308,28238,28224,26286,29429,26225,29215,26864,26586,29933,29777,25192,26700,29366,30202,27714,30200,29368,29945,30182,30180,29367,30192,30199,29587,30867,30191,30696,30178,31447,31106,26887,30416,30718,31322,32075,30784,31315,29830,26359,30201,30702,31323,31278,29246,26667,30226,30415,31316,31320,31991,32902,33119,33112,27132,35631,36891,37182)
                ORDER BY schedules.`date`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.93 ms 
SELECT DISTINCT idtypestructure, typestructure,typestructure_pluriel FROM typesstructures WHERE 1  AND public_view=1  AND idtypestructure IN ('SN','TN','CDN','SC')  ORDER BY order_view, typestructure
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 12.55 ms 
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s0_.idspectacle IN (2840, 4074, 378, 3033, 3441, 4073, 4057, 4055, 4010, 3536, 4279, 4396, 3301, 2822, 3993, 4546, 4491, 4493, 4488, 4541, 4357, 4524, 5082, 4855, 4596, 3960, 5103, 5022, 6906, 7021, 6154, 6068, 6251, 5530, 7164, 5470, 7717, 6456, 5140, 7683, 8074, 2168, 8229, 8326, 5303, 5119, 7673, 9007, 8245, 1778, 9477, 11, 6561, 4281, 9034, 8193, 2884, 1783, 5379, 8331, 9887, 8355, 8828, 8515, 8375, 5149, 8336, 8100, 8415, 9329, 9333, 8102, 7713, 7450, 7429, 7298, 7251, 6702, 7038, 7094, 6994, 5896, 5310, 5407, 5615, 5229, 6023, 5099, 7656, 4713, 4280, 4221, 4320, 3577, 4209, 4061, 4070, 3704, 3816, 3896, 3700, 4322, 3210, 3809, 3712, 3601, 3788, 3795, 3198, 2767, 849, 3543, 3706, 3581, 3464, 3653, 3589, 3484, 3485, 3486, 3482, 3466, 3747, 3260, 2468, 1753, 36, 2819, 2872, 2590, 2575, 2403, 2427, 2270, 1773, 1315, 1139, 3, 896, 2139, 678, 1765, 748, 8507, 9252, 1073, 8559, 5092, 6316, 8248, 8431, 10479, 9843, 7416, 9733, 10449, 10347, 2163, 10345, 10536, 10548, 10565, 10574, 10580, 9727, 7576, 5206, 10772, 8421, 10866, 9522, 9521, 7333, 9884, 6195, 6424, 10870, 8250, 10710, 3774, 3773, 3772, 10918, 4235, 10919, 10921, 10929, 10930, 4870, 5194, 10931, 4072, 10932, 10935, 10939, 10940, 2283, 10299, 10945, 10949, 10950, 5361, 10952, 10953, 10955, 10956, 10974, 10976, 10980, 10981, 10982, 10984, 10986, 3034, 10990, 10991, 10999, 11003, 11004, 5369, 11015, 11025, 11027, 2173, 3241, 10865, 4542, 9561, 5426, 9917, 6631, 11164, 5710, 9269, 9200, 8572, 7502, 9474, 10300, 10425, 8374, 10429, 4485, 4532, 4528, 6660, 3790, 2831, 6168, 3781, 10150, 11465, 11502, 10751, 8084, 6916, 7609, 11761, 9881, 12334, 12943, 8388, 4673, 7418, 8608, 3903, 13092, 12507, 6922, 12524, 11859, 12127, 8358, 11572, 11570, 13559, 13611, 4823, 11850, 13656, 13663, 13774, 13741, 13737, 11719, 11597, 9337, 11598, 14496, 11321, 14609, 14322, 15101, 15102, 15114, 15118, 14783, 14973, 14010, 14238, 15138, 3983, 14895, 13047, 15154, 11316, 15697, 13009, 8419, 14397, 15290, 14947, 16192, 15079, 8536, 7951, 13156, 12777, 11862, 14879, 15130, 14900, 11511, 15135, 15125, 14648, 15056, 16598, 16008, 15128, 15137, 14886, 16025, 16741, 15568, 10747, 15561, 11194, 14903, 11376, 14954, 15155, 14718, 14727, 1970, 15273, 15925, 4523, 16588, 15144, 17192, 10155, 16139, 9693, 17293, 15122, 1243, 17431, 16253, 17511, 16337, 17656, 17647, 3308, 17988, 18400, 18831, 11684, 18282, 17742, 18283, 18354, 18272, 14344, 17657, 19712, 17560, 18306, 18260, 18304, 17814, 17305, 15803, 17231, 19339, 17568, 18308, 2994, 18184, 21720, 17227, 16719, 2189, 20528, 21666, 21632, 20746, 20912, 20743, 20917, 18302, 21113, 6714, 14829, 22535, 21412, 21070, 22031, 20699, 23042, 21069, 23328, 23686, 23699, 23570, 23681, 21491, 23999, 23998, 23991, 24814, 23997, 21071, 24003, 15292, 23871, 23126, 21398, 25347, 23993, 23828, 24792, 24000, 23886, 23996, 24176, 22636, 25497, 23963, 12577, 25012, 23931, 21442, 24010, 13942, 25223, 6174, 22560, 26495, 26181, 26530, 26524, 26139, 10413, 26476, 24011, 25362, 24153, 27710, 26875, 26439, 25641, 26568, 27340, 27716, 27719, 24114, 6963, 11581, 27346, 28317, 28442, 26833, 26906, 26628, 26829, 27592, 26537, 28114, 11393, 15360, 28732, 8427, 24375, 28260, 27728, 28646, 21497, 29244, 29308, 28238, 28224, 26286, 29429, 26225, 29215, 26864, 26586, 29933, 29777, 25192, 26700, 29366, 30202, 27714, 30200, 29368, 29945, 30182, 30180, 29367, 30192, 30199, 29587, 30867, 30191, 30696, 30178, 31447, 31106, 26887, 30416, 30718, 31322, 32075, 30784, 31315, 29830, 26359, 30201, 30702, 31323, 31278, 29246, 26667, 30226, 30415, 31316, 31320, 31991, 32902, 33119, 33112, 27132, 35631, 36891, 37182) AND ((s1_.date BETWEEN '2024-04-27' AND '2026-04-17')) AND c7_.idtypestructure IN ('SN') ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 15.15 ms 
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, s2_.idspectacle AS idspectacle_2, s2_.title AS title_3, s2_.language AS language_4, s2_.creation_date AS creation_date_5, s2_.url_page AS url_page_6, s2_.infos AS infos_7, s2_.tag AS tag_8, s2_.id_rubrique AS id_rubrique_9, s2_.duration AS duration_10, s2_.interlude AS interlude_11, s2_.textfictif AS textfictif_12, s2_.url_redirect AS url_redirect_13, s2_.url_clean AS url_clean_14, s2_.dateupdate AS dateupdate_15, s2_.dateinsert AS dateinsert_16, s2_.publish AS publish_17, s2_.statut AS statut_18, s2_.valid AS valid_19, t1_.idtext AS idtext_20, t1_.type AS type_21, t1_.idtypetext AS idtypetext_22, t1_.special_text AS special_text_23, t1_.title AS title_24, t1_.subtitle AS subtitle_25, t1_.date AS date_26, t1_.language AS language_27, t1_.markdown AS markdown_28, t1_.abstract AS abstract_29, t1_.abstract_author AS abstract_author_30, t1_.abstract_date AS abstract_date_31, t1_.abstract_url AS abstract_url_32, t1_.publisher_url_text AS publisher_url_text_33, t1_.publication_year AS publication_year_34, t1_.publication_month AS publication_month_35, t1_.isbn AS isbn_36, t1_.ean AS ean_37, t1_.publishinfos AS publishinfos_38, t1_.urltextaccess AS urltextaccess_39, t1_.emailtextaccess AS emailtextaccess_40, t1_.idfiletextaccess AS idfiletextaccess_41, t1_.filetextaccesssave AS filetextaccesssave_42, t1_.textaccessmore AS textaccessmore_43, t1_.request_translation_text AS request_translation_text_44, t1_.request_performing_text AS request_performing_text_45, t1_.help_translation AS help_translation_46, t1_.help_publishing AS help_publishing_47, t1_.help_other AS help_other_48, t1_.moreinfo AS moreinfo_49, t1_.nmale AS nmale_50, t1_.nfemale AS nfemale_51, t1_.npeople AS npeople_52, t1_.textorder AS textorder_53, t1_.nbpages AS nbpages_54, t1_.price AS price_55, t1_.selection_aneth AS selection_aneth_56, t1_.idtext_aneth AS idtext_aneth_57, t1_.aide_creation AS aide_creation_58, t1_.comments AS comments_59, t1_.url_clean AS url_clean_60, t1_.textfictif AS textfictif_61, t1_.valid_opendata AS valid_opendata_62, t1_.dateupdate AS dateupdate_63, t1_.dateinsert AS dateinsert_64, t1_.publish AS publish_65, t1_.statut AS statut_66, t1_.valid AS valid_67, t3_.idtypespectacle AS idtypespectacle_68 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s0_.idcontact = c7_.idcontact WHERE s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND s2_.idspectacle IN (2840, 4074, 378, 3033, 3441, 4073, 4057, 4055, 4010, 3536, 4279, 4396, 3301, 2822, 3993, 4546, 4491, 4493, 4488, 4541, 4357, 4524, 5082, 4855, 4596, 3960, 5103, 5022, 6906, 7021, 6154, 6068, 6251, 5530, 7164, 5470, 7717, 6456, 5140, 7683, 8074, 2168, 8229, 8326, 5303, 5119, 7673, 9007, 8245, 1778, 9477, 11, 6561, 4281, 9034, 8193, 2884, 1783, 5379, 8331, 9887, 8355, 8828, 8515, 8375, 5149, 8336, 8100, 8415, 9329, 9333, 8102, 7713, 7450, 7429, 7298, 7251, 6702, 7038, 7094, 6994, 5896, 5310, 5407, 5615, 5229, 6023, 5099, 7656, 4713, 4280, 4221, 4320, 3577, 4209, 4061, 4070, 3704, 3816, 3896, 3700, 4322, 3210, 3809, 3712, 3601, 3788, 3795, 3198, 2767, 849, 3543, 3706, 3581, 3464, 3653, 3589, 3484, 3485, 3486, 3482, 3466, 3747, 3260, 2468, 1753, 36, 2819, 2872, 2590, 2575, 2403, 2427, 2270, 1773, 1315, 1139, 3, 896, 2139, 678, 1765, 748, 8507, 9252, 1073, 8559, 5092, 6316, 8248, 8431, 10479, 9843, 7416, 9733, 10449, 10347, 2163, 10345, 10536, 10548, 10565, 10574, 10580, 9727, 7576, 5206, 10772, 8421, 10866, 9522, 9521, 7333, 9884, 6195, 6424, 10870, 8250, 10710, 3774, 3773, 3772, 10918, 4235, 10919, 10921, 10929, 10930, 4870, 5194, 10931, 4072, 10932, 10935, 10939, 10940, 2283, 10299, 10945, 10949, 10950, 5361, 10952, 10953, 10955, 10956, 10974, 10976, 10980, 10981, 10982, 10984, 10986, 3034, 10990, 10991, 10999, 11003, 11004, 5369, 11015, 11025, 11027, 2173, 3241, 10865, 4542, 9561, 5426, 9917, 6631, 11164, 5710, 9269, 9200, 8572, 7502, 9474, 10300, 10425, 8374, 10429, 4485, 4532, 4528, 6660, 3790, 2831, 6168, 3781, 10150, 11465, 11502, 10751, 8084, 6916, 7609, 11761, 9881, 12334, 12943, 8388, 4673, 7418, 8608, 3903, 13092, 12507, 6922, 12524, 11859, 12127, 8358, 11572, 11570, 13559, 13611, 4823, 11850, 13656, 13663, 13774, 13741, 13737, 11719, 11597, 9337, 11598, 14496, 11321, 14609, 14322, 15101, 15102, 15114, 15118, 14783, 14973, 14010, 14238, 15138, 3983, 14895, 13047, 15154, 11316, 15697, 13009, 8419, 14397, 15290, 14947, 16192, 15079, 8536, 7951, 13156, 12777, 11862, 14879, 15130, 14900, 11511, 15135, 15125, 14648, 15056, 16598, 16008, 15128, 15137, 14886, 16025, 16741, 15568, 10747, 15561, 11194, 14903, 11376, 14954, 15155, 14718, 14727, 1970, 15273, 15925, 4523, 16588, 15144, 17192, 10155, 16139, 9693, 17293, 15122, 1243, 17431, 16253, 17511, 16337, 17656, 17647, 3308, 17988, 18400, 18831, 11684, 18282, 17742, 18283, 18354, 18272, 14344, 17657, 19712, 17560, 18306, 18260, 18304, 17814, 17305, 15803, 17231, 19339, 17568, 18308, 2994, 18184, 21720, 17227, 16719, 2189, 20528, 21666, 21632, 20746, 20912, 20743, 20917, 18302, 21113, 6714, 14829, 22535, 21412, 21070, 22031, 20699, 23042, 21069, 23328, 23686, 23699, 23570, 23681, 21491, 23999, 23998, 23991, 24814, 23997, 21071, 24003, 15292, 23871, 23126, 21398, 25347, 23993, 23828, 24792, 24000, 23886, 23996, 24176, 22636, 25497, 23963, 12577, 25012, 23931, 21442, 24010, 13942, 25223, 6174, 22560, 26495, 26181, 26530, 26524, 26139, 10413, 26476, 24011, 25362, 24153, 27710, 26875, 26439, 25641, 26568, 27340, 27716, 27719, 24114, 6963, 11581, 27346, 28317, 28442, 26833, 26906, 26628, 26829, 27592, 26537, 28114, 11393, 15360, 28732, 8427, 24375, 28260, 27728, 28646, 21497, 29244, 29308, 28238, 28224, 26286, 29429, 26225, 29215, 26864, 26586, 29933, 29777, 25192, 26700, 29366, 30202, 27714, 30200, 29368, 29945, 30182, 30180, 29367, 30192, 30199, 29587, 30867, 30191, 30696, 30178, 31447, 31106, 26887, 30416, 30718, 31322, 32075, 30784, 31315, 29830, 26359, 30201, 30702, 31323, 31278, 29246, 26667, 30226, 30415, 31316, 31320, 31991, 32902, 33119, 33112, 27132, 35631, 36891, 37182) AND ((s0_.date BETWEEN '2024-04-27' AND '2026-04-17')) AND c7_.idtypestructure IN ('SN') GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 20
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.60 ms 
SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_region=1
                AND date_start<='2024-04-27'
                AND date_end>='2024-04-27' AND (region IS NULL AND country IS NULL) ORDER BY bannieres.order ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.99 ms 
SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10
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

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
TheatreCore\Entity\Extranetusers No errors.
TheatreCore\Entity\Spectacles No errors.
TheatreCore\Entity\Typesstructures No errors.
TheatreCore\Entity\Texts No errors.
TheatreCore\Entity\Typesspectacles No errors.
TheatreCore\Entity\Schedules No errors.
TheatreCore\Entity\Persons No errors.
TheatreCore\Entity\Contacts No errors.
TheatreCore\Entity\Bannieres No errors.