https://flashconsulting.slapp.me/manager/cotations-multisites?onlyInProgress=1

Query Metrics

15 Database Queries
7 Different statements
6.89 ms Query time
1 Invalid entities

Queries

Group similar statements

# 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
  • The mappings App\Entity\User#device and App\Entity\Device#user are inconsistent with each other.
  • The field App\Entity\User#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contract#user does not contain the required 'inversedBy="contracts"' attribute.
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.