Query Metrics
8
Database Queries
4
Different statements
58.89 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.33 ms |
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.subdomain AS subdomain_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.deleted_by_id AS deleted_by_id_9 FROM complex t0 WHERE t0.subdomain = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"preejd"
]
|
| 2 | 4.97 ms |
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.description AS description_4, t0.tax AS tax_5, t0.subdomain AS subdomain_6, t0.pms_connection AS pms_connection_7, t0.pms_forbidden_email_domains AS pms_forbidden_email_domains_8, t0.address1 AS address1_9, t0.address2 AS address2_10, t0.postal_code AS postal_code_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.tin AS tin_15, t0.fiscal_name AS fiscal_name_16, t0.invoice_serie AS invoice_serie_17, t0.reply_to_email AS reply_to_email_18, t0.order_emails_to AS order_emails_to_19, t0.count_infants_for_restaurant_reserves AS count_infants_for_restaurant_reserves_20, t0.errors_muted AS errors_muted_21, t0.stripe_publishable_key AS stripe_publishable_key_22, t0.stripe_secret_key AS stripe_secret_key_23, t0.google_tag_stream_id AS google_tag_stream_id_24, t0.google_tag_measurement_id AS google_tag_measurement_id_25, t0.restaurant_reserve_home_position AS restaurant_reserve_home_position_26, t0.create_ticket_home_position AS create_ticket_home_position_27, t0.restaurant_reserve_home_image AS restaurant_reserve_home_image_28, t0.create_ticket_home_image AS create_ticket_home_image_29, t0.last_pms_updated_at AS last_pms_updated_at_30, t0.green_api_active AS green_api_active_31, t0.green_api_id AS green_api_id_32, t0.green_api_token AS green_api_token_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.created_by_id AS created_by_id_36, t0.updated_by_id AS updated_by_id_37, t0.deleted_by_id AS deleted_by_id_38, t0.complex_id AS complex_id_39, t0.blameable_user_id AS blameable_user_id_40, t41.deleted_at AS deleted_at_42, t41.id AS id_43, t41.username AS username_44, t41.email AS email_45, t41.enabled AS enabled_46, t41.password AS password_47, t41.first_name AS first_name_48, t41.last_name AS last_name_49, t41.roles AS roles_50, t41.type AS type_51, t41.order_ticket_printer AS order_ticket_printer_52, t41.restaurant_ticket_printer AS restaurant_ticket_printer_53, t41.phone AS phone_54, t41.created_at AS created_at_55, t41.updated_at AS updated_at_56, t41.created_by_id AS created_by_id_57, t41.updated_by_id AS updated_by_id_58, t41.deleted_by_id AS deleted_by_id_59, t0.ticket_call_assigned_user_id AS ticket_call_assigned_user_id_60 FROM hotel t0 INNER JOIN user t41 ON t0.blameable_user_id = t41.id AND ((t41.deleted_at IS NULL)) WHERE t0.subdomain = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"preejd"
]
|
| 3 | 1.50 ms |
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.subdomain AS subdomain_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.deleted_by_id AS deleted_by_id_9 FROM complex t0 WHERE t0.subdomain = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"preejd"
]
|
| 4 | 1.50 ms |
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.description AS description_4, t0.tax AS tax_5, t0.subdomain AS subdomain_6, t0.pms_connection AS pms_connection_7, t0.pms_forbidden_email_domains AS pms_forbidden_email_domains_8, t0.address1 AS address1_9, t0.address2 AS address2_10, t0.postal_code AS postal_code_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.tin AS tin_15, t0.fiscal_name AS fiscal_name_16, t0.invoice_serie AS invoice_serie_17, t0.reply_to_email AS reply_to_email_18, t0.order_emails_to AS order_emails_to_19, t0.count_infants_for_restaurant_reserves AS count_infants_for_restaurant_reserves_20, t0.errors_muted AS errors_muted_21, t0.stripe_publishable_key AS stripe_publishable_key_22, t0.stripe_secret_key AS stripe_secret_key_23, t0.google_tag_stream_id AS google_tag_stream_id_24, t0.google_tag_measurement_id AS google_tag_measurement_id_25, t0.restaurant_reserve_home_position AS restaurant_reserve_home_position_26, t0.create_ticket_home_position AS create_ticket_home_position_27, t0.restaurant_reserve_home_image AS restaurant_reserve_home_image_28, t0.create_ticket_home_image AS create_ticket_home_image_29, t0.last_pms_updated_at AS last_pms_updated_at_30, t0.green_api_active AS green_api_active_31, t0.green_api_id AS green_api_id_32, t0.green_api_token AS green_api_token_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.created_by_id AS created_by_id_36, t0.updated_by_id AS updated_by_id_37, t0.deleted_by_id AS deleted_by_id_38, t0.complex_id AS complex_id_39, t0.blameable_user_id AS blameable_user_id_40, t41.deleted_at AS deleted_at_42, t41.id AS id_43, t41.username AS username_44, t41.email AS email_45, t41.enabled AS enabled_46, t41.password AS password_47, t41.first_name AS first_name_48, t41.last_name AS last_name_49, t41.roles AS roles_50, t41.type AS type_51, t41.order_ticket_printer AS order_ticket_printer_52, t41.restaurant_ticket_printer AS restaurant_ticket_printer_53, t41.phone AS phone_54, t41.created_at AS created_at_55, t41.updated_at AS updated_at_56, t41.created_by_id AS created_by_id_57, t41.updated_by_id AS updated_by_id_58, t41.deleted_by_id AS deleted_by_id_59, t0.ticket_call_assigned_user_id AS ticket_call_assigned_user_id_60 FROM hotel t0 INNER JOIN user t41 ON t0.blameable_user_id = t41.id AND ((t41.deleted_at IS NULL)) WHERE t0.subdomain = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"preejd"
]
|
| 5 | 1.26 ms |
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.subdomain AS subdomain_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.deleted_by_id AS deleted_by_id_9 FROM complex t0 WHERE t0.subdomain = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"preejd"
]
|
| 6 | 1.57 ms |
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.description AS description_4, t0.tax AS tax_5, t0.subdomain AS subdomain_6, t0.pms_connection AS pms_connection_7, t0.pms_forbidden_email_domains AS pms_forbidden_email_domains_8, t0.address1 AS address1_9, t0.address2 AS address2_10, t0.postal_code AS postal_code_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.tin AS tin_15, t0.fiscal_name AS fiscal_name_16, t0.invoice_serie AS invoice_serie_17, t0.reply_to_email AS reply_to_email_18, t0.order_emails_to AS order_emails_to_19, t0.count_infants_for_restaurant_reserves AS count_infants_for_restaurant_reserves_20, t0.errors_muted AS errors_muted_21, t0.stripe_publishable_key AS stripe_publishable_key_22, t0.stripe_secret_key AS stripe_secret_key_23, t0.google_tag_stream_id AS google_tag_stream_id_24, t0.google_tag_measurement_id AS google_tag_measurement_id_25, t0.restaurant_reserve_home_position AS restaurant_reserve_home_position_26, t0.create_ticket_home_position AS create_ticket_home_position_27, t0.restaurant_reserve_home_image AS restaurant_reserve_home_image_28, t0.create_ticket_home_image AS create_ticket_home_image_29, t0.last_pms_updated_at AS last_pms_updated_at_30, t0.green_api_active AS green_api_active_31, t0.green_api_id AS green_api_id_32, t0.green_api_token AS green_api_token_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.created_by_id AS created_by_id_36, t0.updated_by_id AS updated_by_id_37, t0.deleted_by_id AS deleted_by_id_38, t0.complex_id AS complex_id_39, t0.blameable_user_id AS blameable_user_id_40, t41.deleted_at AS deleted_at_42, t41.id AS id_43, t41.username AS username_44, t41.email AS email_45, t41.enabled AS enabled_46, t41.password AS password_47, t41.first_name AS first_name_48, t41.last_name AS last_name_49, t41.roles AS roles_50, t41.type AS type_51, t41.order_ticket_printer AS order_ticket_printer_52, t41.restaurant_ticket_printer AS restaurant_ticket_printer_53, t41.phone AS phone_54, t41.created_at AS created_at_55, t41.updated_at AS updated_at_56, t41.created_by_id AS created_by_id_57, t41.updated_by_id AS updated_by_id_58, t41.deleted_by_id AS deleted_by_id_59, t0.ticket_call_assigned_user_id AS ticket_call_assigned_user_id_60 FROM hotel t0 INNER JOIN user t41 ON t0.blameable_user_id = t41.id AND ((t41.deleted_at IS NULL)) WHERE t0.subdomain = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"preejd"
]
|
| 7 | 42.40 ms |
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.category AS category_3, t0.name AS name_4, t0.media AS media_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.deleted_by_id AS deleted_by_id_11 FROM media t0 INNER JOIN hotel_media ON t0.id = hotel_media.media_id WHERE hotel_media.hotel_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
b"¦YšuËÌ\x11쨲Îû–_•L"
]
|
| 8 | 2.35 ms |
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.subdomain AS subdomain_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.deleted_by_id AS deleted_by_id_9 FROM complex t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
b"\x1EËe\x06÷Ìh\x1A–›'m‰È€n"
]
|
pms_juan_dolio connection
No database queries were performed.
pms_puerto_plata connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| pms_juan_dolio | doctrine.dbal.pms_juan_dolio_connection |
| pms_puerto_plata | doctrine.dbal.pms_puerto_plata_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| pms_juan_dolio | doctrine.orm.pms_juan_dolio_entity_manager |
| pms_puerto_plata | doctrine.orm.pms_puerto_plata_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\AclPermission | No errors. |
| App\Entity\BehaviorsMappedSuperclass | No errors. |
| App\Entity\Complex | No errors. |
| App\Entity\Hotel | No errors. |
| App\Entity\Room | No errors. |
| App\Entity\RoomReserve | No errors. |
| App\Entity\User | No errors. |
| App\Entity\TourOperator | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\Report | No errors. |
| App\Entity\Detail | No errors. |
| App\Entity\Reporting | No errors. |
| App\Entity\Guest | No errors. |
| App\Entity\Restaurant | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Group | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\WiFiPremium | No errors. |
| App\Entity\ComplexGroup | No errors. |
| App\Entity\ComplexDepartment | No errors. |
pms_juan_dolio entity manager
No loaded entities.
pms_puerto_plata entity manager
No loaded entities.