Query Metrics
4
Database Queries
3
Different statements
4.12 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.81 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.password AS password_6, t0.roles AS roles_7, t0.profile_picture AS profile_picture_8, t0.cover_picture AS cover_picture_9, t0.api_token AS api_token_10, t0.authorize_net_customer_profile_id AS authorize_net_customer_profile_id_11, t0.authorize_net_customer_payment_profile_id AS authorize_net_customer_payment_profile_id_12, t0.discount_code_applied AS discount_code_applied_13, t0.active AS active_14, t0.accepted_tc AS accepted_tc_15, t0.api_auth_token AS api_auth_token_16, t0.first_name AS first_name_17, t0.last_name AS last_name_18, t0.is_auditor AS is_auditor_19, t0.auto_login_token AS auto_login_token_20, t21.id AS id_22, t21.business_title AS business_title_23, t21.first_name AS first_name_24, t21.last_name AS last_name_25, t21.address AS address_26, t21.state_code AS state_code_27, t21.zip AS zip_28, t21.cc_last_four_digits AS cc_last_four_digits_29, t21.exp_date AS exp_date_30, t21.user_id AS user_id_31, t21.city AS city_32, t21.province AS province_33, t21.user_id AS user_id_34, t35.id AS id_36, t35.name AS name_37, t35.description AS description_38, t35.logo AS logo_39, t35.is_cac AS is_cac_40, t35.is_iac AS is_iac_41, t35.is_active AS is_active_42, t35.created_at AS created_at_43, t35.updated_at AS updated_at_44, t35.auth_token AS auth_token_45, t35.deleted_at AS deleted_at_46, t35.is_cnw AS is_cnw_47, t35.is_sunflower AS is_sunflower_48, t35.plan AS plan_49, t35.number_of_locations AS number_of_locations_50, t35.renewal_date AS renewal_date_51, t35.phone AS phone_52, t35.country_code AS country_code_53, t35.street1 AS street1_54, t35.street2 AS street2_55, t35.province AS province_56, t35.postal_code AS postal_code_57, t35.status AS status_58, t35.request_location_id AS request_location_id_59, t35.from_app_user_id AS from_app_user_id_60, t35.whatsapp AS whatsapp_61, t35.twitter AS twitter_62, t35.facebook AS facebook_63, t35.instagram AS instagram_64, t35.jobs_limit AS jobs_limit_65, t35.user_id AS user_id_66, t35.rep_id AS rep_id_67, t35.state_id AS state_id_68, t35.claimer_user_id AS claimer_user_id_69, t70.id AS id_71, t70.name AS name_72, t70.description AS description_73, t70.logo AS logo_74, t70.is_cac AS is_cac_75, t70.is_iac AS is_iac_76, t70.is_active AS is_active_77, t70.created_at AS created_at_78, t70.updated_at AS updated_at_79, t70.auth_token AS auth_token_80, t70.deleted_at AS deleted_at_81, t70.is_cnw AS is_cnw_82, t70.is_sunflower AS is_sunflower_83, t70.plan AS plan_84, t70.number_of_locations AS number_of_locations_85, t70.renewal_date AS renewal_date_86, t70.phone AS phone_87, t70.country_code AS country_code_88, t70.street1 AS street1_89, t70.street2 AS street2_90, t70.province AS province_91, t70.postal_code AS postal_code_92, t70.status AS status_93, t70.request_location_id AS request_location_id_94, t70.from_app_user_id AS from_app_user_id_95, t70.whatsapp AS whatsapp_96, t70.twitter AS twitter_97, t70.facebook AS facebook_98, t70.instagram AS instagram_99, t70.jobs_limit AS jobs_limit_100, t70.user_id AS user_id_101, t70.rep_id AS rep_id_102, t70.state_id AS state_id_103, t70.claimer_user_id AS claimer_user_id_104, t105.id AS id_106, t105.name AS name_107, t105.code AS code_108, t105.phone AS phone_109, t105.website AS website_110, t105.street1 AS street1_111, t105.street2 AS street2_112, t105.city AS city_113, t105.zipcode AS zipcode_114, t105.province AS province_115, t105.country_code AS country_code_116, t105.latitude AS latitude_117, t105.longitude AS longitude_118, t105.is_airport AS is_airport_119, t105.logo AS logo_120, t105.state_id AS state_id_121, t105.user_id AS user_id_122 FROM user t0 LEFT JOIN user_billing_info t21 ON t21.user_id = t0.id LEFT JOIN business t35 ON t35.user_id = t0.id LEFT JOIN business t70 ON t70.claimer_user_id = t0.id LEFT JOIN airport_metro t105 ON t105.user_id = t0.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
10
]
|
| 2 | 0.88 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM app_user a0_ WHERE (a0_.deleted_at IS NULL)
Parameters:
[] |
| 3 | 0.72 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM app_user a0_ WHERE (a0_.deleted_at IS NULL)
Parameters:
[] |
| 4 | 0.71 ms |
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.password AS password_5, a0_.roles AS roles_6, a0_.active AS active_7, a0_.api_auth_token AS api_auth_token_8, a0_.first_name AS first_name_9, a0_.last_name AS last_name_10, a0_.review_block AS review_block_11, a0_.country_code AS country_code_12 FROM app_user a0_ WHERE (a0_.deleted_at IS NULL) LIMIT 25
Parameters:
[] |
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\User | No errors. |
| App\Entity\UserBillingInfo | No errors. |
| App\Entity\Business |
|
| App\Entity\State | No errors. |
| App\Entity\AirportMetro | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\BusinessNote |
|
| App\Entity\BusinessUpgrade | No errors. |
| App\Entity\AppUser |
|
| App\Entity\AppCouponUsage | No errors. |
| App\Entity\LocationReview | No errors. |
| App\Entity\AppUserNotification |
|