GET https://preview2.new.negina.co.il/%D7%99%D7%A6%D7%99%D7%A8%D7%AA-%D7%A7%D7%A9%D7%A8

Response
200 OK
IP
216.73.217.54
Profiled on
Token
7335ff

Query Metrics

4 Database Queries
2 Different statements
1.99 ms Query time
6 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.73 ms 
SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.image_unique_name AS image_unique_name_2, s0_.mobile_image_name AS mobile_image_name_3, s0_.mobile_image_unique_name AS mobile_image_unique_name_4, s0_.type AS type_5, s0_.is_for_paid AS is_for_paid_6, s0_.is_for_free AS is_for_free_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.deleted_at AS deleted_at_10, s0_.url AS url_11, s0_.opens_purchase_popup AS opens_purchase_popup_12, s0_.sale_banner_type_id AS sale_banner_type_id_13 FROM sales_banners s0_ INNER JOIN sales_banners_type s1_ ON s0_.sale_banner_type_id = s1_.id WHERE s0_.deleted_at IS NULL AND s1_.slug = ? ORDER BY s0_.created_at DESC LIMIT 1
Parameters: 
[
  "all-except-main-and-payment-pages"
]
View formatted query    View runnable query    Explain query
2 0.34 ms 
SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.image_unique_name AS image_unique_name_2, s0_.mobile_image_name AS mobile_image_name_3, s0_.mobile_image_unique_name AS mobile_image_unique_name_4, s0_.type AS type_5, s0_.is_for_paid AS is_for_paid_6, s0_.is_for_free AS is_for_free_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.deleted_at AS deleted_at_10, s0_.url AS url_11, s0_.opens_purchase_popup AS opens_purchase_popup_12, s0_.sale_banner_type_id AS sale_banner_type_id_13 FROM sales_banners s0_ INNER JOIN sales_banners_type s1_ ON s0_.sale_banner_type_id = s1_.id WHERE s0_.deleted_at IS NULL AND s1_.slug = ? ORDER BY s0_.created_at DESC LIMIT 1
Parameters: 
[
  "all-except-main-and-payment-pages"
]
View formatted query    View runnable query    Explain query
3 0.31 ms 
SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.image_unique_name AS image_unique_name_2, s0_.mobile_image_name AS mobile_image_name_3, s0_.mobile_image_unique_name AS mobile_image_unique_name_4, s0_.type AS type_5, s0_.is_for_paid AS is_for_paid_6, s0_.is_for_free AS is_for_free_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.deleted_at AS deleted_at_10, s0_.url AS url_11, s0_.opens_purchase_popup AS opens_purchase_popup_12, s0_.sale_banner_type_id AS sale_banner_type_id_13 FROM sales_banners s0_ INNER JOIN sales_banners_type s1_ ON s0_.sale_banner_type_id = s1_.id WHERE s0_.deleted_at IS NULL AND s1_.slug = ? ORDER BY s0_.created_at DESC LIMIT 1
Parameters: 
[
  "all-except-main-and-payment-pages"
]
View formatted query    View runnable query    Explain query
4 0.60 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.header AS header_4, t0.subheader AS subheader_5, t0.incentives AS incentives_6, t0.content AS content_7, t0.description AS description_8, t0.description_mobile AS description_mobile_9, t0.rating AS rating_10, t0.reviews_count AS reviews_count_11, t0.students_count AS students_count_12, t0.video AS video_13, t0.title_seo AS title_seo_14, t0.meta_title_seo AS meta_title_seo_15, t0.meta_description_seo AS meta_description_seo_16, t0.title_breadcrumb AS title_breadcrumb_17, t0.updated_at AS updated_at_18, t0.instrument_id AS instrument_id_19 FROM courses t0
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\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\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\Song No errors.
App\Entity\SongAccompaniment No errors.
App\Entity\SalePage 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.