Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

71.77 ms Query time

0 Invalid entities

Queries

Group similar statements

master connection

#▲	Time	Info
1	71.77 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.referent AS referent_3, t0.referent_position AS referent_position_4, t0.address AS address_5, t0.street_number AS street_number_6, t0.zip AS zip_7, t0.fiscal_code AS fiscal_code_8, t0.creation_date AS creation_date_9, t0.vat AS vat_10, t0.pec AS pec_11, t0.order_type AS order_type_12, t0.order_subscription_num AS order_subscription_num_13, t0.other_city AS other_city_14, t0.other_province AS other_province_15, t0.other_country AS other_country_16, t0.db_name AS db_name_17, t0.configuration_phase AS configuration_phase_18, t0.last_edit_date AS last_edit_date_19, t0.subscription_date AS subscription_date_20, t0.directory_path AS directory_path_21, t0.logo_path AS logo_path_22, t0.is_admin_active AS is_admin_active_23, t0.self_evaluation AS self_evaluation_24, t0.alarm_end_delay AS alarm_end_delay_25, t0.allow_reseller_access AS allow_reseller_access_26, t0.allow_admin_access AS allow_admin_access_27, t0.is_company AS is_company_28, t0.risk_id AS risk_id_29, t0.license_id AS license_id_30, t0.type_id AS type_id_31, t0.city_id AS city_id_32, t0.risk_type_id AS risk_type_id_33 FROM eaml_m_office t0 WHERE t0.id IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.referent AS referent_3, t0.referent_position AS referent_position_4, t0.address AS address_5, t0.street_number AS street_number_6, t0.zip AS zip_7, t0.fiscal_code AS fiscal_code_8, t0.creation_date AS creation_date_9, t0.vat AS vat_10, t0.pec AS pec_11, t0.order_type AS order_type_12, t0.order_subscription_num AS order_subscription_num_13, t0.other_city AS other_city_14, t0.other_province AS other_province_15, t0.other_country AS other_country_16, t0.db_name AS db_name_17, t0.configuration_phase AS configuration_phase_18, t0.last_edit_date AS last_edit_date_19, t0.subscription_date AS subscription_date_20, t0.directory_path AS directory_path_21, t0.logo_path AS logo_path_22, t0.is_admin_active AS is_admin_active_23, t0.self_evaluation AS self_evaluation_24, t0.alarm_end_delay AS alarm_end_delay_25, t0.allow_reseller_access AS allow_reseller_access_26, t0.allow_admin_access AS allow_admin_access_27, t0.is_company AS is_company_28, t0.risk_id AS risk_id_29, t0.license_id AS license_id_30, t0.type_id AS type_id_31, t0.city_id AS city_id_32, t0.risk_type_id AS risk_type_id_33 FROM eaml_m_office t0 WHERE t0.id IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.referent AS referent_3, t0.referent_position AS referent_position_4, t0.address AS address_5, t0.street_number AS street_number_6, t0.zip AS zip_7, t0.fiscal_code AS fiscal_code_8, t0.creation_date AS creation_date_9, t0.vat AS vat_10, t0.pec AS pec_11, t0.order_type AS order_type_12, t0.order_subscription_num AS order_subscription_num_13, t0.other_city AS other_city_14, t0.other_province AS other_province_15, t0.other_country AS other_country_16, t0.db_name AS db_name_17, t0.configuration_phase AS configuration_phase_18, t0.last_edit_date AS last_edit_date_19, t0.subscription_date AS subscription_date_20, t0.directory_path AS directory_path_21, t0.logo_path AS logo_path_22, t0.is_admin_active AS is_admin_active_23, t0.self_evaluation AS self_evaluation_24, t0.alarm_end_delay AS alarm_end_delay_25, t0.allow_reseller_access AS allow_reseller_access_26, t0.allow_admin_access AS allow_admin_access_27, t0.is_company AS is_company_28, t0.risk_id AS risk_id_29, t0.license_id AS license_id_30, t0.type_id AS type_id_31, t0.city_id AS city_id_32, t0.risk_type_id AS risk_type_id_33 FROM eaml_m_office t0 WHERE t0.id IS NULL LIMIT 1;

#▲

Time

Info

