Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.64 ms Query time

31 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.64 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.mime_type AS mime_type_3, t0.data AS data_4 FROM media t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.mime_type AS mime_type_3, t0.data AS data_4 FROM media t0 SELECT t0.id AS id_1, t0.filename AS filename_2, t0.mime_type AS mime_type_3, t0.data AS data_4 FROM media t0;

#▲

Time

Info

0.64 ms

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.mime_type AS mime_type_3, t0.data AS data_4 FROM media t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.mime_type AS mime_type_3,
  t0.data AS data_4
FROM
  media t0

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.mime_type AS mime_type_3, t0.data AS data_4 FROM media t0;

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\Booking\CabinOptionDuration	No errors.
Crea\SecurityBundle\Entity\Right	The target entity 'Crea\SecurityBundle\Entity\ProfileInterface' specified on Crea\SecurityBundle\Entity\Right#profiles is unknown or not an entity.
App\Entity\Accounting\AttributedProductVariant	No errors.
App\Entity\Accounting\AttributedInsurance	The field 'App\Entity\Accounting\AttributedInsurance#buyingPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Accounting\AttributedInsurance#amountForCalculation' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on App\Entity\Accounting\AttributedInsurance#createdBy is unknown or not an entity.
Crea\ParameterBundle\Entity\ParameterType	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on Crea\ParameterBundle\Entity\ParameterType#createdBy is unknown or not an entity.
Crea\ParameterBundle\Entity\Parameter	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on Crea\ParameterBundle\Entity\Parameter#createdBy is unknown or not an entity.
App\Entity\__Accounting\Supplier	The mappings App\Entity\__Accounting\Supplier#legalTexts and App\Entity\__Sale\LegalText#supplier are inconsistent with each other.
Crea\SecurityBundle\Entity\User	No errors.
App\Entity\User\User	The association App\Entity\User\User#payments refers to the owning side field App\Entity\Accounting\Payment#user which does not exist. The association App\Entity\User\User#cabins refers to the owning side field App\Entity\Booking\Cabin#user which does not exist. The target entity 'Crea\SecurityBundle\Entity\ProfileInterface' specified on App\Entity\User\User#profile is unknown or not an entity.
App\Migration\Entity\LoadCorrBooking	No errors.
App\Entity\Booking\Booking	The field App\Entity\Booking\Booking#formalityHistoryBookings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cruise\Formality\FormalityHistoryBooking#booking does not contain the required 'inversedBy="formalityHistoryBookings"' attribute. The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on App\Entity\Booking\Booking#createdBy is unknown or not an entity.
App\Entity\Product\ProductVariant	The field App\Entity\Product\ProductVariant#insurancePrice is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\__Accounting\InsurancePrice#productVariant does not contain the required 'mappedBy="insurancePrice"' attribute.
App\Entity\Discount\Discount	No errors.
App\Entity\Partner\PartnerCompanyDiscount	No errors.
App\Entity\Discount\AttributedDiscount	No errors.
App\Entity\Accounting\QuoteLine	No errors.
App\Entity\Accounting\InvoiceLine	No errors.
App\Entity\Product\MarginProduct	No errors.
App\Entity\Product\MarginCabin	No errors.
App\Entity\Partner\Partner	The mappings App\Entity\Partner\Partner#partnerAllowances and App\Entity\__Accounting\PartnerAllowance\PartnerAllowance#partner are inconsistent with each other. The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on App\Entity\Partner\Partner#createdBy is unknown or not an entity.
App\Entity\Selling\SellingSegment	No errors.
App\Entity\Selling\SellingSegmentCabinTypePoint	No errors.
App\Entity\Booking\ProspectRequest	The association App\Entity\Booking\ProspectRequest#potentialContact refers to the inverse side field App\Entity\__Contact\contact\Contact#prospectRequestsPotentialContact which does not exist.
Crea\EventBundle\Entity\EventCategory	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on Crea\EventBundle\Entity\EventCategory#createdBy is unknown or not an entity.
App\Entity\ApplicationFilter	No errors.
App\Entity\ApplicationFilterLimitation	No errors.
App\Entity\Cruise\Itinerary\Destination	No errors.
App\Entity\Email\EmailContent	No errors.
App\Entity\Partner\PartnerByContact	No errors.
App\Entity\Partner\PartnerByContactHistory	No errors.
App\Entity\Notification\NotificationRule	No errors.
App\Entity\Accounting\Account	No errors.
App\Entity\Accounting\ApplicationFee	No errors.
App\Entity\Accounting\Payment	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on App\Entity\Accounting\Payment#createdBy is unknown or not an entity.
App\Entity\Accounting\BalanceBeforeDeparture	No errors.
Crea\EventBundle\Entity\EventModel	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on Crea\EventBundle\Entity\EventModel#userClicker is unknown or not an entity.
App\Entity\Booking\BookingIndividualTurnover	No errors.
App\Entity\Booking\BookingPartnerTurnover	No errors.
App\Entity\__Accounting\PartnerParticipation\PartnerParticipation	The field 'App\Entity\__Accounting\PartnerParticipation\PartnerParticipation#nbPax' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\__Accounting\PartnerAllowance\PartnerAllowance	The field 'App\Entity\__Accounting\PartnerAllowance\PartnerAllowance#nbPax' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type. The association App\Entity\__Accounting\PartnerAllowance\PartnerAllowance#partner refers to the inverse side field App\Entity\Partner\Partner#partnerPayments which does not exist.
App\Entity\Selling\SellerBonus	No errors.
App\Entity\Schedule\ScheduleEvent	No errors.
App\Entity\Schedule\Leave	No errors.
App\Entity\Notification\Reminder	No errors.
App\Entity\Accounting\Invoice	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on App\Entity\Accounting\Invoice#createdBy is unknown or not an entity.
App\Entity\Booking\AdvBookingChangeCategory	No errors.
App\Entity\Booking\AdvBookingChangeState	No errors.
App\Entity\Booking\AdvBookingChangeAssociationValidationState	No errors.
App\Entity\Booking\AdvBookingChange	No errors.
App\Entity\Cruise\Ship\Ship	The mappings App\Entity\Cruise\Ship\Ship#cabinCategoryHistories and App\Entity\Cruise\CabinCategory\CabinCategoryHistory#ship are inconsistent with each other.
App\Entity\Cruise\Company\Advantage	No errors.
App\Entity\Cruise\Stopover\Stopover	The mappings App\Entity\Cruise\Stopover\Stopover#itinerarySegmentHistories and App\Entity\Cruise\Itinerary\ItinerarySegmentHistory#stopover are inconsistent with each other.
App\Entity\Cruise\Cabin\CabinParticularity	No errors.
App\Entity\Cruise\Ship\Deck	No errors.
App\Entity\__Contact\contact\Contact	The association App\Entity\__Contact\contact\Contact#prospectRequests refers to the owning side field App\Entity\Booking\ProspectRequest#contact which does not exist. The association App\Entity\__Contact\contact\Contact#prospects refers to the owning side field App\Entity\Contact\Prospect#contact which does not exist.
App\Entity\Product\AutoProductVariant	No errors.
App\Entity\Accounting\PortTax	The field 'App\Entity\Accounting\PortTax#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Cruise\Company\Company	The association App\Entity\Cruise\Company\Company#cabinCategories refers to the owning side field App\Entity\Cruise\CabinCategory\CabinCategory#company which does not exist.
App\Entity\Product\Product	No errors.
App\Entity\Booking\Quote	The field 'App\Entity\Booking\Quote#deposit' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Booking\Quote#finalPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Booking\Quote#applicationFee' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on App\Entity\Booking\Quote#createdBy is unknown or not an entity.
App\EntityView\__Accounting\InsuranceView	The field 'App\EntityView\__Accounting\InsuranceView#buyingPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\EntityView\__Accounting\InsuranceView#sellingPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\EntityView\__Accounting\InsuranceView#margin' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\__Accounting\PartnerTemplate\PartnerTemplateContent	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on App\Entity\__Accounting\PartnerTemplate\PartnerTemplateContent#createdBy is unknown or not an entity.
App\Entity\__Accounting\PartnerAllowance\Allowance	The field 'App\Entity\__Accounting\PartnerAllowance\Allowance#nbPax' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\__Accounting\PartnerParticipation\Participation	The field 'App\Entity\__Accounting\PartnerParticipation\Participation#nbPax' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Email\SentEmail	No errors.
App\Entity\Cruise\Cruise\CruiseHistory	No errors.
App\Entity\__Sale\LegalText	The association App\Entity\__Sale\LegalText#supplier refers to the inverse side field App\Entity\__Accounting\Supplier#LegalText which does not exist. The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on App\Entity\__Sale\LegalText#createdBy is unknown or not an entity.
Crea\DocumentationBundle\Entity\Chapter	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on Crea\DocumentationBundle\Entity\Chapter#createdBy is unknown or not an entity.
Crea\DocumentationBundle\Entity\Article	No errors.
Crea\EventBundle\Entity\EventType	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on Crea\EventBundle\Entity\EventType#createdBy is unknown or not an entity.
Crea\EventBundle\Entity\EventLog	The target entity 'Symfony\Component\Security\Core\User\UserInterface' specified on Crea\EventBundle\Entity\EventLog#userClicker is unknown or not an entity.
App\Entity\Media	No errors.
App\Entity\User\UserCMS	The association App\Entity\User\UserCMS#payments refers to the owning side field App\Entity\Accounting\Payment#userCms which does not exist. The association App\Entity\User\UserCMS#cabins refers to the owning side field App\Entity\Booking\Cabin#userCms which does not exist.

Symfony Profiler

https://erp.preprod-croisiland.dev/connexion

Configuration Settings

Theme