Query Metrics
27
Database Queries
19
Different statements
255.51 ms
Query time
2
Invalid entities
Queries
#▲ | 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 |
|
Sulu\Bundle\ContactBundle\Entity\Contact | No errors. |
Sulu\Bundle\ContactBundle\Entity\Account | No errors. |
App\Entity\Category |
|
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. |