GET https://search.jues.net/search/embeds/3?q=%D0%B0%D0%B3%D1%80%D0%B5%D0%B3%D0%B0%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.18 ms
(86.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
  78786
  321410
  348918
  387380
  388936
  389122
  389590
  389943
  396672
  397616
  397903
  397910
  397993
  398744
  399043
  403555
  407313
  413112
  413967
  415028
  417740
  418360
  419176
  419271
  419991
  422295
  423648
  424795
  426194
  428845
  430808
  430815
  431515
  432331
  436582
  436692
  436765
  438841
  439454
  439508
  440836
  441353
  442039
  444290
  444386
  444726
  445460
  445976
  447156
  447216
  447418
  447850
  448183
  451586
  453128
  453590
  454037
  454181
  454539
  455651
  455991
  458454
  458657
  459019
  459948
  460865
  461740
  461785
  462302
  462752
  464358
  466181
  466760
  466948
  467982
  469600
  469700
  470646
  471528
  479973
  480780
  482972
  483042
  484210
  485174
  486475
  488679
  489148
  489946
  492474
  492622
  494147
  495663
  497181
  501626
  507258
  544526
  548629
  551495
  552308
  554396
  558692
  559442
  559520
  562119
  565378
  566475
  567309
  568818
  569655
  571874
  571904
  572486
  573021
  580724
  586804
  589608
  590308
  598027
  598178
]
17.16 ms
(9.27%)
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
  78786
  389943
  388936
  387380
  396672
  397616
  397993
  398744
  403555
  417740
  424795
  440836
  441353
  444290
  413967
  419176
  419271
  423648
  436765
  439454
  442039
  413112
  430808
  431515
  415028
  426194
  432331
  444386
  444726
  445976
  448183
  453128
  453590
  454037
  454539
  455651
  455991
  458657
  462302
  466948
  467982
  469700
  479973
  482972
  484210
  486475
  492622
  447418
  447850
  454181
  458454
  461785
  464358
  466760
  480780
  483042
  489148
  492474
  445460
  459948
  470646
  471528
  488679
  489946
  494147
  495663
  497181
  501626
  507258
  460865
  461740
  469600
  485174
  548629
  551495
  558692
  565378
  571904
  572486
  573021
  544526
  552308
  554396
  559442
  566475
  567309
  568818
  580724
  559520
  562119
  569655
  571874
  586804
  589608
  590308
  598027
  598178
  321410
  348918
  389122
  389590
  397903
  397910
  399043
  407313
  418360
  419991
  422295
  428845
  430815
  436582
  436692
  438841
  439508
  447156
  447216
  451586
  459019
  462752
  466181
]
2.53 ms
(1.37%)
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
  78786
  321410
  348918
  387380
  388936
  389122
  389590
  389943
  396672
  397616
  397903
  397910
  397993
  398744
  399043
  403555
  407313
  413112
  413967
  415028
  417740
  418360
  419176
  419271
  419991
  422295
  423648
  424795
  426194
  428845
  430808
  430815
  431515
  432331
  436582
  436692
  436765
  438841
  439454
  439508
  440836
  441353
  442039
  444290
  444386
  444726
  445460
  445976
  447156
  447216
  447418
  447850
  448183
  451586
  453128
  453590
  454037
  454181
  454539
  455651
  455991
  458454
  458657
  459019
  459948
  460865
  461740
  461785
  462302
  462752
  464358
  466181
  466760
  466948
  467982
  469600
  469700
  470646
  471528
  479973
  480780
  482972
  483042
  484210
  485174
  486475
  488679
  489148
  489946
  492474
  492622
  494147
  495663
  497181
  501626
  507258
  544526
  548629
  551495
  552308
  554396
  558692
  559442
  559520
  562119
  565378
  566475
  567309
  568818
  569655
  571874
  571904
  572486
  573021
  580724
  586804
  589608
  590308
  598027
  598178
]
1.70 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "агрегат"
]
1.61 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "агрегат"
]
1.41 ms
(0.76%)
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.