Query Metrics
47
Database Queries
12
Different statements
2014.41 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.06 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.description AS description_4, t0.image AS image_5 FROM future_conference t0
Parameters:
[] |
2 | 0.79 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7, t0.image_id AS image_id_8 FROM post t0
Parameters:
[] |
3 | 367.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.category_name AS category_name_3, t0.area AS area_4, t0.guide AS guide_5, t0.publisher AS publisher_6, t0.quartile AS quartile_7, t0.is_open_access AS is_open_access_8, t0.print_issn AS print_issn_9, t0.original_print_issn AS original_print_issn_10, t0.original_eissn AS original_eissn_11, t0.eissn AS eissn_12, t0.citation_count AS citation_count_13, t0.country AS country_14, t0.region AS region_15, t0.hindex AS hindex_16, t0.updated_at AS updated_at_17, t0.scope AS scope_18, t0.email AS email_19, t0.home_page AS home_page_20, t0.start_date_open_licence AS start_date_open_licence_21, t0.langue_manuscript AS langue_manuscript_22, t0.country_publisher AS country_publisher_23, t0.licence AS licence_24, t0.review_url AS review_url_25, t0.aim_scoop_url AS aim_scoop_url_26, t0.weeks_between_submission_publication AS weeks_between_submission_publication_27, t0.added_in_doaj_at AS added_in_doaj_at_28, t0.last_updated_in_doaj_at AS last_updated_in_doaj_at_29, t0.recent_article_added_at AS recent_article_added_at_30, t0.how_to_publish AS how_to_publish_31, t0.sjr AS sjr_32, t0.total_doc_last_year AS total_doc_last_year_33, t0.total_docs_3_years AS total_docs_3_years_34, t0.total_refs AS total_refs_35, t0.total_cites_3_years AS total_cites_3_years_36, t0.citable_docs_3_years AS citable_docs_3_years_37, t0.cites_docs_2_years AS cites_docs_2_years_38, t0.ref_per_doc AS ref_per_doc_39, t0.female AS female_40, t0.overton AS overton_41, t0.sdg AS sdg_42, t0.coverage AS coverage_43, t0.contributor_id AS contributor_id_44 FROM journal t0
Parameters:
[] |
4 | 55.45 ms |
SELECT DISTINCT (j0_.country) AS sclr_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> ?
Parameters:
[ "" ] |
5 | 50.24 ms |
SELECT DISTINCT (j0_.publisher) AS sclr_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> ?
Parameters:
[ "" ] |
6 | 1.17 ms |
SELECT DISTINCT c0_.name AS name_0, c0_.id AS id_1 FROM category c0_ WHERE c0_.name IS NOT NULL AND c0_.name <> ? ORDER BY c0_.name ASC
Parameters:
[ "" ] |
7 | 47.26 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Anesthesiology and Pain Medicine%"
]
|
8 | 50.92 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Anesthesiology and Pain Medicine%"
]
|
9 | 52.27 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Algebra and Number Theory%"
]
|
10 | 50.71 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Algebra and Number Theory%"
]
|
11 | 50.04 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Analytical Chemistry%"
]
|
12 | 63.80 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Analytical Chemistry%"
]
|
13 | 57.76 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Assessment and Diagnosis%"
]
|
14 | 45.99 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Artificial Intelligence%"
]
|
15 | 45.98 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Artificial Intelligence%"
]
|
16 | 45.51 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Architecture%"
]
|
17 | 46.39 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Architecture%"
]
|
18 | 51.13 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Anatomy%"
]
|
19 | 52.28 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Anthropology%"
]
|
20 | 52.75 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Aquatic Science%"
]
|
21 | 61.80 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Aquatic Science%"
]
|
22 | 65.08 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Analysis%"
]
|
23 | 56.57 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.scope AS scope_2 FROM journal j0_ WHERE j0_.area LIKE ? LIMIT 4
Parameters:
[
"%Analysis%"
]
|
24 | 74.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternative_name AS alternative_name_3, t0.affiliation AS affiliation_4, t0.last_known_institutions AS last_known_institutions_5, t0.topics AS topics_6, t0.publications AS publications_7, t0.fields AS fields_8 FROM author t0
Parameters:
[] |
25 | 2.41 ms |
SELECT DISTINCT c0_.name AS name_0, c0_.id AS id_1 FROM category c0_ WHERE c0_.name IS NOT NULL AND c0_.name <> ? ORDER BY c0_.name ASC
Parameters:
[ "" ] |
26 | 121.34 ms |
SELECT DISTINCT j0_.publisher AS publisher_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> ? ORDER BY j0_.publisher ASC
Parameters:
[ "" ] |
27 | 1.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[] |
28 | 44.63 ms |
SELECT DISTINCT j0_.country AS country_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> ? ORDER BY j0_.country ASC
Parameters:
[ "" ] |
29 | 1.29 ms |
SELECT DISTINCT c0_.name AS name_0, c0_.id AS id_1 FROM category c0_ WHERE c0_.name IS NOT NULL AND c0_.name <> ? ORDER BY c0_.name ASC
Parameters:
[ "" ] |
30 | 98.15 ms |
SELECT DISTINCT j0_.publisher AS publisher_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> ? ORDER BY j0_.publisher ASC
Parameters:
[ "" ] |
31 | 1.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[] |
32 | 45.88 ms |
SELECT DISTINCT j0_.country AS country_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> ? ORDER BY j0_.country ASC
Parameters:
[ "" ] |
33 | 0.86 ms |
SELECT DISTINCT c0_.name AS name_0, c0_.id AS id_1 FROM category c0_ WHERE c0_.name IS NOT NULL AND c0_.name <> ? ORDER BY c0_.name ASC
Parameters:
[ "" ] |
34 | 80.50 ms |
SELECT DISTINCT j0_.publisher AS publisher_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> ? ORDER BY j0_.publisher ASC
Parameters:
[ "" ] |
35 | 1.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[] |
36 | 38.54 ms |
SELECT DISTINCT j0_.country AS country_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> ? ORDER BY j0_.country ASC
Parameters:
[ "" ] |
37 | 0.83 ms |
SELECT DISTINCT c0_.name AS name_0, c0_.id AS id_1 FROM category c0_ WHERE c0_.name IS NOT NULL AND c0_.name <> ? ORDER BY c0_.name ASC
Parameters:
[ "" ] |
38 | 82.99 ms |
SELECT DISTINCT j0_.publisher AS publisher_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> ? ORDER BY j0_.publisher ASC
Parameters:
[ "" ] |
39 | 1.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[] |
40 | 38.77 ms |
SELECT DISTINCT j0_.country AS country_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> ? ORDER BY j0_.country ASC
Parameters:
[ "" ] |
41 | 0.86 ms |
SELECT DISTINCT c0_.name AS name_0, c0_.id AS id_1 FROM category c0_ WHERE c0_.name IS NOT NULL AND c0_.name <> ? ORDER BY c0_.name ASC
Parameters:
[ "" ] |
42 | 0.71 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.file_path AS file_path_3 FROM media t0 WHERE t0.id = ?
Parameters:
[
57
]
|
43 | 0.39 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.file_path AS file_path_3 FROM media t0 WHERE t0.id = ?
Parameters:
[
56
]
|
44 | 0.32 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.file_path AS file_path_3 FROM media t0 WHERE t0.id = ?
Parameters:
[
55
]
|
45 | 0.39 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.file_path AS file_path_3 FROM media t0 WHERE t0.id = ?
Parameters:
[
54
]
|
46 | 0.33 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.file_path AS file_path_3 FROM media t0 WHERE t0.id = ?
Parameters:
[
53
]
|
47 | 0.36 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.file_path AS file_path_3 FROM media t0 WHERE t0.id = ?
Parameters:
[
52
]
|
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\Allpublications | No errors. |
App\Entity\FutureConference | No errors. |
App\Entity\Post | No errors. |
App\Entity\Media | No errors. |
App\Entity\Category | No errors. |
App\Entity\Tag | No errors. |
App\Entity\Journal | No errors. |
App\Entity\User | No errors. |
App\Entity\Comment | No errors. |
App\Entity\Contribution | No errors. |
App\Entity\Report | No errors. |
App\Entity\Author | No errors. |
App\Entity\Follow | No errors. |