Query Metrics
15
Database Queries
7
Different statements
6.89 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.77 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 2 | 1.55 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.admin AS admin_4, t0.allow_particuliers AS allow_particuliers_5, t0.allow_offres_sur_grilles AS allow_offres_sur_grilles_6, t0.allow_cotations AS allow_cotations_7, t0.allow_customer_base AS allow_customer_base_8, t0.email AS email_9, t0.phone AS phone_10, t0.referent_pricing AS referent_pricing_11, t12.id AS id_13, t12.email AS email_14, t12.password AS password_15, t12.salt AS salt_16, t12.registration_date AS registration_date_17, t12.password_request_date AS password_request_date_18, t12.password_request AS password_request_19, t12.email_valid AS email_valid_20, t12.email_valid_token AS email_valid_token_21, t12.last_login AS last_login_22, t12.enabled AS enabled_23, t12.roles AS roles_24, t12.manager_id AS manager_id_25, t12.user_id AS user_id_26 FROM manager t0 LEFT JOIN account t12 ON t12.manager_id = t0.id WHERE t0.id = ?
Parameters:
[
8
]
|
| 3 | 0.28 ms |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cotation_multisite c0_ LEFT JOIN cotation_state c1_ ON c0_.state_id = c1_.id WHERE c1_.id <> 6
Parameters:
[] |
| 4 | 0.15 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.creation_date AS creation_date_1 FROM cotation_multisite c0_ LEFT JOIN cotation_state c1_ ON c0_.state_id = c1_.id WHERE c1_.id <> 6 ORDER BY c0_.creation_date DESC LIMIT 20
Parameters:
[] |
| 5 | 0.20 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.electricity AS electricity_2, c0_.gas AS gas_3, c0_.siret AS siret_4, c0_.company_name AS company_name_5, c0_.ape_code AS ape_code_6, c0_.sector AS sector_7, c0_.first_name AS first_name_8, c0_.last_name AS last_name_9, c0_.position AS position_10, c0_.phone AS phone_11, c0_.email AS email_12, c0_.elipro_note AS elipro_note_13, c0_.creation_date AS creation_date_14, c0_.edit_date AS edit_date_15, c0_.appointment_date AS appointment_date_16, c0_.tenue_offre AS tenue_offre_17, c0_.tarif_type AS tarif_type_18, c0_.desired_margin AS desired_margin_19, c0_.liasse_fiscale AS liasse_fiscale_20, c0_.sge_elec AS sge_elec_21, c0_.omega_gas AS omega_gas_22, c0_.old_invoice AS old_invoice_23, c0_.acd_file AS acd_file_24, c0_.acd_sign_date AS acd_sign_date_25, c0_.pricing_sent_date AS pricing_sent_date_26, c0_.etude_solution_elec AS etude_solution_elec_27, c0_.etude_solution_gaz AS etude_solution_gaz_28, c0_.etude_commentaire_elec AS etude_commentaire_elec_29, c0_.etude_commentaire_gaz AS etude_commentaire_gaz_30, c0_.company_id AS company_id_31, c0_.user_id AS user_id_32, c0_.manager_id AS manager_id_33, c0_.state_id AS state_id_34 FROM cotation_multisite c0_ LEFT JOIN cotation_state c1_ ON c0_.state_id = c1_.id WHERE c1_.id <> 6 AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.creation_date DESC
Parameters:
[ 14 13 12 11 10 9 8 7 6 5 4 3 2 1 ] |
| 6 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.company_manager AS company_manager_4, t0.owner AS owner_5, t0.address AS address_6, t0.address_2 AS address_2_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.phone AS phone_10, t0.phone_fix AS phone_fix_11, t0.email AS email_12, t0.ape_code AS ape_code_13, t0.creditsafe_note AS creditsafe_note_14, t0.elipro_note AS elipro_note_15, t0.contract_expiry_date AS contract_expiry_date_16, t0.pdl_number AS pdl_number_17, t0.pce_number AS pce_number_18, t0.gas AS gas_19, t0.electricity AS electricity_20, t0.sector AS sector_21, t0.justificatif AS justificatif_22, t0.fact_elec AS fact_elec_23, t0.fact_gas AS fact_gas_24, t0.liasse_fiscale AS liasse_fiscale_25, t0.sge_elec AS sge_elec_26, t0.omega_gas AS omega_gas_27, t0.excel_multisite AS excel_multisite_28, t0.validated AS validated_29, t0.sepa_iban AS sepa_iban_30, t0.sepa_bic AS sepa_bic_31, t0.user_id AS user_id_32 FROM company t0 WHERE t0.id = ?
Parameters:
[
63
]
|
| 7 | 0.26 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.admin AS admin_4, t0.allow_particuliers AS allow_particuliers_5, t0.allow_offres_sur_grilles AS allow_offres_sur_grilles_6, t0.allow_cotations AS allow_cotations_7, t0.allow_customer_base AS allow_customer_base_8, t0.email AS email_9, t0.phone AS phone_10, t0.referent_pricing AS referent_pricing_11, t12.id AS id_13, t12.email AS email_14, t12.password AS password_15, t12.salt AS salt_16, t12.registration_date AS registration_date_17, t12.password_request_date AS password_request_date_18, t12.password_request AS password_request_19, t12.email_valid AS email_valid_20, t12.email_valid_token AS email_valid_token_21, t12.last_login AS last_login_22, t12.enabled AS enabled_23, t12.roles AS roles_24, t12.manager_id AS manager_id_25, t12.user_id AS user_id_26 FROM manager t0 LEFT JOIN account t12 ON t12.manager_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
| 8 | 0.14 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM cotation_state t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 9 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.company_manager AS company_manager_4, t0.owner AS owner_5, t0.address AS address_6, t0.address_2 AS address_2_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.phone AS phone_10, t0.phone_fix AS phone_fix_11, t0.email AS email_12, t0.ape_code AS ape_code_13, t0.creditsafe_note AS creditsafe_note_14, t0.elipro_note AS elipro_note_15, t0.contract_expiry_date AS contract_expiry_date_16, t0.pdl_number AS pdl_number_17, t0.pce_number AS pce_number_18, t0.gas AS gas_19, t0.electricity AS electricity_20, t0.sector AS sector_21, t0.justificatif AS justificatif_22, t0.fact_elec AS fact_elec_23, t0.fact_gas AS fact_gas_24, t0.liasse_fiscale AS liasse_fiscale_25, t0.sge_elec AS sge_elec_26, t0.omega_gas AS omega_gas_27, t0.excel_multisite AS excel_multisite_28, t0.validated AS validated_29, t0.sepa_iban AS sepa_iban_30, t0.sepa_bic AS sepa_bic_31, t0.user_id AS user_id_32 FROM company t0 WHERE t0.id = ?
Parameters:
[
64
]
|
| 10 | 0.19 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.admin AS admin_4, t0.allow_particuliers AS allow_particuliers_5, t0.allow_offres_sur_grilles AS allow_offres_sur_grilles_6, t0.allow_cotations AS allow_cotations_7, t0.allow_customer_base AS allow_customer_base_8, t0.email AS email_9, t0.phone AS phone_10, t0.referent_pricing AS referent_pricing_11, t12.id AS id_13, t12.email AS email_14, t12.password AS password_15, t12.salt AS salt_16, t12.registration_date AS registration_date_17, t12.password_request_date AS password_request_date_18, t12.password_request AS password_request_19, t12.email_valid AS email_valid_20, t12.email_valid_token AS email_valid_token_21, t12.last_login AS last_login_22, t12.enabled AS enabled_23, t12.roles AS roles_24, t12.manager_id AS manager_id_25, t12.user_id AS user_id_26 FROM manager t0 LEFT JOIN account t12 ON t12.manager_id = t0.id WHERE t0.id = ?
Parameters:
[
9
]
|
| 11 | 0.14 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM cotation_state t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 12 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.company_manager AS company_manager_4, t0.owner AS owner_5, t0.address AS address_6, t0.address_2 AS address_2_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.phone AS phone_10, t0.phone_fix AS phone_fix_11, t0.email AS email_12, t0.ape_code AS ape_code_13, t0.creditsafe_note AS creditsafe_note_14, t0.elipro_note AS elipro_note_15, t0.contract_expiry_date AS contract_expiry_date_16, t0.pdl_number AS pdl_number_17, t0.pce_number AS pce_number_18, t0.gas AS gas_19, t0.electricity AS electricity_20, t0.sector AS sector_21, t0.justificatif AS justificatif_22, t0.fact_elec AS fact_elec_23, t0.fact_gas AS fact_gas_24, t0.liasse_fiscale AS liasse_fiscale_25, t0.sge_elec AS sge_elec_26, t0.omega_gas AS omega_gas_27, t0.excel_multisite AS excel_multisite_28, t0.validated AS validated_29, t0.sepa_iban AS sepa_iban_30, t0.sepa_bic AS sepa_bic_31, t0.user_id AS user_id_32 FROM company t0 WHERE t0.id = ?
Parameters:
[
62
]
|
| 13 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.company_manager AS company_manager_4, t0.owner AS owner_5, t0.address AS address_6, t0.address_2 AS address_2_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.phone AS phone_10, t0.phone_fix AS phone_fix_11, t0.email AS email_12, t0.ape_code AS ape_code_13, t0.creditsafe_note AS creditsafe_note_14, t0.elipro_note AS elipro_note_15, t0.contract_expiry_date AS contract_expiry_date_16, t0.pdl_number AS pdl_number_17, t0.pce_number AS pce_number_18, t0.gas AS gas_19, t0.electricity AS electricity_20, t0.sector AS sector_21, t0.justificatif AS justificatif_22, t0.fact_elec AS fact_elec_23, t0.fact_gas AS fact_gas_24, t0.liasse_fiscale AS liasse_fiscale_25, t0.sge_elec AS sge_elec_26, t0.omega_gas AS omega_gas_27, t0.excel_multisite AS excel_multisite_28, t0.validated AS validated_29, t0.sepa_iban AS sepa_iban_30, t0.sepa_bic AS sepa_bic_31, t0.user_id AS user_id_32 FROM company t0 WHERE t0.id = ?
Parameters:
[
60
]
|
| 14 | 0.18 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.admin AS admin_4, t0.allow_particuliers AS allow_particuliers_5, t0.allow_offres_sur_grilles AS allow_offres_sur_grilles_6, t0.allow_cotations AS allow_cotations_7, t0.allow_customer_base AS allow_customer_base_8, t0.email AS email_9, t0.phone AS phone_10, t0.referent_pricing AS referent_pricing_11, t12.id AS id_13, t12.email AS email_14, t12.password AS password_15, t12.salt AS salt_16, t12.registration_date AS registration_date_17, t12.password_request_date AS password_request_date_18, t12.password_request AS password_request_19, t12.email_valid AS email_valid_20, t12.email_valid_token AS email_valid_token_21, t12.last_login AS last_login_22, t12.enabled AS enabled_23, t12.roles AS roles_24, t12.manager_id AS manager_id_25, t12.user_id AS user_id_26 FROM manager t0 LEFT JOIN account t12 ON t12.manager_id = t0.id WHERE t0.id = ?
Parameters:
[
2
]
|
| 15 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.company_manager AS company_manager_4, t0.owner AS owner_5, t0.address AS address_6, t0.address_2 AS address_2_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.phone AS phone_10, t0.phone_fix AS phone_fix_11, t0.email AS email_12, t0.ape_code AS ape_code_13, t0.creditsafe_note AS creditsafe_note_14, t0.elipro_note AS elipro_note_15, t0.contract_expiry_date AS contract_expiry_date_16, t0.pdl_number AS pdl_number_17, t0.pce_number AS pce_number_18, t0.gas AS gas_19, t0.electricity AS electricity_20, t0.sector AS sector_21, t0.justificatif AS justificatif_22, t0.fact_elec AS fact_elec_23, t0.fact_gas AS fact_gas_24, t0.liasse_fiscale AS liasse_fiscale_25, t0.sge_elec AS sge_elec_26, t0.omega_gas AS omega_gas_27, t0.excel_multisite AS excel_multisite_28, t0.validated AS validated_29, t0.sepa_iban AS sepa_iban_30, t0.sepa_bic AS sepa_bic_31, t0.user_id AS user_id_32 FROM company t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Account | No errors. |
| App\Entity\Manager | No errors. |
| App\Entity\User |
|
| App\Entity\CotationMultisite | No errors. |
| App\Entity\CotationState | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Cotation | No errors. |
| App\Entity\Contract | No errors. |