https://imag.pre.virtualconcierge.net/robots.txt

Query Metrics

3 Database Queries
3 Different statements
98.38 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
66.57 ms
(67.66%)
1
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
21.95 ms
(22.31%)
1
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:
[
  "imag"
]
9.87 ms
(10.03%)
1
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:
[
  "imag"
]

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.