GET https://search.jues.net/search/embeds/4?q=black%20boy%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
186.96 ms
(87.25%)
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
  37245
  75852
  383809
  386304
  386596
  388690
  390024
  396526
  396527
  396609
  415883
  418538
  420120
  420192
  421250
  429523
  432559
  432562
  437123
  441185
  445739
  446167
  446976
  448817
  449123
  449869
  451875
  453473
  454925
  457160
  457163
  457166
  458013
  460328
  460706
  461747
  461765
  464188
  464453
  465649
  467568
  468009
  476120
  476143
  478033
  480439
  480929
  483094
  484547
  492064
  492126
  494269
  494345
  495014
  495418
  496033
  496270
  496302
  499174
  499817
  501487
  503855
  508856
  510284
  510394
  511810
  514798
  514939
  518733
  520213
  520405
  523091
  525303
  528035
  529256
  529286
  529360
  530483
  531560
  532441
  536925
  537901
  543808
  546861
  548577
  549992
  550774
  550960
  556533
  558447
  562894
  564776
  565102
  571016
  573373
  574559
  576346
  578500
  580151
  583593
  584105
  584708
  589345
  595764
  596643
  603252
  603724
  603813
  603907
  604451
  605105
  622682
  624930
  643112
  646001
  676463
  678159
  681709
  811040
]
18.40 ms
(8.59%)
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
  523091
  480929
  578500
  383809
  37245
  460328
  467568
  458013
  461747
  520213
  583593
  604451
  386596
  432562
  514939
  496302
  499174
  518733
  492126
  386304
  622682
  529286
  573373
  445739
  451875
  457166
  503855
  75852
  388690
  432559
  528035
  529256
  396609
  429523
  476143
  514798
  468009
  484547
  595764
  596643
  478033
  525303
  508856
  511810
  448817
  464453
  494269
  396527
  390024
  454925
  530483
  537901
  441185
  453473
  520405
  480439
  681709
  603724
  483094
  457163
  476120
  510394
  464188
  574559
  549992
  565102
  576346
  465649
  461765
  495014
  437123
  495418
  532441
  548577
  564776
  676463
  556533
  589345
  811040
  396526
  513476
  449869
  531560
  499817
  418538
  529360
  510284
  643112
  550774
  603252
  562894
  584708
  420192
  460706
  446167
  624930
  543808
  558447
  646001
  457160
  678159
  494345
  571016
  546861
  496270
  420120
  550960
  501487
  605105
  603813
  580151
  584105
  492064
  421250
  446976
  449123
  415883
  536925
  603907
  496033
]
2.32 ms
(1.09%)
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
  37245
  75852
  383809
  386304
  386596
  388690
  390024
  396526
  396527
  396609
  415883
  418538
  420120
  420192
  421250
  429523
  432559
  432562
  437123
  441185
  445739
  446167
  446976
  448817
  449123
  449869
  451875
  453473
  454925
  457160
  457163
  457166
  458013
  460328
  460706
  461747
  461765
  464188
  464453
  465649
  467568
  468009
  476120
  476143
  478033
  480439
  480929
  483094
  484547
  492064
  492126
  494269
  494345
  495014
  495418
  496033
  496270
  496302
  499174
  499817
  501487
  503855
  508856
  510284
  510394
  511810
  514798
  514939
  518733
  520213
  520405
  523091
  525303
  528035
  529256
  529286
  529360
  530483
  531560
  532441
  536925
  537901
  543808
  546861
  548577
  549992
  550774
  550960
  556533
  558447
  562894
  564776
  565102
  571016
  573373
  574559
  576346
  578500
  580151
  583593
  584105
  584708
  589345
  595764
  596643
  603252
  603724
  603813
  603907
  604451
  605105
  622682
  624930
  643112
  646001
  676463
  678159
  681709
  811040
]
1.77 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black boy girls"
]
1.65 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black парен девушк"
]
1.56 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black парен девушк"
]

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.