GET https://search.jues.net/search/embeds/2?q=mom%20%D1%81%D1%8E%D0%B6%D0%B5%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.04 ms
(86.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
  487730
  488123
  501477
  504521
  507916
  511851
  517267
  518976
  519278
  532017
  533425
  542817
  545844
  546017
  546640
  554394
  554411
  556664
  558536
  561119
  561923
  562770
  562773
  562950
  563108
  564821
  565571
  566221
  568148
  568149
  569947
  570742
  572767
  573379
  574364
  576658
  577422
  578059
  578121
  580751
  581157
  582249
  586469
  586483
  586940
  587553
  588314
  588349
  588633
  589097
  591010
  594765
  594788
  594811
  594861
  594880
  595988
  596227
  596445
  597863
  598113
  598861
  601274
  601278
  601724
  601753
  601838
  603249
  603344
  604395
  604723
  605415
  605459
  605613
  605637
  606863
  607052
  608124
  610119
  610339
  610375
  610619
  610623
  610677
  611245
  612051
  613855
  614339
  615554
  619141
  619151
  621402
  623381
  623871
  626890
  628423
  642702
  647362
  663265
  665492
  671639
  672771
  673097
  673992
  674059
  674360
  674740
  676176
  681434
  682187
  683582
  684232
  685579
  685613
  685852
  686017
  687917
  688069
  690410
  691201
]
12.34 ms
(7.41%)
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
  673097
  682187
  686017
  687917
  671639
  681434
  685579
  685613
  691201
  672771
  673992
  674059
  684232
  546640
  573379
  577422
  580751
  588349
  595988
  601278
  601838
  605613
  610375
  610677
  588314
  591010
  594880
  598113
  598861
  601753
  610619
  613855
  587553
  589097
  596445
  601274
  610339
  604723
  606863
  608124
  610623
  615554
  623871
  626890
  604395
  623381
  518976
  504521
  517267
  556664
  501477
  511851
  532017
  533425
  487730
  542817
  546017
  554394
  558536
  565571
  566221
  582249
  568148
  569947
  572767
  576658
  545844
  561119
  562773
  563108
  568149
  570742
  578059
  663265
  665492
  676176
  690410
  674360
  674740
  683582
  685852
  688069
  647362
  554411
  561923
  562770
  562950
  564821
  574364
  578121
  581157
  588633
  594861
  607052
  619151
  586940
  594765
  594788
  594811
  601724
  603249
  610119
  586483
  596227
  597863
  605459
  619141
  621402
  586469
  603344
  605415
  605637
  614339
  642702
  611245
  612051
  628423
  488123
  507916
  519278
]
3.22 ms
(1.94%)
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
  487730
  488123
  501477
  504521
  507916
  511851
  517267
  518976
  519278
  532017
  533425
  542817
  545844
  546017
  546640
  554394
  554411
  556664
  558536
  561119
  561923
  562770
  562773
  562950
  563108
  564821
  565571
  566221
  568148
  568149
  569947
  570742
  572767
  573379
  574364
  576658
  577422
  578059
  578121
  580751
  581157
  582249
  586469
  586483
  586940
  587553
  588314
  588349
  588633
  589097
  591010
  594765
  594788
  594811
  594861
  594880
  595988
  596227
  596445
  597863
  598113
  598861
  601274
  601278
  601724
  601753
  601838
  603249
  603344
  604395
  604723
  605415
  605459
  605613
  605637
  606863
  607052
  608124
  610119
  610339
  610375
  610619
  610623
  610677
  611245
  612051
  613855
  614339
  615554
  619141
  619151
  621402
  623381
  623871
  626890
  628423
  642702
  647362
  663265
  665492
  671639
  672771
  673097
  673992
  674059
  674360
  674740
  676176
  681434
  682187
  683582
  684232
  685579
  685613
  685852
  686017
  687917
  688069
  690410
  691201
]
2.22 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom сюжет"
]
1.75 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom сюжет"
]
1.54 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom сюжет"
]

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.