GET https://search.jues.net/search/embeds/7?q=%D1%81%20%D0%B7%D0%B0%D0%B4%D0%B8%20%D1%81%D1%82%D0%BE%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.15 ms
(89.11%)
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
  415837
  445053
  448898
  465506
  472064
  479514
  479564
  480032
  480836
  487821
  498264
  500089
  511421
  515652
  520967
  523166
  524981
  527174
  527709
  530667
  535222
  535451
  537632
  543069
  545994
  546275
  547643
  547661
  548428
  549833
  550589
  552299
  554806
  558471
  559674
  559723
  560282
  561617
  562429
  564326
  565032
  565370
  565734
  566332
  566893
  566920
  567833
  567927
  570607
  570832
  571933
  573301
  573502
  575278
  577125
  578101
  578133
  578217
  578335
  581109
  584152
  584316
  586237
  586255
  586279
  588290
  588326
  588486
  589106
  589342
  591300
  591461
  591508
  592056
  592089
  593024
  597039
  601751
  602052
  602073
  604028
  605803
  606043
  606683
  607074
  607201
  608103
  608542
  610054
  611347
  613663
  617899
  618031
  618046
  618141
  620281
  621367
  621713
  622911
  626945
  627578
  628431
  634526
  642177
  651084
  655268
  663772
  663887
  664595
  666358
  668821
  673150
  681404
  686578
  686648
  687937
  698230
  775708
  776141
  781651
]
13.03 ms
(6.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
  547643
  552299
  564326
  567833
  567927
  570607
  573301
  543069
  549833
  554806
  558471
  559674
  560282
  562429
  577125
  584152
  663887
  668821
  663772
  664595
  666358
  681404
  686648
  651084
  655268
  673150
  687937
  546275
  547661
  548428
  559723
  561617
  565032
  565370
  565734
  566893
  566920
  570832
  573502
  575278
  578101
  578133
  578217
  578335
  584316
  586237
  586255
  589106
  592089
  593024
  597039
  602052
  607201
  588290
  588326
  589342
  592056
  601751
  604028
  606043
  606683
  618141
  621713
  622911
  586279
  588486
  591461
  611347
  613663
  642177
  591300
  591508
  605803
  617899
  620281
  621367
  626945
  628431
  775708
  776141
  781651
  602073
  608103
  610054
  618031
  618046
  627578
  445053
  415837
  465506
  480032
  511421
  524981
  523166
  527174
  515652
  520967
  527709
  530667
  472064
  479564
  480836
  500089
  535222
  537632
  535451
  550589
  566332
  581109
  571933
  686578
  545994
  607074
  634526
  608542
  698230
  448898
  479514
  498264
  487821
]
2.71 ms
(1.30%)
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
  415837
  445053
  448898
  465506
  472064
  479514
  479564
  480032
  480836
  487821
  498264
  500089
  511421
  515652
  520967
  523166
  524981
  527174
  527709
  530667
  535222
  535451
  537632
  543069
  545994
  546275
  547643
  547661
  548428
  549833
  550589
  552299
  554806
  558471
  559674
  559723
  560282
  561617
  562429
  564326
  565032
  565370
  565734
  566332
  566893
  566920
  567833
  567927
  570607
  570832
  571933
  573301
  573502
  575278
  577125
  578101
  578133
  578217
  578335
  581109
  584152
  584316
  586237
  586255
  586279
  588290
  588326
  588486
  589106
  589342
  591300
  591461
  591508
  592056
  592089
  593024
  597039
  601751
  602052
  602073
  604028
  605803
  606043
  606683
  607074
  607201
  608103
  608542
  610054
  611347
  613663
  617899
  618031
  618046
  618141
  620281
  621367
  621713
  622911
  626945
  627578
  628431
  634526
  642177
  651084
  655268
  663772
  663887
  664595
  666358
  668821
  673150
  681404
  686578
  686648
  687937
  698230
  775708
  776141
  781651
]
2.04 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с зади стоя"
]
1.68 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп сто"
]
1.48 ms
(0.71%)
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.