Symfony Profiler

SELECT
  a.idannonce,
  a.dateinsert,
  a.sujet,
  c.url_clean,
  c.name,
  c.idcategorie
FROM
  ann_annonces a,
  ann_categories c
WHERE
  c.idcategorie = a.idcategorie
  AND a.online = 1
  AND a.valid = 1
  AND c.idcategorie IN (3)
ORDER BY
  a.dateinsert DESC
LIMIT
  0, 3

SELECT a.idannonce,a.dateinsert,a.sujet,c.url_clean, c.name,c.idcategorie
                FROM ann_annonces a, ann_categories c
                WHERE c.idcategorie=a.idcategorie AND a.online=1 AND a.valid=1  AND c.idcategorie IN (3)  ORDER BY a.dateinsert DESC LIMIT 0,3;

SELECT
  a.idannonce,
  a.dateinsert,
  a.sujet,
  c.url_clean,
  c.name,
  c.idcategorie
FROM
  ann_annonces a,
  ann_categories c
WHERE
  c.idcategorie = a.idcategorie
  AND a.online = 1
  AND a.valid = 1
  AND c.idcategorie IN (1)
ORDER BY
  a.dateinsert DESC
LIMIT
  0, 3

SELECT a.idannonce,a.dateinsert,a.sujet,c.url_clean, c.name,c.idcategorie
                FROM ann_annonces a, ann_categories c
                WHERE c.idcategorie=a.idcategorie AND a.online=1 AND a.valid=1  AND c.idcategorie IN (1)  ORDER BY a.dateinsert DESC LIMIT 0,3;

SELECT
  COUNT(*)
FROM
  information_schema.VIEWS
WHERE
  TABLE_SCHEMA = 'statistiques'
  AND TABLE_NAME = '20240425_days1'

SELECT COUNT(*)
                FROM information_schema.VIEWS 
                WHERE TABLE_SCHEMA = 'statistiques' 
                AND TABLE_NAME = '20240425_days1' ;

SELECT
  idmultimedia,
  COUNT(idmultimedia) as views
FROM
  statistiques.20240425_days1
WHERE
  idmultimedia NOT IN (
    5126, 6056, 11808, 11863, 11868, 11899,
    11895, 11897, 11901, 2024
  )
GROUP BY
  idmultimedia
ORDER BY
  COUNT(idmultimedia) DESC
LIMIT
  0, 4

SELECT idmultimedia, COUNT(idmultimedia) as views
                FROM statistiques.20240425_days1 WHERE idmultimedia NOT IN (5126,6056,11808,11863,11868,11899,11895,11897,11901,2024) GROUP BY idmultimedia
                ORDER BY COUNT(idmultimedia) DESC
                LIMIT 0,4;

SELECT
  DISTINCT(multimedias.idmultimedia),
  multimedias.*
FROM
  `multimedias`
WHERE
  1
  AND multimedias.`idmultimedia` IN (3367)
  AND multimedias.`publish` = 1
GROUP BY
  multimedias.idmultimedia
ORDER BY
  FIELD(
    multimedias.`idmultimedia`, 3367
  )
LIMIT
  0, 4

SELECT  DISTINCT(multimedias.idmultimedia), multimedias.* 
FROM  `multimedias`  
 WHERE 1  AND multimedias.`idmultimedia` IN (3367)  AND multimedias.`publish`=1 
GROUP BY multimedias.idmultimedia 
ORDER BY FIELD(multimedias.`idmultimedia`,3367) 
  
LIMIT 0,4;

SELECT
  m0_.idmultimedia AS idmultimedia_0,
  m0_.idsupport AS idsupport_1,
  m0_.publish AS publish_2,
  m0_.status AS status_3,
  m0_.policy_access AS policy_access_4,
  m0_.support AS support_5,
  m0_.evenement AS evenement_6,
  m0_.sujet_titre AS sujet_titre_7,
  m0_.language AS language_8,
  m0_.markdown AS markdown_9,
  m0_.duree AS duree_10,
  m0_.date AS date_11,
  m0_.lieu AS lieu_12,
  m0_.particip_comed AS particip_comed_13,
  m0_.description AS description_14,
  m0_.use_cloud AS use_cloud_15,
  m0_.type_streaming AS type_streaming_16,
  m0_.mp3 AS mp3_17,
  m0_.hd2160 AS hd2160_18,
  m0_.hd1080 AS hd1080_19,
  m0_.upload AS upload_20,
  m0_.hd720 AS hd720_21,
  m0_.h264m AS h264m_22,
  m0_.h264 AS h264_23,
  m0_.flv AS flv_24,
  m0_.flv_width AS flv_width_25,
  m0_.flv_height AS flv_height_26,
  m0_.duree_site AS duree_site_27,
  m0_.duree_site_sec AS duree_site_sec_28,
  m0_.audio_video AS audio_video_29,
  m0_.filmeur AS filmeur_30,
  m0_.copyright AS copyright_31,
  m0_.etalab AS etalab_32,
  m0_.mots AS mots_33,
  m0_.tags AS tags_34,
  m0_.quality AS quality_35,
  m0_.url_clean AS url_clean_36,
  m0_.code AS code_37,
  m0_.fichier_local AS fichier_local_38,
  m0_.note_extranet AS note_extranet_39,
  m0_.note_extranetuser AS note_extranetuser_40,
  m0_.video_tete AS video_tete_41,
  m0_.avignondate AS avignondate_42,
  m0_.heywatch AS heywatch_43,
  m0_.is_coconut AS is_coconut_44,
  m0_.price AS price_45,
  m0_.count_view AS count_view_46,
  m0_.dateupdate AS dateupdate_47,
  m0_.dateinsert AS dateinsert_48,
  m0_.traite_comed AS traite_comed_49,
  m0_.traite_format AS traite_format_50,
  m0_.conversion_local AS conversion_local_51,
  m0_.idextranetuser_producteur AS idextranetuser_producteur_52,
  m0_.type AS type_53,
  m0_.idextranetuser AS idextranetuser_54,
  m0_.idcontact_producteur AS idcontact_producteur_55
