https://313-f-29314-show-more-duplicate.review.mechanic.works/moscow/okrug/tsentralnyij/

301 Redirect from
@profile_list.list_by_county (415a0f)
Method
GET
HTTP Status
200
IP
216.73.216.183
Profiled on
Token
ac32bc

Query Metrics

29 Database Queries
18 Different statements
22.91 ms Query time
5 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

#▲ Time Info
1 0.86 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: 
[
  "/moscow/okrug/tsentralnyij/"
]
View formatted query    View runnable query    Explain query
2 0.39 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_.timezone AS timezone_5, c0_.map_latitude AS map_latitude_6, c0_.map_longitude AS map_longitude_7 FROM cities c0_ WHERE c0_.uri_identity = ? LIMIT 1
Parameters: 
[
  "moscow"
]
View formatted query    View runnable query    Explain query
3 0.40 ms 
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c0_.city_id AS city_id_3 FROM city_counties c0_ WHERE c0_.city_id = ? AND c0_.uri_identity = ? LIMIT 1
Parameters: 
[
  1
  "tsentralnyij"
]
View formatted query    View runnable query    Explain query
4 0.52 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 FROM city_counties t0 WHERE t0.city_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5 0.76 ms 
SELECT p0_.id AS id_0, p0_.placed_at AS placed_at_1, p0_.expires_at AS expires_at_2, p1_.id AS id_3, p1_.is_dummy AS is_dummy_4, p1_.uri_identity AS uri_identity_5, p1_.name AS name_6, p1_.description AS description_7, p1_.client_types AS client_types_8, p1_.phone_number AS phone_number_9, p1_.is_masseur AS is_masseur_10, p1_.extra_charge AS extra_charge_11, p1_.is_approved AS is_approved_12, p1_.moderation_status AS moderation_status_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.inactivated_at AS inactivated_at_16, p1_.seo AS seo_17, p1_.deleted_at AS deleted_at_18, p1_.person_gender AS person_gender_19, p1_.person_age AS person_age_20, p1_.person_height AS person_height_21, p1_.person_weight AS person_weight_22, p1_.person_breast_size AS person_breast_size_23, p1_.person_breast_type AS person_breast_type_24, p1_.person_cloth_size AS person_cloth_size_25, p1_.person_shoes_size AS person_shoes_size_26, p1_.person_body_type AS person_body_type_27, p1_.person_hair_color AS person_hair_color_28, p1_.person_private_haircut AS person_private_haircut_29, p1_.person_nationality AS person_nationality_30, p1_.person_has_tattoo AS person_has_tattoo_31, p1_.person_has_piercing AS person_has_piercing_32, p1_.messengers_telegram AS messengers_telegram_33, p1_.messengers_whatsapp AS messengers_whatsapp_34, p1_.call_time_from AS call_time_from_35, p1_.call_time_to AS call_time_to_36, p1_.call_answering_to AS call_answering_to_37, p1_.client_min_age AS client_min_age_38, p1_.client_max_age AS client_max_age_39, p1_.apartments_one_hour_price AS apartments_one_hour_price_40, p1_.apartments_two_hours_price AS apartments_two_hours_price_41, p1_.apartments_night_price AS apartments_night_price_42, p1_.take_out_one_hour_price AS take_out_one_hour_price_43, p1_.take_out_two_hours_price AS take_out_two_hours_price_44, p1_.take_out_night_price AS take_out_night_price_45, p1_.take_out_locations AS take_out_locations_46, p1_.express_provided AS express_provided_47, p1_.express_price AS express_price_48, p1_.car_provided AS car_provided_49, p1_.map_latitude AS map_latitude_50, p1_.map_longitude AS map_longitude_51, p0_.city_id AS city_id_52, p0_.profile_id AS profile_id_53, p0_.placement_price_id AS placement_price_id_54, p1_.user_id AS user_id_55, p1_.city_id AS city_id_56 FROM profile_top_placements p0_ INNER JOIN profiles p1_ ON p0_.profile_id = p1_.id AND (p1_.deleted_at IS NULL) WHERE p1_.city_id = ? AND (p0_.placed_at <= ? AND ? < p0_.expires_at) LIMIT 1
Parameters: 
[
  1
  "2025-12-17 18:19:32"
  "2025-12-17 18:19:32"
]
View formatted query    View runnable query    Explain query
6 0.85 ms 
SELECT p0_.id AS id_0, p0_.placed_at AS placed_at_1, p0_.expires_at AS expires_at_2, p1_.id AS id_3, p1_.is_dummy AS is_dummy_4, p1_.uri_identity AS uri_identity_5, p1_.name AS name_6, p1_.description AS description_7, p1_.client_types AS client_types_8, p1_.phone_number AS phone_number_9, p1_.is_masseur AS is_masseur_10, p1_.extra_charge AS extra_charge_11, p1_.is_approved AS is_approved_12, p1_.moderation_status AS moderation_status_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.inactivated_at AS inactivated_at_16, p1_.seo AS seo_17, p1_.deleted_at AS deleted_at_18, p1_.person_gender AS person_gender_19, p1_.person_age AS person_age_20, p1_.person_height AS person_height_21, p1_.person_weight AS person_weight_22, p1_.person_breast_size AS person_breast_size_23, p1_.person_breast_type AS person_breast_type_24, p1_.person_cloth_size AS person_cloth_size_25, p1_.person_shoes_size AS person_shoes_size_26, p1_.person_body_type AS person_body_type_27, p1_.person_hair_color AS person_hair_color_28, p1_.person_private_haircut AS person_private_haircut_29, p1_.person_nationality AS person_nationality_30, p1_.person_has_tattoo AS person_has_tattoo_31, p1_.person_has_piercing AS person_has_piercing_32, p1_.messengers_telegram AS messengers_telegram_33, p1_.messengers_whatsapp AS messengers_whatsapp_34, p1_.call_time_from AS call_time_from_35, p1_.call_time_to AS call_time_to_36, p1_.call_answering_to AS call_answering_to_37, p1_.client_min_age AS client_min_age_38, p1_.client_max_age AS client_max_age_39, p1_.apartments_one_hour_price AS apartments_one_hour_price_40, p1_.apartments_two_hours_price AS apartments_two_hours_price_41, p1_.apartments_night_price AS apartments_night_price_42, p1_.take_out_one_hour_price AS take_out_one_hour_price_43, p1_.take_out_two_hours_price AS take_out_two_hours_price_44, p1_.take_out_night_price AS take_out_night_price_45, p1_.take_out_locations AS take_out_locations_46, p1_.express_provided AS express_provided_47, p1_.express_price AS express_price_48, p1_.car_provided AS car_provided_49, p1_.map_latitude AS map_latitude_50, p1_.map_longitude AS map_longitude_51, p0_.city_id AS city_id_52, p0_.profile_id AS profile_id_53, p0_.placement_price_id AS placement_price_id_54, p1_.user_id AS user_id_55, p1_.city_id AS city_id_56 FROM profile_top_placements p0_ INNER JOIN profiles p1_ ON p0_.profile_id = p1_.id AND (p1_.deleted_at IS NULL) WHERE p1_.city_id = ? AND (p0_.placed_at <= ? AND ? < p0_.expires_at) LIMIT 1
Parameters: 
[
  1
  "2025-12-17 18:19:32"
  "2025-12-17 18:19:32"
]
View formatted query    View runnable query    Explain query
7 0.66 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.county_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
8 0.93 ms 
SELECT COUNT(p0_.id) AS sclr_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (?, ?, ?) AND p0_.person_gender IN (?) AND (p0_.city_id = ? AND (p0_.city_id = ? AND EXISTS (SELECT 1 FROM profile_stations p2_ WHERE p2_.profile_id = p0_.id AND p2_.station_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))))) AND (p0_.deleted_at IS NULL)
Parameters: 
[
  0
  2
  1
  1
  1
  1
  4
  9
  13
  14
  15
  16
  19
  22
  39
  41
  44
  46
  56
  59
  63
  64
  65
  66
  67
  69
  72
  78
  80
  83
  85
  86
  95
  96
  100
  104
  105
  106
  115
  116
  118
  121
  123
  125
  129
  130
  138
  140
  144
  145
  148
  150
  151
  152
  157
  159
  161
  163
  172
  176
  180
  181
  182
  184
  224
]
View formatted query    View runnable query    Explain query
9 0.59 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.county_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
10 0.49 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.county_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
11 0.48 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.county_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
12 0.51 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.county_id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
13 0.50 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.county_id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
14 0.48 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.county_id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
15 0.60 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.county_id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
16 0.49 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.county_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
17 0.44 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.county_id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
18 0.35 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.county_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
19 1.19 ms 
SELECT p0_.id AS id_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (?, ?, ?) AND p0_.person_gender IN (?) AND (p0_.city_id = ? AND p0_.is_masseur = ? AND (p0_.city_id = ? AND EXISTS (SELECT 1 FROM profile_stations p2_ WHERE p2_.profile_id = p0_.id AND p2_.station_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))))) AND (p0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 10
Parameters: 
[
  0
  2
  1
  1
  1
  0
  1
  4
  9
  13
  14
  15
  16
  19
  22
  39
  41
  44
  46
  56
  59
  63
  64
  65
  66
  67
  69
  72
  78
  80
  83
  85
  86
  95
  96
  100
  104
  105
  106
  115
  116
  118
  121
  123
  125
  129
  130
  138
  140
  144
  145
  148
  150
  151
  152
  157
  159
  161
  163
  172
  176
  180
  181
  182
  184
  224
  10
  33
  34
  42
  99
  111
  117
  128
  141
  156
  173
  174
  177
  193
  208
  216
  217
  220
  230
  232
  235
  238
  5
  7
  11
  18
  23
  29
  31
  32
  43
  81
  84
  103
  133
  135
  171
  194
  198
  199
  205
  212
  229
  1
  24
  35
  36
  40
  47
  48
  57
  61
  70
  75
  79
  82
  112
  132
  153
  195
  202
  204
  206
  209
  211
  213
  221
  225
  2
  6
  8
  21
  30
  45
  49
  52
  54
  58
  62
  74
  90
  91
  102
  119
  155
  160
  164
  175
  179
  183
  185
  191
  226
  227
  231
  27
  50
  93
  94
  108
  109
  110
  120
  137
  142
  178
  186
  187
  189
  197
  214
  218
  219
  222
  223
  228
  12
  38
  55
  68
  71
  73
  77
  88
  107
  113
  122
  127
  134
  139
  147
  158
  168
  169
  170
  190
  196
  200
  203
  207
  210
  233
  234
  243
  245
  3
  17
  20
  25
  26
  28
  51
  53
  60
  76
  92
  97
  98
  124
  136
  154
  165
  166
  167
  192
  215
  244
  248
  250
  37
  87
  89
  101
  114
  126
  143
  146
  149
  162
  188
  236
  237
  246
  247
  249
  131
  201
  239
  240
  241
  242
]
View formatted query    View runnable query    Explain query
20 0.84 ms 
SELECT p0_.id AS id_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (?, ?, ?) AND p0_.person_gender IN (?) AND (p0_.city_id = ? AND p0_.is_masseur = ?)) AND (p0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 10
Parameters: 
[
  0
  2
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
21 2.79 ms 
SELECT 
                p.*, JSON_UNQUOTE(JSON_EXTRACT(p.name, '$.ru')) 
                    AS `name`, 
                JSON_UNQUOTE(JSON_EXTRACT(p.description, '$.ru')) 
                    AS `description`,
                (SELECT path FROM profile_media_files pmf_avatar WHERE p.id = pmf_avatar.profile_id AND pmf_avatar.type = 'avatar' AND pmf_avatar.is_main = 0 LIMIT 1) 
                    AS `avatar_path`,
                (SELECT TYPE FROM profile_adboard_placements pap WHERE p.id = pap.profile_id LIMIT 1) 
                    AS `adboard_placement_type`,
                (SELECT position FROM profile_adboard_placements pap WHERE p.id = pap.profile_id LIMIT 1) 
                    AS `adboard_placement_position`,
                c.id 
                    AS `city_id`, 
                JSON_UNQUOTE(JSON_EXTRACT(c.name, '$.ru')) 
                    AS `city_name`, 
                c.uri_identity 
                    AS `city_uri_identity`,
                c.country_code 
                    AS `city_country_code`,
                EXISTS(SELECT * FROM profile_top_placements ptp WHERE p.id = ptp.profile_id AND (NOW() BETWEEN ptp.placed_at AND ptp.expires_at))
                    AS `has_top_placement`,
                EXISTS(SELECT * FROM placement_hidings ph WHERE p.id = ph.profile_id AND ph.entity_type = 'profile') 
                    AS `has_placement_hiding`,
                EXISTS(SELECT * FROM profile_comments pc WHERE p.id = pc.profile_id AND pc.deleted_at IS NULL) 
                    AS `has_comments`,
                EXISTS(SELECT * FROM profile_media_files pmf_video WHERE p.id = pmf_video.profile_id AND pmf_video.type = 'video') 
                    AS `has_videos`,
                EXISTS(SELECT * FROM profile_media_files pmf_selfie WHERE p.id = pmf_selfie.profile_id AND pmf_selfie.type = 'selfie') 
                    AS `has_selfies`
            FROM profiles `p`
            JOIN cities `c` ON c.id = p.city_id 
            WHERE p.id IN (35,39,30,13,5,24,45,17,44,46)
            ORDER BY FIELD(p.id,35,39,30,13,5,24,45,17,44,46)
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 1.52 ms 
SELECT 
                    cs.id 
                        AS `id`,
                    JSON_UNQUOTE(JSON_EXTRACT(cs.name, '$.ru')) 
                        AS `name`, 
                    cs.uri_identity 
                        AS `uriIdentity`, 
                    ps.profile_id
                        AS `profile_id`,
                    csl.name
                        AS `line_name`,
                    csl.color
                        AS `line_color`
                FROM profile_stations ps
                JOIN city_stations cs ON ps.station_id = cs.id 
                LEFT JOIN city_subway_station_lines cssl ON cssl.station_id = cs.id
                LEFT JOIN city_subway_lines csl ON csl.id = cssl.line_id
                WHERE ps.profile_id IN (35,39,30,13,5,24,45,17,44,46)
Parameters: 
[]
View formatted query    View runnable query    Explain query
23 0.55 ms 
SELECT 
                    s.id 
                        AS `id`,
                    JSON_UNQUOTE(JSON_EXTRACT(s.name, '$.ru')) 
                        AS `name`, 
                    s.group 
                        AS `group`, 
                    s.uri_identity 
                        AS `uriIdentity`,
                    pps.profile_id
                        AS `profile_id`,
                    pps.service_condition
                        AS `condition`,
                    pps.extra_charge
                        AS `extra_charge`,
                    pps.comment
                        AS `comment`
                FROM profile_provided_services pps
                JOIN services s ON pps.service_id = s.id 
                WHERE pps.profile_id IN (35,39,30,13,5,24,45,17,44,46)
Parameters: 
[]
View formatted query    View runnable query    Explain query
24 1.52 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.city_id = ? ORDER BY t0.name ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
25 0.87 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 FROM city_districts t0 WHERE t0.city_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
26 1.48 ms 
SELECT s0_.id AS id_0, s0_.`group` AS group_1, s0_.name AS name_2, s0_.uri_identity AS uri_identity_3 FROM services s0_ ORDER BY s0_.`group` ASC, s0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
27 0.81 ms 
SELECT p0_.city_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.person_gender IN (?) AND p0_.moderation_status IN (?, ?, ?)) AND (p0_.deleted_at IS NULL) GROUP BY p0_.city_id
Parameters: 
[
  1
  0
  2
  1
]
View formatted query    View runnable query    Explain query
28 0.42 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.country_code AS country_code_4, t0.city_group AS city_group_5, t0.timezone AS timezone_6, t0.map_latitude AS map_latitude_7, t0.map_longitude AS map_longitude_8 FROM cities t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
29 0.62 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
Parameters: 
[]
View formatted query    View runnable query    Explain query

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
  • The field 'App\Entity\Sales\PaidPlacementPrice#priceAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\SEO\PageMetadata No errors.
App\Entity\Location\MapCoordinate
  • The field 'App\Entity\Location\MapCoordinate#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Location\MapCoordinate#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Location\City
  • The field 'App\Entity\Location\City#mapCoordinate.latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Location\City#mapCoordinate.longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
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\Profile\TopPlacement No errors.
App\Entity\Profile\PersonParameters No errors.
App\Entity\Messengers
  • The field 'App\Entity\Messengers#whatsApp' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
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
  • The field 'App\Entity\Profile\Profile#messengers.whatsApp' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Entity\Profile\Profile#mapCoordinate.latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Profile\Profile#mapCoordinate.longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\Entity\Profile\Profile#placementHiding is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sales\Profile\PlacementHiding#profile does not contain the required 'inversedBy="placementHiding"' attribute.
  • The field App\Entity\Profile\Profile#providedServices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\ProfileService#profile does not contain the required 'inversedBy="providedServices"' attribute.
  • The mappings App\Entity\Profile\Profile#selfies and App\Entity\Profile\Selfie#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#videos and App\Entity\Profile\Video#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#adminApprovalPhoto and App\Entity\Profile\AdminApprovalPhoto#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#avatar and App\Entity\Profile\Avatar#profile are inconsistent with each other.
App\Entity\User No errors.
App\Entity\Account\Advertiser No errors.
App\Entity\Location\Subway\Line No errors.
App\Entity\Service No errors.

multi_website entity manager

No loaded entities.