Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.88 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.88 ms	SELECT t0.id AS id_1, t0.begin AS begin_2, t0.name AS name_3, t0.has_customer_comments_enabled AS has_customer_comments_enabled_4, t0.has_how_did_you_find_us_question_enabled AS has_how_did_you_find_us_question_enabled_5, t0.customer_comments_text_helper AS customer_comments_text_helper_6, t0.active AS active_7, t0.removed_at AS removed_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.site AS site_11 FROM vulco_satisfaction_survey t0 WHERE t0.name = ? AND ((t0.site = 'pt') AND (t0.removed_at IS NULL)) LIMIT 1 Parameters: [`"0000-PT-default-satisfaction-survey-name"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.begin AS begin_2, t0.name AS name_3, t0.has_customer_comments_enabled AS has_customer_comments_enabled_4, t0.has_how_did_you_find_us_question_enabled AS has_how_did_you_find_us_question_enabled_5, t0.customer_comments_text_helper AS customer_comments_text_helper_6, t0.active AS active_7, t0.removed_at AS removed_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.site AS site_11 FROM vulco_satisfaction_survey t0 WHERE t0.name = ? AND ( (t0.site = 'pt') AND (t0.removed_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.begin AS begin_2, t0.name AS name_3, t0.has_customer_comments_enabled AS has_customer_comments_enabled_4, t0.has_how_did_you_find_us_question_enabled AS has_how_did_you_find_us_question_enabled_5, t0.customer_comments_text_helper AS customer_comments_text_helper_6, t0.active AS active_7, t0.removed_at AS removed_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.site AS site_11 FROM vulco_satisfaction_survey t0 WHERE t0.name = '0000-PT-default-satisfaction-survey-name' AND ((t0.site = 'pt') AND (t0.removed_at IS NULL)) LIMIT 1;

#▲

Time

Info

0.88 ms

SELECT t0.id AS id_1, t0.begin AS begin_2, t0.name AS name_3, t0.has_customer_comments_enabled AS has_customer_comments_enabled_4, t0.has_how_did_you_find_us_question_enabled AS has_how_did_you_find_us_question_enabled_5, t0.customer_comments_text_helper AS customer_comments_text_helper_6, t0.active AS active_7, t0.removed_at AS removed_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.site AS site_11 FROM vulco_satisfaction_survey t0 WHERE t0.name = ? AND ((t0.site = 'pt') AND (t0.removed_at IS NULL)) LIMIT 1

Parameters:

[
  "0000-PT-default-satisfaction-survey-name"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.begin AS begin_2,
  t0.name AS name_3,
  t0.has_customer_comments_enabled AS has_customer_comments_enabled_4,
  t0.has_how_did_you_find_us_question_enabled AS has_how_did_you_find_us_question_enabled_5,
  t0.customer_comments_text_helper AS customer_comments_text_helper_6,
  t0.active AS active_7,
  t0.removed_at AS removed_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.site AS site_11
FROM
  vulco_satisfaction_survey t0
WHERE
  t0.name = ?
  AND (
    (t0.site = 'pt')
    AND (t0.removed_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.begin AS begin_2, t0.name AS name_3, t0.has_customer_comments_enabled AS has_customer_comments_enabled_4, t0.has_how_did_you_find_us_question_enabled AS has_how_did_you_find_us_question_enabled_5, t0.customer_comments_text_helper AS customer_comments_text_helper_6, t0.active AS active_7, t0.removed_at AS removed_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.site AS site_11 FROM vulco_satisfaction_survey t0 WHERE t0.name = '0000-PT-default-satisfaction-survey-name' AND ((t0.site = 'pt') AND (t0.removed_at IS NULL)) LIMIT 1;

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\SatisfactionSurveys\SatisfactionSurvey	No errors.
App\Entity\SatisfactionSurveys\SatisfactionSurveyQuestion	No errors.
App\Entity\SatisfactionSurveys\SatisfactionSurveyCustomerResponseAnswer	No errors.
App\Entity\SatisfactionSurveys\SatisfactionSurveyCustomerResponse	No errors.
App\Entity\NotificationConfig	No errors.
App\Entity\PurchaseTracking\GaragePurchase	No errors.
App\Entity\Cart\CartItem	No errors.
App\Entity\Cart\CartItemSize	No errors.
App\Entity\Cart\Cart	No errors.
App\Entity\Address	No errors.
App\Entity\Statistics\BarometerStatisticMiniPanel	No errors.
App\Entity\Statistics\MiniPanelStatistic	No errors.
App\Entity\Statistics\StockStatistic	No errors.
App\Entity\Statistics\ConfigStatistic	No errors.
App\Entity\Statistics\SaleStatistic	No errors.
App\Entity\Statistics\BarometerStatistic	No errors.
App\Entity\MediaLibrary\CooperativeMedia	No errors.
App\Entity\MediaLibrary\CooperativeMediaCategory	No errors.
App\Entity\MediaLibrary\CooperativeMediaCategoryFamily	No errors.
App\Entity\InformativePills\InformativePillVideoPlayback	No errors.
App\Entity\InformativePills\InformativePill	No errors.
App\Entity\InformativePills\InformativePillFamily	No errors.
App\Entity\Promotions\NationalPromotion	No errors.
App\Entity\Promotions\LocalPromotion	No errors.
App\Entity\UserGroup	The mappings App\Entity\UserGroup#catalogGiftCategories and App\Entity\OnlineShop\Family#userGroups are inconsistent with each other.
App\Entity\Region	No errors.
App\Entity\LearningCourses\LearningCourse	No errors.
App\Entity\LearningCourses\LearningCourseSession	No errors.
App\Entity\LearningCourses\LearningCourseCategory	No errors.
App\Entity\LearningCourses\LearningCourseLesson	No errors.
App\Entity\LearningCourses\LearningCourseRegistration	No errors.
App\Entity\Garages\GarageOffer2	No errors.
App\Entity\Garages\GarageService	No errors.
App\Entity\Garages\GarageSchedules	No errors.
App\Entity\Garages\GarageFacility	No errors.
App\Entity\Garages\GarageAppointment	No errors.
App\Entity\Garages\Garage	No errors.
App\Entity\Garages\GarageGroup	No errors.
App\Entity\Garages\GarageOwner	No errors.
App\Entity\Garages\GarageAboutUs	No errors.
App\Entity\Garages\GarageSearchConfig	No errors.
App\Entity\Garages\GarageVehicleType	No errors.
App\Entity\TruckRates\TruckRate	No errors.
App\Entity\Documents\DocumentDownload	No errors.
App\Entity\Documents\DocumentCategory	No errors.
App\Entity\Documents\DocumentCategoryFamily	No errors.
App\Entity\Documents\Document	No errors.
App\Entity\Whatsapp\WhatsappMessage	No errors.
App\Entity\Whatsapp\WhatsappOrderProduct	No errors.
App\Entity\Whatsapp\WhatsappCampaign	The field App\Entity\Whatsapp\WhatsappCampaign#messages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Whatsapp\WhatsappCampaignMessage#whatsappCampaign does not contain the required 'inversedBy="messages"' attribute.
App\Entity\Whatsapp\WhatsappMessageTemplate	No errors.
App\Entity\Whatsapp\WhatsappCampaignMessage	No errors.
App\Entity\Whatsapp\WhatsappOrder	No errors.
App\Entity\Whatsapp\WhatsappMessageStatus	No errors.
App\Entity\Tracking\UserTracking	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\User	No errors.
App\Entity\Calendar\CalendarEvent	No errors.
App\Entity\Calendar\CalendarEventCategory	No errors.
App\Entity\Province	No errors.
App\Entity\News\NewsTag	No errors.
App\Entity\Gallery\GalleryAlbum	No errors.
App\Entity\Gallery\GalleryImage	No errors.
App\Entity\Gallery\GalleryVideo	No errors.
App\Entity\PointsCatalog\CatalogSize	No errors.
App\Entity\PointsCatalog\CatalogGift	No errors.
App\Entity\PointsCatalog\CatalogPointMovement	No errors.
App\Entity\PointsCatalog\CatalogSizeGroup	No errors.
App\Entity\PointsCatalog\CatalogGiftHasProvider	No errors.
App\Entity\PointsCatalog\CatalogConversionFormula	No errors.
App\Entity\PointsCatalog\CatalogPointConfig	No errors.
App\Entity\PointsCatalog\CatalogGiftProvider	No errors.
App\Entity\PointsCatalog\CatalogOrderGift	No errors.
App\Entity\PointsCatalog\CatalogOrder	No errors.
App\Entity\PointsCatalog\CatalogFaq	No errors.
App\Entity\PointsCatalog\CatalogGiftCategory	No errors.
App\Entity\OnlineShop\SuperFamily	No errors.
App\Entity\OnlineShop\SupplierDocumentDownload	No errors.
App\Entity\OnlineShop\FamilyLinealDiscount	No errors.
App\Entity\OnlineShop\Supplier	No errors.
App\Entity\OnlineShop\Order	No errors.
App\Entity\OnlineShop\ScaleShippingCost	No errors.
App\Entity\OnlineShop\SupplierCategory	No errors.
App\Entity\OnlineShop\ScalePrice	No errors.
App\Entity\OnlineShop\ProductSpecialPrice	No errors.
App\Entity\OnlineShop\Product	No errors.
App\Entity\OnlineShop\FamilyNoLinealDiscount	No errors.
App\Entity\OnlineShop\ProductOrder	No errors.
App\Entity\OnlineShop\SupplierDocument	No errors.
App\Entity\OnlineShop\OrderFamilyDiscount	No errors.
App\Entity\OnlineShop\Family	No errors.
App\Entity\OnlineShop\OrderSupplierShippingCost	No errors.
App\Entity\OnlineShop\VolumeDiscount	No errors.
App\Entity\Mailing\MailingContact	No errors.
App\Entity\JoinTheNetwork\JoinTheNetwork	No errors.
App\Entity\Tires\TireSize	No errors.
App\Entity\Tires\Tire	No errors.
App\Entity\Tires\TireBrand	No errors.
App\Entity\Sms\PreparedSMSCommunication	No errors.
App\Entity\Sms\SMSComunicationRow	No errors.
App\Entity\Sms\DeliveryList	No errors.
App\Entity\Sms\DeliveryContact	No errors.
App\Entity\Extranet\Alert	No errors.
App\Entity\Extranet\OrganigramNode	No errors.
App\Entity\Extranet\AlertUser	No errors.
App\Entity\Extranet\DashboardLink	No errors.
App\Entity\Extranet\DashboardNewsSlide	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

https://test-novo.vulco.pt/robots.txt

Configuration Settings

Theme