Query Metrics
46
Database Queries
34
Different statements
25.79 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.40 ms |
SELECT idspectacle FROM spectacles WHERE url_clean='Le-Monde-a-l-envers'
Parameters:
[]
|
||||||||||||||||||||||||||||||
2 | 1.22 ms |
SELECT s0_.idspectacle AS idspectacle_0, s0_.title AS title_1, s0_.language AS language_2, s0_.creation_date AS creation_date_3, s0_.url_page AS url_page_4, s0_.infos AS infos_5, s0_.tag AS tag_6, s0_.id_rubrique AS id_rubrique_7, s0_.duration AS duration_8, s0_.interlude AS interlude_9, s0_.textfictif AS textfictif_10, s0_.url_redirect AS url_redirect_11, s0_.url_clean AS url_clean_12, s0_.dateupdate AS dateupdate_13, s0_.dateinsert AS dateinsert_14, s0_.publish AS publish_15, s0_.statut AS statut_16, s0_.valid AS valid_17, t1_.idtypespectacle AS idtypespectacle_18, c2_.idcontact AS idcontact_19, c2_.type AS type_20, c2_.organisation AS organisation_21, c2_.nom_suite AS nom_suite_22, c2_.lastname AS lastname_23, c2_.firstname AS firstname_24, c2_.idtypestructure AS idtypestructure_25, c2_.license AS license_26, c2_.comment AS comment_27, c2_.private_comment AS private_comment_28, c2_.address1 AS address1_29, c2_.address2 AS address2_30, c2_.zip AS zip_31, c2_.city AS city_32, c2_.phone1 AS phone1_33, c2_.phone2 AS phone2_34, c2_.fax AS fax_35, c2_.email1 AS email1_36, c2_.email1_online AS email1_online_37, c2_.email2_online AS email2_online_38, c2_.email2 AS email2_39, c2_.url AS url_40, c2_.url_ticket AS url_ticket_41, c2_.facebook AS facebook_42, c2_.twitter AS twitter_43, c2_.instagram AS instagram_44, c2_.mobile AS mobile_45, c2_.geocodable AS geocodable_46, c2_.x AS x_47, c2_.y AS y_48, c2_.idmultimedia AS idmultimedia_49, c2_.type_view AS type_view_50, c2_.stats_access AS stats_access_51, c2_.ga_tracking_id AS ga_tracking_id_52, c2_.is_festival AS is_festival_53, c2_.link_on_video AS link_on_video_54, c2_.is_partenaire AS is_partenaire_55, c2_.valid_version AS valid_version_56, c2_.other_versions AS other_versions_57, c2_.url_redirect AS url_redirect_58, c2_.url_clean AS url_clean_59, c2_.dateupdate AS dateupdate_60, c2_.dateinsert AS dateinsert_61, c2_.publish AS publish_62, c2_.valid AS valid_63, c3_.idcontact AS idcontact_64, c3_.type AS type_65, c3_.organisation AS organisation_66, c3_.nom_suite AS nom_suite_67, c3_.lastname AS lastname_68, c3_.firstname AS firstname_69, c3_.idtypestructure AS idtypestructure_70, c3_.license AS license_71, c3_.comment AS comment_72, c3_.private_comment AS private_comment_73, c3_.address1 AS address1_74, c3_.address2 AS address2_75, c3_.zip AS zip_76, c3_.city AS city_77, c3_.phone1 AS phone1_78, c3_.phone2 AS phone2_79, c3_.fax AS fax_80, c3_.email1 AS email1_81, c3_.email1_online AS email1_online_82, c3_.email2_online AS email2_online_83, c3_.email2 AS email2_84, c3_.url AS url_85, c3_.url_ticket AS url_ticket_86, c3_.facebook AS facebook_87, c3_.twitter AS twitter_88, c3_.instagram AS instagram_89, c3_.mobile AS mobile_90, c3_.geocodable AS geocodable_91, c3_.x AS x_92, c3_.y AS y_93, c3_.idmultimedia AS idmultimedia_94, c3_.type_view AS type_view_95, c3_.stats_access AS stats_access_96, c3_.ga_tracking_id AS ga_tracking_id_97, c3_.is_festival AS is_festival_98, c3_.link_on_video AS link_on_video_99, c3_.is_partenaire AS is_partenaire_100, c3_.valid_version AS valid_version_101, c3_.other_versions AS other_versions_102, c3_.url_redirect AS url_redirect_103, c3_.url_clean AS url_clean_104, c3_.dateupdate AS dateupdate_105, c3_.dateinsert AS dateinsert_106, c3_.publish AS publish_107, c3_.valid AS valid_108, e4_.idextranetuser AS idextranetuser_109 FROM spectacles s0_ LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser WHERE s0_.idspectacle = ?
Parameters:
[
"31156"
]
|
||||||||||||||||||||||||||||||
3 | 0.41 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=31156
Parameters:
[]
|
||||||||||||||||||||||||||||||
4 | 0.08 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||
5 | 0.57 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`, lt.`fr`, r.`idrole`, r.`role`, r.`type`, sp.`comment`,sp.`date_start`,sp.`date_end` FROM persons p JOIN spectacle_person sp ON sp.`idperson`=p.`idperson` JOIN roles r ON r.`idrole`=sp.`idrole` JOIN langterms lt ON r.`role`=lt.`id` WHERE sp.idspectacle=31156 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||
6 | 0.08 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`, lt.`fr`, r.`idrole`, r.`role`, r.`type`, sp.`comment`,sp.`date_start`,sp.`date_end` FROM persons p JOIN spectacle_person sp ON sp.`idperson`=p.`idperson` JOIN roles r ON r.`idrole`=sp.`idrole` JOIN langterms lt ON r.`role`=lt.`id` WHERE sp.idspectacle=31156 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||
7 | 0.31 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=31156 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||
8 | 0.10 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_affiche_spec'))) AND spectacles=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
9 | 1.51 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='31156' AND of.object='spectacles' AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_affiche_spec'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
|
||||||||||||||||||||||||||||||
10 | 7.38 ms |
SELECT aidecontacts.*,aides.* FROM `spectacle_aide` , `aides` , `aidecontacts` WHERE 1 AND spectacle_aide.idaide = aides.idaide AND aides.`publish`=1 AND aides.`type_aide`=1 AND (aides.aide != "" OR aides.aide IS NULL) AND aides.`idaidecontact`=aidecontacts.`idaidecontact` GROUP BY aidecontacts.`title` ORDER BY title ASC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||
11 | 0.25 ms |
SELECT a0_.idaidecontact AS idaidecontact_0, a0_.title AS title_1, a0_.description AS description_2, a0_.url_clean AS url_clean_3, a0_.dateupdate AS dateupdate_4, a0_.dateinsert AS dateinsert_5, a0_.publish AS publish_6 FROM aidecontacts a0_ WHERE a0_.idaidecontact = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||
12 | 0.99 ms |
SELECT DISTINCT(aides.idaide), aides.* FROM `contacts` , `aides` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide`=1 AND aides.`idaidecontact`=25 AND aides.`idcontact`=contacts.`idcontact` GROUP BY aides.idaide ORDER BY aides.dateinsert DESC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||
13 | 0.06 ms |
SELECT a0_.idaidecontact AS idaidecontact_0, a0_.title AS title_1, a0_.description AS description_2, a0_.url_clean AS url_clean_3, a0_.dateupdate AS dateupdate_4, a0_.dateinsert AS dateinsert_5, a0_.publish AS publish_6 FROM aidecontacts a0_ WHERE a0_.idaidecontact = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||
14 | 0.82 ms |
SELECT DISTINCT(aides.idaide), aides.* FROM `contacts` , `aides` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide`=1 AND aides.`idaidecontact`=99 AND aides.`idcontact`=contacts.`idcontact` GROUP BY aides.idaide ORDER BY aides.dateinsert DESC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||
15 | 0.05 ms |
SELECT a0_.idaidecontact AS idaidecontact_0, a0_.title AS title_1, a0_.description AS description_2, a0_.url_clean AS url_clean_3, a0_.dateupdate AS dateupdate_4, a0_.dateinsert AS dateinsert_5, a0_.publish AS publish_6 FROM aidecontacts a0_ WHERE a0_.idaidecontact = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||
16 | 0.81 ms |
SELECT DISTINCT(aides.idaide), aides.* FROM `contacts` , `aides` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide`=1 AND aides.`idaidecontact`=83 AND aides.`idcontact`=contacts.`idcontact` GROUP BY aides.idaide ORDER BY aides.dateinsert DESC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||
17 | 0.07 ms |
SELECT a0_.idaidecontact AS idaidecontact_0, a0_.title AS title_1, a0_.description AS description_2, a0_.url_clean AS url_clean_3, a0_.dateupdate AS dateupdate_4, a0_.dateinsert AS dateinsert_5, a0_.publish AS publish_6 FROM aidecontacts a0_ WHERE a0_.idaidecontact = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||
18 | 0.84 ms |
SELECT DISTINCT(aides.idaide), aides.* FROM `contacts` , `aides` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide`=1 AND aides.`idaidecontact`=94 AND aides.`idcontact`=contacts.`idcontact` GROUP BY aides.idaide ORDER BY aides.dateinsert DESC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||
19 | 0.07 ms |
SELECT a0_.idaidecontact AS idaidecontact_0, a0_.title AS title_1, a0_.description AS description_2, a0_.url_clean AS url_clean_3, a0_.dateupdate AS dateupdate_4, a0_.dateinsert AS dateinsert_5, a0_.publish AS publish_6 FROM aidecontacts a0_ WHERE a0_.idaidecontact = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||
20 | 0.76 ms |
SELECT DISTINCT(aides.idaide), aides.* FROM `contacts` , `aides` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide`=1 AND aides.`idaidecontact`=126 AND aides.`idcontact`=contacts.`idcontact` GROUP BY aides.idaide ORDER BY aides.dateinsert DESC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||
21 | 0.06 ms |
SELECT a0_.idaidecontact AS idaidecontact_0, a0_.title AS title_1, a0_.description AS description_2, a0_.url_clean AS url_clean_3, a0_.dateupdate AS dateupdate_4, a0_.dateinsert AS dateinsert_5, a0_.publish AS publish_6 FROM aidecontacts a0_ WHERE a0_.idaidecontact = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||
22 | 0.96 ms |
SELECT DISTINCT(aides.idaide), aides.* FROM `contacts` , `aides` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide`=1 AND aides.`idaidecontact`=105 AND aides.`idcontact`=contacts.`idcontact` GROUP BY aides.idaide ORDER BY aides.dateinsert DESC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||
23 | 0.07 ms |
SELECT a0_.idaidecontact AS idaidecontact_0, a0_.title AS title_1, a0_.description AS description_2, a0_.url_clean AS url_clean_3, a0_.dateupdate AS dateupdate_4, a0_.dateinsert AS dateinsert_5, a0_.publish AS publish_6 FROM aidecontacts a0_ WHERE a0_.idaidecontact = ?
Parameters:
[
null
]
|
||||||||||||||||||||||||||||||
24 | 0.78 ms |
SELECT DISTINCT(aides.idaide), aides.* FROM `contacts` , `aides` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide`=1 AND aides.`idaidecontact`=107 AND aides.`idcontact`=contacts.`idcontact` GROUP BY aides.idaide ORDER BY aides.dateinsert DESC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||
25 | 0.09 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_critique'))) AND spectacles=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
26 | 0.53 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total FROM object_content oc, contents c, content_classification cc, classifications cl WHERE oc.idcontent=c.idcontent AND c.idcontent=cc.idcontent AND oc.idobject='31156' AND oc.object='spectacles' AND cl.idclassification=cc.idclassification AND c.publish=1 AND c.valid=1 AND ((cl.classification IN ('class_critique')))
Parameters:
[]
|
||||||||||||||||||||||||||||||
27 | 0.44 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 INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_spectacle T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idspectacle=31156 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
28 | 0.35 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=31156 AND om.object='spectacles' AND m.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
29 | 0.25 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total FROM podcasts d, podcast_spectacle do WHERE d.`publish`=1 AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=31156 AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||
30 | 0.05 ms |
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||
31 | 0.46 ms |
SELECT COUNT(DISTINCT(of.idfile)) as total 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='31156' AND of.object='spectacles' AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
Parameters:
[]
|
||||||||||||||||||||||||||||||
32 | 0.44 ms |
SELECT oc.idcontent FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=31156 AND cc.idclassification=6 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
33 | 0.05 ms |
SELECT oc.idcontent FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=31156 AND cc.idclassification=6 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
34 | 0.27 ms |
SELECT oc.idcontent FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=31156 AND cc.idclassification=1 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
35 | 0.05 ms |
SELECT oc.idcontent FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=31156 AND cc.idclassification=1 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
36 | 0.20 ms |
SELECT COUNT(sc.idspectacle) FROM schedules sc WHERE sc.idspectacle=31156
Parameters:
[]
|
||||||||||||||||||||||||||||||
37 | 0.04 ms |
SELECT COUNT(sc.idspectacle) FROM schedules sc WHERE sc.idspectacle=31156
Parameters:
[]
|
||||||||||||||||||||||||||||||
38 | 0.32 ms |
SELECT oc.idcontent FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=31156 AND cc.idclassification=101 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
39 | 0.10 ms |
SELECT oc.idcontent FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=31156 AND cc.idclassification=101 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
40 | 0.36 ms |
SELECT oc.idcontent FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=31156 AND cc.idclassification=125 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
41 | 0.04 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (125))) AND texts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
42 | 0.34 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total FROM object_content oc, contents c, content_classification cc, classifications cl WHERE oc.idcontent=c.idcontent AND c.idcontent=cc.idcontent AND oc.idobject='38733' AND oc.object='texts' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.idclassification IN (125)))
Parameters:
[]
|
||||||||||||||||||||||||||||||
43 | 0.06 ms |
SELECT oc.idcontent FROM object_content oc, contents c, content_classification cc WHERE oc.idcontent=c.idcontent AND cc.idcontent=c.idcontent AND c.publish=1 AND oc.object='spectacles' AND oc.idobject=31156 AND cc.idclassification=125 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
44 | 0.31 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:
[ "c051de0f36e388c22ada0f484d8d08e0-ffda" 0 "7007ef8da0856d3aafc98526da6c2789" ]
|
||||||||||||||||||||||||||||||
45 | 1.40 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/spectacles/Le-Monde-a-l-envers/aides-etape" "7007ef8da0856d3aafc98526da6c2789" 0 "spectacles" 31156 0 "fr" "c051de0f36e388c22ada0f484d8d08e0-ffda" "/home/web/theatre-contemporain.net/dev/src/Controller/SpectacleController.php:518" ]
|
||||||||||||||||||||||||||||||
46 | 1.00 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
Entities Mapping
Class | Mapping errors |
---|---|
TheatreCore\Entity\Extranetusers | No errors. |
TheatreCore\Entity\Spectacles | No errors. |
TheatreCore\Entity\Typesspectacles | No errors. |
TheatreCore\Entity\Contacts | No errors. |
TheatreCore\Entity\Texts | No errors. |
TheatreCore\Entity\Contents | No errors. |
TheatreCore\Entity\Files | No errors. |
TheatreCore\Entity\Classifications | No errors. |
TheatreCore\Entity\Aidecontacts | No errors. |
TheatreCore\Entity\Aides | No errors. |
TheatreCore\Entity\News | No errors. |
TheatreCore\Entity\Multimedias | No errors. |
TheatreCore\Entity\Podcasts | No errors. |
TheatreCore\Entity\BookmarkExtranetuser | No errors. |
TheatreCore\Entity\Stats | No errors. |
TheatreCore\Entity\Abonnements | No errors. |
TheatreCore\Entity\Bannieres | No errors. |