https://preprod.dev.researchguide.net/advancedSearchResults?openAccess=YES&p=1215

Query Metrics

27 Database Queries
19 Different statements
255.51 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 23.03 ms
SELECT count(j0_.id) AS sclr_0 FROM journal j0_ WHERE j0_.is_open_access IS NULL OR j0_.is_open_access = ? ORDER BY j0_.title ASC
Parameters:
[
  0
]
2 17.39 ms
SELECT count(DISTINCT j0_.id) AS sclr_0 FROM journal j0_ WHERE j0_.is_open_access IS NULL OR j0_.is_open_access = ?
Parameters:
[
  0
]
3 110.32 ms
SELECT DISTINCT j0_.id AS id_0, j0_.title AS title_1 FROM journal j0_ WHERE j0_.is_open_access IS NULL OR j0_.is_open_access = ? ORDER BY j0_.title ASC LIMIT 10 OFFSET 12140
Parameters:
[
  0
]
4 1.18 ms
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.category_name AS category_name_2, j0_.area AS area_3, j0_.guide AS guide_4, j0_.publisher AS publisher_5, j0_.quartile AS quartile_6, j0_.is_open_access AS is_open_access_7, j0_.print_issn AS print_issn_8, j0_.original_print_issn AS original_print_issn_9, j0_.original_eissn AS original_eissn_10, j0_.eissn AS eissn_11, j0_.citation_count AS citation_count_12, j0_.country AS country_13, j0_.region AS region_14, j0_.hindex AS hindex_15, j0_.updated_at AS updated_at_16, j0_.scope AS scope_17, j0_.email AS email_18, j0_.home_page AS home_page_19, j0_.start_date_open_licence AS start_date_open_licence_20, j0_.langue_manuscript AS langue_manuscript_21, j0_.country_publisher AS country_publisher_22, j0_.licence AS licence_23, j0_.review_url AS review_url_24, j0_.aim_scoop_url AS aim_scoop_url_25, j0_.weeks_between_submission_publication AS weeks_between_submission_publication_26, j0_.added_in_doaj_at AS added_in_doaj_at_27, j0_.last_updated_in_doaj_at AS last_updated_in_doaj_at_28, j0_.recent_article_added_at AS recent_article_added_at_29, j0_.how_to_publish AS how_to_publish_30, j0_.contributor_id AS contributor_id_31, j0_.publisher_org_id AS publisher_org_id_32 FROM journal j0_ WHERE (j0_.is_open_access IS NULL OR j0_.is_open_access = ?) AND j0_.id IN (?) ORDER BY j0_.title ASC
Parameters:
[
  0
  [
    4180
    12439
    3558
    3972
    2271
    2992
    10410
    5112
    5421
    14204
  ]
]
5 0.87 ms
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
  "default_live"
]
6 0.47 ms
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[]
7 1.18 ms
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters:
[]
8 0.56 ms
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters:
[]
9 5.39 ms
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/guidejournal/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
  "default_live"
]
10 0.59 ms
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = :workspace AND (path = :path0) ORDER BY sort_order ASC
Parameters:
[
  "workspace" => "default_live"
  "path0" => "/cmf/guidejournal/contents/blog"
]
11 0.56 ms
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  [
    "/cmf/guidejournal/contents/blog"
  ]
  "default_live"
]
12 0.46 ms
SELECT * FROM phpcr_nodes
              WHERE path = :path
                AND workspace_name = :workspace
              ORDER BY depth, sort_order ASC
Parameters:
[
  "path" => "/cmf/guidejournal/contents"
  "pathd" => "/cmf/guidejournal/contents/%"
  "workspace" => "default_live"
]
13 0.59 ms
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  [
    "/cmf/guidejournal/contents"
  ]
  "default_live"
]
14 36.14 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:
[
  ""
]
15 1.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[]
16 36.61 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:
[
  ""
]
17 1.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0
Parameters:
[]
18 5.39 ms
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer"]) > 0')) AND n0.path LIKE '/cmf/guidejournal/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
  "default_live"
]
19 0.98 ms
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = :workspace AND (path = :path0 OR path = :path1 OR path = :path2 OR path = :path3 OR path = :path4 OR path = :path5) ORDER BY sort_order ASC
Parameters:
[
  "workspace" => "default_live"
  "path0" => "/cmf/guidejournal/contents/about-us"
  "path1" => "/cmf/guidejournal/contents/contact-us"
  "path2" => "/cmf/guidejournal/contents/privacy-policy"
  "path3" => "/cmf/guidejournal/contents/top-journals-list"
  "path4" => "/cmf/guidejournal/contents/help"
  "path5" => "/cmf/guidejournal/contents/legal-notice"
]
20 0.67 ms
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  [
    "/cmf/guidejournal/contents/about-us"
    "/cmf/guidejournal/contents/contact-us"
    "/cmf/guidejournal/contents/privacy-policy"
    "/cmf/guidejournal/contents/top-journals-list"
    "/cmf/guidejournal/contents/help"
    "/cmf/guidejournal/contents/legal-notice"
  ]
  "default_live"
]
21 4.97 ms
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="services"]) > 0')) AND n0.path LIKE '/cmf/guidejournal/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
  "default_live"
]
22 0.64 ms
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = :workspace AND (path = :path0) ORDER BY sort_order ASC
Parameters:
[
  "workspace" => "default_live"
  "path0" => "/cmf/guidejournal/contents/indexing-services"
]
23 0.45 ms
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  [
    "/cmf/guidejournal/contents/indexing-services"
  ]
  "default_live"
]
24 1.50 ms
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="services"]) > 0')) AND n0.path LIKE '/cmf/guidejournal/contents/indexing-services/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
  "default_live"
]
25 0.63 ms
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = :workspace AND (path = :path0 OR path = :path1 OR path = :path2 OR path = :path3) ORDER BY sort_order ASC
Parameters:
[
  "workspace" => "default_live"
  "path0" => "/cmf/guidejournal/contents/indexing-services/google-scholar"
  "path1" => "/cmf/guidejournal/contents/indexing-services/doaj"
  "path2" => "/cmf/guidejournal/contents/indexing-services/index-copernicus"
  "path3" => "/cmf/guidejournal/contents/indexing-services/crossref"
]
26 0.56 ms
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  [
    "/cmf/guidejournal/contents/indexing-services/google-scholar"
    "/cmf/guidejournal/contents/indexing-services/doaj"
    "/cmf/guidejournal/contents/indexing-services/index-copernicus"
    "/cmf/guidejournal/contents/indexing-services/crossref"
  ]
  "default_live"
]
27 1.42 ms
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC, w1_.id ASC
Parameters:
[
  "preprod.dev.researchguide.net"
  "dev"
  "guidejournal"
]

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
Sulu\Bundle\FormBundle\Entity\Form No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
App\Entity\Follow No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
App\Entity\User No errors.
App\Entity\Allpublications No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
App\Entity\Journal
  • The association App\Entity\Journal#categories refers to the inverse side field App\Entity\Category#journal which does not exist.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
Sulu\Bundle\ContactBundle\Entity\Account No errors.
App\Entity\Category
  • The mappings App\Entity\Category#journals and App\Entity\Journal#categories are inconsistent with each other.
App\Entity\Comment No errors.
App\Entity\Contribution No errors.
App\Entity\Report No errors.
App\Entity\Post No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.