Query Metrics
4
Database Queries
4
Different statements
732.73 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 27.88 ms |
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = ? OR a0_.phone_number = ?
Parameters:
[ "alain@hairun-technology.com" "alain@hairun-technology.com" ] |
2 | 279.80 ms |
SELECT DISTINCT o0_.id AS id_0 FROM organization o0_ INNER JOIN store s1_ ON o0_.store_id = s1_.id LEFT JOIN postal_address p2_ ON s1_.postal_address_id = p2_.id LEFT JOIN organization_legal_representative o4_ ON o0_.id = o4_.organization_id LEFT JOIN legal_representative l3_ ON l3_.id = o4_.legal_representative_id LEFT JOIN legal_representative l5_ ON l3_.id = l5_.parent_id LEFT JOIN person p6_ ON l3_.person_id = p6_.id AND (p6_.type = 'PHYSICAL') LEFT JOIN person p7_ ON l5_.person_id = p7_.id AND (p7_.type = 'PHYSICAL') INNER JOIN subscription s8_ ON o0_.id = s8_.organization_id INNER JOIN service s9_ ON s8_.id = s9_.subscription_id INNER JOIN product p10_ ON s9_.product_id = p10_.id LEFT JOIN ibml_organization_configuration i11_ ON o0_.id = i11_.organization_id WHERE o0_.status NOT IN (?) AND p10_.unique_key = ? AND s1_.is_exportable_ibml = 1 AND o0_.bal <> '' AND o0_.bal IS NOT NULL AND o0_.bal <> '0' GROUP BY o0_.id LIMIT 30
Parameters:
[ [ "NEW" "SUPPRIME" "PERDU" ] "DOMICILIATION_COMMERCIALE" ] |
3 | 3.80 ms |
SELECT o0_.id AS id_0, o0_.legal_name AS legal_name_1, o0_.alternate_name AS alternate_name_2, i1_.id AS id_3, o0_.status AS status_4, o0_.bal AS bal_5, CASE WHEN i1_.alternate_name IS NOT NULL THEN i1_.alternate_name ELSE o0_.alternate_name END AS sclr_6, CASE WHEN i1_.legal_name IS NOT NULL THEN i1_.legal_name ELSE o0_.legal_name END AS sclr_7, CASE WHEN i1_.name_legal_representative IS NOT NULL THEN i1_.name_legal_representative ELSE (CASE WHEN p2_.family_name IS NOT NULL THEN CONCAT(p2_.given_name, ' ', p2_.family_name) ELSE CONCAT(p3_.given_name, ' ', p3_.family_name) END) END AS sclr_8, CASE WHEN i1_.alternate_name IS NOT NULL OR i1_.legal_name IS NOT NULL THEN 1 ELSE 0 END AS sclr_9, CASE WHEN p2_.family_name IS NOT NULL THEN CONCAT(p2_.given_name, ' ', p2_.family_name) ELSE CONCAT(p3_.given_name, ' ', p3_.family_name) END AS sclr_10, s4_.id AS id_11, o0_.termination_date AS termination_date_12, o0_.email AS email_13 FROM organization o0_ INNER JOIN store s4_ ON o0_.store_id = s4_.id LEFT JOIN postal_address p5_ ON s4_.postal_address_id = p5_.id LEFT JOIN organization_legal_representative o7_ ON o0_.id = o7_.organization_id LEFT JOIN legal_representative l6_ ON l6_.id = o7_.legal_representative_id LEFT JOIN legal_representative l8_ ON l6_.id = l8_.parent_id LEFT JOIN person p3_ ON l6_.person_id = p3_.id AND (p3_.type = 'PHYSICAL') LEFT JOIN person p2_ ON l8_.person_id = p2_.id AND (p2_.type = 'PHYSICAL') INNER JOIN subscription s9_ ON o0_.id = s9_.organization_id INNER JOIN service s10_ ON s9_.id = s10_.subscription_id INNER JOIN product p11_ ON s10_.product_id = p11_.id LEFT JOIN ibml_organization_configuration i1_ ON o0_.id = i1_.organization_id WHERE o0_.status NOT IN (?) AND p11_.unique_key = ? AND s4_.is_exportable_ibml = 1 AND o0_.bal <> '' AND o0_.bal IS NOT NULL AND o0_.bal <> '0' AND o0_.id IN (?) GROUP BY o0_.id
Parameters:
[ [ "NEW" "SUPPRIME" "PERDU" ] "DOMICILIATION_COMMERCIALE" [ 3372 3374 3375 3376 3377 3378 3379 3380 3381 3382 3383 3385 3387 3392 3396 3398 3399 3402 3405 3407 3410 3411 3416 3417 3418 3419 3422 3423 3425 3426 ] ] |
4 | 421.26 ms |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM organization o0_ INNER JOIN store s1_ ON o0_.store_id = s1_.id LEFT JOIN postal_address p2_ ON s1_.postal_address_id = p2_.id LEFT JOIN organization_legal_representative o4_ ON o0_.id = o4_.organization_id LEFT JOIN legal_representative l3_ ON l3_.id = o4_.legal_representative_id LEFT JOIN legal_representative l5_ ON l3_.id = l5_.parent_id LEFT JOIN person p6_ ON l3_.person_id = p6_.id AND (p6_.type = 'PHYSICAL') LEFT JOIN person p7_ ON l5_.person_id = p7_.id AND (p7_.type = 'PHYSICAL') INNER JOIN subscription s8_ ON o0_.id = s8_.organization_id INNER JOIN service s9_ ON s8_.id = s9_.subscription_id INNER JOIN product p10_ ON s9_.product_id = p10_.id LEFT JOIN ibml_organization_configuration i11_ ON o0_.id = i11_.organization_id WHERE o0_.status NOT IN (?) AND p10_.unique_key = ? AND s1_.is_exportable_ibml = 1 AND o0_.bal <> '' AND o0_.bal IS NOT NULL AND o0_.bal <> '0' GROUP BY o0_.id
Parameters:
[ [ "NEW" "SUPPRIME" "PERDU" ] "DOMICILIATION_COMMERCIALE" ] |
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 |
---|---|
Evo\Infrastructure\MappingORM\Product | No errors. |
Evo\Infrastructure\MappingORM\Invoice | No errors. |
Evo\Infrastructure\MappingORM\Subscription | No errors. |
Evo\Infrastructure\MappingORM\SubscriptionModel | No errors. |
Evo\Infrastructure\MappingORM\Organization | No errors. |
Evo\Infrastructure\MappingORM\User | No errors. |
Evo\Infrastructure\MappingORM\Store | No errors. |
Evo\Infrastructure\MappingORM\LegalRepresentative | No errors. |
Evo\Infrastructure\MappingORM\Person | No errors. |
Evo\Infrastructure\MappingORM\PappersActivityLogWrapper | No errors. |
Evo\Infrastructure\MappingORM\CreditNote | No errors. |
Evo\Infrastructure\MappingORM\Quote | No errors. |
Evo\Infrastructure\MappingORM\UserUTM | No errors. |
Evo\Infrastructure\MappingORM\Lead | No errors. |
Evo\Infrastructure\MappingORM\ActivityLog | No errors. |
Evo\Infrastructure\MappingORM\CommercialGesture | No errors. |
Evo\Infrastructure\MappingORM\ActivityDomain | No errors. |
Evo\Infrastructure\MappingORM\ActivitySubdomain | No errors. |
Evo\Infrastructure\MappingORM\PostalAddress | No errors. |
Evo\Infrastructure\MappingORM\ProfessionDetail | No errors. |
Evo\Infrastructure\MappingORM\ProfessionType | No errors. |
Evo\Infrastructure\MappingORM\Service | No errors. |
Evo\Infrastructure\MappingORM\IbmlOrganizationConfiguration | No errors. |