Symfony Profiler

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 = 7460
  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=7460
                    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 = 7116
  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=7116
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 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 = 16238
  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=16238
                    AND object_multimedia.object='texts' 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 = 12725
  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=12725
                    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 = 12725
  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=12725
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;

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 = '12725';

SELECT
  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 = 21498
  AND cc.idclassification = 101
LIMIT
  1

SELECT 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=21498 AND cc.idclassification=101 LIMIT 1;

SELECT
  *
FROM
  multimedias
WHERE
  idmultimedia IN (
    7460, 8331, 16238, 2813, 3915, 12724
  )

SELECT * FROM multimedias
                    WHERE idmultimedia IN (7460,8331,16238,2813,3915,12724);

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 = 16238
  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=16238
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;

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 = 21498
  AND r.type_creator = 1
ORDER BY
  sp.`classement`

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=21498  AND r.type_creator=1 ORDER BY sp.`classement` ;

SELECT
  DISTINCT(cl.type)
FROM
  classifications cl
WHERE
  (
    (
      cl.classification IN ('class_affiche_spec')
    )
  )
  AND spectacles = 1

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_affiche_spec'))) AND spectacles=1;

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 = 3915
  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=3915
                    AND object_multimedia.object='texts' 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 = 3915
  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=3915
                    AND object_multimedia.object='spectacles' 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 = 8331
  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=8331
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;

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

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

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 = '21498'
  AND of.object = 'spectacles'
  AND cl.idclassification = fc.idclassification
  AND (
    (
      cl.classification IN ('class_affiche_spec')
    )
  )
  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='21498'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_affiche_spec'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  DISTINCT(multimedias.idmultimedia),
  multimedias.*
FROM
  `object_multimedia`,
  `multimedias`
WHERE
  1
  AND multimedias.`publish` = 1
  AND object_multimedia.`object` = 'spectacles'
  AND object_multimedia.`idobject` = 21498
  AND multimedias.`idmultimedia` = object_multimedia.`idmultimedia`
GROUP BY
  multimedias.idmultimedia
ORDER BY
  multimedias.dateinsert DESC
LIMIT
  0, 1000

SELECT  DISTINCT(multimedias.idmultimedia), multimedias.* 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1  AND multimedias.`publish`=1  AND object_multimedia.`object`='spectacles'  AND object_multimedia.`idobject`=21498 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.dateinsert 
DESC 
LIMIT 0,1000;

SELECT
  object_multimedia.object,
  object_multimedia.idobject
FROM
  object_multimedia
WHERE
  1
  AND idmultimedia = 12725
  AND object_multimedia.idrole = 22
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=12725 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 = 12724
  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=12724
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;

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 = '21498'
  AND oc.object = 'spectacles'
  AND cl.idclassification = cc.idclassification
  AND c.publish = 1
  AND c.valid = 1
  AND (
    (
      cl.classification IN ('class_critique')
    )
  )

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='21498'
                   AND oc.object='spectacles'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND c.valid=1  AND ((cl.classification IN ('class_critique')));

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 = 3915
  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=3915
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;

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

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;

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 = 7460
  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=7460
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;

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 = '21498'
  AND of.object = 'spectacles'
  AND cl.idclassification = fc.idclassification
  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='21498'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification 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;