1
0.22 ms
SELECT idperson FROM persons WHERE url_clean = '65787105bbd54'
SELECT idperson FROM persons WHERE url_clean = '65787105bbd54' ;
Copy
2
0.22 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 = ?
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 = 110264 ;
Copy
3
0.16 ms
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_author ta , texts t
WHERE t . idtext = ta . idtext AND t . textfictif = 0
AND ta . idperson = 110264 AND t . publish = 1 AND t . type IN (0 , 2 )
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_author ta , texts t
WHERE t . idtext = ta . idtext AND t . textfictif = 0
AND ta . idperson = 110264 AND t . publish = 1 AND t . type IN (0 , 2 ) ;
Copy
4
0.06 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 = 110264 AND t . publish = 1
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 = 110264 AND t . publish = 1 ;
Copy
5
0.06 ms
SELECT COUNT (DISTINCT (sp . idspectacle )) as total
FROM spectacle_person sp , spectacles s
WHERE 1
AND sp . idspectacle = s . idspectacle
AND sp . idperson = 110264
AND sp . idrole = 1 AND s . publish = 1
SELECT COUNT (DISTINCT (sp . idspectacle )) as total
FROM spectacle_person sp , spectacles s
WHERE 1
AND sp . idspectacle = s . idspectacle
AND sp . idperson = 110264
AND sp . idrole = 1 AND s . publish = 1 ;
Copy
6
0.05 ms
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
7
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
8
0.07 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 = 110264 AND j2 . idoffice = 1
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 = 110264 AND j2 . idoffice = 1 ;
Copy
9
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotxt' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotxt' ))) AND persons = 1 ;
Copy
10
0.10 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 = '110264'
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
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 = '110264'
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 ;
Copy
11
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_photo_person' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_photo_person' ))) AND persons = 1 ;
Copy
12
0.10 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 = '110264'
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
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 = '110264'
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 ;
Copy
13
0.06 ms
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (110264 )
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (110264 ) ;
Copy
14
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 (110264 )
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 (110264 ) ;
Copy
15
0.05 ms
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (110264 )
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (110264 ) ;
Copy
16
0.05 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 (110264 )
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 (110264 ) ;
Copy
17
0.06 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 (37307 )
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 (37307 ) ;
Copy
18
1.86 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 = 110264
GROUP BY r . idrole
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 = 110264
GROUP BY r . idrole ;
Copy
19
0.08 ms
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (110264 )
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (110264 ) ;
Copy
20
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 (110264 )
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 (110264 ) ;
Copy
21
0.06 ms
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (110264 )
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (110264 ) ;
Copy
22
0.05 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 (110264 )
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 (110264 ) ;
Copy
23
0.07 ms
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (110264 )
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (110264 ) ;
Copy
24
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 (110264 )
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 (110264 ) ;
Copy
25
0.06 ms
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (110264 )
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (110264 ) ;
Copy
26
0.06 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 (110264 )
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 (110264 ) ;
Copy
27
0.06 ms
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (110264 )
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (110264 ) ;
Copy
28
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 (110264 )
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 (110264 ) ;
Copy
29
0.05 ms
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (110264 )
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (110264 ) ;
Copy
30
0.06 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 (110264 )
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 (110264 ) ;
Copy
31
0.08 ms
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (? ) LIMIT 1
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (4 ) LIMIT 1 ;
Copy
32
0.15 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 45608 ;
Copy
33
0.08 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 = 45608 ORDER BY j2 . classement ASC
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 = 45608 ORDER BY j2 . classement ASC ;
Copy
34
0.11 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 = 37307 ORDER BY p . `lastname`
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 = 37307 ORDER BY p . `lastname` ;
Copy
35
0.15 ms
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , DATEDIFF ('2024-04-29' , s0_ . date ) AS sclr_2 , ABS (DATEDIFF ('2024-04-29' , 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
SELECT
MIN (s0_ . date ) AS sclr_0 ,
MAX (s0_ . date ) AS sclr_1 ,
DATEDIFF ('2024-04-29' , s0_ . date ) AS sclr_2 ,
ABS (
DATEDIFF ('2024-04-29' , 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
Copy
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , DATEDIFF ('2024-04-29' , s0_ . date ) AS sclr_2 , ABS (DATEDIFF ('2024-04-29' , 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 = 37307 GROUP BY s0_ . idcontact ORDER BY sclr_2 ASC , sclr_3 ASC LIMIT 1 ;
Copy
36
0.16 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 = 37307
AND sp . idperson = 110264
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 = 37307
AND sp . idperson = 110264 ;
Copy
37
0.07 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 37307
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 37307
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
38
0.07 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` = 37307 AND d . code_franceinter IS NOT NULL
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` = 37307 AND d . code_franceinter IS NOT NULL ;
Copy
39
0.06 ms
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND spectacles = 1 AND lagarce ! = 1 AND is_public IN (1 )
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND spectacles = 1 AND lagarce ! = 1 AND is_public IN (1 ) ;
Copy
40
0.07 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 = '37307'
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
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 = '37307'
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 ;
Copy
41
0.06 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 = 37307 AND cc . idclassification = 6 LIMIT 1
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 = 37307 AND cc . idclassification = 6 LIMIT 1 ;
Copy
42
0.06 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 = 37307 AND cc . idclassification = 125 LIMIT 1
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 = 37307 AND cc . idclassification = 125 LIMIT 1 ;
Copy
43
0.06 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 = 37307 AND cc . idclassification = 101 LIMIT 1
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 = 37307 AND cc . idclassification = 101 LIMIT 1 ;
Copy
44
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . idclassification IN (6 ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . idclassification IN (6 ))) AND persons = 1 ;
Copy
45
0.06 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 = '110264'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . idclassification IN (6 )))
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 = '110264'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . idclassification IN (6 )));
Copy
46
0.08 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 (110264 ) AND c . `classification` = 'class_auteur_meme'
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 (110264 ) AND c . `classification` = 'class_auteur_meme' ;
Copy
47
0.08 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 (37307 ) AND s . date > = '2024-04-29' ORDER BY s . date ASC LIMIT 0 , 1
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 (37307 ) AND s . date > = '2024-04-29' ORDER BY s . date ASC LIMIT 0 , 1 ;
Copy
48
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotextes' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotextes' ))) AND persons = 1 ;
Copy
49
0.06 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 = '110264'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_biotextes' )))
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 = '110264'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_biotextes' )));
Copy
50
0.07 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 = 110264 ) AND T1 . publish = 1
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 = 110264 ) AND T1 . publish = 1 ;
Copy
51
0.06 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 110264
AND om . object = 'persons'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 110264
AND om . object = 'persons'
AND m . publish = 1 ;
Copy
52
0.06 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` = 110264 AND d . code_franceinter IS NOT NULL
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` = 110264 AND d . code_franceinter IS NOT NULL ;
Copy
53
0.06 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` = 110264 AND d . code_soundcloud IS NOT NULL
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` = 110264 AND d . code_soundcloud IS NOT NULL ;
Copy
54
0.17 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 (37307 ) 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
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 (37307 ) 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 ;
Copy
55
1.55 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 :
[
"1b20c58125d9c1abfe416946811d2590-1e13 "
0
"769737ca180d70fe69b27ec33d250eda "
]
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 = '1b20c58125d9c1abfe416946811d2590-1e13' AND t0 . idcontent = 0 AND t0 . md5url = '769737ca180d70fe69b27ec33d250eda' ;
Copy
56
2.52 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/biographies/65787105bbd54/spectacles/ "
"769737ca180d70fe69b27ec33d250eda "
0
"persons "
110264
0
"fr "
"1b20c58125d9c1abfe416946811d2590-1e13 "
"/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553 "
]
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES ('article' , 'thnet' , '/biographies/65787105bbd54/spectacles/' , '769737ca180d70fe69b27ec33d250eda' , 0 , 'persons' , 110264 , 0 , 'fr' , '1b20c58125d9c1abfe416946811d2590-1e13' , '/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553' );
Copy
57
0.10 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_photo_person' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_photo_person' ))) AND persons = 1 ;
Copy
58
0.16 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 = '110264'
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
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 = '110264'
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 ;
Copy
59
1.89 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
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 ;
Copy