GET https://search.jues.net/search/embeds/10?q=anal%20beautiful%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.72 ms
(82.96%)
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
  384518
  392404
  395597
  395869
  396230
  398317
  400669
  400957
  401177
  413968
  419607
  428184
  432118
  437668
  443883
  444058
  451595
  455585
  458538
  459072
  461438
  463895
  463897
  465987
  468691
  469854
  470045
  472767
  473417
  473940
  474601
  475059
  475451
  479009
  479759
  480960
  482626
  482699
  484274
  488551
  492109
  493039
  493194
  495070
  499103
  501649
  501831
  505453
  510672
  511239
  512495
  514999
  516922
  517106
  517663
  518125
  518446
  519187
  519500
  519565
  521430
  521588
  529054
  538207
  538773
  545670
  548701
  552566
  554290
  557086
  558044
  561710
  561840
  565158
  565440
  566347
  566621
  568460
  575430
  576271
  577333
  578501
  581168
  585160
  592358
  592490
  597552
  597951
  602268
  607093
  621287
  626880
  634161
  649133
  652869
  677726
  679373
  680183
  686091
  692117
  695463
  698012
  714018
  717877
  720197
  721367
  741249
  753480
  761740
  768347
  769767
  770319
  771763
  781326
  790925
  794331
  799342
  800545
  814250
  827835
]
19.44 ms
(11.22%)
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
  521430
  443883
  495070
  419607
  514999
  488551
  511239
  516922
  492109
  505453
  519565
  652869
  428184
  396230
  548701
  677726
  597552
  799342
  790925
  395597
  475451
  475059
  558044
  565158
  557086
  545670
  679373
  554290
  575430
  592358
  395869
  469854
  473940
  400669
  459072
  480960
  437668
  470045
  474601
  392404
  463895
  463897
  501831
  517106
  501649
  517663
  518446
  519500
  398317
  519187
  472767
  451595
  626880
  814250
  565440
  692117
  800545
  741249
  384518
  827835
  770319
  769767
  400957
  720197
  686091
  753480
  714018
  717877
  695463
  781326
  768347
  761740
  794331
  602268
  698012
  649133
  621287
  721367
  566621
  581168
  512495
  521588
  493194
  499103
  529054
  592490
  771763
  538207
  518125
  680183
  413968
  432118
  482699
  482626
  458538
  455585
  468691
  538773
  552566
  561840
  576271
  577333
  566347
  568460
  561710
  578501
  597951
  585160
  634161
  607093
  444058
  461438
  465987
  479759
  401177
  473417
  479009
  484274
  493039
  510672
]
2.88 ms
(1.66%)
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
  384518
  392404
  395597
  395869
  396230
  398317
  400669
  400957
  401177
  413968
  419607
  428184
  432118
  437668
  443883
  444058
  451595
  455585
  458538
  459072
  461438
  463895
  463897
  465987
  468691
  469854
  470045
  472767
  473417
  473940
  474601
  475059
  475451
  479009
  479759
  480960
  482626
  482699
  484274
  488551
  492109
  493039
  493194
  495070
  499103
  501649
  501831
  505453
  510672
  511239
  512495
  514999
  516922
  517106
  517663
  518125
  518446
  519187
  519500
  519565
  521430
  521588
  529054
  538207
  538773
  545670
  548701
  552566
  554290
  557086
  558044
  561710
  561840
  565158
  565440
  566347
  566621
  568460
  575430
  576271
  577333
  578501
  581168
  585160
  592358
  592490
  597552
  597951
  602268
  607093
  621287
  626880
  634161
  649133
  652869
  677726
  679373
  680183
  686091
  692117
  695463
  698012
  714018
  717877
  720197
  721367
  741249
  753480
  761740
  768347
  769767
  770319
  771763
  781326
  790925
  794331
  799342
  800545
  814250
  827835
]
2.13 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал красивая девушк"
]
1.68 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal beautiful girl"
]
1.59 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал красивая девушк"
]

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.