GET https://search.jues.net/search/embeds/5?q=%D1%81%D0%BE%D1%81%D0%BA%D0%BE%D0%BC%20%D0%BF%D0%BE

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.20 ms
(89.59%)
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
  53805
  56805
  81174
  83083
  154512
  185335
  371790
  381939
  382436
  382944
  383137
  385199
  386325
  387415
  387759
  391407
  396790
  398012
  401650
  402772
  403242
  404018
  408705
  408835
  413289
  415036
  417697
  418976
  423972
  424576
  424851
  430585
  439260
  441118
  441750
  443424
  444512
  447758
  448911
  449478
  454342
  465887
  480220
  485863
  506771
  512368
  516400
  530327
  532325
  534634
  537335
  547312
  550151
  550564
  550635
  551684
  557292
  565981
  566674
  569774
  574181
  574487
  576244
  577258
  582736
  582757
  587160
  588481
  596372
  601186
  603513
  611039
  620321
  636413
  636499
  640293
  644543
  645992
  670588
  683445
  696112
  705347
  709155
  709769
  713344
  714290
  714563
  723013
  724562
  738029
  743778
  744556
  750197
  750560
  750935
  758142
  760273
  760625
  769384
  769439
  769556
  772141
  784435
  789244
  793487
  795290
  796064
  796404
  796771
  801605
  801611
  803953
  804257
  804350
  804666
  805252
  808567
  812407
  813823
  813954
]
11.34 ms
(5.73%)
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
  387415
  386325
  404018
  423972
  413289
  449478
  454342
  382944
  383137
  154512
  381939
  382436
  83083
  53805
  387759
  391407
  396790
  402772
  403242
  417697
  430585
  424576
  444512
  408705
  408835
  424851
  439260
  441118
  443424
  415036
  418976
  441750
  813823
  813954
  447758
  480220
  448911
  532325
  534634
  512368
  537335
  506771
  516400
  530327
  465887
  485863
  557292
  565981
  582736
  550564
  566674
  569774
  576244
  547312
  550635
  551684
  574487
  577258
  705347
  714563
  645992
  670588
  683445
  696112
  709155
  709769
  713344
  714290
  550151
  574181
  582757
  587160
  588481
  640293
  603513
  636413
  596372
  601186
  611039
  620321
  636499
  808567
  812407
  789244
  795290
  796064
  796404
  801605
  801611
  804257
  804350
  805252
  738029
  743778
  750197
  750560
  750935
  769384
  793487
  803953
  804666
  724562
  760273
  769556
  758142
  744556
  769439
  772141
  760625
  644543
  723013
  784435
  796771
  56805
  81174
  185335
  371790
  385199
  398012
  401650
]
2.81 ms
(1.42%)
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
  53805
  56805
  81174
  83083
  154512
  185335
  371790
  381939
  382436
  382944
  383137
  385199
  386325
  387415
  387759
  391407
  396790
  398012
  401650
  402772
  403242
  404018
  408705
  408835
  413289
  415036
  417697
  418976
  423972
  424576
  424851
  430585
  439260
  441118
  441750
  443424
  444512
  447758
  448911
  449478
  454342
  465887
  480220
  485863
  506771
  512368
  516400
  530327
  532325
  534634
  537335
  547312
  550151
  550564
  550635
  551684
  557292
  565981
  566674
  569774
  574181
  574487
  576244
  577258
  582736
  582757
  587160
  588481
  596372
  601186
  603513
  611039
  620321
  636413
  636499
  640293
  644543
  645992
  670588
  683445
  696112
  705347
  709155
  709769
  713344
  714290
  714563
  723013
  724562
  738029
  743778
  744556
  750197
  750560
  750935
  758142
  760273
  760625
  769384
  769439
  769556
  772141
  784435
  789244
  793487
  795290
  796064
  796404
  796771
  801605
  801611
  803953
  804257
  804350
  804666
  805252
  808567
  812407
  813823
  813954
]
1.85 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соском по"
]
1.65 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соск"
]
1.48 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.74%)
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.