GET https://search.jues.net/search/embeds/3?q=%D0%B7%D0%B0%D1%81%D1%82%D1%80%D1%8F%D0%BB%20%D0%B2

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
199.25 ms
(88.86%)
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
  394355
  410128
  417303
  417337
  417372
  418918
  421400
  447795
  447804
  448096
  448717
  448949
  449418
  450830
  459086
  459131
  459137
  459150
  459948
  469345
  471457
  471458
  475011
  480245
  482301
  492831
  501326
  503087
  506019
  507204
  509328
  509331
  509336
  510217
  516411
  516479
  519021
  519534
  519562
  519595
  520534
  521465
  521473
  523374
  532140
  539753
  549172
  549660
  551491
  552823
  556990
  558078
  558473
  559688
  559695
  559699
  559700
  559701
  559702
  559704
  559706
  560853
  560879
  561580
  564152
  569428
  570876
  570957
  570975
  573743
  580061
  580715
  581584
  582797
  587397
  588024
  591732
  592345
  595451
  596946
  598736
  599152
  599267
  599559
  600808
  601243
  601868
  601935
  608319
  609141
  611283
  611383
  613007
  618333
  623457
  625642
  630359
  636084
  639619
  645096
  670755
  672040
  672110
  672147
  690366
  702128
  707673
  710389
  712449
  715401
  745591
  746827
  747107
  766504
  792012
  796091
  796935
  800906
  801251
  814499
]
13.48 ms
(6.01%)
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
  601935
  448717
  448949
  417372
  492831
  712449
  569428
  447795
  670755
  596946
  559695
  588024
  417337
  450830
  601868
  516411
  459137
  581584
  630359
  599152
  570876
  421400
  519595
  570957
  469345
  509328
  582797
  394355
  623457
  611283
  516479
  672040
  611383
  600808
  792012
  796935
  418918
  814499
  702128
  715401
  608319
  766504
  459150
  552823
  573743
  747107
  449418
  506019
  558078
  672147
  609141
  745591
  471458
  800906
  561580
  591732
  507204
  559706
  690366
  707673
  639619
  636084
  801251
  710389
  459948
  559701
  559702
  559699
  570975
  459131
  501326
  519534
  520534
  564152
  459086
  448096
  592345
  471457
  523374
  509331
  551491
  559700
  672110
  601243
  539753
  410128
  559688
  549172
  598736
  599267
  595451
  746827
  625642
  796091
  503087
  521473
  519021
  560879
  480245
  482301
  509336
  560853
  417303
  521465
  519562
  559704
  580061
  618333
  599559
  475011
  532140
  587397
  447804
  549660
  613007
  510217
  556990
  558473
  645096
  580715
]
4.78 ms
(2.13%)
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
  394355
  410128
  417303
  417337
  417372
  418918
  421400
  447795
  447804
  448096
  448717
  448949
  449418
  450830
  459086
  459131
  459137
  459150
  459948
  469345
  471457
  471458
  475011
  480245
  482301
  492831
  501326
  503087
  506019
  507204
  509328
  509331
  509336
  510217
  516411
  516479
  519021
  519534
  519562
  519595
  520534
  521465
  521473
  523374
  532140
  539753
  549172
  549660
  551491
  552823
  556990
  558078
  558473
  559688
  559695
  559699
  559700
  559701
  559702
  559704
  559706
  560853
  560879
  561580
  564152
  569428
  570876
  570957
  570975
  573743
  580061
  580715
  581584
  582797
  587397
  588024
  591732
  592345
  595451
  596946
  598736
  599152
  599267
  599559
  600808
  601243
  601868
  601935
  608319
  609141
  611283
  611383
  613007
  618333
  623457
  625642
  630359
  636084
  639619
  645096
  670755
  672040
  672110
  672147
  690366
  702128
  707673
  710389
  712449
  715401
  745591
  746827
  747107
  766504
  792012
  796091
  796935
  800906
  801251
  814499
]
2.00 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "застрял в"
]
1.70 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "застря в"
]
1.41 ms
(0.63%)
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.