Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.22 ms Query time

6 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.header_image_name AS header_image_name_5, t0.header_image_unique_name AS header_image_unique_name_6, t0.background_image_name AS background_image_name_7, t0.background_image_unique_name AS background_image_unique_name_8, t0.button_size AS button_size_9, t0.button_color AS button_color_10, t0.button_text AS button_text_11, t0.button_link AS button_link_12, t0.button_bottom_text AS button_bottom_text_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.button_action AS button_action_17 FROM sales_pages t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"pi.php"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.header_image_name AS header_image_name_5, t0.header_image_unique_name AS header_image_unique_name_6, t0.background_image_name AS background_image_name_7, t0.background_image_unique_name AS background_image_unique_name_8, t0.button_size AS button_size_9, t0.button_color AS button_color_10, t0.button_text AS button_text_11, t0.button_link AS button_link_12, t0.button_bottom_text AS button_bottom_text_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.button_action AS button_action_17 FROM sales_pages t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.header_image_name AS header_image_name_5, t0.header_image_unique_name AS header_image_unique_name_6, t0.background_image_name AS background_image_name_7, t0.background_image_unique_name AS background_image_unique_name_8, t0.button_size AS button_size_9, t0.button_color AS button_color_10, t0.button_text AS button_text_11, t0.button_link AS button_link_12, t0.button_bottom_text AS button_bottom_text_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.button_action AS button_action_17 FROM sales_pages t0 WHERE t0.slug = 'pi.php' LIMIT 1;

#▲

Time

Info

1.22 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.header_image_name AS header_image_name_5, t0.header_image_unique_name AS header_image_unique_name_6, t0.background_image_name AS background_image_name_7, t0.background_image_unique_name AS background_image_unique_name_8, t0.button_size AS button_size_9, t0.button_color AS button_color_10, t0.button_text AS button_text_11, t0.button_link AS button_link_12, t0.button_bottom_text AS button_bottom_text_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.button_action AS button_action_17 FROM sales_pages t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "pi.php"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.header_image_name AS header_image_name_5,
  t0.header_image_unique_name AS header_image_unique_name_6,
  t0.background_image_name AS background_image_name_7,
  t0.background_image_unique_name AS background_image_unique_name_8,
  t0.button_size AS button_size_9,
  t0.button_color AS button_color_10,
  t0.button_text AS button_text_11,
  t0.button_link AS button_link_12,
  t0.button_bottom_text AS button_bottom_text_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.button_action AS button_action_17
FROM
  sales_pages t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.header_image_name AS header_image_name_5, t0.header_image_unique_name AS header_image_unique_name_6, t0.background_image_name AS background_image_name_7, t0.background_image_unique_name AS background_image_unique_name_8, t0.button_size AS button_size_9, t0.button_color AS button_color_10, t0.button_text AS button_text_11, t0.button_link AS button_link_12, t0.button_bottom_text AS button_bottom_text_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.button_action AS button_action_17 FROM sales_pages t0 WHERE t0.slug = 'pi.php' 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\Lesson	No errors.
App\Entity\Instrument	No errors.
App\Entity\SaleBanner	The association App\Entity\SaleBanner#saleBannerType refers to the inverse side field App\Entity\SaleBannerType#sales_banners which does not exist.
App\Entity\VideoTestimonial	No errors.
App\Entity\SalePage	No errors.
App\Entity\Course	No errors.
App\Entity\Permission	No errors.
App\Entity\Exercise	No errors.
App\Entity\Faq	No errors.
App\Entity\LessonFaq	No errors.
App\Entity\SongInstrument	No errors.
App\Entity\Review	No errors.
App\Entity\Accompaniment	No errors.
App\Entity\SaleBannerType	The association App\Entity\SaleBannerType#salesBanners refers to the owning side field App\Entity\SaleBanner#sale_banner_type which does not exist.
App\Entity\Song	No errors.
App\Entity\SongAccompaniment	No errors.
App\Entity\Order	No errors.
App\Entity\UserLogin	No errors.
App\Entity\AnonymousEasyVersionAccess	No errors.
App\Entity\CrossSaleDiscount	No errors.
App\Entity\SongGenre	No errors.
App\Entity\LegacyData	No errors.
App\Entity\ReportLogs	No errors.
App\Entity\SongLyricsVersionHistory	No errors.
App\Entity\Plan	No errors.
App\Entity\Statistic	No errors.
App\Entity\UserAcceptance	No errors.
App\Entity\SendInBlueTask	No errors.
App\Entity\Artist	No errors.
App\Entity\UserLog	No errors.
App\Entity\VideoClick	No errors.
App\Entity\StaticPage	No errors.
App\Entity\Coupon	No errors.
App\Entity\TempPaymentData	No errors.
App\Entity\StartedToRegister	No errors.
App\Entity\PlansGroupDescription	No errors.
App\Entity\FreeViewTimer	No errors.
App\Entity\Genre	No errors.
App\Entity\Subscription	The mappings App\Entity\Subscription#freezedData and App\Entity\FreezedData#subscription are inconsistent with each other.
App\Entity\FailedSearch	No errors.
App\Entity\SongLyrics	No errors.
App\Entity\UserFavoriteSongs	No errors.
App\Entity\FreezedData	The association App\Entity\FreezedData#user refers to the inverse side field App\Entity\User#users which does not exist. The association App\Entity\FreezedData#subscription refers to the inverse side field App\Entity\Subscription#subscriptions which does not exist.
App\Entity\FailedPelecardPayment	No errors.
App\Entity\WatermarkLog	No errors.
App\Entity\UserTracker	No errors.
App\Entity\UserProfile	No errors.
App\Entity\CrossSaleDiscountReligious	No errors.
App\Entity\UserSongAccess	No errors.
App\Entity\Chord	No errors.
App\Entity\User	The mappings App\Entity\User#freezedData and App\Entity\FreezedData#user are inconsistent with each other. The association App\Entity\User#course refers to the inverse side field App\Entity\Course#users which does not exist.
App\Entity\CustomPaymentPage	No errors.
App\Entity\UserEasyVersionAccess	No errors.
App\Entity\UserFavoriteList	The association App\Entity\UserFavoriteList#user refers to the inverse side field App\Entity\User#userFavoriteLists which does not exist.
App\Entity\StoreRegistrationSurvey	No errors.
App\Entity\ChordEditorSave	No errors.
App\Entity\SearchMatch	No errors.
App\Entity\FormLog	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://preview2.new.negina.co.il/pi.php

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping