GET https://ambire.iridian.co/faq

Query Metrics

8 Database Queries
5 Different statements
12.79 ms Query time
0 Invalid entities
77 Managed entities

Queries

Group similar statements

# Time Info
1 1.25 ms
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.position AS position_3 FROM faq_category f0_ ORDER BY f0_.position ASC
Parameters:
[]
2 1.31 ms
SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.published AS published_3, f0_.position AS position_4, f1_.id AS id_5, f1_.name AS name_6, f1_.slug AS slug_7, f1_.position AS position_8, f0_.category_id AS category_id_9 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.category_id = f1_.id WHERE f0_.published = 1 ORDER BY f0_.position ASC
Parameters:
[]
3 1.29 ms
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC
Parameters:
[
  "navbar_docs"
]
4 0.67 ms
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC
Parameters:
[
  "return_to_main"
]
5 5.30 ms
SELECT t0.id AS id_1, t0.logo_image AS logo_image_2, t0.hero_image AS hero_image_3, t0.quick_access_image AS quick_access_image_4, t0.footer_image AS footer_image_5 FROM site_setting t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
6 0.89 ms
SELECT t0.id AS id_1, t0.content_key AS content_key_2, t0.locale AS locale_3, t0.value AS value_4 FROM content_block t0 WHERE t0.locale = ?
Parameters:
[
  "en"
]
7 1.27 ms
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC
Parameters:
[
  "footer_legal"
]
8 0.81 ms
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC
Parameters:
[
  "footer_quick_links"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ContentBlock 28
App\Entity\NavigationItem 22
App\Entity\PdfDocument 13
App\Entity\Faq 8
App\Entity\FaqCategory 5
App\Entity\SiteSetting 1

Entities Mapping

Class Mapping errors
App\Entity\FaqCategory No errors.
App\Entity\Faq No errors.
App\Entity\NavigationItem No errors.
App\Entity\PdfDocument No errors.
App\Entity\SiteSetting No errors.
App\Entity\ContentBlock No errors.