Query Metrics

68 Database Queries
58 Different statements
228.42 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 16.04 ms
SELECT idperson FROM persons WHERE url_clean='Yann-Verburgh'
Parameters:
[]
2 0.43 ms
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 = ?
Parameters:
[
  48881
]
3 1.35 ms
SELECT COUNT(DISTINCT(t.idtext))
                FROM text_author ta, texts t
                WHERE t.idtext=ta.idtext AND t.textfictif=0
                AND ta.idperson=48881 AND t.publish=1 AND t.type IN (0,2)
Parameters:
[]
4 5.01 ms
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=48881 AND t.publish=1
Parameters:
[]
5 4.12 ms
SELECT COUNT(DISTINCT(sp.idspectacle)) as total
                FROM spectacle_person sp, spectacles s
                WHERE 1
                AND sp.idspectacle=s.idspectacle
                AND sp.idperson=48881
                AND sp.idrole=1 AND s.publish=1
Parameters:
[]
6 0.52 ms
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
7 0.13 ms
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
8 0.93 ms
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=48881  AND j2.idoffice=1
Parameters:
[]
9 0.19 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotxt'))) AND persons=1
Parameters:
[]
10 2.17 ms
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='48881'
                   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
Parameters:
[]
11 0.97 ms
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=104968
Parameters:
[]
12 0.07 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
13 2.17 ms
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='48881'
                   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
Parameters:
[]
14 0.71 ms
SELECT t.`idtext`
                           FROM text_author ta
                           JOIN texts t ON ta.`idtext`=t.`idtext`
                           WHERE ta.`idperson` IN (48881)
Parameters:
[]
15 0.99 ms
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 (48881)
Parameters:
[]
16 0.62 ms
SELECT t.`idtext`
                               FROM text_translator tt
                               JOIN texts t ON tt.`idtext`=t.`idtext`
                               WHERE
                               tt.`idperson` IN (48881)
