Query Metrics
658
Database Queries
2
Different statements
158.44 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
153.94 ms (97.16%) |
657 |
SELECT t0.id AS id_1, t0.category AS category_2, t0.is_primary AS is_primary_3, t0.createdon AS createdon_4, t0.vendor_id AS vendor_id_5 FROM vendor_category t0 WHERE t0.vendor_id = ?
Parameters:
[
1966
]
|
4.50 ms (2.84%) |
1 |
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
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\Vendor | No errors. |
App\Entity\VendorContact | No errors. |
App\Entity\VendorAddress | No errors. |
App\Entity\VendorImage | No errors. |
App\Entity\VendorCategory | No errors. |
App\Entity\VoteItem | No errors. |
App\Entity\VendorNote | No errors. |