Query Metrics
6
Database Queries
6
Different statements
4.03 ms
Query time
9
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.70 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.nick_name AS nick_name_3, t0.notes AS notes_4, t0.country_code AS country_code_5, t0.roles AS roles_6, t0.password AS password_7, t0.confirmation_code AS confirmation_code_8, t0.smsc_code AS smsc_code_9, t0.enabled AS enabled_10, t0.trusted AS trusted_11, t0.credits AS credits_12, t0.currency_code AS currency_code_13, t0.full_registered AS full_registered_14, t0.post_registration_step AS post_registration_step_15, t0.created AS created_16, t0.updated AS updated_17, t0.balance_low_notified_at AS balance_low_notified_at_18, t0.ban AS ban_19, t0.city_id AS city_id_20, t22.id AS id_21, t22.path AS path_23, t22.user_id AS user_id_24, t25.account_id AS account_id_26, t0.type FROM user t0 LEFT JOIN user_media_files t22 ON t22.user_id = t0.id LEFT JOIN account_offer_bar_hidden t25 ON t25.account_id = t0.id WHERE t0.id = ? AND t0.type IN ('advertiser', 'customer')
Parameters:
[
1
]
|
| 2 | 0.56 ms |
SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.last_modified AS last_modified_8, p0_.city_id AS city_id_9 FROM page_seo_texts p0_ WHERE p0_.uri = ? LIMIT 1
Parameters:
[
"/moscow/recommendations/profile/cnt5/img357x500/exclude1,4,2,3/gender1"
]
|
| 3 | 0.57 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c0_.country_code AS country_code_3, c0_.city_group AS city_group_4, c0_.city_price_category AS city_price_category_5, c0_.timezone AS timezone_6, c0_.region AS region_7, c0_.map_latitude AS map_latitude_8, c0_.map_longitude AS map_longitude_9 FROM cities c0_ WHERE c0_.uri_identity = ? LIMIT 1
Parameters:
[
"moscow"
]
|
| 4 | 0.79 ms |
SELECT p0_.id AS id_0, p0_.is_dummy AS is_dummy_1, p0_.uri_identity AS uri_identity_2, p0_.name AS name_3, p0_.description AS description_4, p0_.client_types AS client_types_5, p0_.phone_number AS phone_number_6, p0_.is_masseur AS is_masseur_7, p0_.extra_charge AS extra_charge_8, p0_.prepayment AS prepayment_9, p0_.prepayment_amount AS prepayment_amount_10, p0_.prepayment_comment AS prepayment_comment_11, p0_.is_approved AS is_approved_12, p0_.moderation_status AS moderation_status_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.inactivated_at AS inactivated_at_16, p0_.seo AS seo_17, p0_.delete_mode AS delete_mode_18, p0_.deleted_at AS deleted_at_19, p0_.person_gender AS person_gender_20, p0_.person_age AS person_age_21, p0_.person_height AS person_height_22, p0_.person_weight AS person_weight_23, p0_.person_breast_size AS person_breast_size_24, p0_.person_breast_type AS person_breast_type_25, p0_.person_cloth_size AS person_cloth_size_26, p0_.person_shoes_size AS person_shoes_size_27, p0_.person_body_type AS person_body_type_28, p0_.person_hair_color AS person_hair_color_29, p0_.person_private_haircut AS person_private_haircut_30, p0_.person_nationality AS person_nationality_31, p0_.person_appearance AS person_appearance_32, p0_.person_has_tattoo AS person_has_tattoo_33, p0_.person_has_piercing AS person_has_piercing_34, p0_.messengers_telegram AS messengers_telegram_35, p0_.messengers_whatsapp AS messengers_whatsapp_36, p0_.messengers_telegram_username AS messengers_telegram_username_37, p0_.call_time_from AS call_time_from_38, p0_.call_time_to AS call_time_to_39, p0_.call_answering_to AS call_answering_to_40, p0_.client_min_age AS client_min_age_41, p0_.client_max_age AS client_max_age_42, p0_.apartments_one_hour_price AS apartments_one_hour_price_43, p0_.apartments_two_hours_price AS apartments_two_hours_price_44, p0_.apartments_night_price AS apartments_night_price_45, p0_.take_out_one_hour_price AS take_out_one_hour_price_46, p0_.take_out_two_hours_price AS take_out_two_hours_price_47, p0_.take_out_night_price AS take_out_night_price_48, p0_.take_out_locations AS take_out_locations_49, p0_.express_provided AS express_provided_50, p0_.express_price AS express_price_51, p0_.car_provided AS car_provided_52, p0_.map_latitude AS map_latitude_53, p0_.map_longitude AS map_longitude_54, p0_.user_id AS user_id_55, p0_.city_id AS city_id_56, p0_.primary_station_id AS primary_station_id_57, p0_.saloon_id AS saloon_id_58 FROM profiles p0_ WHERE (p0_.id IN (NULL)) AND (p0_.deleted_at IS NULL) ORDER BY FIELD(p0_.id, NULL) ASC
Parameters:
[] |
| 5 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4, t0.county_id AS county_id_5, t0.district_id AS district_id_6 FROM city_stations t0 WHERE t0.id IN (NULL)
Parameters:
[] |
| 6 | 0.99 ms |
SELECT t0.id AS id_1, t0.is_dummy AS is_dummy_2, t0.uri_identity AS uri_identity_3, t0.name AS name_4, t0.description AS description_5, t0.client_types AS client_types_6, t0.phone_number AS phone_number_7, t0.is_masseur AS is_masseur_8, t0.extra_charge AS extra_charge_9, t0.prepayment AS prepayment_10, t0.prepayment_amount AS prepayment_amount_11, t0.prepayment_comment AS prepayment_comment_12, t0.is_approved AS is_approved_13, t0.moderation_status AS moderation_status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.inactivated_at AS inactivated_at_17, t0.seo AS seo_18, t0.delete_mode AS delete_mode_19, t0.deleted_at AS deleted_at_20, t0.person_gender AS person_gender_21, t0.person_age AS person_age_22, t0.person_height AS person_height_23, t0.person_weight AS person_weight_24, t0.person_breast_size AS person_breast_size_25, t0.person_breast_type AS person_breast_type_26, t0.person_cloth_size AS person_cloth_size_27, t0.person_shoes_size AS person_shoes_size_28, t0.person_body_type AS person_body_type_29, t0.person_hair_color AS person_hair_color_30, t0.person_private_haircut AS person_private_haircut_31, t0.person_nationality AS person_nationality_32, t0.person_appearance AS person_appearance_33, t0.person_has_tattoo AS person_has_tattoo_34, t0.person_has_piercing AS person_has_piercing_35, t0.messengers_telegram AS messengers_telegram_36, t0.messengers_whatsapp AS messengers_whatsapp_37, t0.messengers_telegram_username AS messengers_telegram_username_38, t0.call_time_from AS call_time_from_39, t0.call_time_to AS call_time_to_40, t0.call_answering_to AS call_answering_to_41, t0.client_min_age AS client_min_age_42, t0.client_max_age AS client_max_age_43, t0.apartments_one_hour_price AS apartments_one_hour_price_44, t0.apartments_two_hours_price AS apartments_two_hours_price_45, t0.apartments_night_price AS apartments_night_price_46, t0.take_out_one_hour_price AS take_out_one_hour_price_47, t0.take_out_two_hours_price AS take_out_two_hours_price_48, t0.take_out_night_price AS take_out_night_price_49, t0.take_out_locations AS take_out_locations_50, t0.express_provided AS express_provided_51, t0.express_price AS express_price_52, t0.car_provided AS car_provided_53, t0.map_latitude AS map_latitude_54, t0.map_longitude AS map_longitude_55, t0.user_id AS user_id_56, t57.type AS type_58, t57.position_group AS position_group_59, t57.position AS position_60, t57.placed_at AS placed_at_61, t57.placed_until AS placed_until_62, t57.plan_managed AS plan_managed_63, t57.profile_id AS profile_id_64, t57.placement_price_id AS placement_price_id_65, t0.city_id AS city_id_66, t0.primary_station_id AS primary_station_id_67, t0.saloon_id AS saloon_id_68 FROM profiles t0 LEFT JOIN profile_adboard_placements t57 ON t57.profile_id = t0.id WHERE t0.id IN (NULL) AND ((t0.deleted_at IS NULL))
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| multi_website | doctrine.dbal.multi_website_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| multi_website | doctrine.orm.multi_website_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Sales\Profile\AdBoardPlacement | No errors. |
| App\Entity\Sales\PaidPlacementPrice | No errors. |
| App\Entity\Profile\PersonParameters | No errors. |
| App\Entity\Messengers | No errors. |
| App\Entity\PhoneCallRestrictions | No errors. |
| App\Entity\Profile\ClientRestrictions | No errors. |
| App\Entity\ApartmentsPricing | No errors. |
| App\Entity\TakeOutPricing | No errors. |
| App\Entity\ExpressPricing | No errors. |
| App\Entity\Profile\CarPricing | No errors. |
| App\Entity\Location\MapCoordinate |
|
| App\Entity\Profile\Profile |
|
| App\Entity\User | No errors. |
| App\Entity\Location\City |
|
| App\Entity\Account\Avatar | No errors. |
| App\Entity\OfferBarHidden | No errors. |
| App\Entity\Account\Advertiser | No errors. |
| App\Entity\Account\Customer |
|
| App\Entity\Sales\AccountEnrollment |
|
| App\Entity\Sales\AccountCharge |
|
| App\Entity\Sales\AccountTransaction |
|
| App\Entity\Account\PhoneReviewAdded |
|
| App\Entity\Saloon\WorkingHours | No errors. |
| App\Entity\Saloon\Saloon |
|
| App\Entity\SEO\PageMetadata | No errors. |
| App\Entity\Location\County | No errors. |
| App\Entity\Location\District | No errors. |
| App\Entity\Location\Station | No errors. |
| App\Entity\Sales\PaidPlacementsOrder | No errors. |
| App\Entity\Sales\PlacementHiding | No errors. |
| App\Entity\Sales\Profile\PlacementHiding | No errors. |
| App\Entity\Profile\Photo | No errors. |
| App\Entity\Profile\AdminApprovalPhoto | No errors. |
| App\Entity\Profile\Avatar | No errors. |
multi_website entity manager
No loaded entities.