Query Metrics
11
Database Queries
9
Different statements
16.66 ms
Query time
0
Invalid entities
18
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 11.11 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
]
|
| 2 | 1.26 ms |
SELECT t0.id AS id_1, t0.show_name AS show_name_2, t0.checks_payable_to AS checks_payable_to_3, t0.show_website AS show_website_4, t0.show_abbreviation AS show_abbreviation_5, t0.show_year AS show_year_6, t0.active AS active_7, t0.payment_gateway AS payment_gateway_8, t0.online_applications AS online_applications_9, t0.physical_contract AS physical_contract_10, t0.number_of_years_allowed_to_contract AS number_of_years_allowed_to_contract_11, t0.max_allowable_deposit AS max_allowable_deposit_12, t0.print_contract_through_portal AS print_contract_through_portal_13, t0.allow_aaprospects_to_self_register AS allow_aaprospects_to_self_register_14, t0.display_prior_year_items AS display_prior_year_items_15, t0.online_payments AS online_payments_16, t0.link_to_invoice_on_payment_page AS link_to_invoice_on_payment_page_17, t0.allow_edit_deposit AS allow_edit_deposit_18, t0.allow_credit_card_payments AS allow_credit_card_payments_19, t0.credit_card_fee AS credit_card_fee_20, t0.allow_achpayments AS allow_achpayments_21, t0.allow_check_payments AS allow_check_payments_22, t0.allow_wire_payments AS allow_wire_payments_23, t0.online_stage_in_confirmation AS online_stage_in_confirmation_24, t0.online_guest_tix_ordering AS online_guest_tix_ordering_25, t0.digital_guest_tix_ordering AS digital_guest_tix_ordering_26, t0.enable_specific_product_brands_in_portal AS enable_specific_product_brands_in_portal_27, t0.ask_exhibitors_for_boat_list AS ask_exhibitors_for_boat_list_28, t0.boat_list_on_dashboard_and_reminders AS boat_list_on_dashboard_and_reminders_29, t0.crane_service_available AS crane_service_available_30, t0.ask_for_suggested_retail AS ask_for_suggested_retail_31, t0.allow_after_hours_passes AS allow_after_hours_passes_32, t0.allow_smscontract AS allow_smscontract_33, t0.email_entry_on_badge_form AS email_entry_on_badge_form_34, t0.require_shipping_acct_for_credentials AS require_shipping_acct_for_credentials_35, t0.current_web AS current_web_36, t0.portal_entry_threshold AS portal_entry_threshold_37, t0.offer_member_pricing AS offer_member_pricing_38, t0.first_payment_percentage AS first_payment_percentage_39, t0.first_payment_due_date AS first_payment_due_date_40, t0.second_payment_percentage AS second_payment_percentage_41, t0.second_payment_due_date AS second_payment_due_date_42, t0.third_payment_percentage AS third_payment_percentage_43, t0.third_payment_due_date AS third_payment_due_date_44, t0.final_payment_due_date AS final_payment_due_date_45, t0.ticket_price AS ticket_price_46, t0.guest_ticket_price AS guest_ticket_price_47, t0.number_of_free_guest_tickets AS number_of_free_guest_tickets_48, t0.early_bird_discount AS early_bird_discount_49, t0.early_bird_discount_expires AS early_bird_discount_expires_50, t0.early_payment_discount AS early_payment_discount_51, t0.early_payment_discount_expires AS early_payment_discount_expires_52, t0.show_detailed_payments AS show_detailed_payments_53, t0.min_exhibitor_badges AS min_exhibitor_badges_54, t0.max_exhibitor_badges AS max_exhibitor_badges_55, t0.additional_badge_cost AS additional_badge_cost_56, t0.invoice_notes AS invoice_notes_57, t0.show_start_date AS show_start_date_58, t0.show_length AS show_length_59, t0.contract_mailing_date AS contract_mailing_date_60, t0.portal_open AS portal_open_61, t0.contract_release_date AS contract_release_date_62, t0.insurance_lead AS insurance_lead_63, t0.insurance_release AS insurance_release_64, t0.insurance_tail AS insurance_tail_65, t0.move_in_release AS move_in_release_66, t0.decorator_release AS decorator_release_67, t0.hotel_restaurant_release AS hotel_restaurant_release_68, t0.marketing_release AS marketing_release_69, t0.electrical_order_release AS electrical_order_release_70, t0.parking_order_release AS parking_order_release_71, t0.guest_tickets_order_release AS guest_tickets_order_release_72, t0.wifi_order_release AS wifi_order_release_73, t0.contract_due AS contract_due_74, t0.insurance_due AS insurance_due_75, t0.tax_info_due AS tax_info_due_76, t0.move_in_conf_due AS move_in_conf_due_77, t0.electric_order_due AS electric_order_due_78, t0.badge_order_due AS badge_order_due_79, t0.badge_mailing_cutoff AS badge_mailing_cutoff_80, t0.internet_order_due AS internet_order_due_81, t0.telephone_order_due AS telephone_order_due_82, t0.decorator_order_due AS decorator_order_due_83, t0.guest_tix_order_due AS guest_tix_order_due_84, t0.parking_order_due AS parking_order_due_85, t0.directory_info_due AS directory_info_due_86, t0.boat_list_due AS boat_list_due_87, t0.allow_contract_uploads AS allow_contract_uploads_88, t0.allow_insurance_uploads AS allow_insurance_uploads_89, t0.allow_tax_document_uploads AS allow_tax_document_uploads_90, t0.allow_stage_in_document_uploads AS allow_stage_in_document_uploads_91, t0.allow_guest_ticket_order_uploads AS allow_guest_ticket_order_uploads_92, t0.boat_brands_on_portal AS boat_brands_on_portal_93, t0.products_on_portal AS products_on_portal_94, t0.services_on_portal AS services_on_portal_95, t0.provide_rulesand_regulations AS provide_rulesand_regulations_96, t0.provide_exhibitor_manual AS provide_exhibitor_manual_97, t0.provide_decorator_manual AS provide_decorator_manual_98, t0.provide_hotel_information AS provide_hotel_information_99, t0.provide_restaurant_information AS provide_restaurant_information_100, t0.provide_parking_information AS provide_parking_information_101, t0.provide_marketing_materials AS provide_marketing_materials_102, t0.offer_guest_tickets AS offer_guest_tickets_103, t0.when_are_guest_tickets_paid AS when_are_guest_tickets_paid_104, t0.offer_telephone_ordering AS offer_telephone_ordering_105, t0.offer_wifi_ordering AS offer_wifi_ordering_106, t0.provide_faq_page AS provide_faq_page_107, t0.faq_page_active AS faq_page_active_108, t0.enable_portal_store AS enable_portal_store_109, t0.sell_credentials_in_store AS sell_credentials_in_store_110, t0.sell_guest_tickets_in_store AS sell_guest_tickets_in_store_111, t0.contract_requires_approval AS contract_requires_approval_112, t0.enable_dashboard_yellow_light AS enable_dashboard_yellow_light_113, t0.show_only_one_dashboard_light AS show_only_one_dashboard_light_114, t0.word_limit_for_company_descriptions AS word_limit_for_company_descriptions_115, t0.allow_ad_hoc_directory_entries AS allow_ad_hoc_directory_entries_116, t0.require_insurance AS require_insurance_117, t0.insurance_requires_approval AS insurance_requires_approval_118, t0.require_tax_docs AS require_tax_docs_119, t0.tax_doc_requires_approval AS tax_doc_requires_approval_120, t0.require_stage_in_docs AS require_stage_in_docs_121, t0.offer_electrical_ordering AS offer_electrical_ordering_122, t0.payment_light_active AS payment_light_active_123, t0.contract_light_active AS contract_light_active_124, t0.rules_and_regs_on_dashboard AS rules_and_regs_on_dashboard_125, t0.directory_info_light_active AS directory_info_light_active_126, t0.insurance_light_active AS insurance_light_active_127, t0.credentials_light_active AS credentials_light_active_128, t0.tax_light_active AS tax_light_active_129, t0.stage_in_light_active AS stage_in_light_active_130, t0.guest_tix_light_active AS guest_tix_light_active_131, t0.electrical_order_light_active AS electrical_order_light_active_132, t0.decorator_order_light_active AS decorator_order_light_active_133, t0.logo AS logo_134, t0.show_type_id AS show_type_id_135, t0.management_company_id AS management_company_id_136 FROM show_info t0 WHERE t0.id = ?
Parameters:
[
"53"
]
|
| 3 | 0.59 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 = ? LIMIT 1
Parameters:
[
26491
]
|
| 4 | 0.67 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.the_show_id = ? AND t0.company_id = ? LIMIT 1
Parameters:
[ 53 26491 ] |
| 5 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.title AS title_4 FROM template t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
17
]
|
| 6 | 0.44 ms |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.city AS city_5, t0.state AS state_6, t0.zip AS zip_7, t0.company_phone AS company_phone_8, t0.company_fax AS company_fax_9, t0.show_admin_name AS show_admin_name_10, t0.show_admin_phone AS show_admin_phone_11, t0.show_admin_email AS show_admin_email_12, t0.sales_manager_name AS sales_manager_name_13, t0.sales_manager_phone AS sales_manager_phone_14, t0.sales_manager_email AS sales_manager_email_15, t0.stage_in_manager_name AS stage_in_manager_name_16, t0.stage_in_manager_phone AS stage_in_manager_phone_17, t0.stage_in_manager_email AS stage_in_manager_email_18, t0.authorize_net1_api_login AS authorize_net1_api_login_19, t0.authorize_net1_transaction_key AS authorize_net1_transaction_key_20, t0.authorize_net2_api_login AS authorize_net2_api_login_21, t0.authorize_net2_transaction_key AS authorize_net2_transaction_key_22, t0.blue_pay_account_id AS blue_pay_account_id_23, t0.blue_pay_secret_key AS blue_pay_secret_key_24, t0.blue_pay_mode AS blue_pay_mode_25, t0.enable_saved_cc_data AS enable_saved_cc_data_26, t0.twillio_account_sid AS twillio_account_sid_27, t0.twillio_account_auth_token AS twillio_account_auth_token_28, t0.twillio_account_phone_number AS twillio_account_phone_number_29, t0.allow_membership_purchase_online AS allow_membership_purchase_online_30, t0.logo AS logo_31, t0.mailing_address1 AS mailing_address1_32, t0.mailing_city AS mailing_city_33, t0.mailing_state AS mailing_state_34, t0.mailing_zip AS mailing_zip_35 FROM management_company t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.65 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.application_id = ?
Parameters:
[
16113
]
|
| 8 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.length AS length_3, t0.width AS width_4, t0.status AS status_5, t0.product_id AS product_id_6, t0.zone_id AS zone_id_7, t8.id AS id_9, t8.price AS price_10, t8.quantity AS quantity_11, t8.name AS name_12, t8.pricing_unit AS pricing_unit_13, t8.product_id AS product_id_14, t8.application_id AS application_id_15, t8.exhibitor_space_id AS exhibitor_space_id_16 FROM exhibitor_space t0 LEFT JOIN application_products t8 ON t8.exhibitor_space_id = t0.id WHERE t0.id = ?
Parameters:
[
43
]
|
| 9 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.length AS length_3, t0.width AS width_4, t0.status AS status_5, t0.product_id AS product_id_6, t0.zone_id AS zone_id_7, t8.id AS id_9, t8.price AS price_10, t8.quantity AS quantity_11, t8.name AS name_12, t8.pricing_unit AS pricing_unit_13, t8.product_id AS product_id_14, t8.application_id AS application_id_15, t8.exhibitor_space_id AS exhibitor_space_id_16 FROM exhibitor_space t0 LEFT JOIN application_products t8 ON t8.exhibitor_space_id = t0.id WHERE t0.id = ?
Parameters:
[
38
]
|
| 10 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.length AS length_3, t0.width AS width_4, t0.status AS status_5, t0.product_id AS product_id_6, t0.zone_id AS zone_id_7, t8.id AS id_9, t8.price AS price_10, t8.quantity AS quantity_11, t8.name AS name_12, t8.pricing_unit AS pricing_unit_13, t8.product_id AS product_id_14, t8.application_id AS application_id_15, t8.exhibitor_space_id AS exhibitor_space_id_16 FROM exhibitor_space t0 LEFT JOIN application_products t8 ON t8.exhibitor_space_id = t0.id WHERE t0.id = ?
Parameters:
[
217
]
|
| 11 | 0.37 ms |
SELECT t0.id AS id_1, t0.vendor_id AS vendor_id_2, t0.date_added AS date_added_3, t0.amount AS amount_4, t0.status AS status_5, t0.data AS data_6, t0.payment_type AS payment_type_7, t0.processing_fee AS processing_fee_8, t0.application_id AS application_id_9 FROM payment t0 WHERE t0.application_id = ?
Parameters:
[
16113
]
|
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\ApplicationProducts | 3 |
| App\Entity\Product | 3 |
| App\Entity\ExhibitorSpace | 3 |
| App\Entity\Company | 1 |
| App\Entity\Contact | 1 |
| App\Entity\ShowInfo | 1 |
| App\Entity\ShowType | 1 |
| App\Entity\ManagementCompany | 1 |
| App\Entity\Application | 1 |
| App\Entity\Template | 1 |
| App\Entity\ExhibitorZone | 1 |
| App\Entity\Payment | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Company | 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. |
| App\Entity\Application | No errors. |
| App\Entity\ShowInfo | No errors. |
| App\Entity\ShowType | No errors. |
| App\Entity\ManagementCompany | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ApplicationProducts | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\Credential | No errors. |
| App\Entity\Template | No errors. |
| App\Entity\ExhibitorSpace | No errors. |
| App\Entity\ExhibitorZone | No errors. |