Symfony Profiler

SELECT
  DISTINCT 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` = 8914
    OR ts.`idtext` IN (
      9592, 15281, 21116, 24875, 29795, 32687,
      39575, 40032
    )
  )

SELECT DISTINCT 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`=8914 OR ts.`idtext` IN (9592,15281,21116,24875,29795,32687,39575,40032 ) );

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 (
    711, 6395, 6595, 6668, 6672, 7727, 8347,
    10324, 11685, 13519, 14805, 16812,
    18803, 19821, 26202, 26997, 31872,
    32158
  )

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 (711,6395,6595,6668,6672,7727,8347,10324,11685,13519,14805,16812,18803,19821,26202,26997,31872,32158) ;

INSERT INTO stats (
  type, module, url, md5url, idcontent,
  object, idobject, video, lng, remote_addr,
  source
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES ('article', 'thnet', '/spectacles/J-ai-une-grande-vitalite-comme-un-requin-du-Groenland/biographies/', '36833762ddc767034d4ec54d5a8de5e5', 0, 'spectacles', 31872, 0, 'fr', '5a71c34bb740d99188a92a74d9a9cf08-9e06', '/home/web/theatre-contemporain.net/dev/src/Controller/SpectacleController.php:518');

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 = '41324'
  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='41324'
                   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
  DISTINCT(T1.`idtext`),
  T1.`title`,
  T1.`url_clean`,
  T1.`publication_year`,
  T1.`publication_month`,
  T1.`isbn`,
  T1.`textfictif`,
  T1.`dateinsert`,
  T1.`textorder`,
  T1.`type`,
  T1.`publish`,
  T1.`statut`,
  T1.`valid`,
  T2.`idcontact`,
  T2.`url_clean` as `url_clean_publisher`,
  T2.`organisation`,
  CONCAT(
    T1.`publication_year`, T1.`publication_month`
  ) AS publication_date,
  CAST(
    CONCAT(
      T1.`publication_year`, T1.`publication_month`
    ) AS DATE
  ) AS publication_date_full
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`,
  object_content oc2,
  contents c2,
  content_classification cc2
WHERE
  1
  AND oc2.idcontent = c2.idcontent
  AND cc2.idcontent = c2.idcontent
  AND oc2.idobject = T1.idtext
  AND cc2.idclassification IN (125)
  AND oc2.object = 'texts'
  AND T1.`idtext` IN (
    9592, 15281, 21116, 24875, 29795, 32687,
    39575, 40032
  )
GROUP BY
  T1.idtext
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC
LIMIT
  0, 10

SELECT DISTINCT(T1.`idtext`), T1.`title`,T1.`url_clean`,T1.`publication_year`,T1.`publication_month`,T1.`isbn`,T1.`textfictif`,T1.`dateinsert`,T1.`textorder`,T1.`type`,T1.`publish`,T1.`statut`,T1.`valid`,T2.`idcontact`,T2.`url_clean` as `url_clean_publisher`,T2.`organisation`,
                        CONCAT(T1.`publication_year`, T1.`publication_month`) AS publication_date,
                        CAST(CONCAT(T1.`publication_year`, T1.`publication_month`) AS DATE) AS publication_date_full  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  ,object_content oc2, contents c2, content_classification cc2  WHERE 1  AND oc2.idcontent=c2.idcontent
                            AND cc2.idcontent=c2.idcontent
                            AND oc2.idobject=T1.idtext
                            AND cc2.idclassification IN (125)
                            AND oc2.object='texts'  AND T1.`idtext` IN (9592,15281,21116,24875,29795,32687,39575,40032)  GROUP BY T1.idtext  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC LIMIT 0,10;

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 (
    8312, 9050, 11317, 14680, 19699, 19821,
    21970, 23796, 26080, 28733, 29977,
    31114, 31872, 32158, 33451
  )

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 (8312,9050,11317,14680,19699,19821,21970,23796,26080,28733,29977,31114,31872,32158,33451) ;

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 = '80884'
  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='80884'
                   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 = '31872'
  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='31872'
                   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
  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
  s0_.idspectacle AS idspectacle_0,
  s0_.title AS title_1,
  s0_.language AS language_2,
  s0_.creation_date AS creation_date_3,
  s0_.url_page AS url_page_4,
  s0_.infos AS infos_5,
  s0_.tag AS tag_6,
  s0_.id_rubrique AS id_rubrique_7,
  s0_.duration AS duration_8,
  s0_.interlude AS interlude_9,
  s0_.textfictif AS textfictif_10,
  s0_.url_redirect AS url_redirect_11,
  s0_.url_clean AS url_clean_12,
  s0_.dateupdate AS dateupdate_13,
  s0_.dateinsert AS dateinsert_14,
  s0_.publish AS publish_15,
  s0_.statut AS statut_16,
  s0_.valid AS valid_17,
  t1_.idtypespectacle AS idtypespectacle_18,
  c2_.idcontact AS idcontact_19,
  c2_.type AS type_20,
  c2_.organisation AS organisation_21,
  c2_.nom_suite AS nom_suite_22,
  c2_.lastname AS lastname_23,
  c2_.firstname AS firstname_24,
  c2_.idtypestructure AS idtypestructure_25,
  c2_.license AS license_26,
  c2_.comment AS comment_27,
  c2_.private_comment AS private_comment_28,
  c2_.address1 AS address1_29,
  c2_.address2 AS address2_30,
  c2_.zip AS zip_31,
  c2_.city AS city_32,
  c2_.phone1 AS phone1_33,
  c2_.phone2 AS phone2_34,
  c2_.fax AS fax_35,
  c2_.email1 AS email1_36,
  c2_.email1_online AS email1_online_37,
  c2_.email2_online AS email2_online_38,
  c2_.email2 AS email2_39,
  c2_.url AS url_40,
  c2_.url_ticket AS url_ticket_41,
  c2_.facebook AS facebook_42,
  c2_.twitter AS twitter_43,
  c2_.instagram AS instagram_44,
  c2_.mobile AS mobile_45,
  c2_.geocodable AS geocodable_46,
  c2_.x AS x_47,
  c2_.y AS y_48,
  c2_.idmultimedia AS idmultimedia_49,
  c2_.type_view AS type_view_50,
  c2_.stats_access AS stats_access_51,
  c2_.ga_tracking_id AS ga_tracking_id_52,
  c2_.is_festival AS is_festival_53,
  c2_.link_on_video AS link_on_video_54,
  c2_.is_partenaire AS is_partenaire_55,
  c2_.valid_version AS valid_version_56,
  c2_.other_versions AS other_versions_57,
  c2_.url_redirect AS url_redirect_58,
  c2_.url_clean AS url_clean_59,
  c2_.dateupdate AS dateupdate_60,
  c2_.dateinsert AS dateinsert_61,
  c2_.publish AS publish_62,
  c2_.valid AS valid_63,
  c3_.idcontact AS idcontact_64,
  c3_.type AS type_65,
  c3_.organisation AS organisation_66,
  c3_.nom_suite AS nom_suite_67,
  c3_.lastname AS lastname_68,
  c3_.firstname AS firstname_69,
  c3_.idtypestructure AS idtypestructure_70,
  c3_.license AS license_71,
  c3_.comment AS comment_72,
  c3_.private_comment AS private_comment_73,
  c3_.address1 AS address1_74,
  c3_.address2 AS address2_75,
  c3_.zip AS zip_76,
  c3_.city AS city_77,
  c3_.phone1 AS phone1_78,
  c3_.phone2 AS phone2_79,
  c3_.fax AS fax_80,
  c3_.email1 AS email1_81,
  c3_.email1_online AS email1_online_82,
  c3_.email2_online AS email2_online_83,
  c3_.email2 AS email2_84,
  c3_.url AS url_85,
  c3_.url_ticket AS url_ticket_86,
  c3_.facebook AS facebook_87,
  c3_.twitter AS twitter_88,
  c3_.instagram AS instagram_89,
  c3_.mobile AS mobile_90,
  c3_.geocodable AS geocodable_91,
  c3_.x AS x_92,
  c3_.y AS y_93,
  c3_.idmultimedia AS idmultimedia_94,
  c3_.type_view AS type_view_95,
  c3_.stats_access AS stats_access_96,
  c3_.ga_tracking_id AS ga_tracking_id_97,
  c3_.is_festival AS is_festival_98,
  c3_.link_on_video AS link_on_video_99,
  c3_.is_partenaire AS is_partenaire_100,
  c3_.valid_version AS valid_version_101,
  c3_.other_versions AS other_versions_102,
  c3_.url_redirect AS url_redirect_103,
  c3_.url_clean AS url_clean_104,
  c3_.dateupdate AS dateupdate_105,
  c3_.dateinsert AS dateinsert_106,
  c3_.publish AS publish_107,
  c3_.valid AS valid_108,
  e4_.idextranetuser AS idextranetuser_109
FROM
  spectacles s0_
  LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle
  LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact
  LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact
  LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser
WHERE
  s0_.idspectacle = ?

SELECT s0_.idspectacle AS idspectacle_0, s0_.title AS title_1, s0_.language AS language_2, s0_.creation_date AS creation_date_3, s0_.url_page AS url_page_4, s0_.infos AS infos_5, s0_.tag AS tag_6, s0_.id_rubrique AS id_rubrique_7, s0_.duration AS duration_8, s0_.interlude AS interlude_9, s0_.textfictif AS textfictif_10, s0_.url_redirect AS url_redirect_11, s0_.url_clean AS url_clean_12, s0_.dateupdate AS dateupdate_13, s0_.dateinsert AS dateinsert_14, s0_.publish AS publish_15, s0_.statut AS statut_16, s0_.valid AS valid_17, t1_.idtypespectacle AS idtypespectacle_18, c2_.idcontact AS idcontact_19, c2_.type AS type_20, c2_.organisation AS organisation_21, c2_.nom_suite AS nom_suite_22, c2_.lastname AS lastname_23, c2_.firstname AS firstname_24, c2_.idtypestructure AS idtypestructure_25, c2_.license AS license_26, c2_.comment AS comment_27, c2_.private_comment AS private_comment_28, c2_.address1 AS address1_29, c2_.address2 AS address2_30, c2_.zip AS zip_31, c2_.city AS city_32, c2_.phone1 AS phone1_33, c2_.phone2 AS phone2_34, c2_.fax AS fax_35, c2_.email1 AS email1_36, c2_.email1_online AS email1_online_37, c2_.email2_online AS email2_online_38, c2_.email2 AS email2_39, c2_.url AS url_40, c2_.url_ticket AS url_ticket_41, c2_.facebook AS facebook_42, c2_.twitter AS twitter_43, c2_.instagram AS instagram_44, c2_.mobile AS mobile_45, c2_.geocodable AS geocodable_46, c2_.x AS x_47, c2_.y AS y_48, c2_.idmultimedia AS idmultimedia_49, c2_.type_view AS type_view_50, c2_.stats_access AS stats_access_51, c2_.ga_tracking_id AS ga_tracking_id_52, c2_.is_festival AS is_festival_53, c2_.link_on_video AS link_on_video_54, c2_.is_partenaire AS is_partenaire_55, c2_.valid_version AS valid_version_56, c2_.other_versions AS other_versions_57, c2_.url_redirect AS url_redirect_58, c2_.url_clean AS url_clean_59, c2_.dateupdate AS dateupdate_60, c2_.dateinsert AS dateinsert_61, c2_.publish AS publish_62, c2_.valid AS valid_63, c3_.idcontact AS idcontact_64, c3_.type AS type_65, c3_.organisation AS organisation_66, c3_.nom_suite AS nom_suite_67, c3_.lastname AS lastname_68, c3_.firstname AS firstname_69, c3_.idtypestructure AS idtypestructure_70, c3_.license AS license_71, c3_.comment AS comment_72, c3_.private_comment AS private_comment_73, c3_.address1 AS address1_74, c3_.address2 AS address2_75, c3_.zip AS zip_76, c3_.city AS city_77, c3_.phone1 AS phone1_78, c3_.phone2 AS phone2_79, c3_.fax AS fax_80, c3_.email1 AS email1_81, c3_.email1_online AS email1_online_82, c3_.email2_online AS email2_online_83, c3_.email2 AS email2_84, c3_.url AS url_85, c3_.url_ticket AS url_ticket_86, c3_.facebook AS facebook_87, c3_.twitter AS twitter_88, c3_.instagram AS instagram_89, c3_.mobile AS mobile_90, c3_.geocodable AS geocodable_91, c3_.x AS x_92, c3_.y AS y_93, c3_.idmultimedia AS idmultimedia_94, c3_.type_view AS type_view_95, c3_.stats_access AS stats_access_96, c3_.ga_tracking_id AS ga_tracking_id_97, c3_.is_festival AS is_festival_98, c3_.link_on_video AS link_on_video_99, c3_.is_partenaire AS is_partenaire_100, c3_.valid_version AS valid_version_101, c3_.other_versions AS other_versions_102, c3_.url_redirect AS url_redirect_103, c3_.url_clean AS url_clean_104, c3_.dateupdate AS dateupdate_105, c3_.dateinsert AS dateinsert_106, c3_.publish AS publish_107, c3_.valid AS valid_108, e4_.idextranetuser AS idextranetuser_109 FROM spectacles s0_ LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser WHERE s0_.idspectacle = '31872';

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 = '32110'
  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='32110'
                   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 = '98511'
  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='98511'
                   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
  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 (
    16021, 17080, 18354, 21648, 28114, 31872
  )

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 (16021,17080,18354,21648,28114,31872) ;

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 = 31872
  AND r.type = 1
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=31872  AND r.type=1 ORDER BY p.`lastname` ;

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 = '98510'
  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='98510'
                   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
  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 = ?

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 = '5a71c34bb740d99188a92a74d9a9cf08-9e06' AND t0.idcontent = 0 AND t0.md5url = '36833762ddc767034d4ec54d5a8de5e5';

SELECT
  t.`idtext`
FROM
  text_author ta
  JOIN texts t ON ta.`idtext` = t.`idtext`
WHERE
  ta.`idperson` IN (32110)

SELECT t.`idtext`
                           FROM text_author ta
                           JOIN texts t ON ta.`idtext`=t.`idtext`
                           WHERE ta.`idperson` IN (32110) ;