Query Metrics
3
Database Queries
3
Different statements
7.58 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 1.47 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 | 1.37 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 | 4.74 ms |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
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\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\Room | 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\RoomReserve | No errors. |
App\Entity\ComplexDepartment | No errors. |
App\Entity\TourOperatorGlobal | No errors. |
App\Entity\DepartmentTranslation | No errors. |
App\Entity\ComplexReport | No errors. |
App\Entity\ReportTranslation | No errors. |
App\Entity\ComplexDetail | No errors. |
App\Entity\DetailTranslation | No errors. |
App\Entity\ReportingTranslation | No errors. |
App\Entity\Table | No errors. |
App\Entity\Turn | No errors. |
App\Entity\RestaurantReserve | No errors. |
App\Entity\RestaurantTranslation | No errors. |
App\Entity\TicketCall | No errors. |
App\Entity\ProductHour | No errors. |
App\Entity\ProductAvailabilityHour | No errors. |
App\Entity\ProductTranslation | No errors. |
App\Entity\OrderItem | No errors. |
App\Entity\InvoiceItem | No errors. |
App\Entity\PageTranslation | No errors. |
App\Entity\WiFiPremiumAccess | No errors. |
pms_juan_dolio entity manager
No loaded entities.
pms_puerto_plata entity manager
No loaded entities.