Query Metrics
5
Database Queries
2
Different statements
1.78 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.53 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.code_melli AS code_melli_14, t0.mobile AS mobile_15, t0.mail AS mail_16, t0.insert_date AS insert_date_17, t0.api_key AS api_key_18, t0.pic_ext AS pic_ext_19, t0.updated_at AS updated_at_20, t0.medical_council_code AS medical_council_code_21, t0.drugstore_code AS drugstore_code_22, t0.drugstore_originator AS drugstore_originator_23, t0.drugstore_license AS drugstore_license_24, t0.drugstore_license_pic_ext AS drugstore_license_pic_ext_25, t0.drugstore_hix AS drugstore_hix_26, t0.drugstore_gln AS drugstore_gln_27, t0.birth_date AS birth_date_28, t0.status AS status_29, t0.is_male AS is_male_30, t0.is_information_complete AS is_information_complete_31, t0.description AS description_32, t0.operator_job_title AS operator_job_title_33, t0.auth_code AS auth_code_34, t0.trusted_version AS trusted_version_35, t0.balance AS balance_36, t0.operator_all_categories AS operator_all_categories_37, t0.operator_all_license_owners AS operator_all_license_owners_38, t0.cart_count AS cart_count_39, t0.city_id AS city_id_40, t0.type_id AS type_id_41 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||
2 | 0.51 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
Parameters:
[
1
]
|
||||||||||||||||||||
3 | 0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
Parameters:
[
4
]
|
||||||||||||||||||||
4 | 0.22 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
Parameters:
[
2
]
|
||||||||||||||||||||
5 | 0.23 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
Parameters:
[
3
]
|
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 |
---|---|
FOS\UserBundle\Model\User | No errors. |
App\Entity\User | No errors. |
App\Entity\City |
|
App\Entity\DrugstoreType | No errors. |
App\Entity\Category | No errors. |
App\Entity\LicenseOwner | No errors. |
App\Entity\SMS | No errors. |
App\Entity\Address | No errors. |
App\Entity\ItemDrugstore | No errors. |
App\Entity\ItemUser | No errors. |
App\Entity\Cart |
|
App\Entity\MobileVerifyCode | No errors. |
App\Entity\PushNotification | No errors. |
App\Entity\Ticket | No errors. |
App\Entity\Log | No errors. |
App\Entity\Payment | No errors. |
App\Entity\BankAccount | No errors. |
App\Entity\Receipt | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\SupplyDrugstore | No errors. |
App\Entity\Advertise | No errors. |