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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
193.02 ms
(89.01%)
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
  389630
  415029
  441683
  443884
  456526
  459922
  460118
  460581
  466365
  466683
  466723
  474199
  477692
  481023
  483258
  484012
  485494
  486326
  486327
  507432
  508223
  516603
  520652
  527837
  528103
  531380
  541779
  549661
  555184
  555725
  556493
  556716
  558484
  562868
  563299
  563682
  564844
  570081
  571277
  588403
  588916
  591446
  592856
  596818
  600850
  602525
  602662
  602798
  608633
  615138
  617245
  624078
  632124
  632304
  635367
  637521
  638566
  639449
  647122
  651314
  659345
  664732
  673874
  675336
  675583
  685441
  686610
  696567
  698354
  699181
  700592
  700735
  711354
  716921
  716935
  723189
  726390
  731396
  732154
  733742
  740646
  759243
  761677
  761777
  766082
  769550
  770626
  772444
  775271
  775274
  777456
  778523
  783922
  785185
  785548
  786562
  786596
  788032
  788071
  788172
  788359
  788365
  788915
  788945
  789496
  790926
  791572
  792878
  794807
  797651
  798763
  800888
  802766
  802910
  804537
  809974
  809992
  821771
  821899
  822264
]
13.90 ms
(6.41%)
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
  541779
  570081
  558484
  563682
  647122
  651314
  673874
  686610
  699181
  723189
  685441
  711354
  659345
  698354
  555184
  556716
  592856
  602525
  596818
  788032
  788071
  788172
  789496
  797651
  798763
  809974
  761677
  785185
  786596
  794807
  732154
  770626
  637521
  639449
  700592
  778523
  786562
  788359
  800888
  474199
  456526
  486327
  675336
  617245
  733742
  632304
  821899
  822264
  821771
  486326
  477692
  459922
  460581
  555725
  564844
  556493
  563299
  664732
  675583
  716921
  716935
  602662
  624078
  638566
  600850
  635367
  788945
  791572
  804537
  775271
  790926
  731396
  740646
  761777
  802910
  809992
  759243
  766082
  726390
  769550
  772444
  602798
  775274
  783922
  785548
  389630
  460118
  508223
  484012
  485494
  507432
  527837
  777456
  415029
  516603
  571277
  443884
  441683
  466365
  481023
  483258
  466683
  466723
  520652
  531380
  528103
  549661
  562868
  696567
  700735
  615138
  588403
  608633
  632124
  588916
  591446
  788915
  792878
  802766
  788365
]
3.28 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
  389630
  415029
  441683
  443884
  456526
  459922
  460118
  460581
  466365
  466683
  466723
  474199
  477692
  481023
  483258
  484012
  485494
  486326
  486327
  507432
  508223
  516603
  520652
  527837
  528103
  531380
  541779
  549661
  555184
  555725
  556493
  556716
  558484
  562868
  563299
  563682
  564844
  570081
  571277
  588403
  588916
  591446
  592856
  596818
  600850
  602525
  602662
  602798
  608633
  615138
  617245
  624078
  632124
  632304
  635367
  637521
  638566
  639449
  647122
  651314
  659345
  664732
  673874
  675336
  675583
  685441
  686610
  696567
  698354
  699181
  700592
  700735
  711354
  716921
  716935
  723189
  726390
  731396
  732154
  733742
  740646
  759243
  761677
  761777
  766082
  769550
  770626
  772444
  775271
  775274
  777456
  778523
  783922
  785185
  785548
  786562
  786596
  788032
  788071
  788172
  788359
  788365
  788915
  788945
  789496
  790926
  791572
  792878
  794807
  797651
  798763
  800888
  802766
  802910
  804537
  809974
  809992
  821771
  821899
  822264
]
1.87 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "home пов"
]
1.76 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home pov"
]
1.52 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "home пов"
]
1.49 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.