Query Metrics
38
Database Queries
11
Different statements
454.91 ms
Query time
9
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
287.66 ms (63.23%) |
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_ LEFT JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_valid = 1) ORDER BY f1_.is_valid DESC, u0_.sign_up_date DESC LIMIT 42
Parameters: []
|
|
89.24 ms (19.62%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, is_valid_43, sign_up_date_32 FROM (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, f1_.is_valid AS is_valid_43, f1_.type AS type_44 FROM user u0_ LEFT JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_valid = 1)) dctrn_result_inner ORDER BY is_valid_43 DESC, sign_up_date_32 DESC) dctrn_result LIMIT 20
Parameters: []
|
|
67.60 ms (14.86%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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_ LEFT JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_valid = 1) ORDER BY f1_.is_valid DESC, u0_.sign_up_date DESC) dctrn_result) dctrn_table
Parameters: []
|
|
3.98 ms (0.87%) |
20 |
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 => 26529]
|
|
1.91 ms (0.42%) |
1 |
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.brief AS brief_6, t0.header_type AS header_type_7, t0.is_active AS is_active_8, t0.is_on_homepage AS is_on_homepage_9, t0.date AS date_10, t0.image_name AS image_name_11, t0.uri AS uri_12, t0.image_alt AS image_alt_13, t0.locale AS locale_14 FROM article t0 WHERE t0.locale = ? AND t0.is_active = ? ORDER BY t0.date DESC
Parameters: [0 => he, 1 => 1]
|
|
1.51 ms (0.33%) |
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_ LEFT JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_valid = 1) WHERE u0_.id IN (?) ORDER BY f1_.is_valid DESC, u0_.sign_up_date DESC
Parameters: [
0 => [
0 => 26529,
1 => 26527,
2 => 26520,
3 => 26514,
4 => 26510,
5 => 26509,
6 => 26508,
7 => 26507,
8 => 26498,
9 => 26497,
10 => 26496,
11 => 26495,
12 => 26494,
13 => 26489,
14 => 26480,
15 => 26479,
16 => 26477,
17 => 26475,
18 => 26473,
19 => 26468
]
]
|
|
1.13 ms (0.25%) |
7 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0 WHERE t0.id = ?
Parameters: [0 => 10]
|
|
0.81 ms (0.18%) |
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.48 ms (0.11%) |
1 |
SELECT t0.id AS id_1, t0.report_email AS report_email_2, t0.contact_from_email AS contact_from_email_3, t0.contact_email AS contact_email_4, t0.send_message_users_number AS send_message_users_number_5, t0.send_message_users_number_without_photo AS send_message_users_number_without_photo_6, t0.users_per_page AS users_per_page_7, t0.is_charge AS is_charge_8, t0.message_popularity_days_number AS message_popularity_days_number_9, t0.user_considered_as_online_after_last_activity_minutes_number AS user_considered_as_online_after_last_activity_minutes_number_10, t0.delete_messages_after_days_number AS delete_messages_after_days_number_11, t0.user_considered_as_new_after_days_number AS user_considered_as_new_after_days_number_12, t0.sms_username AS sms_username_13, t0.sms_password AS sms_password_14, t0.sms_sufix AS sms_sufix_15, t0.offline_push_title AS offline_push_title_16, t0.offline_push_text AS offline_push_text_17, t0.offline_push_every AS offline_push_every_18, t0.offline_push_after AS offline_push_after_19, t0.offline_push_only_interdate AS offline_push_only_interdate_20 FROM settings t0 WHERE t0.id = ?
Parameters: [0 => 1]
|
|
0.44 ms (0.10%) |
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 => magazine]
|
|
0.16 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM footer_header t0
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\Article | No errors. |
| AppBundle\Entity\Seo | No errors. |
| AppBundle\Entity\Settings | No errors. |
| AppBundle\Entity\User |
|
| AppBundle\Entity\File | No errors. |
| AppBundle\Entity\Photo | No errors. |
| AppBundle\Entity\Role | No errors. |
| AppBundle\Entity\Gender |
|
| 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\LookingFor |
|
| 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\FooterHeader | No errors. |
| AppBundle\Entity\Page | No errors. |
messages entity manager
No loaded entities.