GET https://search.jues.net/search/embeds/3?q=%D0%BD%D0%B0%20%D0%B1%D0%B0%D0%BB%D0%BA%D0%BE%D0%BD

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.28 ms
(85.50%)
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
  384811
  391624
  391936
  405612
  419045
  420014
  443373
  444253
  445600
  445811
  446648
  448688
  452372
  454431
  456509
  462585
  463197
  468519
  469548
  471154
  471603
  472055
  472815
  472816
  475161
  477894
  478972
  479659
  479941
  481273
  483444
  484150
  484969
  488905
  490524
  490653
  491612
  498912
  499389
  501268
  502982
  503072
  504790
  505420
  505864
  508984
  510138
  514452
  515652
  520346
  520959
  522810
  524101
  524457
  525982
  527984
  528325
  528684
  532952
  540743
  542926
  543341
  544511
  545609
  546335
  546704
  551491
  552247
  552368
  552369
  552577
  555011
  556419
  558103
  558382
  560366
  561639
  566958
  568076
  568590
  569848
  570257
  570490
  570607
  571907
  571919
  572048
  572476
  573566
  573946
  580874
  584193
  586144
  588613
  591144
  592735
  594981
  595646
  598923
  600636
  602967
  606397
  607185
  612425
  616012
  621999
  636442
  650789
  653513
  698108
  701260
  736017
  759325
  764654
  772190
  773822
  797888
  805772
  809346
  810757
]
14.96 ms
(8.03%)
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
  586144
  503072
  520346
  478972
  546335
  592735
  797888
  736017
  443373
  477894
  490653
  528325
  445811
  528684
  552368
  555011
  810757
  391624
  569848
  504790
  508984
  570607
  580874
  552577
  653513
  588613
  594981
  420014
  445600
  484150
  510138
  490524
  456509
  475161
  472815
  532952
  570490
  572048
  650789
  571919
  621999
  773822
  446648
  462585
  444253
  514452
  515652
  527984
  545609
  452372
  522810
  525982
  484969
  544511
  568076
  558103
  568590
  570257
  598923
  759325
  463197
  471603
  540743
  505864
  571907
  384811
  454431
  499389
  501268
  542926
  572476
  558382
  584193
  698108
  556419
  764654
  701260
  472816
  502982
  483444
  520959
  606397
  524457
  488905
  573946
  573566
  636442
  471154
  479941
  419045
  524101
  607185
  405612
  498912
  552247
  560366
  600636
  805772
  448688
  472055
  479659
  551491
  566958
  595646
  616012
  602967
  809346
  772190
  481273
  468519
  469548
  491612
  543341
  546704
  552369
  561639
  591144
  612425
  391936
  505420
]
3.52 ms
(1.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на балкон"
]
3.08 ms
(1.65%)
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
  384811
  391624
  391936
  405612
  419045
  420014
  443373
  444253
  445600
  445811
  446648
  448688
  452372
  454431
  456509
  462585
  463197
  468519
  469548
  471154
  471603
  472055
  472815
  472816
  475161
  477894
  478972
  479659
  479941
  481273
  483444
  484150
  484969
  488905
  490524
  490653
  491612
  498912
  499389
  501268
  502982
  503072
  504790
  505420
  505864
  508984
  510138
  514452
  515652
  520346
  520959
  522810
  524101
  524457
  525982
  527984
  528325
  528684
  532952
  540743
  542926
  543341
  544511
  545609
  546335
  546704
  551491
  552247
  552368
  552369
  552577
  555011
  556419
  558103
  558382
  560366
  561639
  566958
  568076
  568590
  569848
  570257
  570490
  570607
  571907
  571919
  572048
  572476
  573566
  573946
  580874
  584193
  586144
  588613
  591144
  592735
  594981
  595646
  598923
  600636
  602967
  606397
  607185
  612425
  616012
  621999
  636442
  650789
  653513
  698108
  701260
  736017
  759325
  764654
  772190
  773822
  797888
  805772
  809346
  810757
]
1.90 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на балкон"
]
1.70 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.