Symfony Profiler

SELECT
  idperson
FROM
  persons
WHERE
  url_clean = 'Olivier-Py'

SELECT idperson FROM persons WHERE url_clean='Olivier-Py' ;

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

SELECT
  COUNT(
    DISTINCT(t.idtext)
  )
FROM
  text_author ta,
  texts t
WHERE
  t.idtext = ta.idtext
  AND t.textfictif = 0
  AND ta.idperson = 24
  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=24 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 = 24
  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=24 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 = 24
  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=24
                AND sp.idrole=1 AND s.publish=1;

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

SELECT
  fr
FROM
  languages
WHERE
  id = 'fr'

SELECT fr FROM languages WHERE id='fr';

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 = 24
  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=24  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 = '24'
  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='24'
                   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
  j1.idclassification,
  j1.classification,
  j1.type,
  j1.idgroupclassification,
  j3.idcontent
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.content_classification j2,
  theatreok_dev.contents j3
WHERE
  j3.idcontent = j2.idcontent
  AND j1.idclassification = j2.idclassification
  AND j3.idcontent = 54767

SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=54767;

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 = '24'
  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='24'
                   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 (24)

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

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

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

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

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

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

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

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` = 24
    OR ts.`idtext` IN (
      225, 463, 1304, 1538, 1545, 1546, 1547,
      2450, 2484, 2486, 3009, 3253, 3366,
      3409, 4470, 4575, 4576, 4577, 4578,
      4579, 5215, 5669, 6414, 7462, 7505,
      8072, 8431, 8522, 8646, 8722, 9030,
      11520, 12718, 13553, 15182, 16546,
      16548, 25625, 26039, 28295, 29366,
      32842, 33076, 36103, 36455, 37560,
      37789, 37790, 37791, 41262, 41265,
      45320, 16548, 7960, 7977, 10473, 10477,
      10478, 10479, 18674, 36457, 226, 462,
      464, 1305, 1345, 1389, 1400, 7506
    )
  )

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`=24 OR ts.`idtext` IN (225,463,1304,1538,1545,1546,1547,2450,2484,2486,3009,3253,3366,3409,4470,4575,4576,4577,4578,4579,5215,5669,6414,7462,7505,8072,8431,8522,8646,8722,9030,11520,12718,13553,15182,16546,16548,25625,26039,28295,29366,32842,33076,36103,36455,37560,37789,37790,37791,41262,41265,45320,16548,7960,7977,10473,10477,10478,10479,18674,36457,226,462,464,1305,1345,1389,1400,7506) );

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 (
    76, 277, 585, 760, 1172, 1178, 1179, 1180,
    1487, 1970, 2002, 2003, 2004, 2005,
    2194, 2420, 2675, 2756, 3511, 3703,
    3772, 3773, 3774, 4073, 4524, 5126,
    5303, 5313, 5356, 5758, 5837, 8094,
    9404, 9596, 10150, 11498, 12833, 13063,
    14609, 16638, 17476, 18150, 18344,
    20724, 20758, 23694, 23720, 26495,
    26533, 29223, 29224, 31032, 33119,
    33184, 33490, 34204, 37073
  )

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 (76,277,585,760,1172,1178,1179,1180,1487,1970,2002,2003,2004,2005,2194,2420,2675,2756,3511,3703,3772,3773,3774,4073,4524,5126,5303,5313,5356,5758,5837,8094,9404,9596,10150,11498,12833,13063,14609,16638,17476,18150,18344,20724,20758,23694,23720,26495,26533,29223,29224,31032,33119,33184,33490,34204,37073) ;

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 = 24
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=24
                GROUP BY r.idrole ;

SELECT
  COUNT(
    DISTINCT (s0_.idspectacle)
  ) AS sclr_0,
  MIN(s1_.date) AS sclr_1
FROM
  spectacles s0_
  LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle
  LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext
  LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle
  LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle
  LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle
  LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson
  INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact
WHERE
  s1_.idspectacle = s0_.idspectacle
  AND (
    s1_.idcontact = c7_.idcontact
    OR s1_.idcontact_festival = c7_.idcontact
  )
  AND t2_.idtext IN (
    225, 463, 1304, 1538, 1545, 1546, 1547,
    2450, 2484, 2486, 3009, 3253, 3366,
    3409, 4470, 4575, 4576, 4577, 4578,
    4579, 5215, 5669, 6414, 7462, 7505,
    8072, 8431, 8522, 8646, 8722, 9030,
    11520, 12718, 13553, 15182, 16546,
    16548, 25625, 26039, 28295, 29366,
    32842, 33076, 36103, 36455, 37560,
    37789, 37790, 37791, 41262, 41265,
    45320, 16548, 7960, 7977, 10473, 10477,
    10478, 10479, 18674, 36457, 226, 462,
    464, 1305, 1345, 1389, 1400, 7506
  )
