https://www.polydate.co.il/app_dev.php/he/

Query Metrics

43 Database Queries
12 Different statements
103.35 ms Query time
9 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
70.91 ms
(68.62%)
1
SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.username AS username_2, u0_.password AS password_3, u0_.email AS email_4, u0_.birthday AS birthday_5, u0_.is_sent_email AS is_sent_email_6, u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, u0_.sexOrientationDetails AS sexOrientationDetails_8, u0_.about AS about_9, u0_.looking AS looking_10, u0_.LookingForDetails AS LookingForDetails_11, u0_.age_from AS age_from_12, u0_.age_to AS age_to_13, u0_.height AS height_14, u0_.views AS views_15, u0_.points AS points_16, u0_.freeze_reason AS freeze_reason_17, u0_.ban_reason AS ban_reason_18, u0_.admin_comments AS admin_comments_19, u0_.ip AS ip_20, u0_.code AS code_21, u0_.is_active AS is_active_22, u0_.is_activated AS is_activated_23, u0_.is_non_locked AS is_non_locked_24, u0_.isUpdatedZodiac AS isUpdatedZodiac_25, u0_.is_frozen AS is_frozen_26, u0_.is_flagged AS is_flagged_27, u0_.is_on_homepage AS is_on_homepage_28, u0_.last_activity_at AS last_activity_at_29, u0_.last_real_activity_at AS last_real_activity_at_30, u0_.last_login_at AS last_login_at_31, u0_.sign_up_date AS sign_up_date_32, u0_.start_subscription AS start_subscription_33, u0_.end_subscription AS end_subscription_34, u0_.code_date AS code_date_35, u0_.verify_count AS verify_count_36, u0_.code_count AS code_count_37, u0_.longitude AS longitude_38, u0_.latitude AS latitude_39, u0_.is_sent_push AS is_sent_push_40, u0_.facebook_id AS facebook_id_41, u0_.is_vip AS is_vip_42 FROM user u0_ INNER JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_main = 1 AND f1_.is_valid = 1) WHERE u0_.is_on_homepage = 1
Parameters: []
23.34 ms
(22.58%)
1
SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.username AS username_2, u0_.password AS password_3, u0_.email AS email_4, u0_.birthday AS birthday_5, u0_.is_sent_email AS is_sent_email_6, u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, u0_.sexOrientationDetails AS sexOrientationDetails_8, u0_.about AS about_9, u0_.looking AS looking_10, u0_.LookingForDetails AS LookingForDetails_11, u0_.age_from AS age_from_12, u0_.age_to AS age_to_13, u0_.height AS height_14, u0_.views AS views_15, u0_.points AS points_16, u0_.freeze_reason AS freeze_reason_17, u0_.ban_reason AS ban_reason_18, u0_.admin_comments AS admin_comments_19, u0_.ip AS ip_20, u0_.code AS code_21, u0_.is_active AS is_active_22, u0_.is_activated AS is_activated_23, u0_.is_non_locked AS is_non_locked_24, u0_.isUpdatedZodiac AS isUpdatedZodiac_25, u0_.is_frozen AS is_frozen_26, u0_.is_flagged AS is_flagged_27, u0_.is_on_homepage AS is_on_homepage_28, u0_.last_activity_at AS last_activity_at_29, u0_.last_real_activity_at AS last_real_activity_at_30, u0_.last_login_at AS last_login_at_31, u0_.sign_up_date AS sign_up_date_32, u0_.start_subscription AS start_subscription_33, u0_.end_subscription AS end_subscription_34, u0_.code_date AS code_date_35, u0_.verify_count AS verify_count_36, u0_.code_count AS code_count_37, u0_.longitude AS longitude_38, u0_.latitude AS latitude_39, u0_.is_sent_push AS is_sent_push_40, u0_.facebook_id AS facebook_id_41, u0_.is_vip AS is_vip_42, u0_.role_id AS role_id_43, u0_.gender_id AS gender_id_44, u0_.region_id AS region_id_45, u0_.city_id AS city_id_46, u0_.children_id AS children_id_47, u0_.religion_id AS religion_id_48, u0_.nutrition_id AS nutrition_id_49, u0_.relationship_status_id AS relationship_status_id_50, u0_.relationship_type_id AS relationship_type_id_51, u0_.sex_orientation_id AS sex_orientation_id_52, u0_.smoking_id AS smoking_id_53, u0_.body_id AS body_id_54, u0_.origin_id AS origin_id_55, u0_.zodiac_id AS zodiac_id_56, u0_.login_from_id AS login_from_id_57 FROM user u0_ INNER JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_main = 1 AND f1_.is_valid = 1) WHERE u0_.is_on_homepage = 1 LIMIT 30 OFFSET 2730
Parameters: []
5.77 ms
(5.59%)
30
SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = ? AND t0.type IN ('1')
Parameters: [0 => 16800]
1.06 ms
(1.03%)
1
SELECT t0.id AS id_1, t0.href AS href_2, t0.img AS img_3, t0.name AS name_4, t0.click_count AS click_count_5, t0.is_active AS is_active_6, t0.before_login AS before_login_7, t0.after_login AS after_login_8, t0.subscription_page AS subscription_page_9, t0.profile_bottom AS profile_bottom_10, t0.profile_top AS profile_top_11, t0.mobile AS mobile_12, t0.mans AS mans_13, t0.womans AS womans_14, t0.abinary AS abinary_15, t0.pay AS pay_16, t0.not_pay AS not_pay_17 FROM banner t0 WHERE t0.before_login = ? AND t0.is_active = ?
Parameters: [0 => 1, 1 => 1]
0.72 ms
(0.70%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.header_type AS header_type_6, t0.is_active AS is_active_7, t0.uri AS uri_8, t0.footer_header_id AS footer_header_id_9 FROM page t0 WHERE t0.footer_header_id = ?
Parameters: [0 => 1]
0.71 ms
(0.69%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.title AS title_2, a0_.description AS description_3, a0_.content AS content_4, a0_.brief AS brief_5, a0_.header_type AS header_type_6, a0_.is_active AS is_active_7, a0_.is_on_homepage AS is_on_homepage_8, a0_.date AS date_9, a0_.image_name AS image_name_10, a0_.uri AS uri_11, a0_.image_alt AS image_alt_12, a0_.locale AS locale_13 FROM article a0_ WHERE a0_.is_on_homepage = 1 AND a0_.is_active = 1 ORDER BY a0_.date DESC LIMIT 3
Parameters: []
0.19 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.image_name AS image_name_4, t0.is_active AS is_active_5, t0.header_type AS header_type_6, t0.ext AS ext_7 FROM slide t0 WHERE t0.is_active = ?
Parameters: [0 => 1]
0.18 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.block1 AS block1_3, t0.block2 AS block2_4, t0.block3 AS block3_5, t0.block4 AS block4_6, t0.block5 AS block5_7, t0.headerType AS headerType_8 FROM home_page t0
Parameters: []
0.14 ms
(0.14%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.page AS page_4 FROM seo t0 WHERE t0.page = ? LIMIT 1
Parameters: [0 => homepage]
0.12 ms
(0.12%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM footer_header t0
Parameters: []
0.10 ms
(0.10%)
1
SELECT g0_.id AS id_0, g0_.name AS name_1 FROM gender g0_
Parameters: []
0.10 ms
(0.10%)
1
SELECT l0_.id AS id_0, l0_.name AS name_1 FROM looking_for l0_
Parameters: []

messages connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
messages doctrine.dbal.messages_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
messages doctrine.orm.messages_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
AppBundle\Entity\Gender
  • The association AppBundle\Entity\Gender#lookingGenderUsers refers to the owning side field AppBundle\Entity\User#lookingGender which does not exist.
AppBundle\Entity\LookingFor
  • The association AppBundle\Entity\LookingFor#users refers to the owning side field AppBundle\Entity\User#looking_for which does not exist.
AppBundle\Entity\Banner No errors.
AppBundle\Entity\User
  • The mappings AppBundle\Entity\User#contactGender and AppBundle\Entity\Gender#users are inconsistent with each other.
  • If association AppBundle\Entity\User#contactGender is many-to-many, then the inversed side AppBundle\Entity\Gender#users has to be many-to-many as well.
  • The mappings AppBundle\Entity\User#lookingFor and AppBundle\Entity\LookingFor#users are inconsistent with each other.
  • If association AppBundle\Entity\User#lookingFor is many-to-many, then the inversed side AppBundle\Entity\LookingFor#users has to be many-to-many as well.
  • The association AppBundle\Entity\User#religion refers to the inverse side field AppBundle\Entity\Religion#users which does not exist.
  • The association AppBundle\Entity\User#nutrition refers to the inverse side field AppBundle\Entity\Nutrition#users which does not exist.
  • The mappings AppBundle\Entity\User#origin and AppBundle\Entity\Origin#users are inconsistent with each other.
  • The mappings AppBundle\Entity\User#videos and AppBundle\Entity\Video#user are inconsistent with each other.
  • The mappings AppBundle\Entity\User#showPhoto and AppBundle\Entity\ShowPhoto#member are inconsistent with each other.
  • The mappings AppBundle\Entity\User#showPhoto2 and AppBundle\Entity\ShowPhoto#owner are inconsistent with each other.
  • The mappings AppBundle\Entity\User#userMessengerNotification and AppBundle\Entity\UserMessengerNotifications#user are inconsistent with each other.
  • The mappings AppBundle\Entity\User#verifyMe and AppBundle\Entity\Verify#userTo are inconsistent with each other.
AppBundle\Entity\File No errors.
AppBundle\Entity\Photo No errors.
AppBundle\Entity\Role No errors.
AppBundle\Entity\Region No errors.
AppBundle\Entity\City No errors.
AppBundle\Entity\Children No errors.
AppBundle\Entity\Religion No errors.
AppBundle\Entity\Nutrition No errors.
AppBundle\Entity\RelationshipStatus No errors.
AppBundle\Entity\RelationshipType No errors.
AppBundle\Entity\SexOrientation No errors.
AppBundle\Entity\Smoking No errors.
AppBundle\Entity\Body No errors.
AppBundle\Entity\Origin
  • The association AppBundle\Entity\Origin#users refers to the owning side field AppBundle\Entity\User#origin_id which does not exist.
AppBundle\Entity\Zodiac No errors.
AppBundle\Entity\LoginFrom No errors.
AppBundle\Entity\Payment No errors.
AppBundle\Entity\Video
  • The association AppBundle\Entity\Video#user refers to the inverse side field AppBundle\Entity\User#video which does not exist.
  • The field AppBundle\Entity\Video#views is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\VideoView#video does not contain the required 'inversedBy="views"' attribute.
AppBundle\Entity\ShowPhoto
  • The association AppBundle\Entity\ShowPhoto#owner refers to the inverse side field AppBundle\Entity\User#user which does not exist.
  • The association AppBundle\Entity\ShowPhoto#member refers to the inverse side field AppBundle\Entity\User#user which does not exist.
AppBundle\Entity\Note No errors.
AppBundle\Entity\View No errors.
AppBundle\Entity\Contact No errors.
AppBundle\Entity\Favorite No errors.
AppBundle\Entity\BlackList No errors.
AppBundle\Entity\Communication No errors.
AppBundle\Entity\UserNotifications
  • The association AppBundle\Entity\UserNotifications#notification refers to the inverse side field AppBundle\Entity\Notifications#userNotification which does not exist.
AppBundle\Entity\UserMessengerNotifications
  • The association AppBundle\Entity\UserMessengerNotifications#notification refers to the inverse side field AppBundle\Entity\Notifications#userNotification which does not exist.
  • The association AppBundle\Entity\UserMessengerNotifications#push refers to the inverse side field AppBundle\Entity\Push#id which is not defined as association.
  • The association AppBundle\Entity\UserMessengerNotifications#push refers to the inverse side field AppBundle\Entity\Push#id which does not exist.
  • The association AppBundle\Entity\UserMessengerNotifications#user refers to the inverse side field AppBundle\Entity\User#messengerNotification which does not exist.
  • The association AppBundle\Entity\UserMessengerNotifications#fromUser refers to the inverse side field AppBundle\Entity\User#messengerNotification which does not exist.
AppBundle\Entity\LikeMe No errors.
AppBundle\Entity\ArenaDislike No errors.
AppBundle\Entity\Verify
  • The mappings AppBundle\Entity\Verify#userFrom and AppBundle\Entity\User#verify are inconsistent with each other.
AppBundle\Entity\Article No errors.
AppBundle\Entity\HomePage No errors.
AppBundle\Entity\Seo No errors.
AppBundle\Entity\Slide No errors.
AppBundle\Entity\FooterHeader No errors.
AppBundle\Entity\Page No errors.

messages entity manager

No loaded entities.