GET https://search.jues.net/search/embeds/7?q=step%20girl

Query Metrics

7 Database Queries
7 Different statements
205.64 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
182.28 ms
(88.64%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  239151
  403086
  420767
  430071
  452702
  458725
  460658
  499294
  507789
  513189
  533110
  534513
  535095
  537127
  539531
  543565
  547642
  548161
  550612
  553905
  561811
  562102
  563901
  575241
  576768
  577238
  586269
  587479
  591096
  591099
  594974
  596552
  599085
  599090
  607350
  608111
  617195
  617989
  625950
  629514
  630720
  631558
  633653
  636972
  646522
  650650
  651005
  667576
  674523
  676156
  678218
  678219
  683538
  685915
  703113
  703299
  706412
  709554
  711712
  715190
  715239
  718400
  719321
  719373
  719989
  732132
  734940
  737482
  739295
  739516
  741890
  743667
  743749
  755044
  756450
  757322
  759167
  760187
  761121
  762634
  767616
  771675
  775314
  776171
  776181
  777114
  778002
  778022
  780101
  780379
  781070
  781130
  781437
  788568
  789916
  789951
  791260
  794201
  794922
  797318
  799490
  801437
  802050
  813631
  816824
  818126
  818417
  820078
  821791
  824024
  824231
  827046
  827154
  827156
  827839
  827845
  827867
  827882
  828317
]
13.85 ms
(6.74%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  507789
  535095
  563901
  646522
  591099
  599085
  599090
  788568
  780379
  734940
  778022
  802050
  827841
  577238
  586269
  430071
  403086
  824231
  818126
  827046
  827154
  828317
  553905
  561811
  683538
  685915
  596552
  631558
  801437
  737482
  703113
  789916
  420767
  513189
  543565
  575241
  617195
  625950
  458725
  460658
  820078
  824024
  816824
  534513
  499294
  576768
  651005
  650650
  674523
  718400
  594974
  776171
  781130
  743667
  781437
  799490
  757322
  761121
  732132
  780101
  608111
  550612
  760187
  607350
  239151
  818417
  821791
  827839
  827845
  827867
  452702
  539531
  533110
  537127
  562102
  667576
  676156
  706412
  719321
  678219
  678218
  709554
  715239
  719373
  617989
  629514
  630720
  636972
  776181
  791260
  794201
  775314
  778002
  739516
  739295
  762634
  741890
  755044
  759167
  767616
  743749
  756450
  771675
  633653
  703299
  777114
  781070
  789951
  797318
  813631
  827156
  827882
  547642
  715190
  711712
  719989
  548161
  587479
  591096
  794922
]
2.40 ms
(1.17%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  239151
  403086
  420767
  430071
  452702
  458725
  460658
  499294
  507789
  513189
  533110
  534513
  535095
  537127
  539531
  543565
  547642
  548161
  550612
  553905
  561811
  562102
  563901
  575241
  576768
  577238
  586269
  587479
  591096
  591099
  594974
  596552
  599085
  599090
  607350
  608111
  617195
  617989
  625950
  629514
  630720
  631558
  633653
  636972
  646522
  650650
  651005
  667576
  674523
  676156
  678218
  678219
  683538
  685915
  703113
  703299
  706412
  709554
  711712
  715190
  715239
  718400
  719321
  719373
  719989
  732132
  734940
  737482
  739295
  739516
  741890
  743667
  743749
  755044
  756450
  757322
  759167
  760187
  761121
  762634
  767616
  771675
  775314
  776171
  776181
  777114
  778002
  778022
  780101
  780379
  781070
  781130
  781437
  788568
  789916
  789951
  791260
  794201
  794922
  797318
  799490
  801437
  802050
  813631
  816824
  818126
  818417
  820078
  821791
  824024
  824231
  827046
  827154
  827156
  827839
  827845
  827867
  827882
  828317
]
2.03 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step girl"
]
1.78 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step девушк"
]
1.50 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step девушк"
]

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.

Entities Mapping

No loaded entities.