ORDER BY
  s1_.date ASC

SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND t2_.idtext IN (225, 463, 1304, 1538, 1545, 1546, 1547, 2450, 2484, 2486, 3009, 3253, 3366, 3409, 4470, 4575, 4576, 4577, 4578, 4579, 5215, 5669, 6414, 7462, 7505, 8072, 8431, 8522, 8646, 8722, 9030, 11520, 12718, 13553, 15182, 16546, 16548, 25625, 26039, 28295, 29366, 32842, 33076, 36103, 36455, 37560, 37789, 37790, 37791, 41262, 41265, 45320, 16548, 7960, 7977, 10473, 10477, 10478, 10479, 18674, 36457, 226, 462, 464, 1305, 1345, 1389, 1400, 7506) ORDER BY s1_.date ASC;

SELECT
  schedules.`date`,
  YEAR(schedules.`date`) as annee
FROM
  schedules,
  spectacles
WHERE
  schedules.`idspectacle` = spectacles.`idspectacle`
  AND spectacles.`publish` = 1
  AND schedules.`idspectacle` IN (
    76, 277, 585, 760, 1172, 1178, 1179, 1180,
    1487, 1970, 2002, 2003, 2004, 2005,
    2194, 2420, 2675, 2756, 3511, 3703,
    3772, 3773, 3774, 4073, 4524, 5126,
    5303, 5313, 5356, 5758, 5837, 8094,
    9404, 9596, 10150, 11498, 12833, 13063,
    14609, 16638, 17476, 18150, 18344,
    20724, 20758, 23694, 23720, 26495,
    26533, 29223, 29224, 31032, 33119,
    33184, 33490, 34204, 37073
  )
ORDER BY
  schedules.`date`

SELECT schedules.`date`, YEAR(schedules.`date`) as annee
            FROM schedules, spectacles
            WHERE schedules.`idspectacle`=spectacles.`idspectacle`
            AND spectacles.`publish`=1
            AND schedules.`idspectacle` IN (76,277,585,760,1172,1178,1179,1180,1487,1970,2002,2003,2004,2005,2194,2420,2675,2756,3511,3703,3772,3773,3774,4073,4524,5126,5303,5313,5356,5758,5837,8094,9404,9596,10150,11498,12833,13063,14609,16638,17476,18150,18344,20724,20758,23694,23720,26495,26533,29223,29224,31032,33119,33184,33490,34204,37073)
            ORDER BY schedules.`date`;

SELECT
  COUNT(
    DISTINCT (s0_.idspectacle)
  ) AS sclr_0,
  MIN(s1_.date) AS sclr_1
FROM
  spectacles s0_
  LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle
  LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext
  LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle
  LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle
  LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle
  LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson
  INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact
WHERE
  s1_.idspectacle = s0_.idspectacle
  AND (
    s1_.idcontact = c7_.idcontact
    OR s1_.idcontact_festival = c7_.idcontact
  )
  AND s0_.idspectacle IN (
    76, 277, 585, 760, 1172, 1178, 1179, 1180,
    1487, 1970, 2002, 2003, 2004, 2005,
    2194, 2420, 2675, 2756, 3511, 3703,
    3772, 3773, 3774, 4073, 4524, 5126,
    5303, 5313, 5356, 5758, 5837, 8094,
    9404, 9596, 10150, 11498, 12833, 13063,
    14609, 16638, 17476, 18150, 18344,
    20724, 20758, 23694, 23720, 26495,
    26533, 29223, 29224, 31032, 33119,
    33184, 33490, 34204, 37073
  )
ORDER BY
  sclr_1 DESC

SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s0_.idspectacle IN (76, 277, 585, 760, 1172, 1178, 1179, 1180, 1487, 1970, 2002, 2003, 2004, 2005, 2194, 2420, 2675, 2756, 3511, 3703, 3772, 3773, 3774, 4073, 4524, 5126, 5303, 5313, 5356, 5758, 5837, 8094, 9404, 9596, 10150, 11498, 12833, 13063, 14609, 16638, 17476, 18150, 18344, 20724, 20758, 23694, 23720, 26495, 26533, 29223, 29224, 31032, 33119, 33184, 33490, 34204, 37073) ORDER BY sclr_1 DESC;