Query Metrics
10
Database Queries
6
Different statements
4.82 ms
Query time
8
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.69 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_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = ? LIMIT 1
Parameters:
[
"/profile_ctr/increase-shows/"
]
|
| 2 | 0.80 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_.is_approved AS is_approved_9, p0_.moderation_status AS moderation_status_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.inactivated_at AS inactivated_at_13, p0_.seo AS seo_14, p0_.deleted_at AS deleted_at_15, p0_.person_gender AS person_gender_16, p0_.person_age AS person_age_17, p0_.person_height AS person_height_18, p0_.person_weight AS person_weight_19, p0_.person_breast_size AS person_breast_size_20, p0_.person_breast_type AS person_breast_type_21, p0_.person_cloth_size AS person_cloth_size_22, p0_.person_shoes_size AS person_shoes_size_23, p0_.person_body_type AS person_body_type_24, p0_.person_hair_color AS person_hair_color_25, p0_.person_private_haircut AS person_private_haircut_26, p0_.person_nationality AS person_nationality_27, p0_.person_has_tattoo AS person_has_tattoo_28, p0_.person_has_piercing AS person_has_piercing_29, p0_.messengers_telegram AS messengers_telegram_30, p0_.messengers_whatsapp AS messengers_whatsapp_31, p0_.call_time_from AS call_time_from_32, p0_.call_time_to AS call_time_to_33, p0_.call_answering_to AS call_answering_to_34, p0_.client_min_age AS client_min_age_35, p0_.client_max_age AS client_max_age_36, p0_.apartments_one_hour_price AS apartments_one_hour_price_37, p0_.apartments_two_hours_price AS apartments_two_hours_price_38, p0_.apartments_night_price AS apartments_night_price_39, p0_.take_out_one_hour_price AS take_out_one_hour_price_40, p0_.take_out_two_hours_price AS take_out_two_hours_price_41, p0_.take_out_night_price AS take_out_night_price_42, p0_.take_out_locations AS take_out_locations_43, p0_.express_provided AS express_provided_44, p0_.express_price AS express_price_45, p0_.car_provided AS car_provided_46, p0_.map_latitude AS map_latitude_47, p0_.map_longitude AS map_longitude_48, p0_.user_id AS user_id_49, p0_.city_id AS city_id_50 FROM profiles p0_ WHERE (p0_.id IN (?, ?)) AND (p0_.deleted_at IS NULL) ORDER BY FIELD(p0_.id, ?, ?) ASC
Parameters:
[ "1" "2" "1" "2" ] |
| 3 | 0.50 ms |
SELECT t0.type AS type_1, t0.position_group AS position_group_2, t0.position AS position_3, t0.placed_at AS placed_at_4, t0.placed_until AS placed_until_5, t0.profile_id AS profile_id_6, t0.placement_price_id AS placement_price_id_7 FROM profile_adboard_placements t0 WHERE t0.profile_id = ?
Parameters:
[
1
]
|
| 4 | 0.52 ms |
SELECT t0.id AS id_1, t0.placed_at AS placed_at_2, t0.placed_until AS placed_until_3, t0.profile_id AS profile_id_4, t0.entity_type FROM placement_hidings t0 WHERE t0.profile_id = ? AND t0.entity_type IN ('profile')
Parameters:
[
1
]
|
| 5 | 0.49 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('adm_apr_ph')
Parameters:
[
1
]
|
| 6 | 0.37 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('avatar')
Parameters:
[
1
]
|
| 7 | 0.37 ms |
SELECT t0.type AS type_1, t0.position_group AS position_group_2, t0.position AS position_3, t0.placed_at AS placed_at_4, t0.placed_until AS placed_until_5, t0.profile_id AS profile_id_6, t0.placement_price_id AS placement_price_id_7 FROM profile_adboard_placements t0 WHERE t0.profile_id = ?
Parameters:
[
2
]
|
| 8 | 0.37 ms |
SELECT t0.id AS id_1, t0.placed_at AS placed_at_2, t0.placed_until AS placed_until_3, t0.profile_id AS profile_id_4, t0.entity_type FROM placement_hidings t0 WHERE t0.profile_id = ? AND t0.entity_type IN ('profile')
Parameters:
[
2
]
|
| 9 | 0.36 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('adm_apr_ph')
Parameters:
[
2
]
|
| 10 | 0.35 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('avatar')
Parameters:
[
2
]
|
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 |
|
| App\Entity\SEO\PageMetadata | No errors. |
| App\Entity\Location\MapCoordinate |
|
| App\Entity\Location\City |
|
| App\Entity\Sales\PaidPlacementsOrder | No errors. |
| App\Entity\Profile\PersonParameters | No errors. |
| App\Entity\Messengers |
|
| 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\Profile\Profile |
|
| App\Entity\User | No errors. |
| App\Entity\Account\Advertiser | No errors. |
| App\Entity\Sales\Profile\TopPlacement | No errors. |
| App\Entity\Sales\PlacementHiding | No errors. |
| App\Entity\Sales\Profile\PlacementHiding | No errors. |
| App\Entity\Profile\ProfileService | No errors. |
| App\Entity\Profile\Photo | No errors. |
| App\Entity\Profile\Selfie | No errors. |
| App\Entity\Profile\Video | No errors. |
| App\Entity\Profile\FileProcessingTask | No errors. |
| App\Entity\Profile\AdminApprovalPhoto | No errors. |
| App\Entity\Profile\Confirmation\ConfirmationRequest |
|
| App\Entity\Profile\Confirmation\ModerationRequest |
|
| App\Entity\Profile\Avatar | No errors. |
| App\Entity\Profile\Comment\Comment | No errors. |
| App\Entity\Profile\Comment\CommentByCustomer |
|
| App\Entity\Location\Station | No errors. |
multi_website entity manager
No loaded entities.