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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
194.32 ms
(88.29%)
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
  396909
  417551
  420622
  442060
  470462
  502934
  513809
  527274
  531389
  539632
  539847
  554967
  565026
  577460
  579437
  585343
  593336
  607098
  609090
  610711
  614530
  614625
  615023
  616423
  619505
  631420
  633897
  637304
  643507
  672795
  683670
  692693
  700375
  703932
  703951
  708983
  714223
  718639
  719365
  719773
  723122
  724674
  725374
  726453
  728486
  730229
  733072
  744075
  761235
  763068
  763428
  764405
  764757
  764762
  764776
  765729
  765890
  766427
  767276
  767913
  769892
  771842
  771940
  771977
  772004
  773793
  773919
  774234
  774370
  775711
  776533
  776662
  777905
  780573
  781905
  783104
  783449
  783490
  788370
  788482
  788964
  789127
  789449
  789856
  789921
  789999
  791081
  791371
  791601
  791713
  793879
  794975
  796497
  797895
  799426
  799668
  799669
  801224
  802513
  803107
  804819
  804878
  805007
  806838
  807474
  809233
  809762
  809773
  809976
  809995
  810396
  812169
  812710
  813176
  813328
  815098
  817197
  821650
  825643
  825680
]
15.93 ms
(7.24%)
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
  767913
  804878
  396909
  420622
  825680
  821650
  825643
  577460
  672795
  703932
  703951
  708983
  683670
  719365
  616423
  633897
  607098
  585343
  775711
  777905
  780573
  783104
  788370
  788482
  791081
  801224
  809976
  812169
  813328
  781905
  797895
  799668
  804819
  725374
  730229
  761235
  763428
  764776
  773919
  789449
  793879
  803107
  809233
  809773
  813176
  771842
  764405
  769892
  771977
  764762
  767276
  771940
  772004
  733072
  744075
  765890
  773793
  774370
  619505
  631420
  776662
  791371
  805007
  810396
  812710
  417551
  700375
  719773
  593336
  794975
  614530
  723122
  806838
  539847
  539632
  714223
  614625
  718639
  442060
  817197
  815098
  470462
  513809
  527274
  531389
  502934
  554967
  579437
  692693
  565026
  609090
  610711
  615023
  637304
  643507
  783449
  783490
  789921
  789999
  796497
  799669
  776533
  788964
  789856
  791601
  799426
  809995
  789127
  791713
  802513
  807474
  809762
  724674
  726453
  774234
  728486
  763068
  764757
  766427
  765729
]
3.31 ms
(1.51%)
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
  396909
  417551
  420622
  442060
  470462
  502934
  513809
  527274
  531389
  539632
  539847
  554967
  565026
  577460
  579437
  585343
  593336
  607098
  609090
  610711
  614530
  614625
  615023
  616423
  619505
  631420
  633897
  637304
  643507
  672795
  683670
  692693
  700375
  703932
  703951
  708983
  714223
  718639
  719365
  719773
  723122
  724674
  725374
  726453
  728486
  730229
  733072
  744075
  761235
  763068
  763428
  764405
  764757
  764762
  764776
  765729
  765890
  766427
  767276
  767913
  769892
  771842
  771940
  771977
  772004
  773793
  773919
  774234
  774370
  775711
  776533
  776662
  777905
  780573
  781905
  783104
  783449
  783490
  788370
  788482
  788964
  789127
  789449
  789856
  789921
  789999
  791081
  791371
  791601
  791713
  793879
  794975
  796497
  797895
  799426
  799668
  799669
  801224
  802513
  803107
  804819
  804878
  805007
  806838
  807474
  809233
  809762
  809773
  809976
  809995
  810396
  812169
  812710
  813176
  813328
  815098
  817197
  821650
  825643
  825680
]
1.94 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "on you pov"
]
1.63 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "you пов"
]
1.39 ms
(0.63%)
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.