Symfony Profiler

SELECT
  idperson
FROM
  persons
WHERE
  url_clean = 'Anton-Tchekhov'

SELECT idperson FROM persons WHERE url_clean='Anton-Tchekhov' ;

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 = 4308;

SELECT
  COUNT(
    DISTINCT(t.idtext)
  )
FROM
  text_author ta,
  texts t
WHERE
  t.idtext = ta.idtext
  AND t.textfictif = 0
  AND ta.idperson = 4308
  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=4308 AND t.publish=1 AND t.type IN (0,2) ;

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 = 4308
  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=4308 AND t.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 = 4308
  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=4308
                AND sp.idrole=1 AND s.publish=1;

SELECT
  fr
FROM
  countries
WHERE
  id = 'RU'

SELECT fr FROM countries WHERE id='RU';

SELECT
  fr
FROM
  languages
WHERE
  id = 'ru'

SELECT fr FROM languages WHERE id='ru';

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 = 4308
  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=4308  AND j2.idoffice=1;

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;

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

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 = '4308'
  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='4308'
                   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
  t.`idtext`
FROM
  text_author ta
  JOIN texts t ON ta.`idtext` = t.`idtext`
WHERE
  ta.`idperson` IN (4308)

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

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 (4308)

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 (4308) ;

SELECT
  t.`idtext`
FROM
  text_translator tt
  JOIN texts t ON tt.`idtext` = t.`idtext`
WHERE
  tt.`idperson` IN (4308)

SELECT t.`idtext`
                               FROM text_translator tt
                               JOIN texts t ON tt.`idtext`=t.`idtext`
                               WHERE
                               tt.`idperson` IN (4308) ;

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 (4308)

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 (4308) ;

SELECT
  s.`idspectacle`
FROM
  spectacles s
  LEFT JOIN spectacle_person sp ON sp.`idspectacle` = s.`idspectacle`
  LEFT JOIN text_spectacle ts ON ts.`idspectacle` = s.`idspectacle`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND (
    sp.`idperson` = 4308
    OR ts.`idtext` IN (
      3527,
      3568,
      3570,
      8011,
      8107,
      8130,
      8189,
      8504,
      8581,
      8644,
      9397,
      9398,
      10355,
      10554,
      11659,
      11789,
      19081,
      20689,
      26646,
      30033,
      32754,
      35026,
      35450,
      36432,
      36435,
      41252,
      3554,
      3554,
      3554,
      20688,
      34182,
      18432,
      18472,
      22095,
      26672,
      26699,
      36651,
      44741,
      8108,
      12002,
      19398,
      9581,
      14124,
      15925,
      16816,
      18126,
      23306,
      26699,
      39881,
      43440,
      8506,
      12068,
      12841,
      16031,
      16903,
      17676,
      24652,
      29585,
      30313,
      43584,
      11660,
      15290,
      18410,
      19972,
      24734,
      25792,
      33932,
      42558,
      8645,
      8725,
      9878,
      10950,
      11104,
      14985,
      20554,
      20688,
      22074,
      30915,
      34177,
      35025,
      36407,
      44105,
      9531,
      18162,
      19398,
      20688,
      23306,
      34427,
      44102,
      20688,
      23611,
      34427,
      35064,
      10356,
      18454,
      19737,
      22476,
      26019,
      30448,
      30791,
      30917,
      11660,
      23306,
      42558,
      11790,
      27781,
      19082,
      20688,
      26650,
      32755,
      35027,
      41253,
      3529,
      3569,
      18009,
      10990,
      24746,
      8131,
      31251,
      37654,
      8190,
      36431,
      8582,
      18727,
      43254,
      9017,
      9683,
      10078,
      12083,
      18958,
      43600,
      9399,
      30032,
      9400,
      30031,
      10556,
      16715,
      31836,
      42805,
      39885,
      24745,
      36434,
      30034,
      35451,
      36433,
      36436,
      41501,
      41702
    )
  )

