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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
198.11 ms
(88.51%)
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
  341079
  388175
  437836
  456115
  466408
  507097
  513008
  513364
  524604
  529701
  532306
  533164
  535854
  537507
  547715
  552692
  563589
  565588
  567612
  584364
  585521
  585586
  588098
  588460
  589521
  589633
  592654
  597754
  601420
  602070
  602995
  606555
  619625
  624932
  626121
  626288
  626300
  627619
  631579
  634412
  636628
  637798
  644527
  646421
  652747
  655900
  656514
  666890
  671264
  691182
  691212
  696128
  707056
  713999
  724048
  729308
  733995
  734903
  739389
  759249
  761861
  764062
  764282
  764433
  764613
  765313
  765977
  766659
  766971
  770030
  771021
  772551
  773407
  773736
  775289
  776289
  777497
  780763
  780827
  781458
  783354
  784425
  785018
  785559
  785763
  787821
  788842
  789474
  789610
  791422
  791557
  794112
  794136
  794875
  797208
  797355
  797484
  798834
  799843
  800772
  800782
  803055
  803943
  805209
  806118
  806217
  806713
  808237
  808478
  808495
  808761
  809826
  809851
  810422
  812614
  812975
  817270
  820857
  822580
  825889
]
14.98 ms
(6.69%)
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
  713999
  655900
  656514
  666890
  563589
  627619
  636628
  588098
  626300
  602995
  619625
  631579
  791557
  794112
  794875
  797484
  798834
  806118
  806713
  808761
  809851
  780827
  789474
  799843
  800772
  806217
  809826
  773736
  784425
  789610
  794136
  803943
  761861
  764433
  764282
  766659
  644527
  787821
  791422
  797355
  808237
  507097
  780763
  766971
  547715
  808495
  777497
  765313
  729308
  646421
  456115
  812614
  585521
  724048
  537507
  707056
  652747
  691212
  589633
  626121
  626288
  775289
  805209
  783354
  797208
  808478
  759249
  773407
  772551
  637798
  800782
  764613
  437836
  671264
  565588
  589521
  592654
  634412
  770030
  764062
  825889
  606555
  624932
  588460
  532306
  552692
  691182
  781458
  733995
  739389
  771021
  513008
  696128
  388175
  529701
  533164
  584364
  567612
  810422
  812975
  341079
  822580
  820857
  535854
  601420
  803055
  765977
  466408
  597754
  524604
  513364
  817270
  585586
  602070
  785763
  785559
  788842
  734903
  776289
  785018
]
3.79 ms
(1.69%)
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
  341079
  388175
  437836
  456115
  466408
  507097
  513008
  513364
  524604
  529701
  532306
  533164
  535854
  537507
  547715
  552692
  563589
  565588
  567612
  584364
  585521
  585586
  588098
  588460
  589521
  589633
  592654
  597754
  601420
  602070
  602995
  606555
  619625
  624932
  626121
  626288
  626300
  627619
  631579
  634412
  636628
  637798
  644527
  646421
  652747
  655900
  656514
  666890
  671264
  691182
  691212
  696128
  707056
  713999
  724048
  729308
  733995
  734903
  739389
  759249
  761861
  764062
  764282
  764433
  764613
  765313
  765977
  766659
  766971
  770030
  771021
  772551
  773407
  773736
  775289
  776289
  777497
  780763
  780827
  781458
  783354
  784425
  785018
  785559
  785763
  787821
  788842
  789474
  789610
  791422
  791557
  794112
  794136
  794875
  797208
  797355
  797484
  798834
  799843
  800772
  800782
  803055
  803943
  805209
  806118
  806217
  806713
  808237
  808478
  808495
  808761
  809826
  809851
  810422
  812614
  812975
  817270
  820857
  822580
  825889
]
1.92 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп пов"
]
1.80 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass pov"
]
1.61 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.72%)
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.