https://141.95.127.228/

Query Metrics

40 Database Queries
12 Different statements
1683.55 ms Query time
0 Invalid entities
  • Queries
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Group similar statements

# Time Info
1 3.50 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 1.18 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 406.64 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 64.91 ms
SELECT DISTINCT (j0_.country) AS sclr_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> ?
Parameters:
0 of 0
[ "" ]
5 64.71 ms
SELECT DISTINCT (j0_.publisher) AS sclr_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> ?
Parameters:
0 of 0
[ "" ]
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:
0 of 0
[ "" ]
7 55.19 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:
0 of 0
[ "%Agronomy and Crop Science%" ]
8 0.88 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:
0 of 0
[ "%Arts and Humanities%" ]
9 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:
0 of 0
[ "%Agricultural and Biological Sciences%" ]
10 50.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:
0 of 0
[ "%Behavioral Neuroscience%" ]
11 52.97 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:
0 of 0
[ "%Artificial Intelligence%" ]
12 57.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:
0 of 0
[ "%Atomic and Molecular Physics%" ]
13 54.49 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:
0 of 0
[ "%Aging%" ]
14 60.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:
0 of 0
[ "%Assessment and Diagnosis%" ]
15 62.38 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:
0 of 0
[ "%Applied Psychology%" ]
16 62.63 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:
0 of 0
[ "%Applied Microbiology and Biotechnology%" ]
17 73.25 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:
[]
18 1.78 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:
0 of 0
[ "" ]
19 101.32 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:
0 of 0
[ "" ]
20 0.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[]
21 40.76 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:
0 of 0
[ "" ]
22 0.99 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:
0 of 0
[ "" ]
23 96.92 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:
0 of 0
[ "" ]
24 1.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[]
25 45.32 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:
0 of 0
[ "" ]
26 1.42 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:
0 of 0
[ "" ]
27 92.32 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:
0 of 0
[ "" ]
28 1.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[]
29 73.85 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:
0 of 0
[ "" ]
30 1.25 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:
0 of 0
[ "" ]
31 97.84 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:
0 of 0
[ "" ]
32 1.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[]
33 47.84 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:
0 of 0
[ "" ]
34 0.94 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:
0 of 0
[ "" ]
35 0.92 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:
0 of 0
[ 70 ]
36 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:
0 of 0
[ 72 ]
37 0.38 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:
0 of 0
[ 73 ]
38 0.41 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:
0 of 0
[ 74 ]
39 0.38 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:
0 of 0
[ 75 ]
40 0.40 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:
0 of 0
[ 76 ]