18.21 ms (22.13%)
|
1 |
SELECT r.`idrole`,l.`fr` as role
FROM roles r
JOIN langterms l ON l.`id`=r.`role`
JOIN ecole_role er ON r.`idrole`=er.`idrole`
JOIN person_ecole pe ON pe.`idperson`=er.`idperson` WHERE 1 AND pe.`idcontact`!=3914 AND YEAR(pe.`date_end`)='2022' GROUP BY r.`idrole` ORDER BY l.`fr`
SELECT r.`idrole`,l.`fr` as role
FROM roles r
JOIN langterms l ON l.`id`=r.`role`
JOIN ecole_role er ON r.`idrole`=er.`idrole`
JOIN person_ecole pe ON pe.`idperson`=er.`idperson` WHERE 1 AND pe.`idcontact`!=3914 AND YEAR(pe.`date_end`)='2022' GROUP BY r.`idrole` ORDER BY l.`fr` ;
|
16.66 ms (20.25%)
|
1 |
SELECT DISTINCT(T1.idperson), T1.lastname,T1.firstname,T1.url_clean , cte.`url_clean` as contact_url_clean, cte.`idcontact` as contact_idcontact, cte.`organisation` as contact_organisation, pe.*, YEAR(pe.`date_start`) as year_start, YEAR(pe.`date_end`) as year_end FROM persons T1 JOIN person_ecole pe ON T1.`idperson`=pe.`idperson`
JOIN contacts cte ON pe.`idcontact`=cte.`idcontact` WHERE 1 AND pe.`idcontact`!=3914 AND YEAR(pe.`date_end`)='2022' GROUP BY T1.idperson ORDER BY T1.lastname ASC LIMIT 180,20
SELECT DISTINCT(T1.idperson), T1.lastname,T1.firstname,T1.url_clean , cte.`url_clean` as contact_url_clean, cte.`idcontact` as contact_idcontact, cte.`organisation` as contact_organisation, pe.*, YEAR(pe.`date_start`) as year_start, YEAR(pe.`date_end`) as year_end FROM persons T1 JOIN person_ecole pe ON T1.`idperson`=pe.`idperson`
JOIN contacts cte ON pe.`idcontact`=cte.`idcontact` WHERE 1 AND pe.`idcontact`!=3914 AND YEAR(pe.`date_end`)='2022' GROUP BY T1.idperson ORDER BY T1.lastname ASC LIMIT 180,20;
|
8.57 ms (10.42%)
|
15 |
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 = ?
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 = '2041';
|
7.22 ms (8.77%)
|
1 |
SELECT COUNT(DISTINCT(idperson))
FROM person_ecole WHERE 1
SELECT COUNT(DISTINCT(idperson))
FROM person_ecole WHERE 1 ;
|
4.77 ms (5.79%)
|
2 |
SELECT YEAR(date_end) as year_end
FROM person_ecole pe
WHERE 1 AND YEAR(pe.`date_end`)<='2024'
GROUP BY year_end
ORDER BY year_end DESC
SELECT YEAR(date_end) as year_end
FROM person_ecole pe
WHERE 1 AND YEAR(pe.`date_end`)<='2024'
GROUP BY year_end
ORDER BY year_end DESC;
|
4.37 ms (5.32%)
|
1 |
SELECT COUNT(DISTINCT(idperson))
FROM person_ecole WHERE 1 AND date_end < '2024-04-24 00:00:00'
SELECT COUNT(DISTINCT(idperson))
FROM person_ecole WHERE 1 AND date_end < '2024-04-24 00:00:00' ;
|
3.98 ms (4.84%)
|
1 |
SELECT COUNT(DISTINCT(T1.idperson)) as total FROM persons T1 JOIN person_ecole pe ON T1.`idperson`=pe.`idperson`
JOIN contacts cte ON pe.`idcontact`=cte.`idcontact` WHERE 1 AND pe.`idcontact`!=3914 AND YEAR(pe.`date_end`)='2022'
SELECT COUNT(DISTINCT(T1.idperson)) as total FROM persons T1 JOIN person_ecole pe ON T1.`idperson`=pe.`idperson`
JOIN contacts cte ON pe.`idcontact`=cte.`idcontact` WHERE 1 AND pe.`idcontact`!=3914 AND YEAR(pe.`date_end`)='2022' ;
|
2.11 ms (2.56%)
|
22 |
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;
|
1.82 ms (2.21%)
|
2 |
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='98853'
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='98853'
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;
|
1.37 ms (1.66%)
|
2 |
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='99526'
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='99526'
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;
|
1.21 ms (1.47%)
|
2 |
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='77447'
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='77447'
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;
|
1.12 ms (1.37%)
|
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='30078'
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='30078'
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;
|
1.11 ms (1.35%)
|
2 |
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='99535'
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='99535'
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;
|
1.10 ms (1.34%)
|
2 |
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='92078'
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='92078'
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;
|
0.99 ms (1.20%)
|
2 |
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='94107'
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='94107'
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;
|
0.95 ms (1.16%)
|
2 |
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='103655'
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='103655'
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;
|
0.94 ms (1.14%)
|
2 |
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='75515'
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='75515'
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;
|
0.92 ms (1.12%)
|
2 |
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='94136'
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='94136'
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;
|
0.86 ms (1.04%)
|
1 |
SELECT DISTINCT(contacts.idcontact), contacts.*
FROM `contacts`
WHERE 1 AND contacts.`idtypestructure`='EC' AND contacts.idcontact NOT IN (SELECT idcontact FROM contact_classification WHERE idclassification=99) AND contacts.`publish`=1
GROUP BY contacts.idcontact
ORDER BY organisation
ASC
LIMIT 0,300
SELECT DISTINCT(contacts.idcontact), contacts.*
FROM `contacts`
WHERE 1 AND contacts.`idtypestructure`='EC' AND contacts.idcontact NOT IN (SELECT idcontact FROM contact_classification WHERE idclassification=99) AND contacts.`publish`=1
GROUP BY contacts.idcontact
ORDER BY organisation
ASC
LIMIT 0,300;
|
0.82 ms (1.00%)
|
2 |
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='96837'
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='96837'
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;
|
0.82 ms (1.00%)
|
2 |
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='92076'
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='92076'
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;
|
0.81 ms (0.99%)
|
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='33933'
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='33933'
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;
|
0.71 ms (0.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;
|
0.25 ms (0.30%)
|
1 |
SELECT fr FROM countries WHERE id='CH'
SELECT fr FROM countries WHERE id='CH';
|
0.20 ms (0.25%)
|
1 |
SELECT fr FROM countries WHERE id='IS'
SELECT fr FROM countries WHERE id='IS';
|
0.15 ms (0.18%)
|
1 |
SELECT fr FROM countries WHERE id='FR'
SELECT fr FROM countries WHERE id='FR';
|
0.14 ms (0.17%)
|
2 |
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;
|
0.10 ms (0.13%)
|
1 |
SELECT fr FROM countries WHERE id='RU'
SELECT fr FROM countries WHERE id='RU';
|