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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.09 ms
(58.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "best pov"
]
125.46 ms
(35.72%)
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
  401757
  412571
  413639
  421806
  422447
  424617
  430362
  434587
  436478
  439900
  442057
  446999
  448524
  451043
  458832
  459618
  469399
  470812
  471968
  480012
  483296
  505967
  509772
  527697
  543641
  547207
  549661
  561167
  562645
  562687
  567359
  567565
  575335
  578581
  582619
  583252
  585318
  585457
  591383
  592874
  599766
  609099
  616931
  623234
  628768
  649056
  659349
  677419
  681219
  689440
  694883
  700269
  701548
  708905
  713760
  717433
  718415
  719792
  722925
  729354
  731687
  739853
  746373
  751920
  761711
  762045
  763808
  763955
  764892
  764923
  764947
  765178
  767061
  768280
  772057
  772618
  777260
  779278
  779425
  779460
  780174
  783953
  784088
  784551
  785276
  785356
  787002
  787579
  792214
  793121
  794088
  794857
  795148
  795205
  795539
  795741
  797306
  798089
  799243
  799974
  800034
  800810
  802204
  802823
  803444
  804733
  804990
  804993
  805392
  807123
  807477
  808244
  809683
  813072
  813471
  819938
  826763
  827825
  827842
]
12.89 ms
(3.67%)
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
  787579
  799243
  809683
  480012
  422447
  442057
  509772
  421806
  412571
  718415
  746373
  767061
  762045
  567359
  401757
  424617
  430362
  434587
  819938
  827842
  827825
  448524
  483296
  547207
  578581
  582619
  543641
  562645
  659349
  681219
  717433
  719792
  583252
  599766
  609099
  585318
  779460
  794088
  800034
  802204
  802823
  805392
  777260
  784551
  795741
  799974
  804733
  807123
  807477
  739853
  765178
  784088
  794857
  804990
  763808
  764947
  751920
  772057
  761711
  764892
  628768
  780548
  795205
  797306
  804993
  413639
  439900
  469399
  470812
  527697
  592874
  689440
  729354
  826763
  446999
  451043
  458832
  459618
  505967
  561167
  575335
  549661
  567565
  562687
  649056
  694883
  700269
  701548
  677419
  713760
  585457
  616931
  591383
  779425
  779278
  792214
  795148
  795539
  798089
  800810
  803444
  813072
  785276
  785356
  793121
  808244
  813471
  763955
  764923
  768280
  731687
  772618
  623234
  708905
  722925
  780174
  783953
  787002
  436478
  471968
]
2.68 ms
(0.76%)
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
  401757
  412571
  413639
  421806
  422447
  424617
  430362
  434587
  436478
  439900
  442057
  446999
  448524
  451043
  458832
  459618
  469399
  470812
  471968
  480012
  483296
  505967
  509772
  527697
  543641
  547207
  549661
  561167
  562645
  562687
  567359
  567565
  575335
  578581
  582619
  583252
  585318
  585457
  591383
  592874
  599766
  609099
  616931
  623234
  628768
  649056
  659349
  677419
  681219
  689440
  694883
  700269
  701548
  708905
  713760
  717433
  718415
  719792
  722925
  729354
  731687
  739853
  746373
  751920
  761711
  762045
  763808
  763955
  764892
  764923
  764947
  765178
  767061
  768280
  772057
  772618
  777260
  779278
  779425
  779460
  780174
  783953
  784088
  784551
  785276
  785356
  787002
  787579
  792214
  793121
  794088
  794857
  795148
  795205
  795539
  795741
  797306
  798089
  799243
  799974
  800034
  800810
  802204
  802823
  803444
  804733
  804990
  804993
  805392
  807123
  807477
  808244
  809683
  813072
  813471
  819938
  826763
  827825
  827842
]
1.99 ms
(0.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "best пов"
]
1.68 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "best пов"
]

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.