Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

1.68 ms Query time

7 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.18 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	1.32 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"dvpr2022"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dvpr2022' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
3	0.18 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

#▲

Time

Info

0.18 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

1.32 ms

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "dvpr2022"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'dvpr2022'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

0.18 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

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.

Entities Mapping

Class	Mapping errors
App\Entity\PaymentMethod	No errors.
App\Entity\SolicitudPublicaLog	The association App\Entity\SolicitudPublicaLog#user refers to the inverse side field App\Entity\User#solicitudPublicaLogs which does not exist.
App\Entity\PromoCode	The association App\Entity\PromoCode#users refers to the owning side field App\Entity\User#PromoCode which does not exist. The association App\Entity\PromoCode#user refers to the inverse side field App\Entity\User#promoCodes which does not exist.
App\Entity\SendgridJob	No errors.
App\Entity\DiscountName	No errors.
App\Entity\ProviderType	No errors.
App\Entity\PercentOff	No errors.
App\Entity\Provider	No errors.
App\Entity\PaymentIntent	No errors.
App\Entity\SolicitudPublica	The association App\Entity\SolicitudPublica#socio refers to the inverse side field App\Entity\User#solicitudPublicas which does not exist.
App\Entity\Color	No errors.
App\Entity\Tax	No errors.
App\Entity\Mailing	No errors.
App\Entity\Discount	No errors.
App\Entity\MailingLog	No errors.
App\Entity\Orden	No errors.
App\Entity\MailingList	No errors.
App\Entity\User	No errors.
App\Entity\Subscription	The association App\Entity\Subscription#subscriptionStatus refers to the inverse side field App\Entity\SubscriptionStatus#subscripciones which does not exist.
App\Entity\OrdenOrigen	No errors.
App\Entity\Coupon	The association App\Entity\Coupon#promoCodes refers to the owning side field App\Entity\PromoCode#coupon which does not exist.
App\Entity\TaxRecord	No errors.
App\Entity\SubscriptionStatus	The association App\Entity\SubscriptionStatus#users refers to the owning side field App\Entity\User#subscriptionStatus which is not defined as association, but as field. The association App\Entity\SubscriptionStatus#users refers to the owning side field App\Entity\User#subscriptionStatus which does not exist.
App\Entity\Rate	No errors.
App\Entity\Transaction	No errors.
App\Entity\Solicitud	No errors.
App\Entity\Payout	No errors.
App\Entity\Product	The association App\Entity\Product#programa refers to the inverse side field App\Entity\Programa#products which does not exist.
App\Entity\DiscountType	No errors.
App\Entity\Programa	No errors.
App\Entity\PlatformFee	No errors.
App\Entity\Commission	No errors.
App\Entity\SolicitudLog	No errors.
App\Entity\Restriction	No errors.
App\Entity\OrdenItem	No errors.
App\Entity\PromoCodeUsage	No errors.
App\Entity\ProgramaType	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

https://dreamvacationpr.com/database/.env

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping