Query Metrics
61
Database Queries
5
Different statements
9.91 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.64 ms (87.18%) |
57 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_lab ON t0.id = media_lab.media_id WHERE media_lab.lab_id = ?
Parameters:
[
65
]
|
0.40 ms (4.05%) |
1 |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.acronym AS acronym_2, l0_.description AS description_3, l0_.address AS address_4, l0_.translation AS translation_5, l0_.slug AS slug_6, l0_.status AS status_7, l0_.created_at AS created_at_8, l0_.website AS website_9, l0_.github AS github_10, l0_.gitlab AS gitlab_11, l0_.bitbucket AS bitbucket_12, l0_.logo AS logo_13, l0_.linked_in AS linked_in_14, l0_.twitter AS twitter_15, l0_.facebook AS facebook_16, l0_.instagram AS instagram_17, l0_.youtube AS youtube_18, l0_.research_gate AS research_gate_19, l0_.academia AS academia_20, l0_.review AS review_21 FROM lab l0_ WHERE l0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY l0_.acronym ASC
Parameters:
[] |
0.35 ms (3.50%) |
1 |
SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, l1_.id AS id_6, l1_.name AS name_7, l1_.acronym AS acronym_8, l1_.description AS description_9, l1_.address AS address_10, l1_.translation AS translation_11, l1_.slug AS slug_12, l1_.status AS status_13, l1_.created_at AS created_at_14, l1_.website AS website_15, l1_.github AS github_16, l1_.gitlab AS gitlab_17, l1_.bitbucket AS bitbucket_18, l1_.logo AS logo_19, l1_.linked_in AS linked_in_20, l1_.twitter AS twitter_21, l1_.facebook AS facebook_22, l1_.instagram AS instagram_23, l1_.youtube AS youtube_24, l1_.research_gate AS research_gate_25, l1_.academia AS academia_26, l1_.review AS review_27, d0_.parent_id AS parent_id_28, d0_.author_id AS author_id_29 FROM domain d0_ INNER JOIN lab_domain l2_ ON d0_.id = l2_.domain_id INNER JOIN lab l1_ ON l1_.id = l2_.lab_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND l1_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[] |
0.28 ms (2.83%) |
1 |
SELECT g0_.id AS id_0, g0_.continent AS continent_1, g0_.country AS country_2, g0_.region AS region_3, g0_.department AS department_4, g0_.city AS city_5, g0_.status AS status_6, g0_.created_at AS created_at_7, g0_.zip_code AS zip_code_8, g0_.address AS address_9, g0_.department_num AS department_num_10, l1_.id AS id_11, l1_.name AS name_12, l1_.acronym AS acronym_13, l1_.description AS description_14, l1_.address AS address_15, l1_.translation AS translation_16, l1_.slug AS slug_17, l1_.status AS status_18, l1_.created_at AS created_at_19, l1_.website AS website_20, l1_.github AS github_21, l1_.gitlab AS gitlab_22, l1_.bitbucket AS bitbucket_23, l1_.logo AS logo_24, l1_.linked_in AS linked_in_25, l1_.twitter AS twitter_26, l1_.facebook AS facebook_27, l1_.instagram AS instagram_28, l1_.youtube AS youtube_29, l1_.research_gate AS research_gate_30, l1_.academia AS academia_31, l1_.review AS review_32 FROM geolocation g0_ INNER JOIN lab_geolocation l2_ ON g0_.id = l2_.geolocation_id INNER JOIN lab l1_ ON l1_.id = l2_.lab_id
Parameters:
[] |
0.24 ms (2.44%) |
1 |
SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, l1_.id AS id_6, l1_.name AS name_7, l1_.acronym AS acronym_8, l1_.description AS description_9, l1_.address AS address_10, l1_.translation AS translation_11, l1_.slug AS slug_12, l1_.status AS status_13, l1_.created_at AS created_at_14, l1_.website AS website_15, l1_.github AS github_16, l1_.gitlab AS gitlab_17, l1_.bitbucket AS bitbucket_18, l1_.logo AS logo_19, l1_.linked_in AS linked_in_20, l1_.twitter AS twitter_21, l1_.facebook AS facebook_22, l1_.instagram AS instagram_23, l1_.youtube AS youtube_24, l1_.research_gate AS research_gate_25, l1_.academia AS academia_26, l1_.review AS review_27, d0_.parent_id AS parent_id_28, d0_.author_id AS author_id_29 FROM discipline d0_ INNER JOIN lab_discipline l2_ ON d0_.id = l2_.discipline_id INNER JOIN lab l1_ ON l1_.id = l2_.lab_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND l1_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[] |
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\Entity\Domain | No errors. |
App\Entity\Lab | No errors. |
App\Entity\User |
|
App\Entity\Software | No errors. |
App\Entity\Team | No errors. |
App\Entity\Institution | No errors. |
App\Entity\Training | No errors. |
App\Entity\Discipline | No errors. |
App\Entity\Skill | No errors. |
App\Entity\Comment | No errors. |
App\Entity\Media | No errors. |
App\Entity\Article | No errors. |
App\Entity\License | No errors. |
App\Entity\Page | No errors. |
App\Entity\Keyword | No errors. |
App\Entity\Tag | No errors. |
App\Entity\LabCopy | No errors. |
App\Entity\Geolocation | No errors. |