Query Metrics
17
Database Queries
5
Different statements
807.15 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 99.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 ] |
| 2 | 2.81 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 ] |
| 3 | 4.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 ] |
| 4 | 91.25 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 ] |
| 5 | 8.16 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%" ] |
| 6 | 188.12 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 ] |
| 7 | 102.09 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 ] |
| 8 | 97.24 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 ] |
| 9 | 8.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 ] |
| 10 | 95.51 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%" ] |
| 11 | 0.67 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 ] |
| 12 | 3.65 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 ] |
| 13 | 90.20 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 ] |
| 14 | 5.37 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 ] |
| 15 | 0.40 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%" ] |
| 16 | 1.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.ceased = ? AND t0.deleted = ? ORDER BY t0.title ASC LIMIT 100
Parameters:
[ 0 0 ] |
| 17 | 7.50 ms |
SELECT COUNT(*) FROM journals t0 WHERE t0.ceased = ? AND t0.deleted = ?
Parameters:
[ 0 0 ] |
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 |
|