SELECT s.`idspectacle`
                               FROM spectacles s
                               LEFT JOIN spectacle_person sp ON sp.`idspectacle`=s.`idspectacle`
                               LEFT JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle`
                               WHERE s.`publish`=1 AND s.`valid`=1
                               AND (sp.`idperson`=4308 OR ts.`idtext` IN (3527,3568,3570,8011,8107,8130,8189,8504,8581,8644,9397,9398,10355,10554,11659,11789,19081,20689,26646,30033,32754,35026,35450,36432,36435,41252,3554,3554,3554,20688,34182,18432,18472,22095,26672,26699,36651,44741,8108,12002,19398,9581,14124,15925,16816,18126,23306,26699,39881,43440,8506,12068,12841,16031,16903,17676,24652,29585,30313,43584,11660,15290,18410,19972,24734,25792,33932,42558,8645,8725,9878,10950,11104,14985,20554,20688,22074,30915,34177,35025,36407,44105,9531,18162,19398,20688,23306,34427,44102,20688,23611,34427,35064,10356,18454,19737,22476,26019,30448,30791,30917,11660,23306,42558,11790,27781,19082,20688,26650,32755,35027,41253,3529,3569,18009,10990,24746,8131,31251,37654,8190,36431,8582,18727,43254,9017,9683,10078,12083,18958,43600,9399,30032,9400,30031,10556,16715,31836,42805,39885,24745,36434,30034,35451,36433,36436,41501,41702) );

SELECT
  DISTINCT(multimedias.idmultimedia)
FROM
  `object_multimedia`,
  `multimedias`
WHERE
  1
  AND object_multimedia.`idrole` = 25
  AND multimedias.`publish` = 1
  AND object_multimedia.`object` = 'persons'
  AND object_multimedia.`idobject` = 4308
  AND multimedias.`idmultimedia` = object_multimedia.`idmultimedia`
GROUP BY
  multimedias.idmultimedia
ORDER BY
  multimedias.dateinsert DESC
LIMIT
  0, 10

SELECT  DISTINCT(multimedias.idmultimedia) 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1 AND object_multimedia.`idrole`=25  AND multimedias.`publish`=1  AND object_multimedia.`object`='persons'  AND object_multimedia.`idobject`=4308 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.dateinsert 
DESC 
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 (
    795,
    1747,
    5334,
    5386,
    5407,
    5582,
    5650,
    5784,
    5843,
    6106,
    6206,
    6251,
    6416,
    6502,
    6544,
    6584,
    6668,
    6672,
    6892,
    6938,
    7037,
    7094,
    7304,
    7441,
    7846,
    7881,
    7985,
    8347,
    8421,
    8540,
    8743,
    8803,
    8815,
    8819,
    9517,
    10324,
    10351,
    10536,
    10578,
    10723,
    10815,
    10918,
    10931,
    11400,
    11660,
    11688,
    12168,
    12199,
    12522,
    12994,
    13073,
    13126,
    13367,
    13630,
    13633,
    13828,
    13830,
    14135,
    14137,
    14167,
    14370,
    14393,
    14399,
    14421,
    14588,
    14606,
    14861,
    14998,
    15277,
    15297,
    15579,
    15637,
    15810,
    15861,
    16206,
    16373,
    17131,
    17507,
    17520,
    17524,
    17867,
    17953,
    18309,
    18754,
    18892,
    19518,
    19592,
    19597,
    19680,
    20106,
    20574,
    20715,
    20922,
    21219,
    21331,
    21351,
    21390,
    21527,
    21958,
    22264,
    23894,
    24218,
    24490,
    24572,
    24859,
    24950,
    25275,
    25614,
    25715,
    26080,
    26246,
    26440,
    26548,
    26931,
    26976,
    27319,
    27439,
    27560,
    27565,
    27808,
    28066,
    28188,
    28298,
    28303,
    28351,
    29395,
    29403,
    30650,
    30696,
    31334,
    31405,
    31459,
    32519,
    32557,
    32795,
    33116,
    33402,
    34296,
    34529,
    34676,
    34938,
    35090,
    35261,
    35279,
    35784,
    35785,
    36240
  )

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 (795,1747,5334,5386,5407,5582,5650,5784,5843,6106,6206,6251,6416,6502,6544,6584,6668,6672,6892,6938,7037,7094,7304,7441,7846,7881,7985,8347,8421,8540,8743,8803,8815,8819,9517,10324,10351,10536,10578,10723,10815,10918,10931,11400,11660,11688,12168,12199,12522,12994,13073,13126,13367,13630,13633,13828,13830,14135,14137,14167,14370,14393,14399,14421,14588,14606,14861,14998,15277,15297,15579,15637,15810,15861,16206,16373,17131,17507,17520,17524,17867,17953,18309,18754,18892,19518,19592,19597,19680,20106,20574,20715,20922,21219,21331,21351,21390,21527,21958,22264,23894,24218,24490,24572,24859,24950,25275,25614,25715,26080,26246,26440,26548,26931,26976,27319,27439,27560,27565,27808,28066,28188,28298,28303,28351,29395,29403,30650,30696,31334,31405,31459,32519,32557,32795,33116,33402,34296,34529,34676,34938,35090,35261,35279,35784,35785,36240) ;

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

SELECT
  COUNT(
    DISTINCT(t.idtext)
  )
FROM
  text_traduction tt,
  texts t
  LEFT OUTER JOIN contacts ON contacts.idcontact = t.idcontact_publisher
WHERE
  1
  AND tt.idtexttraduction = t.idtext
  AND t.publish = 1
  AND tt.idtext IN (
    SELECT
      idtext
    FROM
      text_author
    WHERE
      idperson = 4308
  )

SELECT COUNT(DISTINCT(t.idtext))
                        FROM text_traduction tt, texts t
                        LEFT OUTER JOIN contacts ON contacts.idcontact=t.idcontact_publisher
                        WHERE 1
                        AND tt.idtexttraduction=t.idtext
                        AND t.publish=1
                        AND tt.idtext IN (
                            SELECT idtext
                            FROM text_author
                            WHERE idperson=4308
                        )
            ;

SELECT
  DISTINCT(t.idtext),
  c.organisation,
  c.url_clean as url_clean_publisher,
  c.country as publisher_country,
  CONCAT_WS(
    '-', t.publication_year, t.publication_month,
    '01'
  ) as datepublication,
  t.*
FROM
  text_traduction tt,
  texts t
  LEFT OUTER JOIN contacts c ON c.idcontact = t.idcontact_publisher
WHERE
  1
  AND tt.idtexttraduction = t.idtext
  AND t.publish = 1
  AND tt.idtext IN (
    SELECT
      idtext
    FROM
      text_author
    WHERE
      idperson = 4308
  )
ORDER BY
  date DESC
LIMIT
  20, 20

SELECT DISTINCT(t.idtext),c.organisation,
                         c.url_clean as url_clean_publisher, c.country as publisher_country,
                         CONCAT_WS('-',t.publication_year,t.publication_month,'01') as datepublication,
    		             t.*
		    FROM text_traduction tt, texts t
		    LEFT OUTER JOIN contacts c ON c.idcontact=t.idcontact_publisher WHERE 1
        AND tt.idtexttraduction=t.idtext
        AND t.publish=1
        AND tt.idtext IN (
            SELECT idtext
            FROM text_author
            WHERE idperson=4308
        )ORDER BY date DESC  LIMIT 20, 20;

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

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

SELECT
  t.idtext,
  t.title,
  t.type,
  t.language,
  t.date,
  t.url_clean
FROM
  texts t,
  text_traduction tt
WHERE
  t.idtext = tt.idtext
  AND tt.idtexttraduction = 24746
ORDER BY
  t.title

SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
                  FROM texts t, text_traduction tt
                  WHERE t.idtext=tt.idtext
                  AND tt.idtexttraduction=24746
                  ORDER BY t.title;

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