GET https://hbs.managemyshows.com/admin/exhibitor-space

Query Metrics

33 Database Queries
9 Different statements
6.93 ms Query time
0 Invalid entities
35 Managed entities

Queries

Group similar statements

# 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