GET https://www.ijobg.com/subscription-information

Query Metrics

79 Database Queries
4 Different statements
19.44 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
18.21 ms
(93.71%)
76
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = ? AND t0.journal_id = ?) ORDER BY t0.ordering ASC
Parameters:
[
  0
  "bffa9f00-c60b-4514-8bcf-65d5c2281047"
]
0.68 ms
(3.50%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.type AS type_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11 FROM pages t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "subscription-information"
]
0.31 ms
(1.62%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.abbreviation AS abbreviation_3, t0.url AS url_4, t0.issn AS issn_5, t0.doi AS doi_6, t0.ceased AS ceased_7, t0.email AS email_8, t0.cover_image AS cover_image_9, t0.created AS created_10, t0.updated AS updated_11, t0.deleted AS deleted_12, t0.deleted_at AS deleted_at_13, t0.group_id AS group_id_14, t15.id AS id_16, t15.name AS name_17, t15.created AS created_18, t15.updated AS updated_19, t15.deleted AS deleted_20, t15.deleted_at AS deleted_at_21 FROM journals t0 INNER JOIN journal_groups t15 ON t0.group_id = t15.id WHERE t0.url = ? AND t0.deleted = ? LIMIT 1
Parameters:
[
  "ijog"
  0
]
0.23 ms
(1.17%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.abbreviation AS abbreviation_3, t0.url AS url_4, t0.issn AS issn_5, t0.doi AS doi_6, t0.ceased AS ceased_7, t0.email AS email_8, t0.cover_image AS cover_image_9, t0.created AS created_10, t0.updated AS updated_11, t0.deleted AS deleted_12, t0.deleted_at AS deleted_at_13, t0.group_id AS group_id_14, t15.id AS id_16, t15.name AS name_17, t15.created AS created_18, t15.updated AS updated_19, t15.deleted AS deleted_20, t15.deleted_at AS deleted_at_21 FROM journals t0 INNER JOIN journal_groups t15 ON t0.group_id = t15.id WHERE t0.url = ? LIMIT 1
Parameters:
[
  "ijog"
]

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\Journal\Model\Journal No errors.
App\Journal\Model\Group No errors.
App\Journal\Model\Page No errors.
App\Journal\Article\Model\Article
  • The mappings App\Journal\Article\Model\Article#articleType and App\Journal\Article\Model\ArticleType#articles are inconsistent with each other.
App\Content\Model\Page No errors.