1 |
1.43 ms |
SELECT t0.idnew AS idnew_1, t0.title AS title_2, t0.type_news AS type_news_3, t0.description AS description_4, t0.markdown AS markdown_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.hour AS hour_8, t0.location AS location_9, t0.city AS city_10, t0.zip AS zip_11, t0.contacts AS contacts_12, t0.url AS url_13, t0.url_more AS url_more_14, t0.infos_contacts AS infos_contacts_15, t0.url_file AS url_file_16, t0.copyright_file AS copyright_file_17, t0.is_homepage AS is_homepage_18, t0.publish AS publish_19, t0.valid AS valid_20, t0.statut AS statut_21, t0.dateinsert AS dateinsert_22, t0.dateupdate AS dateupdate_23, t0.idextranetuser_lock AS idextranetuser_lock_24, t0.idextranetuser AS idextranetuser_25, t0.idregion AS idregion_26, t0.country AS country_27 FROM news t0 WHERE t0.idnew = ?
SELECT t0.idnew AS idnew_1, t0.title AS title_2, t0.type_news AS type_news_3, t0.description AS description_4, t0.markdown AS markdown_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.hour AS hour_8, t0.location AS location_9, t0.city AS city_10, t0.zip AS zip_11, t0.contacts AS contacts_12, t0.url AS url_13, t0.url_more AS url_more_14, t0.infos_contacts AS infos_contacts_15, t0.url_file AS url_file_16, t0.copyright_file AS copyright_file_17, t0.is_homepage AS is_homepage_18, t0.publish AS publish_19, t0.valid AS valid_20, t0.statut AS statut_21, t0.dateinsert AS dateinsert_22, t0.dateupdate AS dateupdate_23, t0.idextranetuser_lock AS idextranetuser_lock_24, t0.idextranetuser AS idextranetuser_25, t0.idregion AS idregion_26, t0.country AS country_27 FROM news t0 WHERE t0.idnew = '8988';
|
2 |
2.78 ms |
SELECT DISTINCT(s.idnewschedule),s.note,s.hour,c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,MIN(s.date) AS datedebut
FROM newschedules s,contacts c
WHERE s.idcontact=c.idcontact
AND s.idnew=8988 GROUP BY s.idcontact ORDER BY s.date ASC
SELECT DISTINCT(s.idnewschedule),s.note,s.hour,c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,MIN(s.date) AS datedebut
FROM newschedules s,contacts c
WHERE s.idcontact=c.idcontact
AND s.idnew=8988 GROUP BY s.idcontact ORDER BY s.date ASC;
|
3 |
2.02 ms |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=8988
AND idcontact=247 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=8988
AND idcontact=247 ORDER BY date;
|
4 |
0.68 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-15"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-15"
AND idnew=8988
AND idcontact=247;
|
5 |
0.73 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-16"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-16"
AND idnew=8988
AND idcontact=247;
|
6 |
0.49 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-20"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-20"
AND idnew=8988
AND idcontact=247;
|
7 |
0.42 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-21"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-21"
AND idnew=8988
AND idcontact=247;
|
8 |
0.31 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-22"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-22"
AND idnew=8988
AND idcontact=247;
|
9 |
0.38 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-23"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-23"
AND idnew=8988
AND idcontact=247;
|
10 |
0.63 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-27"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-27"
AND idnew=8988
AND idcontact=247;
|
11 |
0.55 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-28"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-28"
AND idnew=8988
AND idcontact=247;
|
12 |
0.47 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-29"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-29"
AND idnew=8988
AND idcontact=247;
|
13 |
0.40 ms |
SELECT hour,note
FROM newschedules
WHERE date="2019-06-30"
AND idnew=8988
AND idcontact=247
SELECT hour,note
FROM newschedules
WHERE date="2019-06-30"
AND idnew=8988
AND idcontact=247;
|
14 |
0.18 ms |
SELECT url_file FROM news WHERE idnew=8988
SELECT url_file FROM news WHERE idnew=8988;
|
15 |
0.34 ms |
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
WHERE sc.idcontact=c.idcontact
AND sc.idnew=8988 AND sc.date>='2024-04-18' ORDER BY sc.date ASC LIMIT 0,1
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
WHERE sc.idcontact=c.idcontact
AND sc.idnew=8988 AND sc.date>='2024-04-18' ORDER BY sc.date ASC LIMIT 0,1;
|
16 |
0.05 ms |
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
WHERE sc.idcontact=c.idcontact
AND sc.idnew=8988 AND sc.date>='2024-04-18' ORDER BY sc.date ASC LIMIT 0,1
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
WHERE sc.idcontact=c.idcontact
AND sc.idnew=8988 AND sc.date>='2024-04-18' ORDER BY sc.date ASC LIMIT 0,1;
|
17 |
0.30 ms |
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
WHERE sc.idcontact=c.idcontact
AND sc.idnew=8988 AND sc.date<='2024-04-18' ORDER BY sc.date ASC LIMIT 0,1
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
WHERE sc.idcontact=c.idcontact
AND sc.idnew=8988 AND sc.date<='2024-04-18' ORDER BY sc.date ASC LIMIT 0,1;
|
18 |
0.68 ms |
SELECT MIN(sc.date) as datestart, MAX(sc.date) as dateend, c.city, c.country FROM newschedules sc, contacts c
WHERE sc.idcontact=c.idcontact
AND sc.idnew=8988 AND sc.date<='2024-04-18' AND sc.idcontact=247 GROUP BY sc.idcontact
SELECT MIN(sc.date) as datestart, MAX(sc.date) as dateend, c.city, c.country FROM newschedules sc, contacts c
WHERE sc.idcontact=c.idcontact
AND sc.idnew=8988 AND sc.date<='2024-04-18' AND sc.idcontact=247 GROUP BY sc.idcontact;
|
19 |
1.02 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idnew FROM theatreok_dev.persons j1, theatreok_dev.new_person j2, theatreok_dev.news j3
WHERE j3.idnew=j2.idnew
AND j1.idperson=j2.idperson
AND j3.idnew=8988
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idnew FROM theatreok_dev.persons j1, theatreok_dev.new_person j2, theatreok_dev.news j3
WHERE j3.idnew=j2.idnew
AND j1.idperson=j2.idperson
AND j3.idnew=8988;
|
20 |
1.02 ms |
SELECT j1.idcontact,j1.lastname,j1.firstname,j1.organisation,j1.type,j1.url_clean ,j3.idnew FROM theatreok_dev.contacts j1, theatreok_dev.new_contact j2, theatreok_dev.news j3
WHERE j3.idnew=j2.idnew
AND j1.idcontact=j2.idcontact
AND j3.idnew=8988
SELECT j1.idcontact,j1.lastname,j1.firstname,j1.organisation,j1.type,j1.url_clean ,j3.idnew FROM theatreok_dev.contacts j1, theatreok_dev.new_contact j2, theatreok_dev.news j3
WHERE j3.idnew=j2.idnew
AND j1.idcontact=j2.idcontact
AND j3.idnew=8988;
|
21 |
0.55 ms |
SELECT j1.idspectacle,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.spectacles j1, theatreok_dev.new_spectacle j2, theatreok_dev.news j3
WHERE j3.idnew=j2.idnew
AND j1.idspectacle=j2.idspectacle
AND j3.idnew=8988
SELECT j1.idspectacle,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.spectacles j1, theatreok_dev.new_spectacle j2, theatreok_dev.news j3
WHERE j3.idnew=j2.idnew
AND j1.idspectacle=j2.idspectacle
AND j3.idnew=8988;
|
22 |
0.21 ms |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=25824
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=25824;
|
23 |
0.13 ms |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=25825
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=25825;
|
24 |
0.25 ms |
SELECT j1.idtext,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.texts j1, theatreok_dev.new_text j2, theatreok_dev.news j3
WHERE j3.idnew=j2.idnew
AND j1.idtext=j2.idtext
AND j3.idnew=8988
SELECT j1.idtext,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.texts j1, theatreok_dev.new_text j2, theatreok_dev.news j3
WHERE j3.idnew=j2.idnew
AND j1.idtext=j2.idtext
AND j3.idnew=8988;
|
25 |
0.45 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = 1625;
|
26 |
0.30 ms |
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=1625
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=1625
ORDER BY t.title;
|
27 |
0.26 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=1623 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=1623 ORDER BY j2.classement ASC;
|
28 |
0.13 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = 32121;
|
29 |
0.20 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=32121 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=32121 ORDER BY j2.classement ASC;
|
30 |
0.10 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = 32122;
|
31 |
0.27 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=32122 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=32122 ORDER BY j2.classement ASC;
|
32 |
1.35 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
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;
|