Query Metrics
49
Database Queries
15
Different statements
1789.83 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 8.57 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.97 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 | 342.41 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 | 78.40 ms |
SELECT DISTINCT (j0_.country) AS sclr_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> ?
Parameters:
[ "" ] |
5 | 65.24 ms |
SELECT DISTINCT (j0_.publisher) AS sclr_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> ?
Parameters:
[ "" ] |
6 | 1.26 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 | 45.42 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%"
]
|
8 | 45.96 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%"
]
|
9 | 58.62 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:
[
"%Atmospheric Science%"
]
|
10 | 72.72 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:
[
"%Automotive Engineering%"
]
|
11 | 1.02 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:
[
"%Accounting%"
]
|
12 | 0.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:
[
"%Accounting%"
]
|
13 | 62.87 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:
[
"%Applied Mathematics%"
]
|
14 | 66.91 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:
[
"%Applied Mathematics%"
]
|
15 | 54.81 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:
[
"%Archeology%"
]
|
16 | 0.90 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:
[
"%Arts and Humanities%"
]
|
17 | 0.65 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:
[
"%Arts and Humanities%"
]
|
18 | 59.07 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 | 0.87 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:
[
"%Agricultural and Biological Sciences%"
]
|
20 | 0.58 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:
[
"%Agricultural and Biological Sciences%"
]
|
21 | 50.07 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:
[
"%Aging%"
]
|
22 | 59.85 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:
[
"%Aging%"
]
|
23 | 1.30 ms |
"START TRANSACTION"
Parameters:
[] |
24 | 2.29 ms |
UPDATE future_conference SET image = ? WHERE id = ?
Parameters:
[ null 166 ] |
25 | 5.46 ms |
"COMMIT"
Parameters:
[] |
26 | 71.94 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:
[] |
27 | 1.28 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:
[ "" ] |
28 | 128.89 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:
[ "" ] |
29 | 1.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[] |
30 | 46.44 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:
[ "" ] |
31 | 1.20 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:
[ "" ] |
32 | 114.79 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:
[ "" ] |
33 | 2.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[] |
34 | 45.69 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:
[ "" ] |
35 | 0.95 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:
[ "" ] |
36 | 103.96 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:
[ "" ] |
37 | 1.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[] |
38 | 44.49 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:
[ "" ] |
39 | 1.05 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:
[ "" ] |
40 | 91.30 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:
[ "" ] |
41 | 0.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[] |
42 | 41.91 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:
[ "" ] |
43 | 0.95 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:
[ "" ] |
44 | 0.87 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
]
|
45 | 0.35 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
]
|
46 | 0.29 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
]
|
47 | 0.27 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
]
|
48 | 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:
[
53
]
|
49 | 0.23 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. |