Symfony Profiler

SELECT
  idcontact
FROM
  contacts
WHERE
  url_clean = 'Espaces-34-Editions'

SELECT idcontact FROM contacts WHERE url_clean='Espaces-34-Editions' ;

SELECT
  c0_.idcontact AS idcontact_0,
  c0_.type AS type_1,
  c0_.organisation AS organisation_2,
  c0_.nom_suite AS nom_suite_3,
  c0_.lastname AS lastname_4,
  c0_.firstname AS firstname_5,
  c0_.idtypestructure AS idtypestructure_6,
  c0_.license AS license_7,
  c0_.comment AS comment_8,
  c0_.private_comment AS private_comment_9,
  c0_.address1 AS address1_10,
  c0_.address2 AS address2_11,
  c0_.zip AS zip_12,
  c0_.city AS city_13,
  c0_.phone1 AS phone1_14,
  c0_.phone2 AS phone2_15,
  c0_.fax AS fax_16,
  c0_.email1 AS email1_17,
  c0_.email1_online AS email1_online_18,
  c0_.email2_online AS email2_online_19,
  c0_.email2 AS email2_20,
  c0_.url AS url_21,
  c0_.url_ticket AS url_ticket_22,
  c0_.facebook AS facebook_23,
  c0_.twitter AS twitter_24,
  c0_.instagram AS instagram_25,
  c0_.mobile AS mobile_26,
  c0_.geocodable AS geocodable_27,
  c0_.x AS x_28,
  c0_.y AS y_29,
  c0_.idmultimedia AS idmultimedia_30,
  c0_.type_view AS type_view_31,
  c0_.stats_access AS stats_access_32,
  c0_.ga_tracking_id AS ga_tracking_id_33,
  c0_.is_festival AS is_festival_34,
  c0_.link_on_video AS link_on_video_35,
  c0_.is_partenaire AS is_partenaire_36,
  c0_.valid_version AS valid_version_37,
  c0_.other_versions AS other_versions_38,
  c0_.url_redirect AS url_redirect_39,
  c0_.url_clean AS url_clean_40,
  c0_.dateupdate AS dateupdate_41,
  c0_.dateinsert AS dateinsert_42,
  c0_.publish AS publish_43,
  c0_.valid AS valid_44,
  c1_.id AS id_45,
  c1_.fr AS fr_46,
  c1_.en AS en_47,
  c1_.es AS es_48,
  c1_.pt AS pt_49,
  c1_.de AS de_50,
  c1_.ru AS ru_51,
  c1_.orderby AS orderby_52
FROM
  contacts c0_
  LEFT JOIN countries c1_ ON c0_.country = c1_.id
WHERE
  c0_.idcontact = ?

SELECT c0_.idcontact AS idcontact_0, c0_.type AS type_1, c0_.organisation AS organisation_2, c0_.nom_suite AS nom_suite_3, c0_.lastname AS lastname_4, c0_.firstname AS firstname_5, c0_.idtypestructure AS idtypestructure_6, c0_.license AS license_7, c0_.comment AS comment_8, c0_.private_comment AS private_comment_9, c0_.address1 AS address1_10, c0_.address2 AS address2_11, c0_.zip AS zip_12, c0_.city AS city_13, c0_.phone1 AS phone1_14, c0_.phone2 AS phone2_15, c0_.fax AS fax_16, c0_.email1 AS email1_17, c0_.email1_online AS email1_online_18, c0_.email2_online AS email2_online_19, c0_.email2 AS email2_20, c0_.url AS url_21, c0_.url_ticket AS url_ticket_22, c0_.facebook AS facebook_23, c0_.twitter AS twitter_24, c0_.instagram AS instagram_25, c0_.mobile AS mobile_26, c0_.geocodable AS geocodable_27, c0_.x AS x_28, c0_.y AS y_29, c0_.idmultimedia AS idmultimedia_30, c0_.type_view AS type_view_31, c0_.stats_access AS stats_access_32, c0_.ga_tracking_id AS ga_tracking_id_33, c0_.is_festival AS is_festival_34, c0_.link_on_video AS link_on_video_35, c0_.is_partenaire AS is_partenaire_36, c0_.valid_version AS valid_version_37, c0_.other_versions AS other_versions_38, c0_.url_redirect AS url_redirect_39, c0_.url_clean AS url_clean_40, c0_.dateupdate AS dateupdate_41, c0_.dateinsert AS dateinsert_42, c0_.publish AS publish_43, c0_.valid AS valid_44, c1_.id AS id_45, c1_.fr AS fr_46, c1_.en AS en_47, c1_.es AS es_48, c1_.pt AS pt_49, c1_.de AS de_50, c1_.ru AS ru_51, c1_.orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_.country = c1_.id WHERE c0_.idcontact = '151';

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

