GET https://search.jues.net/search/embeds/9?q=%D1%80%D1%8F%D0%B4

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.75 ms
(81.45%)
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
  445444
  446086
  448064
  450637
  451088
  451614
  452708
  453236
  454949
  457021
  459754
  459968
  460092
  460129
  460437
  462903
  463163
  463547
  466924
  468982
  472410
  475847
  477325
  482121
  482973
  484876
  485025
  485847
  485949
  486266
  487221
  487534
  489702
  490402
  490752
  491094
  494163
  496334
  497395
  499005
  499325
  501352
  504752
  504764
  505469
  506127
  507156
  507879
  509515
  512590
  514037
  515263
  525678
  534837
  535697
  537105
  542052
  542087
  542664
  542920
  544117
  546002
  546022
  546580
  546608
  546817
  546847
  548593
  548665
  548729
  548781
  548872
  550485
  551798
  552110
  553685
  553687
  553931
  553941
  556019
  556391
  556879
  557940
  558377
  558615
  560485
  561332
  561439
  561462
  565859
  565992
  566345
  568630
  568845
  569632
  570710
  571271
  571713
  573113
  574425
  575443
  576137
  577413
  578856
  579221
  579605
  581495
  582477
  584736
  586656
  591389
  593376
  598450
  599320
  621745
  628161
  681445
  691713
  701609
  709428
]
17.68 ms
(11.73%)
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
  466924
  472410
  475847
  485025
  485949
  489702
  445444
  446086
  451088
  451614
  452708
  453236
  459754
  460129
  460437
  463163
  463547
  482121
  484876
  487221
  491094
  448064
  450637
  454949
  457021
  462903
  468982
  485847
  486266
  487534
  490402
  490752
  497395
  499005
  504752
  504764
  506127
  509515
  512590
  515263
  525678
  537105
  494163
  501352
  507156
  514037
  534837
  496334
  499325
  505469
  507879
  535697
  459968
  460092
  477325
  482973
  542052
  542920
  548593
  548781
  552110
  553931
  553941
  561462
  571713
  573113
  575443
  579605
  542087
  546817
  546847
  548665
  553687
  558377
  560485
  568845
  569632
  570710
  574425
  582477
  542664
  544117
  546022
  546608
  548872
  550485
  551798
  553685
  556391
  561332
  561439
  565992
  566345
  568630
  571271
  576137
  578856
  584736
  691713
  681445
  701609
  709428
  546002
  546580
  548729
  556019
  556879
  557940
  558615
  565859
  577413
  579221
  581495
  586656
  598450
  628161
  591389
  593376
  599320
  621745
]
3.25 ms
(2.16%)
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
  445444
  446086
  448064
  450637
  451088
  451614
  452708
  453236
  454949
  457021
  459754
  459968
  460092
  460129
  460437
  462903
  463163
  463547
  466924
  468982
  472410
  475847
  477325
  482121
  482973
  484876
  485025
  485847
  485949
  486266
  487221
  487534
  489702
  490402
  490752
  491094
  494163
  496334
  497395
  499005
  499325
  501352
  504752
  504764
  505469
  506127
  507156
  507879
  509515
  512590
  514037
  515263
  525678
  534837
  535697
  537105
  542052
  542087
  542664
  542920
  544117
  546002
  546022
  546580
  546608
  546817
  546847
  548593
  548665
  548729
  548781
  548872
  550485
  551798
  552110
  553685
  553687
  553931
  553941
  556019
  556391
  556879
  557940
  558377
  558615
  560485
  561332
  561439
  561462
  565859
  565992
  566345
  568630
  568845
  569632
  570710
  571271
  571713
  573113
  574425
  575443
  576137
  577413
  578856
  579221
  579605
  581495
  582477
  584736
  586656
  591389
  593376
  598450
  599320
  621745
  628161
  681445
  691713
  701609
  709428
]
2.13 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ряд"
]
1.63 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ряд"
]
1.63 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ряд"
]
1.63 ms
(1.08%)
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.