71.77 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.referent AS referent_3, t0.referent_position AS referent_position_4, t0.address AS address_5, t0.street_number AS street_number_6, t0.zip AS zip_7, t0.fiscal_code AS fiscal_code_8, t0.creation_date AS creation_date_9, t0.vat AS vat_10, t0.pec AS pec_11, t0.order_type AS order_type_12, t0.order_subscription_num AS order_subscription_num_13, t0.other_city AS other_city_14, t0.other_province AS other_province_15, t0.other_country AS other_country_16, t0.db_name AS db_name_17, t0.configuration_phase AS configuration_phase_18, t0.last_edit_date AS last_edit_date_19, t0.subscription_date AS subscription_date_20, t0.directory_path AS directory_path_21, t0.logo_path AS logo_path_22, t0.is_admin_active AS is_admin_active_23, t0.self_evaluation AS self_evaluation_24, t0.alarm_end_delay AS alarm_end_delay_25, t0.allow_reseller_access AS allow_reseller_access_26, t0.allow_admin_access AS allow_admin_access_27, t0.is_company AS is_company_28, t0.risk_id AS risk_id_29, t0.license_id AS license_id_30, t0.type_id AS type_id_31, t0.city_id AS city_id_32, t0.risk_type_id AS risk_type_id_33 FROM eaml_m_office t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.referent AS referent_3,
  t0.referent_position AS referent_position_4,
  t0.address AS address_5,
  t0.street_number AS street_number_6,
  t0.zip AS zip_7,
  t0.fiscal_code AS fiscal_code_8,
  t0.creation_date AS creation_date_9,
  t0.vat AS vat_10,
  t0.pec AS pec_11,
  t0.order_type AS order_type_12,
  t0.order_subscription_num AS order_subscription_num_13,
  t0.other_city AS other_city_14,
  t0.other_province AS other_province_15,
  t0.other_country AS other_country_16,
  t0.db_name AS db_name_17,
  t0.configuration_phase AS configuration_phase_18,
  t0.last_edit_date AS last_edit_date_19,
  t0.subscription_date AS subscription_date_20,
  t0.directory_path AS directory_path_21,
  t0.logo_path AS logo_path_22,
  t0.is_admin_active AS is_admin_active_23,
  t0.self_evaluation AS self_evaluation_24,
  t0.alarm_end_delay AS alarm_end_delay_25,
  t0.allow_reseller_access AS allow_reseller_access_26,
  t0.allow_admin_access AS allow_admin_access_27,
  t0.is_company AS is_company_28,
  t0.risk_id AS risk_id_29,
  t0.license_id AS license_id_30,
  t0.type_id AS type_id_31,
  t0.city_id AS city_id_32,
  t0.risk_type_id AS risk_type_id_33
FROM
  eaml_m_office t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.referent AS referent_3, t0.referent_position AS referent_position_4, t0.address AS address_5, t0.street_number AS street_number_6, t0.zip AS zip_7, t0.fiscal_code AS fiscal_code_8, t0.creation_date AS creation_date_9, t0.vat AS vat_10, t0.pec AS pec_11, t0.order_type AS order_type_12, t0.order_subscription_num AS order_subscription_num_13, t0.other_city AS other_city_14, t0.other_province AS other_province_15, t0.other_country AS other_country_16, t0.db_name AS db_name_17, t0.configuration_phase AS configuration_phase_18, t0.last_edit_date AS last_edit_date_19, t0.subscription_date AS subscription_date_20, t0.directory_path AS directory_path_21, t0.logo_path AS logo_path_22, t0.is_admin_active AS is_admin_active_23, t0.self_evaluation AS self_evaluation_24, t0.alarm_end_delay AS alarm_end_delay_25, t0.allow_reseller_access AS allow_reseller_access_26, t0.allow_admin_access AS allow_admin_access_27, t0.is_company AS is_company_28, t0.risk_id AS risk_id_29, t0.license_id AS license_id_30, t0.type_id AS type_id_31, t0.city_id AS city_id_32, t0.risk_type_id AS risk_type_id_33 FROM eaml_m_office t0 WHERE t0.id IS NULL LIMIT 1;

slave connection

No database queries were performed.

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\Office	No errors.
App\Entity\Master\OfficeRisk	No errors.
App\Entity\Master\License	No errors.
App\Entity\Master\OfficeType	No errors.
App\Entity\Master\City	No errors.
App\Entity\Master\OfficeRiskType	No errors.
App\Entity\Master\JoinTableOfficeUser	No errors.
App\Entity\Master\OfficeInsurance	No errors.
App\Entity\Master\OfficeRiskLevel	No errors.
App\Entity\Master\OfficeRiskCnl	No errors.
App\Entity\Master\Reseller	No errors.
App\Entity\Master\LicenseType	No errors.
App\Entity\Master\Province	No errors.

slave entity manager

No loaded entities.