14.71 ms (21.96%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-11"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-11"
AND idnew=5634
AND idcontact=12356;
|
12.54 ms (18.71%)
|
1 |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=8946 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=8946 ORDER BY date;
|
2.44 ms (3.64%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-09"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-09"
AND idnew=5634
AND idcontact=12356;
|
1.91 ms (2.85%)
|
1 |
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=5634
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=5634;
|
1.89 ms (2.81%)
|
1 |
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=5634 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=5634 GROUP BY s.idcontact ORDER BY s.date ASC;
|
1.52 ms (2.27%)
|
1 |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=12356 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=12356 ORDER BY date;
|
1.47 ms (2.19%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-17"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-17"
AND idnew=5634
AND idcontact=12356;
|
1.34 ms (2.01%)
|
1 |
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=5634
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=5634;
|
1.30 ms (1.93%)
|
1 |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=2229 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=2229 ORDER BY date;
|
1.25 ms (1.87%)
|
1 |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=12359 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=12359 ORDER BY date;
|
1.25 ms (1.87%)
|
1 |
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;
|
1.24 ms (1.85%)
|
1 |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=1021 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=1021 ORDER BY date;
|
1.20 ms (1.79%)
|
1 |
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 = '5634';
|
1.14 ms (1.71%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-05"
AND idnew=5634
AND idcontact=1021
SELECT hour,note
FROM newschedules
WHERE date="2014-02-05"
AND idnew=5634
AND idcontact=1021;
|
1.06 ms (1.58%)
|
1 |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=1994 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=1994 ORDER BY date;
|
1.05 ms (1.57%)
|
1 |
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=5634 AND sc.date<='2024-04-17' AND sc.idcontact=12356 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=5634 AND sc.date<='2024-04-17' AND sc.idcontact=12356 GROUP BY sc.idcontact;
|
0.92 ms (1.38%)
|
2 |
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=5634 AND sc.date>='2024-04-17' 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=5634 AND sc.date>='2024-04-17' ORDER BY sc.date ASC LIMIT 0,1;
|
0.92 ms (1.37%)
|
1 |
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=5634
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=5634;
|
0.91 ms (1.36%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-08"
AND idnew=5634
AND idcontact=2229
SELECT hour,note
FROM newschedules
WHERE date="2014-02-08"
AND idnew=5634
AND idcontact=2229;
|
0.82 ms (1.22%)
|
1 |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=2713 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=2713 ORDER BY date;
|
0.71 ms (1.06%)
|
1 |
SELECT url_file FROM news WHERE idnew=5634
SELECT url_file FROM news WHERE idnew=5634;
|
0.69 ms (1.03%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-05"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-05"
AND idnew=5634
AND idcontact=12356;
|
0.69 ms (1.03%)
|
1 |
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=12358 ORDER BY date
SELECT DISTINCT(date), note
FROM newschedules
WHERE idnew=5634
AND idcontact=12358 ORDER BY date;
|
0.69 ms (1.03%)
|
1 |
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=5634
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=5634;
|
0.68 ms (1.01%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-18"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-18"
AND idnew=5634
AND idcontact=12356;
|
0.66 ms (0.99%)
|
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=5634 AND sc.date<='2024-04-17' 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=5634 AND sc.date<='2024-04-17' ORDER BY sc.date ASC LIMIT 0,1;
|
0.60 ms (0.89%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-30"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-30"
AND idnew=5634
AND idcontact=12356;
|
0.60 ms (0.89%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-23"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-23"
AND idnew=5634
AND idcontact=12356;
|
0.58 ms (0.87%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-22"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-22"
AND idnew=5634
AND idcontact=12356;
|
0.58 ms (0.86%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-08"
AND idnew=5634
AND idcontact=1994
SELECT hour,note
FROM newschedules
WHERE date="2014-02-08"
AND idnew=5634
AND idcontact=1994;
|
0.55 ms (0.82%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-25"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-25"
AND idnew=5634
AND idcontact=12356;
|
0.54 ms (0.81%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-14"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-14"
AND idnew=5634
AND idcontact=12356;
|
0.51 ms (0.76%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-05"
AND idnew=5634
AND idcontact=1994
SELECT hour,note
FROM newschedules
WHERE date="2014-02-05"
AND idnew=5634
AND idcontact=1994;
|
0.50 ms (0.75%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-01"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-01"
AND idnew=5634
AND idcontact=12356;
|
0.49 ms (0.74%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-10"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-10"
AND idnew=5634
AND idcontact=12356;
|
0.48 ms (0.71%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-13"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-13"
AND idnew=5634
AND idcontact=12356;
|
0.46 ms (0.69%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-07"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-07"
AND idnew=5634
AND idcontact=12356;
|
0.45 ms (0.68%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-29"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-29"
AND idnew=5634
AND idcontact=12356;
|
0.44 ms (0.65%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-15"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-15"
AND idnew=5634
AND idcontact=12356;
|
0.43 ms (0.64%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-28"
AND idnew=5634
AND idcontact=2713
SELECT hour,note
FROM newschedules
WHERE date="2014-01-28"
AND idnew=5634
AND idcontact=2713;
|
0.42 ms (0.63%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-07"
AND idnew=5634
AND idcontact=1994
SELECT hour,note
FROM newschedules
WHERE date="2014-02-07"
AND idnew=5634
AND idcontact=1994;
|
0.42 ms (0.62%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-30"
AND idnew=5634
AND idcontact=8946
SELECT hour,note
FROM newschedules
WHERE date="2014-01-30"
AND idnew=5634
AND idcontact=8946;
|
0.42 ms (0.62%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-12"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-12"
AND idnew=5634
AND idcontact=12356;
|
0.42 ms (0.62%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-31"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-31"
AND idnew=5634
AND idcontact=12356;
|
0.41 ms (0.62%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-15"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-15"
AND idnew=5634
AND idcontact=12356;
|
0.41 ms (0.62%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-06"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-06"
AND idnew=5634
AND idcontact=12356;
|
0.39 ms (0.59%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-16"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-16"
AND idnew=5634
AND idcontact=12356;
|
0.37 ms (0.55%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-24"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-01-24"
AND idnew=5634
AND idcontact=12356;
|
0.35 ms (0.53%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-08"
AND idnew=5634
AND idcontact=12356
SELECT hour,note
FROM newschedules
WHERE date="2014-02-08"
AND idnew=5634
AND idcontact=12356;
|
0.33 ms (0.50%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-30"
AND idnew=5634
AND idcontact=12358
SELECT hour,note
FROM newschedules
WHERE date="2014-01-30"
AND idnew=5634
AND idcontact=12358;
|
0.33 ms (0.49%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-06"
AND idnew=5634
AND idcontact=1994
SELECT hour,note
FROM newschedules
WHERE date="2014-02-06"
AND idnew=5634
AND idcontact=1994;
|
0.28 ms (0.42%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-01-29"
AND idnew=5634
AND idcontact=2713
SELECT hour,note
FROM newschedules
WHERE date="2014-01-29"
AND idnew=5634
AND idcontact=2713;
|
0.24 ms (0.36%)
|
1 |
SELECT hour,note
FROM newschedules
WHERE date="2014-02-01"
AND idnew=5634
AND idcontact=12359
SELECT hour,note
FROM newschedules
WHERE date="2014-02-01"
AND idnew=5634
AND idcontact=12359;
|