Query Metrics
81
Database Queries
63
Different statements
108.14 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.92 ms |
SELECT idperson FROM persons WHERE url_clean='Pierre-Nouvel'
Parameters:
[]
|
||||||||||||||||||||||||||||||
2 | 0.52 ms |
SELECT p0_.idperson AS idperson_0, p0_.lastname AS lastname_1, p0_.firstname AS firstname_2, p0_.sexe AS sexe_3, p0_.datestart AS datestart_4, p0_.dateend AS dateend_5, p0_.language AS language_6, p0_.language2 AS language2_7, p0_.email AS email_8, p0_.comment AS comment_9, p0_.cname AS cname_10, p0_.caddress AS caddress_11, p0_.czip AS czip_12, p0_.ccity AS ccity_13, p0_.ccountry AS ccountry_14, p0_.cphone AS cphone_15, p0_.cfax AS cfax_16, p0_.cemail AS cemail_17, p0_.cmobile AS cmobile_18, p0_.url_redirect AS url_redirect_19, p0_.url_clean AS url_clean_20, p0_.url_mav AS url_mav_21, p0_.dateupdate AS dateupdate_22, p0_.dateinsert AS dateinsert_23, p0_.publish AS publish_24, p0_.valid AS valid_25, p0_.idcorvin AS idcorvin_26, p0_.country AS country_27, p0_.idrole AS idrole_28, p0_.idextranetuser AS idextranetuser_29 FROM persons p0_ WHERE p0_.idperson = ?
Parameters:
[
6047
]
|
||||||||||||||||||||||||||||||
3 | 0.60 ms |
SELECT COUNT(DISTINCT(t.idtext)) FROM text_author ta, texts t WHERE t.idtext=ta.idtext AND t.textfictif=0 AND ta.idperson=6047 AND t.publish=1 AND t.type IN (0,2)
Parameters:
[]
|
||||||||||||||||||||||||||||||
4 | 0.31 ms |
SELECT COUNT(DISTINCT(tt.idtext)) as total FROM text_translator tt, texts t WHERE 1 AND t.idtext=tt.idtext AND t.textfictif=0 AND tt.idperson=6047 AND t.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
5 | 0.61 ms |
SELECT COUNT(DISTINCT(sp.idspectacle)) as total FROM spectacle_person sp, spectacles s WHERE 1 AND sp.idspectacle=s.idspectacle AND sp.idperson=6047 AND sp.idrole=1 AND s.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
6 | 0.11 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||||||
7 | 0.07 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||
8 | 0.44 ms |
SELECT j1.idcontact,j1.organisation,j1.url_clean,j2.idoffice,j2.date_start,j2.date_end ,j3.idperson FROM theatreok_dev.contacts j1, theatreok_dev.contact_person j2, theatreok_dev.persons j3 WHERE j3.idperson=j2.idperson AND j1.idcontact=j2.idcontact AND j3.idperson=6047 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
9 | 0.09 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotxt'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
10 | 1.58 ms |
SELECT * FROM object_content oc, contents c, content_classification cc, classifications cl WHERE oc.idcontent=c.idcontent AND c.idcontent=cc.idcontent AND oc.idobject='6047' AND oc.object='persons' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_biotxt'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
|
||||||||||||||||||||||||||||||
11 | 0.33 ms |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3 WHERE j3.idcontent=j2.idcontent AND j1.idclassification=j2.idclassification AND j3.idcontent=23003
Parameters:
[]
|
||||||||||||||||||||||||||||||
12 | 0.15 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
13 | 1.30 ms |
SELECT * FROM object_file of, files f, file_classification fc, classifications cl,typesfiles tf WHERE of.idfile=f.idfile AND f.idfile=fc.idfile AND of.idobject='6047' AND of.object='persons' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
|
||||||||||||||||||||||||||||||
14 | 0.38 ms |
SELECT t.`idtext` FROM text_author ta JOIN texts t ON ta.`idtext`=t.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
15 | 0.41 ms |
SELECT tad.`idtextadaptation` FROM text_adaptation tad JOIN texts t ON t.`idtext`=tad.`idtext` JOIN text_author ta ON t.`idtext`=ta.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
16 | 0.27 ms |
SELECT t.`idtext` FROM text_translator tt JOIN texts t ON tt.`idtext`=t.`idtext` WHERE tt.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
17 | 0.30 ms |
SELECT tt.`idtexttraduction` FROM text_traduction tt JOIN text_author ta ON tt.`idtext`=ta.`idtext` JOIN texts t ON tt.`idtext`=t.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
18 | 0.84 ms |
SELECT s.`idspectacle` FROM spectacles s LEFT JOIN spectacle_person sp ON sp.`idspectacle`=s.`idspectacle` LEFT JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle` WHERE s.`publish`=1 AND s.`valid`=1 AND (sp.`idperson`=6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
19 | 5.85 ms |
SELECT COUNT(DISTINCT(ct.`idcontent`)) FROM spectacles s JOIN object_content oc ON s.`idspectacle`=oc.`idobject` JOIN contents ct ON oc.`idcontent`=ct.`idcontent` JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent` WHERE s.`publish`=1 AND s.`valid`=1 AND ct.`publish`=1 AND ct.`valid`=1 AND cc.`idclassification`=101 AND s.`idspectacle` IN (1287,2715,3179,3273,3597,3808,3978,4785,4919,5490,6602,6920,8246,8323,8463,8899,9793,9806,11802,11811,14900,15315,16206,16207,18041,18539,20565,20733,20734,20943,21150,21204,21377,23699,23815,24123,25535,25765,26537,26874,27140,27169,28562,28607,29830,29928,30180,30415,31564,32139,32852,33530,33909,34283,35928,36024,36444,36447)
Parameters:
[]
|
||||||||||||||||||||||||||||||
20 | 0.98 ms |
SELECT r.idrole, r.role, r.role_male, r.role_female, lg.fr FROM spectacle_person sp JOIN roles r ON sp.idrole=r.idrole JOIN langterms lg ON lg.id=r.role WHERE sp.idperson=6047 GROUP BY r.idrole
Parameters:
[]
|
||||||||||||||||||||||||||||||
21 | 0.53 ms |
SELECT t.`idtext` FROM text_author ta JOIN texts t ON ta.`idtext`=t.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
22 | 0.03 ms |
SELECT tad.`idtextadaptation` FROM text_adaptation tad JOIN texts t ON t.`idtext`=tad.`idtext` JOIN text_author ta ON t.`idtext`=ta.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
23 | 0.03 ms |
SELECT t.`idtext` FROM text_translator tt JOIN texts t ON tt.`idtext`=t.`idtext` WHERE tt.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
24 | 0.03 ms |
SELECT tt.`idtexttraduction` FROM text_traduction tt JOIN text_author ta ON tt.`idtext`=ta.`idtext` JOIN texts t ON tt.`idtext`=t.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
25 | 5.12 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 (1287,2715,3179,3273,3597,3808,3978,4785,4919,5490,6602,6920,8246,8323,8463,8899,9793,9806,11802,11811,14900,15315,16206,16207,18041,18539,20565,20733,20734,20943,21150,21204,21377,23699,23815,24123,25535,25765,26537,26874,27140,27169,28562,28607,29830,29928,30180,30415,31564,32139,32852,33530,33909,34283,35928,36024,36444,36447) ORDER BY schedules.`date`
Parameters:
[]
|
||||||||||||||||||||||||||||||
26 | 0.14 ms |
SELECT t.`idtext` FROM text_author ta JOIN texts t ON ta.`idtext`=t.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
27 | 0.06 ms |
SELECT tad.`idtextadaptation` FROM text_adaptation tad JOIN texts t ON t.`idtext`=tad.`idtext` JOIN text_author ta ON t.`idtext`=ta.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
28 | 0.04 ms |
SELECT t.`idtext` FROM text_translator tt JOIN texts t ON tt.`idtext`=t.`idtext` WHERE tt.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
29 | 0.04 ms |
SELECT tt.`idtexttraduction` FROM text_traduction tt JOIN text_author ta ON tt.`idtext`=ta.`idtext` JOIN texts t ON tt.`idtext`=t.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
30 | 0.05 ms |
SELECT t.`idtext` FROM text_author ta JOIN texts t ON ta.`idtext`=t.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
31 | 0.04 ms |
SELECT tad.`idtextadaptation` FROM text_adaptation tad JOIN texts t ON t.`idtext`=tad.`idtext` JOIN text_author ta ON t.`idtext`=ta.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
32 | 0.04 ms |
SELECT t.`idtext` FROM text_translator tt JOIN texts t ON tt.`idtext`=t.`idtext` WHERE tt.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
33 | 0.04 ms |
SELECT tt.`idtexttraduction` FROM text_traduction tt JOIN text_author ta ON tt.`idtext`=ta.`idtext` JOIN texts t ON tt.`idtext`=t.`idtext` WHERE ta.`idperson` IN (6047)
Parameters:
[]
|
||||||||||||||||||||||||||||||
34 | 31.32 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 (1287, 2715, 3179, 3273, 3597, 3808, 3978, 4785, 4919, 5490, 6602, 6920, 8246, 8323, 8463, 8899, 9793, 9806, 11802, 11811, 14900, 15315, 16206, 16207, 18041, 18539, 20565, 20733, 20734, 20943, 21150, 21204, 21377, 23699, 23815, 24123, 25535, 25765, 26537, 26874, 27140, 27169, 28562, 28607, 29830, 29928, 30180, 30415, 31564, 32139, 32852, 33530, 33909, 34283, 35928, 36024, 36444, 36447) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||
35 | 1.63 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 (1287, 2715, 3179, 3273, 3597, 3808, 3978, 4785, 4919, 5490, 6602, 6920, 8246, 8323, 8463, 8899, 9793, 9806, 11802, 11811, 14900, 15315, 16206, 16207, 18041, 18539, 20565, 20733, 20734, 20943, 21150, 21204, 21377, 23699, 23815, 24123, 25535, 25765, 26537, 26874, 27140, 27169, 28562, 28607, 29830, 29928, 30180, 30415, 31564, 32139, 32852, 33530, 33909, 34283, 35928, 36024, 36444, 36447) AND ((s1_.date BETWEEN '2024-05-02' AND '2026-04-22')) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
36 | 2.91 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 (1287, 2715, 3179, 3273, 3597, 3808, 3978, 4785, 4919, 5490, 6602, 6920, 8246, 8323, 8463, 8899, 9793, 9806, 11802, 11811, 14900, 15315, 16206, 16207, 18041, 18539, 20565, 20733, 20734, 20943, 21150, 21204, 21377, 23699, 23815, 24123, 25535, 25765, 26537, 26874, 27140, 27169, 28562, 28607, 29830, 29928, 30180, 30415, 31564, 32139, 32852, 33530, 33909, 34283, 35928, 36024, 36444, 36447) AND ((s0_.date BETWEEN '2024-05-02' AND '2026-04-22')) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 20
Parameters:
[]
|
||||||||||||||||||||||||||||||
37 | 1.48 ms |
SELECT COUNT(DISTINCT (s0_.idschedule)) AS sclr_0, MIN(s0_.date) AS sclr_1 FROM spectacles s1_ LEFT JOIN text_spectacle t3_ ON s1_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s1_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s0_ ON s1_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s6_ ON s1_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s0_.idcontact = c7_.idcontact WHERE s0_.idspectacle = s1_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND s1_.idspectacle IN (1287, 2715, 3179, 3273, 3597, 3808, 3978, 4785, 4919, 5490, 6602, 6920, 8246, 8323, 8463, 8899, 9793, 9806, 11802, 11811, 14900, 15315, 16206, 16207, 18041, 18539, 20565, 20733, 20734, 20943, 21150, 21204, 21377, 23699, 23815, 24123, 25535, 25765, 26537, 26874, 27140, 27169, 28562, 28607, 29830, 29928, 30180, 30415, 31564, 32139, 32852, 33530, 33909, 34283, 35928, 36024, 36444, 36447) AND ((s0_.date BETWEEN '2024-05-02' AND '2026-04-22')) ORDER BY s0_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
38 | 0.11 ms |
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||
39 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
41809
]
|
||||||||||||||||||||||||||||||
40 | 0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=41809 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||
41 | 0.03 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3 WHERE j3.idtext=j2.idtext AND j1.idperson=j2.idperson AND j3.idtext=41808 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
42 | 0.07 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`, lt.`fr`, r.`idrole`, r.`role`, r.`type`, sp.`comment`,sp.`date_start`,sp.`date_end` FROM persons p JOIN spectacle_person sp ON sp.`idperson`=p.`idperson` JOIN roles r ON r.`idrole`=sp.`idrole` JOIN langterms lt ON r.`role`=lt.`id` WHERE sp.idspectacle=33530 ORDER BY p.`lastname`
Parameters:
[]
|
||||||||||||||||||||||||||||||
43 | 2.41 ms |
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, DATEDIFF('2024-05-02', s0_.date) AS sclr_2, ABS(DATEDIFF('2024-05-02', s0_.date)) AS sclr_3, s0_.idschedule AS idschedule_4, s0_.date AS date_5, s0_.hour AS hour_6, s0_.is_creation AS is_creation_7, s0_.is_cancelled AS is_cancelled_8, s0_.idcontact_festival AS idcontact_festival_9, s0_.url_spectacle AS url_spectacle_10, s0_.url_booking AS url_booking_11, s0_.note AS note_12, s0_.dateupdate AS dateupdate_13, s0_.dateinsert AS dateinsert_14, s0_.publish AS publish_15, s0_.valid AS valid_16, c1_.idcontact AS idcontact_17, c1_.type AS type_18, c1_.organisation AS organisation_19, c1_.nom_suite AS nom_suite_20, c1_.lastname AS lastname_21, c1_.firstname AS firstname_22, c1_.idtypestructure AS idtypestructure_23, c1_.license AS license_24, c1_.comment AS comment_25, c1_.private_comment AS private_comment_26, c1_.address1 AS address1_27, c1_.address2 AS address2_28, c1_.zip AS zip_29, c1_.city AS city_30, c1_.phone1 AS phone1_31, c1_.phone2 AS phone2_32, c1_.fax AS fax_33, c1_.email1 AS email1_34, c1_.email1_online AS email1_online_35, c1_.email2_online AS email2_online_36, c1_.email2 AS email2_37, c1_.url AS url_38, c1_.url_ticket AS url_ticket_39, c1_.facebook AS facebook_40, c1_.twitter AS twitter_41, c1_.instagram AS instagram_42, c1_.mobile AS mobile_43, c1_.geocodable AS geocodable_44, c1_.x AS x_45, c1_.y AS y_46, c1_.idmultimedia AS idmultimedia_47, c1_.type_view AS type_view_48, c1_.stats_access AS stats_access_49, c1_.ga_tracking_id AS ga_tracking_id_50, c1_.is_festival AS is_festival_51, c1_.link_on_video AS link_on_video_52, c1_.is_partenaire AS is_partenaire_53, c1_.valid_version AS valid_version_54, c1_.other_versions AS other_versions_55, c1_.url_redirect AS url_redirect_56, c1_.url_clean AS url_clean_57, c1_.dateupdate AS dateupdate_58, c1_.dateinsert AS dateinsert_59, c1_.publish AS publish_60, c1_.valid AS valid_61, s0_.idspectacle AS idspectacle_62, s0_.idcontact AS idcontact_63, s0_.idextranetuser AS idextranetuser_64, c1_.country AS country_65, c1_.idextranetuser AS idextranetuser_66 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? GROUP BY s0_.idcontact ORDER BY sclr_2 ASC, sclr_3 ASC LIMIT 1
Parameters:
[
33530
]
|
||||||||||||||||||||||||||||||
44 | 0.50 ms |
SELECT sp.idrole,r.role_male,r.role_female,lg.fr FROM spectacle_person sp, roles r, langterms lg WHERE 1 AND sp.idrole=r.idrole AND r.role=lg.id AND sp.idspectacle=33530 AND sp.idperson=6047
Parameters:
[]
|
||||||||||||||||||||||||||||||
45 | 0.40 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=33530 AND om.object='spectacles' AND m.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
46 | 0.43 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total FROM podcasts d, podcast_spectacle do WHERE d.`publish`=1 AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=33530 AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||
47 | 0.80 ms |
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||
48 | 0.74 ms |
SELECT COUNT(DISTINCT(of.idfile)) as total FROM object_file of, files f, file_classification fc, classifications cl,typesfiles tf WHERE of.idfile=f.idfile AND f.idfile=fc.idfile AND of.idobject='33530' AND of.object='spectacles' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
Parameters:
[]
|
||||||||||||||||||||||||||||||
49 | 0.74 ms |
SELECT COUNT(oc.idcontent) FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=33530 AND cc.idclassification=6 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
50 | 0.71 ms |
SELECT COUNT(oc.idcontent) FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=33530 AND cc.idclassification=125 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
51 | 0.69 ms |
SELECT COUNT(oc.idcontent) FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=33530 AND cc.idclassification=101 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
52 | 0.06 ms |
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||
53 | 0.19 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
39994
]
|
||||||||||||||||||||||||||||||
54 | 0.51 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3 WHERE j3.idtext=j2.idtext AND j1.idperson=j2.idperson AND j3.idtext=39994 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
55 | 1.46 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`, lt.`fr`, r.`idrole`, r.`role`, r.`type`, sp.`comment`,sp.`date_start`,sp.`date_end` FROM persons p JOIN spectacle_person sp ON sp.`idperson`=p.`idperson` JOIN roles r ON r.`idrole`=sp.`idrole` JOIN langterms lt ON r.`role`=lt.`id` WHERE sp.idspectacle=32139 ORDER BY p.`lastname`
Parameters:
[]
|
||||||||||||||||||||||||||||||
56 | 1.55 ms |
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, DATEDIFF('2024-05-02', s0_.date) AS sclr_2, ABS(DATEDIFF('2024-05-02', s0_.date)) AS sclr_3, s0_.idschedule AS idschedule_4, s0_.date AS date_5, s0_.hour AS hour_6, s0_.is_creation AS is_creation_7, s0_.is_cancelled AS is_cancelled_8, s0_.idcontact_festival AS idcontact_festival_9, s0_.url_spectacle AS url_spectacle_10, s0_.url_booking AS url_booking_11, s0_.note AS note_12, s0_.dateupdate AS dateupdate_13, s0_.dateinsert AS dateinsert_14, s0_.publish AS publish_15, s0_.valid AS valid_16, c1_.idcontact AS idcontact_17, c1_.type AS type_18, c1_.organisation AS organisation_19, c1_.nom_suite AS nom_suite_20, c1_.lastname AS lastname_21, c1_.firstname AS firstname_22, c1_.idtypestructure AS idtypestructure_23, c1_.license AS license_24, c1_.comment AS comment_25, c1_.private_comment AS private_comment_26, c1_.address1 AS address1_27, c1_.address2 AS address2_28, c1_.zip AS zip_29, c1_.city AS city_30, c1_.phone1 AS phone1_31, c1_.phone2 AS phone2_32, c1_.fax AS fax_33, c1_.email1 AS email1_34, c1_.email1_online AS email1_online_35, c1_.email2_online AS email2_online_36, c1_.email2 AS email2_37, c1_.url AS url_38, c1_.url_ticket AS url_ticket_39, c1_.facebook AS facebook_40, c1_.twitter AS twitter_41, c1_.instagram AS instagram_42, c1_.mobile AS mobile_43, c1_.geocodable AS geocodable_44, c1_.x AS x_45, c1_.y AS y_46, c1_.idmultimedia AS idmultimedia_47, c1_.type_view AS type_view_48, c1_.stats_access AS stats_access_49, c1_.ga_tracking_id AS ga_tracking_id_50, c1_.is_festival AS is_festival_51, c1_.link_on_video AS link_on_video_52, c1_.is_partenaire AS is_partenaire_53, c1_.valid_version AS valid_version_54, c1_.other_versions AS other_versions_55, c1_.url_redirect AS url_redirect_56, c1_.url_clean AS url_clean_57, c1_.dateupdate AS dateupdate_58, c1_.dateinsert AS dateinsert_59, c1_.publish AS publish_60, c1_.valid AS valid_61, s0_.idspectacle AS idspectacle_62, s0_.idcontact AS idcontact_63, s0_.idextranetuser AS idextranetuser_64, c1_.country AS country_65, c1_.idextranetuser AS idextranetuser_66 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? GROUP BY s0_.idcontact ORDER BY sclr_2 ASC, sclr_3 ASC LIMIT 1
Parameters:
[
32139
]
|
||||||||||||||||||||||||||||||
57 | 0.25 ms |
SELECT sp.idrole,r.role_male,r.role_female,lg.fr FROM spectacle_person sp, roles r, langterms lg WHERE 1 AND sp.idrole=r.idrole AND r.role=lg.id AND sp.idspectacle=32139 AND sp.idperson=6047
Parameters:
[]
|
||||||||||||||||||||||||||||||
58 | 0.42 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=32139 AND om.object='spectacles' AND m.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
59 | 0.33 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total FROM podcasts d, podcast_spectacle do WHERE d.`publish`=1 AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=32139 AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||
60 | 0.15 ms |
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||
61 | 0.39 ms |
SELECT COUNT(DISTINCT(of.idfile)) as total FROM object_file of, files f, file_classification fc, classifications cl,typesfiles tf WHERE of.idfile=f.idfile AND f.idfile=fc.idfile AND of.idobject='32139' AND of.object='spectacles' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
Parameters:
[]
|
||||||||||||||||||||||||||||||
62 | 0.42 ms |
SELECT COUNT(oc.idcontent) FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=32139 AND cc.idclassification=6 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
63 | 0.38 ms |
SELECT COUNT(oc.idcontent) FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=32139 AND cc.idclassification=125 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
64 | 0.38 ms |
SELECT COUNT(oc.idcontent) FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=32139 AND cc.idclassification=101 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
65 | 0.34 ms |
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total FROM playlists p LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist` LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification` WHERE p.`publish`=1 AND p.`idperson` IN (6047) AND c.`classification`='class_auteur_meme'
Parameters:
[]
|
||||||||||||||||||||||||||||||
66 | 2.24 ms |
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle, c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean, ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean FROM schedules s JOIN contacts c ON s.idcontact=c.idcontact LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact WHERE 1 AND s.idspectacle IN (1287,2715,3179,3273,3597,3808,3978,4785,4919,5490,6602,6920,8246,8323,8463,8899,9793,9806,11802,11811,14900,15315,16206,16207,18041,18539,20565,20733,20734,20943,21150,21204,21377,23699,23815,24123,25535,25765,26537,26874,27140,27169,28562,28607,29830,29928,30180,30415,31564,32139,32852,33530,33909,34283,35928,36024,36444,36447) AND s.date>='2024-05-02' ORDER BY s.date ASC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||
67 | 0.05 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotextes'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
68 | 0.32 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total FROM object_content oc, contents c, content_classification cc, classifications cl WHERE oc.idcontent=c.idcontent AND c.idcontent=cc.idcontent AND oc.idobject='6047' AND oc.object='persons' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_biotextes')))
Parameters:
[]
|
||||||||||||||||||||||||||||||
69 | 2.35 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 (1287,2715,3179,3273,3597,3808,3978,4785,4919,5490,6602,6920,8246,8323,8463,8899,9793,9806,11802,11811,14900,15315,16206,16207,18041,18539,20565,20733,20734,20943,21150,21204,21377,23699,23815,24123,25535,25765,26537,26874,27140,27169,28562,28607,29830,29928,30180,30415,31564,32139,32852,33530,33909,34283,35928,36024,36444,36447) GROUP BY spectacles.`idspectacle` ORDER BY schedules.`date`
Parameters:
[]
|
||||||||||||||||||||||||||||||
70 | 0.42 ms |
SELECT COUNT(DISTINCT(T1.idnew)) as total FROM news T1 INNER JOIN newschedules T3 ON T3.idnew=T1.idnew INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_person T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idperson=6047 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
71 | 0.37 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=6047 AND om.object='persons' AND m.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
72 | 0.30 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total FROM podcasts d, podcast_person do WHERE d.`publish`=1 AND do.`idpodcast`= d.`idpodcast` AND do.`idperson`=6047 AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||
73 | 0.27 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total FROM podcasts d, podcast_person do WHERE d.`publish`=1 AND do.`idpodcast`= d.`idpodcast` AND do.`idperson`=6047 AND d.code_soundcloud IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||
74 | 11.11 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (125) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND s0_.idspectacle IN (1287, 2715, 3179, 3273, 3597, 3808, 3978, 4785, 4919, 5490, 6602, 6920, 8246, 8323, 8463, 8899, 9793, 9806, 11802, 11811, 14900, 15315, 16206, 16207, 18041, 18539, 20565, 20733, 20734, 20943, 21150, 21204, 21377, 23699, 23815, 24123, 25535, 25765, 26537, 26874, 27140, 27169, 28562, 28607, 29830, 29928, 30180, 30415, 31564, 32139, 32852, 33530, 33909, 34283, 35928, 36024, 36444, 36447) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||
75 | 7.41 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (82) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND s0_.idspectacle IN (1287, 2715, 3179, 3273, 3597, 3808, 3978, 4785, 4919, 5490, 6602, 6920, 8246, 8323, 8463, 8899, 9793, 9806, 11802, 11811, 14900, 15315, 16206, 16207, 18041, 18539, 20565, 20733, 20734, 20943, 21150, 21204, 21377, 23699, 23815, 24123, 25535, 25765, 26537, 26874, 27140, 27169, 28562, 28607, 29830, 29928, 30180, 30415, 31564, 32139, 32852, 33530, 33909, 34283, 35928, 36024, 36444, 36447) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||
76 | 2.29 ms |
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*,spectacles.`idspectacle`,schedules.`idcontact` FROM `object_multimedia` , `schedules` , `spectacles` , `contacts` , `multimedias` , `multimedia_classification` WHERE 1 AND multimedias.`publish`=1 AND object_multimedia.`object`='spectacles' AND object_multimedia.`idrole` IS NULL AND schedules.`date` BETWEEN '1999-01-01' AND '2030-01-01' AND object_multimedia.`object`='spectacles' AND object_multimedia.`idobject` IN (1287,2715,3179,3273,3597,3808,3978,4785,4919,5490,6602,6920,8246,8323,8463,8899,9793,9806,11802,11811,14900,15315,16206,16207,18041,18539,20565,20733,20734,20943,21150,21204,21377,23699,23815,24123,25535,25765,26537,26874,27140,27169,28562,28607,29830,29928,30180,30415,31564,32139,32852,33530,33909,34283,35928,36024,36444,36447) AND multimedia_classification.`idclassification`=145 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND schedules.`idspectacle`=spectacles.`idspectacle` AND spectacles.`idspectacle`=object_multimedia.`idobject` AND contacts.`idcontact`=schedules.`idcontact` AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND multimedias.`idmultimedia`=multimedia_classification.`idmultimedia` GROUP BY object_multimedia.`idobject` ORDER BY schedules.`date` ASC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||
77 | 0.51 ms |
SELECT t0.idstat AS idstat_1, t0.type AS type_2, t0.module AS module_3, t0.url AS url_4, t0.idcontent AS idcontent_5, t0.object AS object_6, t0.idobject AS idobject_7, t0.video AS video_8, t0.remote_addr AS remote_addr_9, t0.lng AS lng_10, t0.source AS source_11, t0.md5url AS md5url_12, t0.dateinsert AS dateinsert_13 FROM stats t0 WHERE t0.remote_addr = ? AND t0.idcontent = ? AND t0.md5url = ?
Parameters:
[ "2e1df2ca998597d6a5c1c3baf4cc9794-69fa" 0 "c1256b86e3ae7a0aee2856539acfed10" ]
|
||||||||||||||||||||||||||||||
78 | 2.91 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/biographies/Pierre-Nouvel/spectacles/" "c1256b86e3ae7a0aee2856539acfed10" 0 "persons" 6047 0 "fr" "2e1df2ca998597d6a5c1c3baf4cc9794-69fa" "/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553" ]
|
||||||||||||||||||||||||||||||
79 | 0.11 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
80 | 0.07 ms |
SELECT * FROM object_file of, files f, file_classification fc, classifications cl,typesfiles tf WHERE of.idfile=f.idfile AND f.idfile=fc.idfile AND of.idobject='6047' AND of.object='persons' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
|
||||||||||||||||||||||||||||||
81 | 3.27 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:
[]
|
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\Persons | No errors. |
TheatreCore\Entity\Contents | No errors. |
TheatreCore\Entity\Multimedias | No errors. |
TheatreCore\Entity\Countries | No errors. |
TheatreCore\Entity\Roles | No errors. |
TheatreCore\Entity\News | No errors. |
TheatreCore\Entity\Classifications | No errors. |
TheatreCore\Entity\Contacts | No errors. |
TheatreCore\Entity\Podcasts | No errors. |
TheatreCore\Entity\Spectacles | No errors. |
TheatreCore\Entity\Texts | No errors. |
TheatreCore\Entity\Files | No errors. |
TheatreCore\Entity\Typesspectacles | No errors. |
TheatreCore\Entity\Schedules | No errors. |
TheatreCore\Entity\ContactAide | No errors. |
TheatreCore\Entity\Contactsaisons | No errors. |
TheatreCore\Entity\Playlists | No errors. |
TheatreCore\Entity\ObjectContent | No errors. |
TheatreCore\Entity\BookmarkExtranetuser | No errors. |
TheatreCore\Entity\Stats | No errors. |
TheatreCore\Entity\Abonnements | No errors. |
TheatreCore\Entity\Bannieres | No errors. |