GET https://search.jues.net/search/embeds/3?q=on%20you%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.20 ms
(89.98%)
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
  339285
  433406
  440987
  449356
  525429
  531670
  533164
  541852
  550958
  567218
  571488
  604046
  612764
  613405
  618729
  622585
  628942
  635027
  640392
  648261
  648741
  652422
  673869
  679892
  693248
  693283
  697129
  697164
  702445
  705874
  715389
  717013
  718778
  724634
  725237
  725728
  737404
  742333
  742645
  753119
  756094
  758879
  759799
  761820
  763661
  764888
  765117
  765737
  765924
  767751
  769338
  771982
  771989
  772047
  772401
  772960
  773917
  773918
  773929
  774447
  777088
  778554
  778597
  778617
  779095
  779165
  779974
  780675
  781405
  782088
  783125
  783485
  783505
  785639
  786518
  788033
  789420
  790328
  790729
  791728
  791941
  792323
  792474
  793777
  795349
  796019
  797374
  799670
  800970
  801801
  801920
  802022
  802938
  803199
  803411
  803422
  804544
  804739
  805833
  809095
  810779
  810865
  813214
  814219
  814703
  815079
  815113
  815120
  817257
  817342
  819796
  820362
  821088
  823946
  824217
  824571
  825501
  826144
  826474
]
11.61 ms
(4.99%)
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
  339285
  567218
  604046
  449356
  756094
  813214
  801920
  742333
  673869
  814219
  819796
  825501
  823946
  820362
  814703
  815079
  824217
  541852
  648261
  652422
  693248
  628942
  640392
  788033
  791728
  792474
  804739
  805833
  778617
  785639
  786518
  799670
  771982
  772553
  803199
  804544
  761820
  765117
  767751
  772401
  724634
  725237
  742645
  769338
  773918
  763661
  773929
  778597
  779095
  790328
  792323
  774447
  815113
  533164
  705874
  791941
  790729
  781405
  613405
  779974
  810779
  440987
  777088
  797374
  802022
  737404
  783485
  433406
  826474
  826144
  817342
  821088
  815120
  817257
  525429
  531670
  571488
  679892
  693283
  697164
  702445
  717013
  622585
  612764
  635027
  618729
  796019
  803422
  809095
  780675
  782088
  783505
  810865
  783125
  789420
  793777
  758879
  759799
  765924
  764888
  725728
  765737
  773917
  697129
  715389
  778554
  779165
  795349
  801801
  802938
  803411
  824571
  718778
  550958
  648741
  772047
  772960
  753119
  800970
  771989
]
3.66 ms
(1.57%)
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
  339285
  433406
  440987
  449356
  525429
  531670
  533164
  541852
  550958
  567218
  571488
  604046
  612764
  613405
  618729
  622585
  628942
  635027
  640392
  648261
  648741
  652422
  673869
  679892
  693248
  693283
  697129
  697164
  702445
  705874
  715389
  717013
  718778
  724634
  725237
  725728
  737404
  742333
  742645
  753119
  756094
  758879
  759799
  761820
  763661
  764888
  765117
  765737
  765924
  767751
  769338
  771982
  771989
  772047
  772401
  772960
  773917
  773918
  773929
  774447
  777088
  778554
  778597
  778617
  779095
  779165
  779974
  780675
  781405
  782088
  783125
  783485
  783505
  785639
  786518
  788033
  789420
  790328
  790729
  791728
  791941
  792323
  792474
  793777
  795349
  796019
  797374
  799670
  800970
  801801
  801920
  802022
  802938
  803199
  803411
  803422
  804544
  804739
  805833
  809095
  810779
  810865
  813214
  814219
  814703
  815079
  815113
  815120
  817257
  817342
  819796
  820362
  821088
  823946
  824217
  824571
  825501
  826144
  826474
]
2.25 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "on you pov"
]
2.16 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "you пов"
]
1.70 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "you пов"
]

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.