https://test.internauka.org/conf/tech

Query Metrics

19 Database Queries
15 Different statements
106.50 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 71.92 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/tech"
]
2 5.08 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/tech"
  "2026-03-16"
]
3 0.38 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:
[
  696912
]
4 0.25 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:
[
  3205
]
5 0.18 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:
[
  3205
]
6 13.22 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:
[
  3205
  "edition"
]
7 4.63 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/tech"
  "2026-03-16"
]
8 4.00 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/tech"
  "2026-03-16"
]
9 3.63 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/tech"
  "2026-03-16"
]
10 0.33 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:
[
  3205
]
11 0.49 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:
[
  132925
  133077
  133650
]
12 0.35 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:
[
  132925
  133077
  133650
]
13 0.21 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:
[
  930
]
14 0.38 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:
[
  930
]
15 0.17 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:
[
  928
]
16 0.47 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:
[
  928
]
17 0.21 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:
[
  924
]
18 0.23 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:
[
  924
]
19 0.39 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.