Query Metrics
43
Database Queries
12
Different statements
103.35 ms
Query time
9
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.06 ms |
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]
|
| 2 | 70.91 ms |
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: []
|
| 3 | 23.34 ms |
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: []
|
| 4 | 0.71 ms |
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: []
|
| 5 | 0.18 ms |
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: []
|
| 6 | 0.14 ms |
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]
|
| 7 | 0.19 ms |
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]
|
| 8 | 0.10 ms |
SELECT g0_.id AS id_0, g0_.name AS name_1 FROM gender g0_
Parameters: []
|
| 9 | 0.10 ms |
SELECT l0_.id AS id_0, l0_.name AS name_1 FROM looking_for l0_
Parameters: []
|
| 10 | 0.45 ms |
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]
|
| 11 | 0.15 ms |
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 => 16806]
|
| 12 | 0.13 ms |
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 => 16810]
|
| 13 | 0.13 ms |
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 => 16820]
|
| 14 | 0.14 ms |
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 => 16811]
|
| 15 | 0.15 ms |
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 => 16831]
|
| 16 | 0.14 ms |
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 => 9390]
|
| 17 | 0.15 ms |
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 => 16836]
|
| 18 | 0.14 ms |
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 => 11395]
|
| 19 | 0.16 ms |
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 => 16837]
|
| 20 | 0.14 ms |
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 => 16845]
|
| 21 | 0.23 ms |
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 => 16847]
|
| 22 | 0.20 ms |
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 => 16852]
|
| 23 | 0.21 ms |
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 => 16861]
|
| 24 | 0.20 ms |
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 => 16878]
|
| 25 | 0.15 ms |
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 => 16880]
|
| 26 | 0.19 ms |
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 => 16881]
|
| 27 | 0.23 ms |
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 => 16886]
|
| 28 | 0.16 ms |
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 => 16889]
|
| 29 | 0.17 ms |
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 => 12339]
|
| 30 | 0.14 ms |
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 => 7804]
|
| 31 | 0.14 ms |
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 => 13933]
|
| 32 | 0.15 ms |
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 => 16869]
|
| 33 | 0.48 ms |
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 => 16917]
|
| 34 | 0.19 ms |
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 => 16919]
|
| 35 | 0.20 ms |
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 => 16925]
|
| 36 | 0.32 ms |
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 => 16932]
|
| 37 | 0.21 ms |
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 => 16935]
|
| 38 | 0.16 ms |
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 => 9615]
|
| 39 | 0.15 ms |
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 => 16942]
|
| 40 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM footer_header t0
Parameters: []
|
| 41 | 0.43 ms |
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]
|
| 42 | 0.18 ms |
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 => 2]
|
| 43 | 0.12 ms |
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 => 3]
|
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 |
|
| AppBundle\Entity\LookingFor |
|
| AppBundle\Entity\Banner | No errors. |
| AppBundle\Entity\User |
|
| 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 |
|
| AppBundle\Entity\Zodiac | No errors. |
| AppBundle\Entity\LoginFrom | No errors. |
| AppBundle\Entity\Payment | No errors. |
| AppBundle\Entity\Video |
|
| AppBundle\Entity\ShowPhoto |
|
| 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 |
|
| AppBundle\Entity\UserMessengerNotifications |
|
| AppBundle\Entity\LikeMe | No errors. |
| AppBundle\Entity\ArenaDislike | No errors. |
| AppBundle\Entity\Verify |
|
| 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.