GET https://search.jues.net/search/embeds/6?q=pov%20step%20sister

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
380.44 ms
(93.36%)
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
  419008
  424238
  429455
  429782
  431954
  433220
  433829
  434156
  435346
  437383
  437876
  438114
  441366
  441929
  442402
  442416
  444067
  444184
  444429
  444620
  450530
  453437
  453801
  454876
  454929
  455653
  455787
  456300
  458179
  459580
  459865
  459866
  460421
  460694
  461337
  461348
  461596
  463344
  463654
  464082
  464516
  464694
  465162
  465738
  472145
  473616
  476013
  476405
  477235
  478743
  478861
  479164
  479558
  479632
  480960
  483032
  483051
  483056
  483172
  486633
  491177
  491332
  495002
  495088
  499951
  500010
  501397
  502604
  502938
  502988
  505161
  505526
  506615
  507904
  508309
  508549
  509819
  510016
  510203
  511602
  512738
  516425
  519024
  519664
  526092
  526602
  526996
  527675
  527788
  527965
  528550
  534494
  534512
  542284
  552460
  555563
  555930
  557361
  560002
  567181
  567194
  581721
  582330
  582382
  584560
  594152
  596642
  597198
  598198
  599150
  599376
  599421
  599713
  621055
  624390
  626153
  628653
  676424
  813127
]
17.45 ms
(4.28%)
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
  438114
  444067
  454876
  459580
  464516
  477235
  444429
  459866
  459987
  463654
  465738
  478861
  442402
  442416
  472145
  478743
  500010
  502938
  491332
  534512
  483056
  486633
  508309
  508549
  527675
  483051
  506615
  519664
  594152
  624390
  528550
  526996
  476405
  495002
  424238
  441366
  444620
  419008
  434156
  429782
  453437
  464082
  473616
  491177
  450530
  459865
  479164
  454929
  507904
  534494
  502604
  510203
  519024
  505526
  526602
  461337
  461348
  581721
  582330
  542284
  557361
  567181
  567194
  560002
  676424
  552460
  555563
  555930
  582382
  584560
  597198
  599376
  598198
  599421
  626153
  599150
  599713
  628653
  596642
  621055
  813127
  455787
  460421
  460694
  479632
  433220
  433829
  437876
  453801
  480960
  431954
  435346
  441929
  444184
  458179
  461596
  464694
  479558
  429455
  456300
  463344
  437383
  455653
  465162
  476013
  499951
  505161
  509819
  510016
  511602
  512738
  516425
  527788
  483172
  502988
  526092
  527965
  483032
  495088
  501397
]
2.37 ms
(0.58%)
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
  419008
  424238
  429455
  429782
  431954
  433220
  433829
  434156
  435346
  437383
  437876
  438114
  441366
  441929
  442402
  442416
  444067
  444184
  444429
  444620
  450530
  453437
  453801
  454876
  454929
  455653
  455787
  456300
  458179
  459580
  459865
  459866
  460421
  460694
  461337
  461348
  461596
  463344
  463654
  464082
  464516
  464694
  465162
  465738
  472145
  473616
  476013
  476405
  477235
  478743
  478861
  479164
  479558
  479632
  480960
  483032
  483051
  483056
  483172
  486633
  491177
  491332
  495002
  495088
  499951
  500010
  501397
  502604
  502938
  502988
  505161
  505526
  506615
  507904
  508309
  508549
  509819
  510016
  510203
  511602
  512738
  516425
  519024
  519664
  526092
  526602
  526996
  527675
  527788
  527965
  528550
  534494
  534512
  542284
  552460
  555563
  555930
  557361
  560002
  567181
  567194
  581721
  582330
  582382
  584560
  594152
  596642
  597198
  598198
  599150
  599376
  599421
  599713
  621055
  624390
  626153
  628653
  676424
  813127
]
2.26 ms
(0.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов step sister"
]
1.80 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov step sister"
]
1.59 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов step sister"
]

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.