GET https://search.jues.net/search/embeds/3?q=%D1%81%D0%B8%D0%B4%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.79 ms
(85.06%)
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
  39059
  86568
  193761
  227213
  256975
  312447
  381823
  381913
  382312
  382354
  383989
  384137
  385500
  388364
  389019
  390720
  391045
  396071
  397390
  397516
  398685
  400950
  401508
  404422
  411151
  411196
  416112
  418019
  420633
  425549
  426485
  426997
  429643
  432481
  432534
  433707
  436068
  436845
  438482
  439869
  440986
  441193
  443115
  444105
  447556
  448749
  449990
  450155
  451106
  452344
  452695
  454684
  455101
  456378
  457218
  458952
  460012
  461806
  465579
  465939
  467013
  470030
  470033
  471031
  471471
  474057
  475282
  477429
  478726
  478759
  480557
  480651
  483358
  487280
  489779
  492091
  493339
  496020
  503402
  505768
  510942
  511885
  526804
  529044
  530416
  534370
  534447
  534735
  542736
  544089
  554654
  555738
  560673
  562850
  565662
  567612
  569878
  569935
  570111
  573290
  575026
  576182
  599447
  621116
  622322
  656027
  656677
  658358
  659430
  659449
  662807
  665633
  668025
  669903
  711531
  717139
  782675
  795707
  803873
  810622
]
18.09 ms
(9.23%)
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
  460012
  475282
  530416
  534735
  534447
  465939
  471471
  474057
  544089
  570111
  573290
  555738
  658358
  659449
  662807
  717139
  665633
  656027
  656677
  711531
  567612
  622322
  599447
  621116
  782675
  803873
  795707
  810622
  382354
  396071
  398685
  429643
  443115
  448749
  480651
  385500
  193761
  383989
  397390
  432481
  436845
  455101
  458952
  465579
  256975
  382312
  432534
  39059
  426997
  433707
  449990
  454684
  470030
  478726
  478759
  480557
  411151
  440986
  470033
  511885
  503402
  526804
  529044
  510942
  492091
  505768
  86568
  384137
  227213
  312447
  381823
  381913
  389019
  388364
  390720
  391045
  397516
  400950
  401508
  404422
  416112
  420633
  425549
  438482
  441193
  426485
  436068
  439869
  444105
  418019
  411196
  452344
  477429
  487280
  447556
  450155
  452695
  456378
  457218
  467013
  483358
  451106
  461806
  471031
  489779
  534370
  496020
  493339
  560673
  562850
  565662
  569878
  542736
  569935
  554654
  575026
  576182
  659430
  669903
  668025
]
3.52 ms
(1.80%)
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
  39059
  86568
  193761
  227213
  256975
  312447
  381823
  381913
  382312
  382354
  383989
  384137
  385500
  388364
  389019
  390720
  391045
  396071
  397390
  397516
  398685
  400950
  401508
  404422
  411151
  411196
  416112
  418019
  420633
  425549
  426485
  426997
  429643
  432481
  432534
  433707
  436068
  436845
  438482
  439869
  440986
  441193
  443115
  444105
  447556
  448749
  449990
  450155
  451106
  452344
  452695
  454684
  455101
  456378
  457218
  458952
  460012
  461806
  465579
  465939
  467013
  470030
  470033
  471031
  471471
  474057
  475282
  477429
  478726
  478759
  480557
  480651
  483358
  487280
  489779
  492091
  493339
  496020
  503402
  505768
  510942
  511885
  526804
  529044
  530416
  534370
  534447
  534735
  542736
  544089
  554654
  555738
  560673
  562850
  565662
  567612
  569878
  569935
  570111
  573290
  575026
  576182
  599447
  621116
  622322
  656027
  656677
  658358
  659430
  659449
  662807
  665633
  668025
  669903
  711531
  717139
  782675
  795707
  803873
  810622
]
2.23 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сидя"
]
2.03 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сид"
]
1.56 ms
(0.80%)
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.