GET https://mail.afjmas.com/publication-ethics

Response
200 OK
IP
216.73.217.95
Profiled on
Token
6fccc0

Query Metrics

16 Database Queries
4 Different statements
895.37 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 85.71 ms 
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: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
2 13.33 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
3 11.17 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "MAIL"
  0
]
View formatted query    View runnable query    Explain query
4 80.70 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
5 11.66 ms 
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.abbreviation AS abbreviation_2, j0_.url AS url_3, j0_.issn AS issn_4, j0_.doi AS doi_5, j0_.ceased AS ceased_6, j0_.email AS email_7, j0_.cover_image AS cover_image_8, j0_.created AS created_9, j0_.updated AS updated_10, j0_.deleted AS deleted_11, j0_.deleted_at AS deleted_at_12, j0_.group_id AS group_id_13 FROM journals j0_ WHERE j0_.deleted = 0 AND (LOWER(TRIM(j0_.url)) = ? OR LOWER(TRIM(j0_.abbreviation)) = ? OR LOWER(TRIM(j0_.url)) = ? OR LOWER(TRIM(j0_.url)) = ? OR LOWER(j0_.title) LIKE ?) LIMIT 1
Parameters: 
[
  "mail"
  "mail"
  "mail/"
  "/mail"
  "%mail%"
]
View formatted query    View runnable query    Explain query
6 78.61 ms 
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: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
7 99.71 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
8 99.62 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "MAIL"
  0
]
View formatted query    View runnable query    Explain query
9 99.86 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
10 8.72 ms 
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.abbreviation AS abbreviation_2, j0_.url AS url_3, j0_.issn AS issn_4, j0_.doi AS doi_5, j0_.ceased AS ceased_6, j0_.email AS email_7, j0_.cover_image AS cover_image_8, j0_.created AS created_9, j0_.updated AS updated_10, j0_.deleted AS deleted_11, j0_.deleted_at AS deleted_at_12, j0_.group_id AS group_id_13 FROM journals j0_ WHERE j0_.deleted = 0 AND (LOWER(TRIM(j0_.url)) = ? OR LOWER(TRIM(j0_.abbreviation)) = ? OR LOWER(TRIM(j0_.url)) = ? OR LOWER(TRIM(j0_.url)) = ? OR LOWER(j0_.title) LIKE ?) LIMIT 1
Parameters: 
[
  "mail"
  "mail"
  "mail/"
  "/mail"
  "%mail%"
]
View formatted query    View runnable query    Explain query
11 90.54 ms 
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: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
12 3.17 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
13 96.23 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "MAIL"
  0
]
View formatted query    View runnable query    Explain query
14 13.52 ms 
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.abbreviation = ? AND t0.deleted = ? LIMIT 1
Parameters: 
[
  "mail"
  0
]
View formatted query    View runnable query    Explain query
15 90.92 ms 
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.abbreviation AS abbreviation_2, j0_.url AS url_3, j0_.issn AS issn_4, j0_.doi AS doi_5, j0_.ceased AS ceased_6, j0_.email AS email_7, j0_.cover_image AS cover_image_8, j0_.created AS created_9, j0_.updated AS updated_10, j0_.deleted AS deleted_11, j0_.deleted_at AS deleted_at_12, j0_.group_id AS group_id_13 FROM journals j0_ WHERE j0_.deleted = 0 AND (LOWER(TRIM(j0_.url)) = ? OR LOWER(TRIM(j0_.abbreviation)) = ? OR LOWER(TRIM(j0_.url)) = ? OR LOWER(TRIM(j0_.url)) = ? OR LOWER(j0_.title) LIKE ?) LIMIT 1
Parameters: 
[
  "mail"
  "mail"
  "mail/"
  "/mail"
  "%mail%"
]
View formatted query    View runnable query    Explain query
16 11.90 ms 
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: 
[
  "publication-ethics"
]
View formatted query    View runnable query    Explain query

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\Content\Model\Page No errors.