GET https://search.jues.net/search/embeds/4?q=%D0%B3%D0%BE%D0%BB%D1%8C%D1%84%D0%B0%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
223.51 ms
(88.39%)
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
  373950
  399861
  420517
  426359
  426362
  431335
  431514
  432288
  432297
  436139
  436735
  442573
  446796
  447532
  447549
  447560
  447914
  448210
  449320
  450722
  452268
  457495
  462377
  464842
  467929
  468189
  468724
  472114
  474322
  476448
  478044
  482087
  483739
  487197
  487202
  488153
  490268
  491190
  491839
  495014
  496042
  497301
  498520
  499765
  499812
  500504
  500694
  501734
  502499
  502703
  504700
  504765
  508838
  509322
  511078
  512440
  515847
  516782
  517454
  518366
  520740
  521119
  521855
  522280
  522463
  522724
  524203
  524400
  526564
  526593
  528041
  528768
  529244
  530507
  536738
  544992
  545009
  548582
  554288
  555510
  558786
  559295
  564385
  564772
  565170
  569567
  569668
  571245
  576301
  578685
  579098
  579312
  580702
  583254
  583654
  584794
  586734
  589400
  590174
  591867
  593966
  594460
  597750
  598118
  598193
  598858
  602829
  603168
  603835
  609890
  611479
  619165
  621171
  621650
  648593
  676492
  680206
  680859
]
18.60 ms
(7.36%)
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
  457495
  509322
  521119
  490268
  487202
  491839
  496042
  522463
  491190
  511078
  521855
  373950
  399861
  436139
  446796
  448210
  474322
  482087
  447914
  468724
  497689
  512440
  499765
  499812
  504765
  524400
  536738
  502499
  515847
  554288
  559295
  569567
  548582
  564385
  576301
  541345
  555510
  580702
  583254
  680859
  578685
  584794
  590174
  597750
  609890
  611479
  591867
  594460
  621650
  593966
  598193
  598858
  621171
  436735
  462377
  467929
  468189
  426359
  447549
  450722
  420517
  447532
  452268
  431335
  449320
  464842
  472114
  526593
  529244
  483739
  488153
  498520
  432297
  442573
  487197
  478044
  518366
  502703
  516782
  528041
  500504
  501734
  528768
  522724
  524203
  476448
  545009
  583654
  564772
  571245
  676492
  680206
  648593
  565170
  569668
  579098
  579312
  603835
  619165
  589400
  603168
  586734
  598118
  602829
  447560
  431514
  432288
  426362
  495014
  520740
  522280
  526564
  504700
  497301
  500694
  508838
  517454
  530507
  544992
  558786
]
3.71 ms
(1.47%)
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
  373950
  399861
  420517
  426359
  426362
  431335
  431514
  432288
  432297
  436139
  436735
  442573
  446796
  447532
  447549
  447560
  447914
  448210
  449320
  450722
  452268
  457495
  462377
  464842
  467929
  468189
  468724
  472114
  474322
  476448
  478044
  482087
  483739
  487197
  487202
  488153
  490268
  491190
  491839
  495014
  496042
  497301
  498520
  499765
  499812
  500504
  500694
  501734
  502499
  502703
  504700
  504765
  508838
  509322
  511078
  512440
  515847
  516782
  517454
  518366
  520740
  521119
  521855
  522280
  522463
  522724
  524203
  524400
  526564
  526593
  528041
  528768
  529244
  530507
  536738
  544992
  545009
  548582
  554288
  555510
  558786
  559295
  564385
  564772
  565170
  569567
  569668
  571245
  576301
  578685
  579098
  579312
  580702
  583254
  583654
  584794
  586734
  589400
  590174
  591867
  593966
  594460
  597750
  598118
  598193
  598858
  602829
  603168
  603835
  609890
  611479
  619165
  621171
  621650
  648593
  676492
  680206
  680859
]
2.23 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "гольфах"
]
1.90 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "гольф"
]
1.50 ms
(0.59%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.57%)
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.