FROM
  multimedias m0_
WHERE
  m0_.idmultimedia = ?

SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = '3367';

SELECT
  object_multimedia.object,
  object_multimedia.idobject,
  persons.idperson,
  persons.lastname,
  persons.firstname,
  persons.url_clean
FROM
  object_multimedia,
  persons
WHERE
  object_multimedia.idobject = persons.idperson
  AND object_multimedia.idmultimedia = 3367
  AND object_multimedia.object = 'persons'
  AND object_multimedia.idrole = 21
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3367
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;

SELECT
  object_multimedia.object,
  object_multimedia.idobject,
  persons.idperson,
  persons.lastname,
  persons.firstname,
  persons.url_clean
FROM
  object_multimedia,
  persons
WHERE
  object_multimedia.idobject = persons.idperson
  AND object_multimedia.idmultimedia = 3367
  AND object_multimedia.object = 'persons'
  AND object_multimedia.idrole = 1
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3367
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;

SELECT
  object_multimedia.object,
  object_multimedia.idobject,
  persons.idperson,
  persons.lastname,
  persons.firstname,
  persons.url_clean
FROM
  object_multimedia,
  persons
WHERE
  object_multimedia.idobject = persons.idperson
  AND object_multimedia.idmultimedia = 3367
  AND object_multimedia.object = 'persons'
  AND object_multimedia.idrole = 5
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3367
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;

SELECT
  object_multimedia.object,
  object_multimedia.idobject,
  persons.idperson,
  persons.lastname,
  persons.firstname,
  persons.url_clean
FROM
  object_multimedia,
  persons
WHERE
  object_multimedia.idobject = persons.idperson
  AND object_multimedia.idmultimedia = 3367
  AND object_multimedia.object = 'persons'
  AND object_multimedia.idrole = 25
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3367
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;

SELECT
  object_multimedia.object,
  object_multimedia.idobject,
  contacts.idcontact,
  contacts.type,
  contacts.organisation,
  contacts.url_clean,
  contacts.link_on_video
FROM
  object_multimedia,
  contacts
WHERE
  object_multimedia.idobject = contacts.idcontact
  AND object_multimedia.idmultimedia = 3367
  AND object_multimedia.object = 'contacts'
  AND object_multimedia.idrole = 22
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=3367
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;

SELECT
  object_multimedia.object,
  object_multimedia.idobject,
  contacts.idcontact,
  contacts.type,
  contacts.organisation,
  contacts.url_clean,
  contacts.link_on_video
FROM
  object_multimedia,
  contacts
WHERE
  object_multimedia.idobject = contacts.idcontact
  AND object_multimedia.idmultimedia = 3367
  AND object_multimedia.object = 'contacts'
  AND object_multimedia.idrole = 23
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=3367
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;

SELECT
  object_multimedia.object,
  object_multimedia.idobject,
  spectacles.idspectacle,
  spectacles.title,
  spectacles.url_clean,
  spectacles.idtypespectacle
FROM
  object_multimedia,
  spectacles
WHERE
  object_multimedia.idobject = spectacles.idspectacle
  AND object_multimedia.idmultimedia = 3367
  AND object_multimedia.object = 'spectacles'
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=3367
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;

SELECT
  idspectacle,
  title,
  url_clean,
  valid
FROM
  spectacles
WHERE
  idspectacle = 5984

SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=5984;

SELECT
  t.title
FROM
  texts t,
  text_spectacle ts
WHERE
  t.idtext = ts.idtext
  AND ts.idspectacle = 5984

SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=5984;

SELECT
  object_multimedia.object,
  object_multimedia.idobject,
  texts.idtext,
  texts.title,
  texts.url_clean,
  texts.textfictif,
  texts.valid
FROM
  object_multimedia,
  texts
WHERE
  object_multimedia.idobject = texts.idtext
  AND object_multimedia.idmultimedia = 3367
  AND object_multimedia.object = 'texts'
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=3367
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;

SELECT
  DISTINCT(keywords.idkeyword),
  keywords.*
FROM
  `multimedia_keyword`,
  `keywords`
WHERE
  1
  AND keywords.`publish` = 1
  AND multimedia_keyword.`idmultimedia` = 3367
  AND keywords.`idkeyword` = multimedia_keyword.`idkeyword`
GROUP BY
  keywords.idkeyword
ORDER BY
  keywords.dateinsert DESC
LIMIT
  0, 10

SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=3367 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10;

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

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;

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;

SELECT
  t0_.type AS type_0
FROM
  texts t0_
WHERE
  t0_.idtext = ?

SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = 10517;

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 = 10517
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=10517  ORDER BY j2.classement ASC;

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 = 7418
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=7418  ORDER BY p.`lastname` ;

SELECT
  MIN(s0_.date) AS sclr_0,
  MAX(s0_.date) AS sclr_1,
  DATEDIFF('2024-04-25', s0_.date) AS sclr_2,
  ABS(
    DATEDIFF('2024-04-25', 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-25', s0_.date) AS sclr_2, ABS(DATEDIFF('2024-04-25', 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 = 7418 GROUP BY s0_.idcontact ORDER BY sclr_2 ASC, sclr_3 ASC LIMIT 1;

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;

SELECT
  t0_.type AS type_0
FROM
  texts t0_
WHERE
  t0_.idtext = ?

SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = 35903;