Parameters:
[]
17 1.58 ms
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 (48881)
Parameters:
[]
18 1.58 ms
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`=48881 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.dateinsert 
DESC 
LIMIT 0,10
Parameters:
[]
19 7.76 ms
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=14327
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
20 20.14 ms
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 (15978,21113,21486,22730,25188,28418,28526,31803,31921,33238,34570,34875,35030,36377)
Parameters:
[]
21 5.94 ms
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=48881  AND podcasts.`code_franceinter` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND (podcasts.type_franceinter is NULL OR podcasts.type_franceinter = 0) AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
LIMIT 0,20
Parameters:
[]
22 1.66 ms
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=48881  AND podcasts.`code_franceinter` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0)  AND podcasts.`type_franceinter`=1 AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
LIMIT 0,20
Parameters:
[]
23 1.59 ms
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=48881  AND podcasts.`code_soundcloud` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
LIMIT 0,20
Parameters:
[]
24 1.46 ms
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=48881  AND ( `podcasts`.`code_franceinter` IS NOT NULL  OR `podcasts`.`code_soundcloud` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
LIMIT 0,20
Parameters:
[]
25 2.35 ms
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=48881  AND ( `podcasts`.`code_franceinter` IS NOT NULL  OR `podcasts`.`code_soundcloud` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,20
Parameters:
[]
26 0.51 ms
SELECT p0_.idpodcast AS idpodcast_0, p0_.title AS title_1, p0_.description AS description_2, p0_.title_program AS title_program_3, p0_.name_program AS name_program_4, p0_.date_podcast AS date_podcast_5, p0_.hour_podcast AS hour_podcast_6, p0_.code_franceinter AS code_franceinter_7, p0_.type_franceinter AS type_franceinter_8, p0_.integrate_player AS integrate_player_9, p0_.link AS link_10, p0_.duration AS duration_11, p0_.code_ft AS code_ft_12, p0_.is_integrale AS is_integrale_13, p0_.type_diffusion AS type_diffusion_14, p0_.fin_visionnage_ft AS fin_visionnage_ft_15, p0_.date_captation_ft AS date_captation_ft_16, p0_.debut_visionnage_ft AS debut_visionnage_ft_17, p0_.code_arte AS code_arte_18, p0_.code_soundcloud AS code_soundcloud_19, p0_.code_spotify AS code_spotify_20, p0_.url_file AS url_file_21, p0_.url_clean AS url_clean_22, p0_.dateupdate AS dateupdate_23, p0_.dateinsert AS dateinsert_24, p0_.publish AS publish_25, p0_.valid AS valid_26, p0_.idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_.idpodcast = ?
Parameters:
[
  "160"
]
27 0.85 ms
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idpodcast FROM theatreok_dev.spectacles j1, theatreok_dev.podcast_spectacle j2, theatreok_dev.podcasts j3
                        WHERE j3.idpodcast=j2.idpodcast
                        AND j1.idspectacle=j2.idspectacle
                        AND j3.idpodcast=160
Parameters:
[]
28 1.20 ms
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idpodcast FROM theatreok_dev.contacts j1, theatreok_dev.podcast_contact j2, theatreok_dev.podcasts j3
                        WHERE j3.idpodcast=j2.idpodcast
                        AND j1.idcontact=j2.idcontact
                        AND j3.idpodcast=160
Parameters:
[]
29 0.58 ms
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idpodcast FROM theatreok_dev.persons j1, theatreok_dev.podcast_person j2, theatreok_dev.podcasts j3
                        WHERE j3.idpodcast=j2.idpodcast
                        AND j1.idperson=j2.idperson
                        AND j3.idpodcast=160
Parameters:
[]
30 1.34 ms
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idpodcast FROM theatreok_dev.texts j1, theatreok_dev.podcast_text j2, theatreok_dev.podcasts j3
                        WHERE j3.idpodcast=j2.idpodcast
                        AND j1.idtext=j2.idtext
                        AND j3.idpodcast=160
Parameters:
[]
31 0.39 ms
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
  23509
]
32 0.97 ms
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=23509  ORDER BY j2.classement ASC
Parameters:
[]
33 0.38 ms
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
  29497
]
34 0.80 ms
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=29497  ORDER BY j2.classement ASC
Parameters:
[]
35 0.44 ms
SELECT url_file FROM podcasts WHERE idpodcast=160
Parameters:
[]
36 0.12 ms
SELECT url_file FROM podcasts WHERE idpodcast=160
Parameters:
[]
37 1.03 ms
SELECT p0_.idpodcast AS idpodcast_0, p0_.title AS title_1, p0_.description AS description_2, p0_.title_program AS title_program_3, p0_.name_program AS name_program_4, p0_.date_podcast AS date_podcast_5, p0_.hour_podcast AS hour_podcast_6, p0_.code_franceinter AS code_franceinter_7, p0_.type_franceinter AS type_franceinter_8, p0_.integrate_player AS integrate_player_9, p0_.link AS link_10, p0_.duration AS duration_11, p0_.code_ft AS code_ft_12, p0_.is_integrale AS is_integrale_13, p0_.type_diffusion AS type_diffusion_14, p0_.fin_visionnage_ft AS fin_visionnage_ft_15, p0_.date_captation_ft AS date_captation_ft_16, p0_.debut_visionnage_ft AS debut_visionnage_ft_17, p0_.code_arte AS code_arte_18, p0_.code_soundcloud AS code_soundcloud_19, p0_.code_spotify AS code_spotify_20, p0_.url_file AS url_file_21, p0_.url_clean AS url_clean_22, p0_.dateupdate AS dateupdate_23, p0_.dateinsert AS dateinsert_24, p0_.publish AS publish_25, p0_.valid AS valid_26, p0_.idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_.idpodcast = ?
Parameters:
[
  "1560"
]
38 1.84 ms
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idpodcast FROM theatreok_dev.spectacles j1, theatreok_dev.podcast_spectacle j2, theatreok_dev.podcasts j3
                        WHERE j3.idpodcast=j2.idpodcast
                        AND j1.idspectacle=j2.idspectacle
                        AND j3.idpodcast=1560
Parameters:
[]
39 1.40 ms
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idpodcast FROM theatreok_dev.contacts j1, theatreok_dev.podcast_contact j2, theatreok_dev.podcasts j3
                        WHERE j3.idpodcast=j2.idpodcast
                        AND j1.idcontact=j2.idcontact
                        AND j3.idpodcast=1560
Parameters:
[]
40 1.34 ms
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idpodcast FROM theatreok_dev.persons j1, theatreok_dev.podcast_person j2, theatreok_dev.podcasts j3
                        WHERE j3.idpodcast=j2.idpodcast
                        AND j1.idperson=j2.idperson
                        AND j3.idpodcast=1560
Parameters:
[]
41 1.52 ms
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idpodcast FROM theatreok_dev.texts j1, theatreok_dev.podcast_text j2, theatreok_dev.podcasts j3
                        WHERE j3.idpodcast=j2.idpodcast
                        AND j1.idtext=j2.idtext
                        AND j3.idpodcast=1560
Parameters:
[]
42 0.18 ms
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
  23509
]
43 0.06 ms
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=23509  ORDER BY j2.classement ASC
Parameters:
[]
44 0.06 ms
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
  29497
]
45 0.06 ms
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=29497  ORDER BY j2.classement ASC
Parameters:
[]
46 0.85 ms
SELECT url_file FROM podcasts WHERE idpodcast=1560
Parameters:
[]
47 0.09 ms
SELECT url_file FROM podcasts WHERE idpodcast=1560
Parameters:
[]
48 45.45 ms
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
                FROM playlists p
                    LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
                    LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
                WHERE p.`publish`=1
                AND p.`idperson` IN (48881)  AND c.`classification`='class_auteur_meme'
Parameters:
[]
49 1.42 ms
SELECT p.`idplaylist`
                FROM playlists p
                    LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
                    LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
                WHERE p.`publish`=1
                AND p.`idperson`=48881 AND c.`classification`='class_auteur_meme' LIMIT 0,1
Parameters:
[]
50 0.67 ms
SELECT p0_.idplaylist AS idplaylist_0, p0_.title AS title_1, p0_.description AS description_2, p0_.url_clean AS url_clean_3, p0_.dateupdate AS dateupdate_4, p0_.dateinsert AS dateinsert_5, p0_.publish AS publish_6, p0_.valid AS valid_7 FROM playlists p0_ WHERE p0_.idplaylist = ?
Parameters:
[
  "451"
]
51 0.52 ms
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
                        WHERE j1.idperson=j3.idperson
                        AND j3.idplaylist=451
Parameters:
[]
52 0.94 ms
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
                        WHERE j1.idspectacle=j3.idspectacle
                        AND j3.idplaylist=451
Parameters:
[]
53 16.30 ms
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
                        WHERE j1.idcontact=j3.idcontact
                        AND j3.idplaylist=451
Parameters:
[]
54 1.42 ms
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
                        WHERE j1.idtext=j3.idtext
                        AND j3.idplaylist=451
Parameters:
[]
55 1.04 ms
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
                        WHERE j3.idplaylist=j2.idplaylist
                        AND j1.idmultimedia=j2.idmultimedia
                        AND j3.idplaylist=451  ORDER BY j2.`orderplaylist`
Parameters:
[]
56 1.18 ms
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
                        WHERE j3.idplaylist=j2.idplaylist
                        AND j1.idclassification=j2.idclassification
                        AND j3.idplaylist=451
Parameters:
[]
57 2.63 ms
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle,
                    c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,
                    ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
                    FROM schedules s
                    JOIN contacts c ON s.idcontact=c.idcontact
                    LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
                    WHERE 1 AND s.idspectacle IN (15978,21113,21486,22730,25188,28418,28526,31803,31921,33238,34570,34875,35030,36377) AND s.date>='2024-04-26' ORDER BY s.date ASC LIMIT 0,1
Parameters:
[]
58 3.00 ms
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_person T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idperson=48881 ) AND T1.publish=1
Parameters:
[]
59 1.92 ms
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=48881
                AND om.object='persons'
                AND m.publish=1
Parameters:
[]
60 1.47 ms
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_person do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idperson`=48881 AND d.code_franceinter IS NOT NULL
Parameters:
[]
61 1.31 ms
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_person do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idperson`=48881 AND d.code_soundcloud IS NOT NULL
Parameters:
[]
62 3.27 ms
SELECT COUNT(DISTINCT(T1.`idtext`)) as total  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 (16940,23509,25040,25043,25044,25133,26431,26788,28302,29215,29497,29787,31162,35134,39519,39646,39655,42848,43356,44693,41816)  ORDER BY publication_year DESC
Parameters:
[]
63 26.52 ms
SELECT  DISTINCT(multimedias.idmultimedia), multimedias.*,spectacles.`idspectacle`,schedules.`idcontact` 
FROM  `object_multimedia` ,
 `schedules` ,
 `spectacles` ,
 `contacts` ,
 `multimedias` ,
 `multimedia_classification`  
 WHERE 1  AND multimedias.`publish`=1  AND object_multimedia.`object`='spectacles'  AND object_multimedia.`idrole` IS NULL  AND schedules.`date` BETWEEN '1999-01-01' AND '2030-01-01'   AND object_multimedia.`object`='spectacles'  AND object_multimedia.`idobject` IN (15978,21113,21486,22730,25188,28418,28526,31803,31921,33238,34570,34875,35030,36377)  AND multimedia_classification.`idclassification`=145 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND schedules.`idspectacle`=spectacles.`idspectacle` AND spectacles.`idspectacle`=object_multimedia.`idobject` AND contacts.`idcontact`=schedules.`idcontact` AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND multimedias.`idmultimedia`=multimedia_classification.`idmultimedia` 
 GROUP BY object_multimedia.`idobject` 
ORDER BY schedules.`date` 
ASC 
LIMIT 0,100
Parameters:
[]
64 5.41 ms
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 = ?
Parameters:
[
  "9de95d012bedeed3e4f22dc5d63d7085-0678"
  0
  "9c962d5552b0e64d006b15036c6e8107"
]
65 15.78 ms
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "article"
  "thnet"
  "/biographies/Yann-Verburgh/podcasts/"
  "9c962d5552b0e64d006b15036c6e8107"
  0
  "persons"
  48881
  0
  "fr"
  "9de95d012bedeed3e4f22dc5d63d7085-0678"
  "/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553"
]
66 0.16 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
67 0.13 ms
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='48881'
                   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
Parameters:
[]
68 1.38 ms
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts