GET https://back.mr-ling.com/api/portfolios/cities?city.isEnabled=true&itemsPerPage=20&order%5Bordering%5D=asc&order%5Bid%5D=asc&page=1&status%5B0%5D=enabled&status…

Response
200 OK
IP
172.20.0.1
Profiled on
Token
14f6d1

Query Metrics

118 Database Queries
13 Different statements
74.75 ms Query time
0 Invalid entities
2736 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
11.07 ms
(14.81%) 		20 
SELECT t0.id AS id_1, t0.path AS path_2 FROM file t0 INNER JOIN portfolio_file ON t0.id = portfolio_file.file_id WHERE portfolio_file.portfolio_id = ?
Parameters: 
[
  431
]
View formatted query    View runnable query    Explain query    View query backtrace
10.44 ms
(13.97%) 		20 
SELECT t0.id AS id_1, t0.name AS name_2 FROM extra_service t0 INNER JOIN portfolio_extra_service ON t0.id = portfolio_extra_service.extra_service_id WHERE portfolio_extra_service.portfolio_id = ?
Parameters: 
[
  431
]
View formatted query    View runnable query    Explain query    View query backtrace
10.13 ms
(13.55%) 		20 
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.type AS type_3, t0.portfolio_id AS portfolio_id_4 FROM portfolio_view t0 WHERE t0.portfolio_id = ?
Parameters: 
[
  431
]
View formatted query    View runnable query    Explain query    View query backtrace
8.78 ms
(11.75%) 		1 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.phone AS phone_2, p0_.whatsapp AS whatsapp_3, p0_.telegram AS telegram_4, p0_.address AS address_5, p0_.about AS about_6, p0_.age AS age_7, p0_.weight AS weight_8, p0_.height AS height_9, p0_.leg_size AS leg_size_10, p0_.bust_size AS bust_size_11, p0_.shape AS shape_12, p0_.hair_color AS hair_color_13, p0_.is_meeting_at_my_place AS is_meeting_at_my_place_14, p0_.is_visit_to_client_available AS is_visit_to_client_available_15, p0_.visit_to_client_price AS visit_to_client_price_16, p0_.is_client_paid_taxi AS is_client_paid_taxi_17, p0_.standart_program_price AS standart_program_price_18, p0_.status AS status_19, p0_.programs AS programs_20, p0_.decline_reason AS decline_reason_21, p0_.is_photo_with_face AS is_photo_with_face_22, p0_.reject_reason AS reject_reason_23, p0_.additional_programs AS additional_programs_24, p0_.address_coordinates AS address_coordinates_25, p0_.schedule AS schedule_26, p0_.meta_title AS meta_title_27, p0_.h1 AS h1_28, p0_.meta_description AS meta_description_29, p0_.is_indexed AS is_indexed_30, p0_.created_at AS created_at_31, p0_.active_periods AS active_periods_32, p0_.ordering AS ordering_33, p0_.is_paid AS is_paid_34, p0_.is_remoderation_required AS is_remoderation_required_35, CASE WHEN p0_.id IN (545, 1082, 555, 549, 552, 550, 548, 556, 553, 554, 1068, 1041, 1065, 1060, 1079, 1047, 1064, 1061, 1063, 1072, 1053, 1080, 1058, 1074, 1078, 1066, 1067, 1069, 1070, 1052, 1073, 1057, 1059, 1076, 1081, 1051, 1049, 1050, 1055, 1056, 1048, 1054, 1062, 1071, 1077, 1075, 1182, 1214, 1155, 1212, 1213, 1215, 1157, 1156, 1161, 1159, 1158, 1234, 1227, 1220, 1219, 1226, 1232, 1239, 1233, 1221, 1240, 1235, 1236, 1218, 1229, 1224, 1225, 1237, 1222, 1223, 1228, 1230, 1238, 1231, 1246, 1254, 1247, 1250, 1257, 1260, 1262, 1251, 1242, 1255, 1243, 1258, 1259, 1256, 1244, 1249, 1241, 1253, 1280, 1300, 1274, 1289, 1306, 1293, 1303, 1272, 1269, 1286, 1284, 1299, 1291, 1281, 1295, 1285, 1301, 1294, 1305, 1296, 1288, 1290, 1307, 1271, 1304, 1273, 1270, 1298, 1279, 1302, 1297, 1292, 1283, 1275, 1282, 1287, 1311, 1314, 1310, 1318, 1309, 1312, 1317, 1316, 1315, 1308, 1313, 1153, 565, 923, 446, 599, 539, 443, 571, 736, 540, 521, 672, 445, 588, 592, 981, 710, 842, 1148, 1119, 562, 433, 1116, 430, 632, 621, 1141, 834, 936, 988, 734, 684, 695, 498, 809, 970, 66, 569, 951, 952, 967, 600, 723, 659, 441, 663, 563, 935, 679, 505, 669, 587, 607, 533, 636, 1137, 729, 461, 987, 737, 725, 616, 1142, 517, 641, 942, 434, 513, 668, 1146, 634, 689, 738, 707, 603, 718, 693, 593, 615, 1118, 678, 638, 576, 449, 727, 578, 528, 601, 968, 510, 683, 882, 833, 757, 1140, 509, 731, 651, 627, 504, 639, 702, 705, 456, 949, 726, 541, 831, 664, 819, 826, 646, 886, 431, 583, 598, 666, 635, 591, 637, 1139, 986, 657, 758, 543, 963, 594, 530, 969, 619, 934, 907, 1117, 459, 812, 542, 613, 820, 568, 429, 828, 885, 579, 704, 606, 442, 830, 835, 595, 1113, 841, 690, 913, 742, 618, 976, 979, 926, 694, 983, 909, 910, 912, 1125, 916, 918, 925, 965, 937, 962, 971, 972, 1166, 1126, 1122, 825, 827, 829, 832, 837, 863, 868, 879, 884, 520, 444, 625, 582, 620, 612, 515, 881, 845, 883, 839, 887, 890, 896, 901, 898, 428, 585, 870, 859, 605, 823, 815, 821) THEN 0 ELSE 1 END AS sclr_36, CASE WHEN p0_.id IN (545, 1082, 555, 549, 552, 550, 548, 556, 553, 554, 1068, 1041, 1065, 1060, 1079, 1047, 1064, 1061, 1063, 1072, 1053, 1080, 1058, 1074, 1078, 1066, 1067, 1069, 1070, 1052, 1073, 1057, 1059, 1076, 1081, 1051, 1049, 1050, 1055, 1056, 1048, 1054, 1062, 1071, 1077, 1075, 1182, 1214, 1155, 1212, 1213, 1215, 1157, 1156, 1161, 1159, 1158, 1234, 1227, 1220, 1219, 1226, 1232, 1239, 1233, 1221, 1240, 1235, 1236, 1218, 1229, 1224, 1225, 1237, 1222, 1223, 1228, 1230, 1238, 1231, 1246, 1254, 1247, 1250, 1257, 1260, 1262, 1251, 1242, 1255, 1243, 1258, 1259, 1256, 1244, 1249, 1241, 1253, 1280, 1300, 1274, 1289, 1306, 1293, 1303, 1272, 1269, 1286, 1284, 1299, 1291, 1281, 1295, 1285, 1301, 1294, 1305, 1296, 1288, 1290, 1307, 1271, 1304, 1273, 1270, 1298, 1279, 1302, 1297, 1292, 1283, 1275, 1282, 1287, 1311, 1314, 1310, 1318, 1309, 1312, 1317, 1316, 1315, 1308, 1313, 1153, 565, 923, 446, 599, 539, 443, 571, 736, 540, 521, 672, 445, 588, 592, 981, 710, 842, 1148, 1119, 562, 433, 1116, 430, 632, 621, 1141, 834, 936, 988, 734, 684, 695, 498, 809, 970, 66, 569, 951, 952, 967, 600, 723, 659, 441, 663, 563, 935, 679, 505, 669, 587, 607, 533, 636, 1137, 729, 461, 987, 737, 725, 616, 1142, 517, 641, 942, 434, 513, 668, 1146, 634, 689, 738, 707, 603, 718, 693, 593, 615, 1118, 678, 638, 576, 449, 727, 578, 528, 601, 968, 510, 683, 882, 833, 757, 1140, 509, 731, 651, 627, 504, 639, 702, 705, 456, 949, 726, 541, 831, 664, 819, 826, 646, 886, 431, 583, 598, 666, 635, 591, 637, 1139, 986, 657, 758, 543, 963, 594, 530, 969, 619, 934, 907, 1117, 459, 812, 542, 613, 820, 568, 429, 828, 885, 579, 704, 606, 442, 830, 835, 595, 1113, 841, 690, 913, 742, 618, 976, 979, 926, 694, 983, 909, 910, 912, 1125, 916, 918, 925, 965, 937, 962, 971, 972, 1166, 1126, 1122, 825, 827, 829, 832, 837, 863, 868, 879, 884, 520, 444, 625, 582, 620, 612, 515, 881, 845, 883, 839, 887, 890, 896, 901, 898, 428, 585, 870, 859, 605, 823, 815, 821) THEN 0 ELSE 1 END AS sclr_37, CASE WHEN p0_.id IN (545, 1082, 555, 549, 552, 550, 548, 556, 553, 554, 1068, 1041, 1065, 1060, 1079, 1047, 1064, 1061, 1063, 1072, 1053, 1080, 1058, 1074, 1078, 1066, 1067, 1069, 1070, 1052, 1073, 1057, 1059, 1076, 1081, 1051, 1049, 1050, 1055, 1056, 1048, 1054, 1062, 1071, 1077, 1075, 1182, 1214, 1155, 1212, 1213, 1215, 1157, 1156, 1161, 1159, 1158, 1234, 1227, 1220, 1219, 1226, 1232, 1239, 1233, 1221, 1240, 1235, 1236, 1218, 1229, 1224, 1225, 1237, 1222, 1223, 1228, 1230, 1238, 1231, 1246, 1254, 1247, 1250, 1257, 1260, 1262, 1251, 1242, 1255, 1243, 1258, 1259, 1256, 1244, 1249, 1241, 1253, 1280, 1300, 1274, 1289, 1306, 1293, 1303, 1272, 1269, 1286, 1284, 1299, 1291, 1281, 1295, 1285, 1301, 1294, 1305, 1296, 1288, 1290, 1307, 1271, 1304, 1273, 1270, 1298, 1279, 1302, 1297, 1292, 1283, 1275, 1282, 1287, 1311, 1314, 1310, 1318, 1309, 1312, 1317, 1316, 1315, 1308, 1313, 1153, 565, 923, 446, 599, 539, 443, 571, 736, 540, 521, 672, 445, 588, 592, 981, 710, 842, 1148, 1119, 562, 433, 1116, 430, 632, 621, 1141, 834, 936, 988, 734, 684, 695, 498, 809, 970, 66, 569, 951, 952, 967, 600, 723, 659, 441, 663, 563, 935, 679, 505, 669, 587, 607, 533, 636, 1137, 729, 461, 987, 737, 725, 616, 1142, 517, 641, 942, 434, 513, 668, 1146, 634, 689, 738, 707, 603, 718, 693, 593, 615, 1118, 678, 638, 576, 449, 727, 578, 528, 601, 968, 510, 683, 882, 833, 757, 1140, 509, 731, 651, 627, 504, 639, 702, 705, 456, 949, 726, 541, 831, 664, 819, 826, 646, 886, 431, 583, 598, 666, 635, 591, 637, 1139, 986, 657, 758, 543, 963, 594, 530, 969, 619, 934, 907, 1117, 459, 812, 542, 613, 820, 568, 429, 828, 885, 579, 704, 606, 442, 830, 835, 595, 1113, 841, 690, 913, 742, 618, 976, 979, 926, 694, 983, 909, 910, 912, 1125, 916, 918, 925, 965, 937, 962, 971, 972, 1166, 1126, 1122, 825, 827, 829, 832, 837, 863, 868, 879, 884, 520, 444, 625, 582, 620, 612, 515, 881, 845, 883, 839, 887, 890, 896, 901, 898, 428, 585, 870, 859, 605, 823, 815, 821) THEN 0 ELSE 1 END AS sclr_38, CASE WHEN p0_.id IN (545, 1082, 555, 549, 552, 550, 548, 556, 553, 554, 1068, 1041, 1065, 1060, 1079, 1047, 1064, 1061, 1063, 1072, 1053, 1080, 1058, 1074, 1078, 1066, 1067, 1069, 1070, 1052, 1073, 1057, 1059, 1076, 1081, 1051, 1049, 1050, 1055, 1056, 1048, 1054, 1062, 1071, 1077, 1075, 1182, 1214, 1155, 1212, 1213, 1215, 1157, 1156, 1161, 1159, 1158, 1234, 1227, 1220, 1219, 1226, 1232, 1239, 1233, 1221, 1240, 1235, 1236, 1218, 1229, 1224, 1225, 1237, 1222, 1223, 1228, 1230, 1238, 1231, 1246, 1254, 1247, 1250, 1257, 1260, 1262, 1251, 1242, 1255, 1243, 1258, 1259, 1256, 1244, 1249, 1241, 1253, 1280, 1300, 1274, 1289, 1306, 1293, 1303, 1272, 1269, 1286, 1284, 1299, 1291, 1281, 1295, 1285, 1301, 1294, 1305, 1296, 1288, 1290, 1307, 1271, 1304, 1273, 1270, 1298, 1279, 1302, 1297, 1292, 1283, 1275, 1282, 1287, 1311, 1314, 1310, 1318, 1309, 1312, 1317, 1316, 1315, 1308, 1313, 1153, 565, 923, 446, 599, 539, 443, 571, 736, 540, 521, 672, 445, 588, 592, 981, 710, 842, 1148, 1119, 562, 433, 1116, 430, 632, 621, 1141, 834, 936, 988, 734, 684, 695, 498, 809, 970, 66, 569, 951, 952, 967, 600, 723, 659, 441, 663, 563, 935, 679, 505, 669, 587, 607, 533, 636, 1137, 729, 461, 987, 737, 725, 616, 1142, 517, 641, 942, 434, 513, 668, 1146, 634, 689, 738, 707, 603, 718, 693, 593, 615, 1118, 678, 638, 576, 449, 727, 578, 528, 601, 968, 510, 683, 882, 833, 757, 1140, 509, 731, 651, 627, 504, 639, 702, 705, 456, 949, 726, 541, 831, 664, 819, 826, 646, 886, 431, 583, 598, 666, 635, 591, 637, 1139, 986, 657, 758, 543, 963, 594, 530, 969, 619, 934, 907, 1117, 459, 812, 542, 613, 820, 568, 429, 828, 885, 579, 704, 606, 442, 830, 835, 595, 1113, 841, 690, 913, 742, 618, 976, 979, 926, 694, 983, 909, 910, 912, 1125, 916, 918, 925, 965, 937, 962, 971, 972, 1166, 1126, 1122, 825, 827, 829, 832, 837, 863, 868, 879, 884, 520, 444, 625, 582, 620, 612, 515, 881, 845, 883, 839, 887, 890, 896, 901, 898, 428, 585, 870, 859, 605, 823, 815, 821) THEN 0 ELSE 1 END AS sclr_39, CASE WHEN p0_.id IN (545, 1082, 555, 549, 552, 550, 548, 556, 553, 554, 1068, 1041, 1065, 1060, 1079, 1047, 1064, 1061, 1063, 1072, 1053, 1080, 1058, 1074, 1078, 1066, 1067, 1069, 1070, 1052, 1073, 1057, 1059, 1076, 1081, 1051, 1049, 1050, 1055, 1056, 1048, 1054, 1062, 1071, 1077, 1075, 1182, 1214, 1155, 1212, 1213, 1215, 1157, 1156, 1161, 1159, 1158, 1234, 1227, 1220, 1219, 1226, 1232, 1239, 1233, 1221, 1240, 1235, 1236, 1218, 1229, 1224, 1225, 1237, 1222, 1223, 1228, 1230, 1238, 1231, 1246, 1254, 1247, 1250, 1257, 1260, 1262, 1251, 1242, 1255, 1243, 1258, 1259, 1256, 1244, 1249, 1241, 1253, 1280, 1300, 1274, 1289, 1306, 1293, 1303, 1272, 1269, 1286, 1284, 1299, 1291, 1281, 1295, 1285, 1301, 1294, 1305, 1296, 1288, 1290, 1307, 1271, 1304, 1273, 1270, 1298, 1279, 1302, 1297, 1292, 1283, 1275, 1282, 1287, 1311, 1314, 1310, 1318, 1309, 1312, 1317, 1316, 1315, 1308, 1313, 1153, 565, 923, 446, 599, 539, 443, 571, 736, 540, 521, 672, 445, 588, 592, 981, 710, 842, 1148, 1119, 562, 433, 1116, 430, 632, 621, 1141, 834, 936, 988, 734, 684, 695, 498, 809, 970, 66, 569, 951, 952, 967, 600, 723, 659, 441, 663, 563, 935, 679, 505, 669, 587, 607, 533, 636, 1137, 729, 461, 987, 737, 725, 616, 1142, 517, 641, 942, 434, 513, 668, 1146, 634, 689, 738, 707, 603, 718, 693, 593, 615, 1118, 678, 638, 576, 449, 727, 578, 528, 601, 968, 510, 683, 882, 833, 757, 1140, 509, 731, 651, 627, 504, 639, 702, 705, 456, 949, 726, 541, 831, 664, 819, 826, 646, 886, 431, 583, 598, 666, 635, 591, 637, 1139, 986, 657, 758, 543, 963, 594, 530, 969, 619, 934, 907, 1117, 459, 812, 542, 613, 820, 568, 429, 828, 885, 579, 704, 606, 442, 830, 835, 595, 1113, 841, 690, 913, 742, 618, 976, 979, 926, 694, 983, 909, 910, 912, 1125, 916, 918, 925, 965, 937, 962, 971, 972, 1166, 1126, 1122, 825, 827, 829, 832, 837, 863, 868, 879, 884, 520, 444, 625, 582, 620, 612, 515, 881, 845, 883, 839, 887, 890, 896, 901, 898, 428, 585, 870, 859, 605, 823, 815, 821) THEN 0 ELSE 1 END AS sclr_40, p0_.account_id AS account_id_41, p0_.main_photo_id AS main_photo_id_42, p0_.area_id AS area_id_43, p0_.metro_id AS metro_id_44, p0_.salon_id AS salon_id_45, p0_.verification_photo_id AS verification_photo_id_46, p0_.verification_photo2_id AS verification_photo2_id_47, p0_.video_id AS video_id_48, p0_.city_id AS city_id_49, p0_.video2_id AS video2_id_50, p0_.video3_id AS video3_id_51, p0_.video_cover_id AS video_cover_id_52, p0_.video_cover2_id AS video_cover2_id_53, p0_.video_cover3_id AS video_cover3_id_54 FROM portfolio p0_ INNER JOIN city c1_ ON p0_.city_id = c1_.id WHERE p0_.id IN (SELECT p2_.id FROM portfolio p2_ INNER JOIN city c3_ ON p2_.city_id = c3_.id WHERE p2_.status IN (?, ?, ?) AND c3_.is_enabled = ?) ORDER BY sclr_36 ASC, sclr_37 ASC, sclr_38 ASC, sclr_39 ASC, sclr_40 ASC, p0_.ordering ASC, p0_.id ASC LIMIT 20
Parameters: 
[
  "enabled"
  "pause"
  "disabled"
  "true"
]
View formatted query    View runnable query    Explain query    View query backtrace
8.71 ms
(11.65%) 		5 
SELECT portfolio.id FROM portfolio
                LEFT JOIN salon ON salon.id = portfolio.salon_id WHERE (active_periods->>?)::integer & (1 << (3 - ?)) <> 0
                AND ((portfolio.salon_id IS NULL AND portfolio.status IN('enabled', 're-moderation')) OR (salon.status IN('enabled', 're-moderation') AND portfolio.status IN('enabled', 're-moderation')))
                AND portfolio.is_paid = true