SELECT
  fr
FROM
  countries
WHERE
  id = 'France'

SELECT fr FROM countries WHERE id='France';

SELECT
  DISTINCT(cl.type)
FROM
  classifications cl
WHERE
  (
    (
      cl.idclassification IN (100)
    )
  )
  AND contacts = 1

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=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 = '151'
  AND of.object = 'contacts'
  AND cl.idclassification = fc.idclassification
  AND f.publish = 1
  AND (
    (
      cl.idclassification IN (100)
    )
  )
  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='151'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (100))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

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

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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 = '151'
  AND of.object = 'contacts'
  AND cl.idclassification = fc.idclassification
  AND (
    (
      cl.classification IN ('class_pp')
    )
  )
  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='151'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  COUNT(
    DISTINCT(m.idmultimedia)
  )
FROM
  object_multimedia om,
  multimedias m
WHERE
  om.idmultimedia = m.idmultimedia
  AND om.idobject = 151
  AND om.object = 'contacts'
  AND m.publish = 1
  AND m.audio_video = 2

SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=151
                AND om.object='contacts'
                AND m.publish=1  AND m.audio_video=2;

SELECT
  COUNT(
    DISTINCT(T1.idperson)
  ) as total
FROM
  persons T1
  JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
  JOIN texts t ON t.`idtext` = T2.`idtext`
WHERE
  1
  AND t.`idcontact_publisher` IN ('151')
  AND T1.`publish` = 1

SELECT COUNT(DISTINCT(T1.idperson)) as total  FROM persons T1 
                    JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
                    JOIN texts t ON t.`idtext`=T2.`idtext` 
                 WHERE 1  AND t.`idcontact_publisher` IN  ('151')  AND T1.`publish`=1 ;

SELECT
  idtext,
  idgenretext
FROM
  texts
WHERE
  type = 0
  AND idcontact_publisher = 151

SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=151;

SELECT
  idtext
FROM
  texts
WHERE
  type = 1
  AND idcontact_publisher = 151

SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=151;

SELECT
  tt.idtext
FROM
  text_traduction tt,
  texts t
WHERE
  t.idtext = tt.idtext
  AND (
    t.idgenretext = 1
    OR t.idgenretext IS NULL
  )
  AND tt.idtexttraduction IN (
    5771, 6151, 6153, 6695, 7154, 7325, 7327,
    7329, 9054, 9056, 9835, 9837, 15086,
    17236, 22335, 23194, 23719, 24284,
    24540, 24555, 25168, 30931, 31359,
    31815, 32597, 34639, 38761, 41197,
    41607, 43045, 44821
  )

