Query Metrics
4
Database Queries
4
Different statements
8.59 ms
Query time
3
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.35 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.iatanumber AS iatanumber_2, c0_.description AS description_3, c0_.internal_comment AS internal_comment_4, c0_.address_line1 AS address_line1_5, c0_.address_line2 AS address_line2_6, c0_.zip_code AS zip_code_7, c0_.city AS city_8, c0_.phone AS phone_9, c0_.fax AS fax_10, c0_.email AS email_11, c0_.logo AS logo_12, c0_.website_logo AS website_logo_13, c0_.hotel_blacklist AS hotel_blacklist_14, c0_.domains AS domains_15, c0_.custom_css AS custom_css_16, c0_.website AS website_17, c0_.markup_hotel AS markup_hotel_18, c0_.markup_activity AS markup_activity_19, c0_.markup_transfer AS markup_transfer_20, c0_.markup_car_rental AS markup_car_rental_21, c0_.markup_flight AS markup_flight_22, c0_.commission_hotel AS commission_hotel_23, c0_.commission_activity AS commission_activity_24, c0_.commission_transfer AS commission_transfer_25, c0_.commission_car_rental AS commission_car_rental_26, c0_.commission_flight AS commission_flight_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.deleted_at AS deleted_at_30, c0_.deactivated_at AS deactivated_at_31, c0_.credit_level AS credit_level_32, c0_.is_commission_customer_account AS is_commission_customer_account_33, c0_.can_edit_commission AS can_edit_commission_34, c0_.send_pending_payments_email AS send_pending_payments_email_35, c0_.pending_payment_email_config AS pending_payment_email_config_36, c0_.concierge_service_price AS concierge_service_price_37, c0_.can_add_customer_account_fee AS can_add_customer_account_fee_38, c0_.customer_account_fee_processing_fee_percentage AS customer_account_fee_processing_fee_percentage_39, c0_.concierge_service_tax_percentage AS concierge_service_tax_percentage_40, c0_.can_add_concierge_service AS can_add_concierge_service_41, c0_.can_filter_by_taxes AS can_filter_by_taxes_42, c0_.send_commission_to_parent AS send_commission_to_parent_43, c0_.send_children_commission_to_parent AS send_children_commission_to_parent_44, c0_.parent_can_view AS parent_can_view_45, c0_.parent_can_edit AS parent_can_edit_46, c0_.use_parent_logo AS use_parent_logo_47, c0_.send_customer_account_fee_to_parent AS send_customer_account_fee_to_parent_48, c0_.send_children_customer_account_fee_to_parent AS send_children_customer_account_fee_to_parent_49, c0_.quickbooks_id AS quickbooks_id_50, c0_.quickbooks_vendor_id AS quickbooks_vendor_id_51, c0_.is_virtuoso_agency AS is_virtuoso_agency_52, c0_.is_net_commission_agency AS is_net_commission_agency_53, c0_.show_shopping_cart AS show_shopping_cart_54, c0_.country_id AS country_id_55, c0_.phone_country_code_id AS phone_country_code_id_56, c0_.language_id AS language_id_57, c0_.currency_id AS currency_id_58, c0_.state_id AS state_id_59, c0_.parent_customer_account_id AS parent_customer_account_id_60, c0_.customer_account_type_id AS customer_account_type_id_61, c0_.host_id AS host_id_62, c0_.team_owner_id AS team_owner_id_63, c0_.on_agent_owner_id AS on_agent_owner_id_64 FROM customer_account c0_ WHERE c0_.domains LIKE LOWER(?)
Parameters:
[
"%"domain1": "qa2.otitestserver.com"%"
]
|
| 2 | 3.70 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.iatanumber AS iatanumber_2, c0_.description AS description_3, c0_.internal_comment AS internal_comment_4, c0_.address_line1 AS address_line1_5, c0_.address_line2 AS address_line2_6, c0_.zip_code AS zip_code_7, c0_.city AS city_8, c0_.phone AS phone_9, c0_.fax AS fax_10, c0_.email AS email_11, c0_.logo AS logo_12, c0_.website_logo AS website_logo_13, c0_.hotel_blacklist AS hotel_blacklist_14, c0_.domains AS domains_15, c0_.custom_css AS custom_css_16, c0_.website AS website_17, c0_.markup_hotel AS markup_hotel_18, c0_.markup_activity AS markup_activity_19, c0_.markup_transfer AS markup_transfer_20, c0_.markup_car_rental AS markup_car_rental_21, c0_.markup_flight AS markup_flight_22, c0_.commission_hotel AS commission_hotel_23, c0_.commission_activity AS commission_activity_24, c0_.commission_transfer AS commission_transfer_25, c0_.commission_car_rental AS commission_car_rental_26, c0_.commission_flight AS commission_flight_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.deleted_at AS deleted_at_30, c0_.deactivated_at AS deactivated_at_31, c0_.credit_level AS credit_level_32, c0_.is_commission_customer_account AS is_commission_customer_account_33, c0_.can_edit_commission AS can_edit_commission_34, c0_.send_pending_payments_email AS send_pending_payments_email_35, c0_.pending_payment_email_config AS pending_payment_email_config_36, c0_.concierge_service_price AS concierge_service_price_37, c0_.can_add_customer_account_fee AS can_add_customer_account_fee_38, c0_.customer_account_fee_processing_fee_percentage AS customer_account_fee_processing_fee_percentage_39, c0_.concierge_service_tax_percentage AS concierge_service_tax_percentage_40, c0_.can_add_concierge_service AS can_add_concierge_service_41, c0_.can_filter_by_taxes AS can_filter_by_taxes_42, c0_.send_commission_to_parent AS send_commission_to_parent_43, c0_.send_children_commission_to_parent AS send_children_commission_to_parent_44, c0_.parent_can_view AS parent_can_view_45, c0_.parent_can_edit AS parent_can_edit_46, c0_.use_parent_logo AS use_parent_logo_47, c0_.send_customer_account_fee_to_parent AS send_customer_account_fee_to_parent_48, c0_.send_children_customer_account_fee_to_parent AS send_children_customer_account_fee_to_parent_49, c0_.quickbooks_id AS quickbooks_id_50, c0_.quickbooks_vendor_id AS quickbooks_vendor_id_51, c0_.is_virtuoso_agency AS is_virtuoso_agency_52, c0_.is_net_commission_agency AS is_net_commission_agency_53, c0_.show_shopping_cart AS show_shopping_cart_54, c0_.country_id AS country_id_55, c0_.phone_country_code_id AS phone_country_code_id_56, c0_.language_id AS language_id_57, c0_.currency_id AS currency_id_58, c0_.state_id AS state_id_59, c0_.parent_customer_account_id AS parent_customer_account_id_60, c0_.customer_account_type_id AS customer_account_type_id_61, c0_.host_id AS host_id_62, c0_.team_owner_id AS team_owner_id_63, c0_.on_agent_owner_id AS on_agent_owner_id_64 FROM customer_account c0_ INNER JOIN customer_account_type c1_ ON c0_.customer_account_type_id = c1_.id WHERE c1_.name = 'Agency host' ORDER BY c0_.name ASC
Parameters:
[] |
| 3 | 0.98 ms |
SELECT c0_.id AS id_0, c0_.country_code AS country_code_1, c0_.regex_for_phone_number AS regex_for_phone_number_2, c0_.name AS name_3, c0_.phone_code AS phone_code_4, c0_.alpha_code_2 AS alpha_code_2_5 FROM country c0_ WHERE c0_.phone_code <> 0 GROUP BY c0_.phone_code ORDER BY c0_.phone_code ASC
Parameters:
[] |
| 4 | 0.56 ms |
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2 FROM language l0_
Parameters:
[] |
api connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| api | doctrine.dbal.api_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| api | doctrine.orm.api_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\CustomerAccount |
|
| App\Entity\Country | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Currency | No errors. |
| App\Entity\State | No errors. |
| App\Entity\CustomerAccountType | No errors. |
| App\Entity\Team | No errors. |
| App\Entity\User |
|
| App\Entity\RequestAccess | No errors. |
| App\Entity\NotificationEventCustomerAccountConfig | No errors. |
| App\Entity\QBInvoice |
|
| App\Entity\Quote | No errors. |
| App\Entity\Consortia | No errors. |
api entity manager
No loaded entities.