GET https://app-test.yato.group/faqs

Query Metrics

3 Database Queries
3 Different statements
1.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

master connection

Time Count Info
0.90 ms
(47.71%)
1
SELECT h0_.id AS id_0, h0_.priority AS priority_1, h0_.slug AS slug_2, h0_.value AS value_3 FROM ht_m_faq_category h0_ INNER JOIN ht_m_faq h1_ ON h0_.id = h1_.category_id ORDER BY h0_.priority ASC
Parameters:
[]
0.56 ms
(29.80%)
1
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.is_active AS is_active_3, t0.is_public AS is_public_4, t0.question AS question_5, t0.answer AS answer_6, t0.category_id AS category_id_7 FROM ht_m_faq t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
0.42 ms
(22.49%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_admin_active AS is_admin_active_3, t0.email AS email_4, t0.pec AS pec_5, t0.phone AS phone_6, t0.vat AS vat_7, t0.fiscal_code AS fiscal_code_8, t0.sdi AS sdi_9, t0.website AS website_10, t0.address AS address_11, t0.civic AS civic_12, t0.city AS city_13, t0.zip AS zip_14, t0.province AS province_15, t0.country AS country_16, t0.reminder AS reminder_17, t0.db_name AS db_name_18, t0.logo_path AS logo_path_19, t0.absolute_logo_path AS absolute_logo_path_20, t0.square_logo_path AS square_logo_path_21, t0.absolute_square_logo_path AS absolute_square_logo_path_22, t0.otp_active AS otp_active_23, t0.activation_date AS activation_date_24, t0.property_type_id AS property_type_id_25 FROM ht_m_property t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[]

Database Connections

Name Service
master doctrine.dbal.master_connection
slave doctrine.dbal.slave_connection

Entity Managers

Name Service
master doctrine.orm.master_entity_manager
slave doctrine.orm.slave_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

master entity manager

Class Mapping errors
App\Entity\Master\FaqCategory No errors.
App\Entity\Master\Faq No errors.
App\Entity\Master\Property No errors.
App\Entity\Master\PropertyType No errors.

slave entity manager

No loaded entities.