Query Metrics
6
Database Queries
6
Different statements
6.06 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.62 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.title AS title_6, t0.is_verified AS is_verified_7, t0.createdon AS createdon_8, t0.is_deleted AS is_deleted_9 FROM user t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 2 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.staff_votes AS staff_votes_3, t0.max_vendor_votes AS max_vendor_votes_4, t0.starts_on AS starts_on_5, t0.ends_on AS ends_on_6, t0.created_on AS created_on_7, t0.vote_complete AS vote_complete_8, t0.status AS status_9, t0.table_category AS table_category_10, t0.created_by_id AS created_by_id_11 FROM vote_event t0
Parameters:
[] |
| 3 | 0.22 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.title AS title_6, t0.is_verified AS is_verified_7, t0.createdon AS createdon_8, t0.is_deleted AS is_deleted_9 FROM user t0
Parameters:
[] |
| 4 | 0.59 ms |
SELECT t0.id AS id_1, t0.votes AS votes_2, t0.created_on AS created_on_3, t0.is_skip AS is_skip_4, t0.user_id AS user_id_5, t0.vote_event_id AS vote_event_id_6, t0.vendor_id AS vendor_id_7 FROM vote_item t0 WHERE t0.vote_event_id = ?
Parameters:
[
40
]
|
| 5 | 0.61 ms |
SELECT t0.id AS id_1, t0.votes AS votes_2, t0.created_on AS created_on_3, t0.is_skip AS is_skip_4, t0.user_id AS user_id_5, t0.vote_event_id AS vote_event_id_6, t0.vendor_id AS vendor_id_7 FROM vote_item t0 WHERE t0.user_id = ?
Parameters:
[
16
]
|
| 6 | 3.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.registrationdate AS registrationdate_3, t0.taxid AS taxid_4, t0.products_and_services AS products_and_services_5, t0.rating AS rating_6, t0.is_mature AS is_mature_7, t0.website AS website_8, t0.twitter AS twitter_9, t0.table_request_type AS table_request_type_10, t0.seating_requests AS seating_requests_11, t0.neighbor_requests AS neighbor_requests_12, t0.other_requests AS other_requests_13, t0.special_requests AS special_requests_14, t0.createdon AS createdon_15, t0.remote_id AS remote_id_16, t0.image_block AS image_block_17, t0.table_amount AS table_amount_18, t0.num_assistants AS num_assistants_19, t0.assistant_amount AS assistant_amount_20, t0.has_endcap AS has_endcap_21, t0.status AS status_22, t0.image_urls AS image_urls_23, t0.mature_dealers_section AS mature_dealers_section_24, t0.table_category AS table_category_25, t0.area AS area_26, t27.id AS id_28, t27.first_name AS first_name_29, t27.last_name AS last_name_30, t27.badge_name AS badge_name_31, t27.badge_number AS badge_number_32, t27.email_address AS email_address_33, t27.createdon AS createdon_34, t27.vendor_id AS vendor_id_35, t36.id AS id_37, t36.street1 AS street1_38, t36.stree2 AS stree2_39, t36.city AS city_40, t36.state AS state_41, t36.postal AS postal_42, t36.country AS country_43, t36.createdon AS createdon_44, t36.vendor_id AS vendor_id_45 FROM vendor t0 LEFT JOIN vendor_contact t27 ON t27.vendor_id = t0.id LEFT JOIN vendor_address t36 ON t36.vendor_id = t0.id WHERE t0.status != ?
Parameters:
[
"Approved"
]
|
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\Message | No errors. |
| App\Entity\VoteItem | No errors. |
| App\Entity\VendorNote | No errors. |
| App\Entity\VoteEvent | No errors. |
| App\Entity\Vendor | No errors. |
| App\Entity\VendorContact | No errors. |
| App\Entity\VendorAddress | No errors. |
| App\Entity\VendorImage | No errors. |
| App\Entity\VendorCategory | No errors. |