Query Metrics
19
Database Queries
15
Different statements
128.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 87.91 ms |
SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.path AS path_4 FROM path t0 WHERE t0.path = ? ORDER BY t0.entity_type DESC
Parameters:
[
"conf/pedagogy"
]
|
| 2 | 5.56 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.direction AS direction_2, e0_.date_end AS date_end_3, e0_.date_publ AS date_publ_4, e0_.cover AS cover_5, e0_.number AS number_6, e0_.link_elibrary AS link_elibrary_7, e0_.created AS created_8, e0_.body AS body_9, e0_.nid AS nid_10, e0_.exit_data AS exit_data_11, e0_.link_rinc AS link_rinc_12, e0_.updated AS updated_13, e0_.file AS file_14, e0_.email_subscribe AS email_subscribe_15, e0_.status AS status_16, e0_.send_email_pdf AS send_email_pdf_17, e0_.date_send_elibrary AS date_send_elibrary_18, e0_.date_send_date AS date_send_date_19, e0_.date_send_postal AS date_send_postal_20, e0_.price AS price_21, e0_.path_id AS path_id_22, e0_.user_id AS user_id_23 FROM edition e0_ WHERE e0_.direction = ? AND e0_.date_end >= ? AND e0_.status = 1 ORDER BY e0_.date_end ASC LIMIT 1
Parameters:
[ "conf/pedagogy" "2026-03-16" ] |
| 3 | 0.47 ms |
SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.path AS path_4 FROM path t0 WHERE t0.id IN (?)
Parameters:
[
696922
]
|
| 4 | 0.63 ms |
SELECT t0.id AS id_1, t0.pages AS pages_2, t0.filepath AS filepath_3, t0.entity_id AS entity_id_4 FROM edition_pages t0 WHERE t0.entity_id IN (?)
Parameters:
[
3207
]
|
| 5 | 0.22 ms |
SELECT t0.id AS id_1, t0.pages AS pages_2, t0.filepath AS filepath_3, t0.entity_id AS entity_id_4 FROM edition_pages t0 WHERE t0.entity_id = ?
Parameters:
[
3207
]
|
| 6 | 14.07 ms |
SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.category_id AS category_id_4, t5.id AS id_6, t5.gid AS gid_7, t5.name AS name_8, t5.weight AS weight_9, t5.parent AS parent_10 FROM category_entity t0 INNER JOIN category t5 ON t0.category_id = t5.id WHERE t0.entity_id = ? AND t0.entity_type = ?
Parameters:
[ 3207 "edition" ] |
| 7 | 5.51 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.direction AS direction_2, e0_.date_end AS date_end_3, e0_.date_publ AS date_publ_4, e0_.cover AS cover_5, e0_.number AS number_6, e0_.link_elibrary AS link_elibrary_7, e0_.created AS created_8, e0_.body AS body_9, e0_.nid AS nid_10, e0_.exit_data AS exit_data_11, e0_.link_rinc AS link_rinc_12, e0_.updated AS updated_13, e0_.file AS file_14, e0_.email_subscribe AS email_subscribe_15, e0_.status AS status_16, e0_.send_email_pdf AS send_email_pdf_17, e0_.date_send_elibrary AS date_send_elibrary_18, e0_.date_send_date AS date_send_date_19, e0_.date_send_postal AS date_send_postal_20, e0_.price AS price_21, p1_.path AS path_22 FROM edition e0_ INNER JOIN path p1_ ON e0_.path_id = p1_.id WHERE e0_.direction = ? AND e0_.date_end < ? AND e0_.status = 1 ORDER BY e0_.date_end DESC LIMIT 1
Parameters:
[ "conf/pedagogy" "2026-03-16" ] |
| 8 | 4.66 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.direction AS direction_2, e0_.date_end AS date_end_3, e0_.date_publ AS date_publ_4, e0_.cover AS cover_5, e0_.number AS number_6, e0_.link_elibrary AS link_elibrary_7, e0_.created AS created_8, e0_.body AS body_9, e0_.nid AS nid_10, e0_.exit_data AS exit_data_11, e0_.link_rinc AS link_rinc_12, e0_.updated AS updated_13, e0_.file AS file_14, e0_.email_subscribe AS email_subscribe_15, e0_.status AS status_16, e0_.send_email_pdf AS send_email_pdf_17, e0_.date_send_elibrary AS date_send_elibrary_18, e0_.date_send_date AS date_send_date_19, e0_.date_send_postal AS date_send_postal_20, e0_.price AS price_21, p1_.path AS path_22 FROM edition e0_ INNER JOIN path p1_ ON e0_.path_id = p1_.id WHERE e0_.direction = ? AND e0_.date_end >= ? AND e0_.status = 1 ORDER BY e0_.date_end ASC LIMIT 1
Parameters:
[ "conf/pedagogy" "2026-03-16" ] |
| 9 | 4.90 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.direction AS direction_2, e0_.date_end AS date_end_3, e0_.date_publ AS date_publ_4, e0_.cover AS cover_5, e0_.number AS number_6, e0_.link_elibrary AS link_elibrary_7, e0_.created AS created_8, e0_.body AS body_9, e0_.nid AS nid_10, e0_.exit_data AS exit_data_11, e0_.link_rinc AS link_rinc_12, e0_.updated AS updated_13, e0_.file AS file_14, e0_.email_subscribe AS email_subscribe_15, e0_.status AS status_16, e0_.send_email_pdf AS send_email_pdf_17, e0_.date_send_elibrary AS date_send_elibrary_18, e0_.date_send_date AS date_send_date_19, e0_.date_send_postal AS date_send_postal_20, e0_.price AS price_21, p1_.path AS path_22 FROM edition e0_ INNER JOIN path p1_ ON e0_.path_id = p1_.id WHERE e0_.direction = ? AND e0_.date_end >= ? AND e0_.status = 1 ORDER BY e0_.date_end ASC LIMIT 1 OFFSET 1
Parameters:
[ "conf/pedagogy" "2026-03-16" ] |
| 10 | 0.48 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pages AS pages_3, t0.publ_status AS publ_status_4, t0.part AS part_5, t0.status AS status_6, t0.created AS created_7, t0.nid AS nid_8, t0.updated AS updated_9, t0.doi AS doi_10, t0.content AS content_11, t0.remove AS remove_12, t0.remove_text AS remove_text_13, t0.edition_id AS edition_id_14, t0.category_id AS category_id_15, t0.user_id AS user_id_16, t0.path_id AS path_id_17 FROM articles t0 WHERE t0.edition_id = ?
Parameters:
[
3207
]
|
| 11 | 0.59 ms |
SELECT t0.id AS id_1, t0.article_id AS article_id_2, t3.id AS id_4, t3.title AS title_5, t3.pages AS pages_6, t3.publ_status AS publ_status_7, t3.part AS part_8, t3.status AS status_9, t3.created AS created_10, t3.nid AS nid_11, t3.updated AS updated_12, t3.doi AS doi_13, t3.content AS content_14, t3.remove AS remove_15, t3.remove_text AS remove_text_16, t3.edition_id AS edition_id_17, t3.category_id AS category_id_18, t3.user_id AS user_id_19, t3.path_id AS path_id_20, t0.authors_id AS authors_id_21, t22.id AS id_23, t22.name AS name_24, t22.status AS status_25, t22.created AS created_26, t22.nid AS nid_27, t22.user_id AS user_id_28, t22.path_id AS path_id_29 FROM article_authors t0 INNER JOIN articles t3 ON t0.article_id = t3.id INNER JOIN authors t22 ON t0.authors_id = t22.id WHERE t0.article_id IN (?, ?, ?)
Parameters:
[ 133256 133296 133621 ] |
| 12 | 0.44 ms |
SELECT t0.id AS id_1, t0.article_id AS article_id_2, t3.id AS id_4, t3.title AS title_5, t3.pages AS pages_6, t3.publ_status AS publ_status_7, t3.part AS part_8, t3.status AS status_9, t3.created AS created_10, t3.nid AS nid_11, t3.updated AS updated_12, t3.doi AS doi_13, t3.content AS content_14, t3.remove AS remove_15, t3.remove_text AS remove_text_16, t3.edition_id AS edition_id_17, t3.category_id AS category_id_18, t3.user_id AS user_id_19, t3.path_id AS path_id_20, t0.authors_id AS authors_id_21, t22.id AS id_23, t22.name AS name_24, t22.status AS status_25, t22.created AS created_26, t22.nid AS nid_27, t22.user_id AS user_id_28, t22.path_id AS path_id_29 FROM article_scidirectors t0 INNER JOIN articles t3 ON t0.article_id = t3.id INNER JOIN authors t22 ON t0.authors_id = t22.id WHERE t0.article_id IN (?, ?, ?)
Parameters:
[ 133256 133296 133621 ] |
| 13 | 0.24 ms |
SELECT t0.id AS id_1, t0.gid AS gid_2, t0.name AS name_3, t0.weight AS weight_4, t0.parent AS parent_5 FROM category t0 WHERE t0.id = ?
Parameters:
[
865
]
|
| 14 | 0.98 ms |
SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.category_id AS category_id_4, t5.id AS id_6, t5.gid AS gid_7, t5.name AS name_8, t5.weight AS weight_9, t5.parent AS parent_10 FROM category_entity t0 INNER JOIN category t5 ON t0.category_id = t5.id WHERE t0.category_id IN (?)
Parameters:
[
865
]
|
| 15 | 0.42 ms |
SELECT t0.id AS id_1, t0.gid AS gid_2, t0.name AS name_3, t0.weight AS weight_4, t0.parent AS parent_5 FROM category t0 WHERE t0.id = ?
Parameters:
[
878
]
|
| 16 | 0.68 ms |
SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.category_id AS category_id_4, t5.id AS id_6, t5.gid AS gid_7, t5.name AS name_8, t5.weight AS weight_9, t5.parent AS parent_10 FROM category_entity t0 INNER JOIN category t5 ON t0.category_id = t5.id WHERE t0.category_id IN (?)
Parameters:
[
878
]
|
| 17 | 0.25 ms |
SELECT t0.id AS id_1, t0.gid AS gid_2, t0.name AS name_3, t0.weight AS weight_4, t0.parent AS parent_5 FROM category t0 WHERE t0.id = ?
Parameters:
[
867
]
|
| 18 | 0.46 ms |
SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.category_id AS category_id_4, t5.id AS id_6, t5.gid AS gid_7, t5.name AS name_8, t5.weight AS weight_9, t5.parent AS parent_10 FROM category_entity t0 INNER JOIN category t5 ON t0.category_id = t5.id WHERE t0.category_id IN (?)
Parameters:
[
867
]
|
| 19 | 0.40 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.email AS email_2, f0_.subject AS subject_3, f0_.message AS message_4, f0_.status AS status_5, f0_.created AS created_6, f0_.direction AS direction_7, f0_.agreement AS agreement_8, f0_.contact_phone AS contact_phone_9 FROM feedback f0_ WHERE f0_.status = 1 AND f0_.direction = ? ORDER BY f0_.id DESC LIMIT 10
Parameters:
[
4
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Path | No errors. |
| App\Entity\Edition | No errors. |
| App\Entity\User | No errors. |
| App\Entity\EditionPages | No errors. |
| App\Entity\Articles | No errors. |
| App\Entity\CategoryEntity | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\ArticleAuthors | No errors. |
| App\Entity\ArticleScidirectors | No errors. |
| App\Entity\Authors | No errors. |
| App\Entity\Feedback | No errors. |