SELECT tt.idtext FROM text_traduction tt, texts t
                                        WHERE t.idtext=tt.idtext
                                        AND (t.idgenretext=1 OR t.idgenretext IS NULL)
                                        AND tt.idtexttraduction IN (5771,6151,6153,6695,7154,7325,7327,7329,9054,9056,9835,9837,15086,17236,22335,23194,23719,24284,24540,24555,25168,30931,31359,31815,32597,34639,38761,41197,41607,43045,44821);

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    774,
    775,
    953,
    1314,
    1534,
    2329,
    2386,
    2407,
    2408,
    2527,
    2528,
    2529,
    2953,
    3453,
    3454,
    3455,
    3456,
    3457,
    3458,
    3474,
    3477,
    4057,
    5162,
    5300,
    6079,
    6264,
    6476,
    6692,
    6693,
    6876,
    6950,
    6951,
    6971,
    6972,
    7101,
    7191,
    7192,
    7193,
    7302,
    7303,
    7323,
    7759,
    7998,
    7999,
    8289,
    8411,
    8412,
    8420,
    9414,
    10285,
    10928,
    10929,
    10930,
    10931,
    11526,
    11838,
    11878,
    12405,
    12407,
    13571,
    14780,
    14969,
    15007,
    15082,
    15083,
    15087,
    15837,
    16488,
    16489,
    16931,
    16935,
    17856,
    18781,
    19436,
    19791,
    19792,
    19802,
    20216,
    20237,
    20967,
    21158,
    21159,
    21657,
    21750,
    22323,
    22336,
    23214,
    23874,
    23985,
    23986,
    25658,
    25750,
    26562,
    26684,
    27016,
    27017,
    28543,
    28786,
    28922,
    29202,
    29258,
    29838,
    30019,
    30348,
    30533,
    30743,
    31275,
    31588,
    31709,
    31951,
    32364,
    32705,
    33228,
    33651,
    34137,
    34309,
    36575,
    36631,
    36670,
    36671,
    36703,
    36704,
    36705,
    37081,
    37098,
    37464,
    37476,
    37812,
    38024,
    38120,
    38314,
    39005,
    39006,
    39007,
    40985,
    40999,
    41000,
    41001,
    41002,
    41003,
    41004,
    41005,
    41060,
    41061,
    41062,
    41063,
    41064,
    41065,
    41066,
    41067,
    41068,
    41069,
    41070,
    41071,
    41479,
    41833,
    41834,
    42735,
    44838,
    45008,
    45481
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (774,775,953,1314,1534,2329,2386,2407,2408,2527,2528,2529,2953,3453,3454,3455,3456,3457,3458,3474,3477,4057,5162,5300,6079,6264,6476,6692,6693,6876,6950,6951,6971,6972,7101,7191,7192,7193,7302,7303,7323,7759,7998,7999,8289,8411,8412,8420,9414,10285,10928,10929,10930,10931,11526,11838,11878,12405,12407,13571,14780,14969,15007,15082,15083,15087,15837,16488,16489,16931,16935,17856,18781,19436,19791,19792,19802,20216,20237,20967,21158,21159,21657,21750,22323,22336,23214,23874,23985,23986,25658,25750,26562,26684,27016,27017,28543,28786,28922,29202,29258,29838,30019,30348,30533,30743,31275,31588,31709,31951,32364,32705,33228,33651,34137,34309,36575,36631,36670,36671,36703,36704,36705,37081,37098,37464,37476,37812,38024,38120,38314,39005,39006,39007,40985,40999,41000,41001,41002,41003,41004,41005,41060,41061,41062,41063,41064,41065,41066,41067,41068,41069,41070,41071,41479,41833,41834,42735,44838,45008,45481)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    774,
    775,
    953,
    1314,
    1534,
    2329,
    2386,
    2407,
    2408,
    2527,
    2528,
    2529,
    2953,
    3453,
    3454,
    3455,
    3456,
    3457,
    3458,
    3474,
    3477,
    4057,
    5162,
    5300,
    6079,
    6264,
    6476,
    6692,
    6693,
    6876,
    6950,
    6951,
    6971,
    6972,
    7101,
    7191,
    7192,
    7193,
    7302,
    7303,
    7323,
    7759,
    7998,
    7999,
    8289,
    8411,
    8412,
    8420,
    9414,
    10285,
    10928,
    10929,
    10930,
    10931,
    11526,
    11838,
    11878,
    12405,
    12407,
    13571,
    14780,
    14969,
    15007,
    15082,
    15083,
    15087,
    15837,
    16488,
    16489,
    16931,
    16935,
    17856,
    18781,
    19436,
    19791,
    19792,
    19802,
    20216,
    20237,
    20967,
    21158,
    21159,
    21657,
    21750,
    22323,
    22336,
    23214,
    23874,
    23985,
    23986,
    25658,
    25750,
    26562,
    26684,
    27016,
    27017,
    28543,
    28786,
    28922,
    29202,
    29258,
    29838,
    30019,
    30348,
    30533,
    30743,
    31275,
    31588,
    31709,
    31951,
    32364,
    32705,
    33228,
    33651,
    34137,
    34309,
    36575,
    36631,
    36670,
    36671,
    36703,
    36704,
    36705,
    37081,
    37098,
    37464,
    37476,
    37812,
    38024,
    38120,
    38314,
    39005,
    39006,
    39007,
    40985,
    40999,
    41000,
    41001,
    41002,
    41003,
    41004,
    41005,
    41060,
    41061,
    41062,
    41063,
    41064,
    41065,
    41066,
    41067,
    41068,
    41069,
    41070,
    41071,
    41479,
    41833,
    41834,
    42735,
    44838,
    45008,
    45481
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (774,775,953,1314,1534,2329,2386,2407,2408,2527,2528,2529,2953,3453,3454,3455,3456,3457,3458,3474,3477,4057,5162,5300,6079,6264,6476,6692,6693,6876,6950,6951,6971,6972,7101,7191,7192,7193,7302,7303,7323,7759,7998,7999,8289,8411,8412,8420,9414,10285,10928,10929,10930,10931,11526,11838,11878,12405,12407,13571,14780,14969,15007,15082,15083,15087,15837,16488,16489,16931,16935,17856,18781,19436,19791,19792,19802,20216,20237,20967,21158,21159,21657,21750,22323,22336,23214,23874,23985,23986,25658,25750,26562,26684,27016,27017,28543,28786,28922,29202,29258,29838,30019,30348,30533,30743,31275,31588,31709,31951,32364,32705,33228,33651,34137,34309,36575,36631,36670,36671,36703,36704,36705,37081,37098,37464,37476,37812,38024,38120,38314,39005,39006,39007,40985,40999,41000,41001,41002,41003,41004,41005,41060,41061,41062,41063,41064,41065,41066,41067,41068,41069,41070,41071,41479,41833,41834,42735,44838,45008,45481)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    5771, 6151, 6153, 6695, 7154, 7325, 7327,
    7329, 9054, 9056, 9835, 9837, 15086,
    17236, 22335, 23194, 23719, 24284,
    24540, 24555, 25168, 30931, 31359,
    31815, 32597, 34639, 38761, 41197,
    41607, 43045, 44821
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (5771,6151,6153,6695,7154,7325,7327,7329,9054,9056,9835,9837,15086,17236,22335,23194,23719,24284,24540,24555,25168,30931,31359,31815,32597,34639,38761,41197,41607,43045,44821)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    5771, 6151, 6153, 6695, 7154, 7325, 7327,
    7329, 9054, 9056, 9835, 9837, 15086,
    17236, 22335, 23194, 23719, 24284,
    24540, 24555, 25168, 30931, 31359,
    31815, 32597, 34639, 38761, 41197,
    41607, 43045, 44821
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (5771,6151,6153,6695,7154,7325,7327,7329,9054,9056,9835,9837,15086,17236,22335,23194,23719,24284,24540,24555,25168,30931,31359,31815,32597,34639,38761,41197,41607,43045,44821)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1,
  contacts T2
