Query Metrics
33
Database Queries
9
Different statements
6.93 ms
Query time
0
Invalid entities
35
Managed 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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.status AS status_7 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
198
]
|
| 2 | 0.30 ms |
SELECT DISTINCT e0_.id AS id_0 FROM exhibitor_space e0_ LIMIT 25
Parameters:
[] |
| 3 | 0.36 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.length AS length_2, e0_.width AS width_3, e0_.status AS status_4, e0_.product_id AS product_id_5, e0_.zone_id AS zone_id_6 FROM exhibitor_space e0_ WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 60 61 62 63 64 65 66 67 68 69 ] |
| 4 | 0.24 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
43
]
|
| 5 | 0.20 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
44
]
|
| 6 | 0.17 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
45
]
|
| 7 | 0.17 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
46
]
|
| 8 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
47
]
|
| 9 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
48
]
|
| 10 | 0.17 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
49
]
|
| 11 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
50
]
|
| 12 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
51
]
|
| 13 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
52
]
|
| 14 | 0.17 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
53
]
|
| 15 | 0.19 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
54
]
|
| 16 | 0.17 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
55
]
|
| 17 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
56
]
|
| 18 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
57
]
|
| 19 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
60
]
|
| 20 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
61
]
|
| 21 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
62
]
|
| 22 | 0.17 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
63
]
|
| 23 | 0.19 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
64
]
|
| 24 | 0.18 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
65
]
|
| 25 | 0.17 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
66
]
|
| 26 | 0.18 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
67
]
|
| 27 | 0.17 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
68
]
|
| 28 | 0.16 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.name AS name_4, t0.pricing_unit AS pricing_unit_5, t0.product_id AS product_id_6, t0.application_id AS application_id_7, t0.exhibitor_space_id AS exhibitor_space_id_8 FROM application_products t0 WHERE t0.exhibitor_space_id = ?
Parameters:
[
69
]
|
| 29 | 0.21 ms |
SELECT count(*) AS sclr_0 FROM exhibitor_space e0_
Parameters:
[] |
| 30 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM exhibitor_zone t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 31 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.member_price AS member_price_4, t0.display_area_type AS display_area_type_5, t0.pricing_unit AS pricing_unit_6, t0.max_units_member_pricing AS max_units_member_pricing_7, t0.min_spend AS min_spend_8, t0.requires_shipping AS requires_shipping_9, t0.on_contract AS on_contract_10, t0.badge_thresholds AS badge_thresholds_11, t0.active AS active_12, t0.on_application AS on_application_13, t0.category_id AS category_id_14, t0.show_info_id AS show_info_id_15 FROM product t0 WHERE t0.id = ?
Parameters:
[
324
]
|
| 32 | 0.39 ms |
SELECT t0.id AS id_1, t0.address1 AS address1_2, t0.address2 AS address2_3, t0.city AS city_4, t0.state AS state_5, t0.zip AS zip_6, t0.country AS country_7, t0.website AS website_8, t0.show_site_coordinator_name AS show_site_coordinator_name_9, t0.show_site_coordinator_phone AS show_site_coordinator_phone_10, t0.show_site_coordinator_email AS show_site_coordinator_email_11, t0.space_preference1 AS space_preference1_12, t0.space_preference2 AS space_preference2_13, t0.space_preference3 AS space_preference3_14, t0.preferred_exhibit_neighboring_companies AS preferred_exhibit_neighboring_companies_15, t0.unpreferred_exhibit_neighboring_companies AS unpreferred_exhibit_neighboring_companies_16, t0.display_products AS display_products_17, t0.special_considerations AS special_considerations_18, t0.agree_terms AS agree_terms_19, t0.company_phone AS company_phone_20, t0.contact_title AS contact_title_21, t0.contact_first_name AS contact_first_name_22, t0.contact_last_name AS contact_last_name_23, t0.contact_suffix AS contact_suffix_24, t0.contact_cell_phone AS contact_cell_phone_25, t0.status AS status_26, t0.date_added AS date_added_27, t0.date_updated AS date_updated_28, t0.contact_email AS contact_email_29, t0.confirm_authority AS confirm_authority_30, t0.digital_signature AS digital_signature_31, t0.digitally_signed_date AS digitally_signed_date_32, t0.contract AS contract_33, t0.insurance AS insurance_34, t0.rules_and_regulations_signature AS rules_and_regulations_signature_35, t0.rules_and_regulations_signed_date AS rules_and_regulations_signed_date_36, t0.contract_upload_date AS contract_upload_date_37, t0.insurance_upload_date AS insurance_upload_date_38, t0.approved_date AS approved_date_39, t0.approved AS approved_40, t0.notes AS notes_41, t0.directory_info_confirmed AS directory_info_confirmed_42, t0.move_in_confirmed AS move_in_confirmed_43, t0.contract_signature_name AS contract_signature_name_44, t0.contract_signature_initials AS contract_signature_initials_45, t0.contract_signature_accept_terms AS contract_signature_accept_terms_46, t0.contract_signature_date AS contract_signature_date_47, t0.insurance_approved AS insurance_approved_48, t0.display_name AS display_name_49, t0.move_in_signature AS move_in_signature_50, t0.company_id AS company_id_51, t0.the_show_id AS the_show_id_52, t0.approved_by_id AS approved_by_id_53 FROM application t0 WHERE t0.id = ?
Parameters:
[
16110
]
|
| 33 | 0.31 ms |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.active AS active_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.city AS city_6, t0.state AS state_7, t0.zip AS zip_8, t0.country AS country_9, t0.phone AS phone_10, t0.fax AS fax_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.instagram AS instagram_14, t0.linkedin AS linkedin_15, t0.twitter AS twitter_16, t0.marine_related AS marine_related_17, t0.non_profit AS non_profit_18, t0.opt_out AS opt_out_19, t0.black_ball AS black_ball_20, t0.notes AS notes_21, t0.dba AS dba_22, t0.business_type AS business_type_23, t0.filter_invitations AS filter_invitations_24, t0.mailing_address1 AS mailing_address1_25, t0.mailing_address2 AS mailing_address2_26, t0.mailing_city AS mailing_city_27, t0.mailing_state AS mailing_state_28, t0.mailing_zip AS mailing_zip_29, t0.mailing_country AS mailing_country_30, t0.password AS password_31, t0.logo AS logo_32, t0.username AS username_33, t0.password_plain AS password_plain_34, t0.roles AS roles_35, t0.company_description AS company_description_36, t0.date_created AS date_created_37, t0.membership_level AS membership_level_38, t0.primary_contact_id AS primary_contact_id_39, t0.biz_type_id AS biz_type_id_40 FROM company t0 WHERE t0.id = ?
Parameters:
[
26491
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\ExhibitorSpace | 25 |
| App\Entity\ShowInfo | 2 |
| App\Entity\User | 1 |
| App\Entity\Product | 1 |
| App\Entity\ExhibitorZone | 1 |
| App\Entity\ApplicationProducts | 1 |
| App\Entity\Application | 1 |
| App\Entity\ProductCategory | 1 |
| App\Entity\Company | 1 |
| App\Entity\Contact | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Application | No errors. |
| App\Entity\TodoNotes | No errors. |
| App\Entity\ExhibitorSpace | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ExhibitorZone | No errors. |
| App\Entity\ApplicationProducts | No errors. |
| App\Entity\ProductCategory | No errors. |
| App\Entity\ShowInfo | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\Credential | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\BusinessType | No errors. |
| App\Entity\Prospect | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\ExhibitorProduct | No errors. |
| App\Entity\ExhibitorService | No errors. |