Parameters: 
[
  "saturday"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
8.47 ms
(11.33%) 		20 
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.active_from AS active_from_3, t0.duration AS duration_4, t0.write_off_amount AS write_off_amount_5, t0.portfolio_id AS portfolio_id_6 FROM order_top t0 WHERE t0.portfolio_id = ?
Parameters: 
[
  431
]
View formatted query    View runnable query    Explain query    View query backtrace
7.25 ms
(9.69%) 		20 
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.telegram AS telegram_5, t0.address AS address_6, t0.about AS about_7, t0.programs AS programs_8, t0.additional_programs AS additional_programs_9, t0.portfolio_id AS portfolio_id_10, t0.main_photo_id AS main_photo_id_11, t0.area_id AS area_id_12, t0.metro_id AS metro_id_13, t0.verification_photo_id AS verification_photo_id_14, t0.verification_photo2_id AS verification_photo2_id_15, t0.city_id AS city_id_16, t0.video_id AS video_id_17, t0.video2_id AS video2_id_18, t0.video3_id AS video3_id_19, t0.video_cover_id AS video_cover_id_20, t0.video_cover2_id AS video_cover2_id_21, t0.video_cover3_id AS video_cover3_id_22 FROM temp_portfolio t0 WHERE t0.portfolio_id = ?
Parameters: 
[
  431
]
View formatted query    View runnable query    Explain query    View query backtrace
4.26 ms
(5.69%) 		5 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.phone AS phone_2, p0_.whatsapp AS whatsapp_3, p0_.telegram AS telegram_4, p0_.address AS address_5, p0_.about AS about_6, p0_.age AS age_7, p0_.weight AS weight_8, p0_.height AS height_9, p0_.leg_size AS leg_size_10, p0_.bust_size AS bust_size_11, p0_.shape AS shape_12, p0_.hair_color AS hair_color_13, p0_.is_meeting_at_my_place AS is_meeting_at_my_place_14, p0_.is_visit_to_client_available AS is_visit_to_client_available_15, p0_.visit_to_client_price AS visit_to_client_price_16, p0_.is_client_paid_taxi AS is_client_paid_taxi_17, p0_.standart_program_price AS standart_program_price_18, p0_.status AS status_19, p0_.programs AS programs_20, p0_.decline_reason AS decline_reason_21, p0_.is_photo_with_face AS is_photo_with_face_22, p0_.reject_reason AS reject_reason_23, p0_.additional_programs AS additional_programs_24, p0_.address_coordinates AS address_coordinates_25, p0_.schedule AS schedule_26, p0_.meta_title AS meta_title_27, p0_.h1 AS h1_28, p0_.meta_description AS meta_description_29, p0_.is_indexed AS is_indexed_30, p0_.created_at AS created_at_31, p0_.active_periods AS active_periods_32, p0_.ordering AS ordering_33, p0_.is_paid AS is_paid_34, p0_.is_remoderation_required AS is_remoderation_required_35, p0_.account_id AS account_id_36, p0_.main_photo_id AS main_photo_id_37, p0_.area_id AS area_id_38, p0_.metro_id AS metro_id_39, p0_.salon_id AS salon_id_40, p0_.verification_photo_id AS verification_photo_id_41, p0_.verification_photo2_id AS verification_photo2_id_42, p0_.video_id AS video_id_43, p0_.city_id AS city_id_44, p0_.video2_id AS video2_id_45, p0_.video3_id AS video3_id_46, p0_.video_cover_id AS video_cover_id_47, p0_.video_cover2_id AS video_cover2_id_48, p0_.video_cover3_id AS video_cover3_id_49 FROM portfolio p0_ INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id WHERE o1_.active_from <= ? AND (o1_.active_from + (o1_.duration || ' HOUR')::interval) >= ?
Parameters: 
[
  "2026-03-14 07:19:50"
  "2026-03-14 07:19:50"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.98 ms
(3.99%) 		1 
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM portfolio p0_ INNER JOIN city c1_ ON p0_.city_id = c1_.id WHERE p0_.id IN (SELECT p2_.id FROM portfolio p2_ INNER JOIN city c3_ ON p2_.city_id = c3_.id WHERE p2_.status IN (?, ?, ?) AND c3_.is_enabled = ?)
Parameters: 
[
  "enabled"
  "pause"
  "disabled"
  "true"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.43 ms
(1.91%) 		3 
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.email AS email_4, t0.status AS status_5, t0.balance AS balance_6, t0.type AS type_7, t0.telegram AS telegram_8, t0.phone AS phone_9, t0.whatsapp AS whatsapp_10 FROM "user" t0 WHERE t0.id = ?
Parameters: 
[
  47
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.61%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.city_id AS city_id_3 FROM district t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.57%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.district_id AS district_id_3 FROM area t0 WHERE t0.id = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.46%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.district_id AS district_id_3 FROM area t0 WHERE t0.district_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\PortfolioView 2163
App\Entity\File 452
App\Entity\ExtraService 28
App\Entity\Portfolio 20
App\Entity\TempPortfolio 20
App\Entity\Area 19
App\Entity\OrderTop 15
App\Entity\Metro 14
App\Entity\User 3
App\Entity\City 1
App\Entity\District 1

Entities Mapping

Class Mapping errors
App\Entity\Portfolio No errors.
App\Entity\User No errors.
App\Entity\City No errors.
App\Entity\Salon No errors.
App\Entity\File No errors.
App\Entity\TempSalon No errors.
App\Entity\Area No errors.
App\Entity\Metro No errors.
App\Entity\TempPortfolio No errors.
App\Entity\ExtraService No errors.
App\Entity\Page No errors.
App\Entity\Tariff No errors.
App\Entity\District No errors.
App\Entity\SalonOption No errors.
App\Entity\Article No errors.
App\Entity\BalanceLogRecord No errors.
App\Entity\PortfolioView No errors.
App\Entity\OrderTop No errors.