WHERE
  1
  AND T2.idcontact = T1.idcontact_publisher
  AND T1.idcontact_publisher = 151
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1,contacts T2 WHERE 1  AND T2.idcontact=T1.idcontact_publisher AND T1.idcontact_publisher=151  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.idnew)
  ) as total
FROM
  news T1
  INNER JOIN newschedules T3 ON T3.idnew = T1.idnew
  INNER JOIN extranetusers T2 ON T2.idextranetuser = T1.idextranetuser
  LEFT JOIN contacts T4 ON T4.idcontact = T3.idcontact
  LEFT JOIN new_contact T5 ON T5.idnew = T1.idnew
WHERE
  1
  AND (T5.idcontact = 151)
  AND T1.publish = 1
  AND T1.publish = 1
  AND T1.valid = 1
  AND (
    (T3.date >= '2024-05-02')
  )

SELECT COUNT(DISTINCT(T1.idnew)) as total  FROM news T1 INNER JOIN newschedules T3
                            ON T3.idnew=T1.idnew
                            INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
                            LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idcontact=151 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND (( T3.date>='2024-05-02' ))    ;

SELECT
  COUNT(
    DISTINCT(T1.idnew)
  ) as total
FROM
  news T1
  INNER JOIN newschedules T3 ON T3.idnew = T1.idnew
  INNER JOIN extranetusers T2 ON T2.idextranetuser = T1.idextranetuser
  LEFT JOIN contacts T4 ON T4.idcontact = T3.idcontact
  LEFT JOIN new_contact T5 ON T5.idnew = T1.idnew
WHERE
  1
  AND (T5.idcontact = 151)
  AND T1.publish = 1
  AND T1.publish = 1
  AND T1.valid = 1
  AND (
    (T3.date < '2024-05-02')
  )

SELECT COUNT(DISTINCT(T1.idnew)) as total  FROM news T1 INNER JOIN newschedules T3
                            ON T3.idnew=T1.idnew
                            INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
                            LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idcontact=151 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND (( T3.date<'2024-05-02' ))    ;