GET https://search.jues.net/search/embeds/4?q=%D0%BC%D1%83%D0%B6%20%D0%B4%D0%B5%D0%BB%D0%B8%D1%82%D1%81%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.96 ms
(82.38%)
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
  386623
  390508
  398949
  423858
  442171
  455974
  456432
  458784
  460178
  466134
  484441
  485851
  497859
  498368
  502136
  506842
  506924
  510220
  516070
  517622
  518081
  522446
  524234
  527225
  527326
  528632
  535718
  541994
  543392
  546994
  554615
  561289
  561441
  562955
  564263
  566187
  571308
  572214
  573410
  573749
  573756
  574995
  575233
  577422
  577437
  579848
  580771
  581427
  582459
  583688
  585771
  587860
  589132
  589598
  591165
  591167
  593835
  595785
  596766
  598185
  599525
  603669
  609606
  613536
  614020
  614565
  615673
  623620
  625594
  636576
  637280
  642521
  650646
  653618
  662140
  662922
  670205
  675951
  700263
  710030
  713312
  717603
  719057
  719808
  735855
  736798
  738653
  739916
  742675
  742677
  743906
  745404
  748432
  751026
  753505
  755011
  755170
  756880
  758388
  761102
  761230
  762402
  766321
  766734
  779939
  781306
  788402
  790962
  793337
  796203
  799209
  800936
  800937
  802182
  808418
  811461
  811770
  812998
  813071
  813483
]
18.80 ms
(12.30%)
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
  527326
  650646
  713312
  799209
  591167
  599525
  603669
  736798
  755011
  753505
  535718
  710030
  662140
  662922
  675951
  700263
  596766
  613536
  637280
  636576
  615673
  756880
  758388
  766321
  811461
  762402
  761230
  609606
  788402
  796203
  812998
  813071
  485851
  719057
  517622
  502136
  583688
  581427
  591165
  742675
  751026
  742677
  779939
  573410
  577422
  460178
  719808
  653618
  739916
  506842
  518081
  524234
  554615
  561441
  574995
  562955
  589132
  598185
  642521
  595785
  790962
  802182
  811770
  813483
  745404
  781306
  800936
  766734
  761102
  458784
  423858
  516070
  497859
  522446
  498368
  735855
  546994
  566187
  572214
  589598
  755170
  743906
  456432
  793337
  738653
  717603
  748432
  386623
  571308
  510220
  527225
  541994
  573749
  582459
  561289
  580771
  670205
  564263
  573756
  579848
  614020
  623620
  625594
  466134
  484441
  528632
  585771
  506924
  800937
  808418
  442171
  543392
  455974
  398949
  577437
  587860
  575233
  593835
  614565
  390508
]
2.21 ms
(1.45%)
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
  386623
  390508
  398949
  423858
  442171
  455974
  456432
  458784
  460178
  466134
  484441
  485851
  497859
  498368
  502136
  506842
  506924
  510220
  516070
  517622
  518081
  522446
  524234
  527225
  527326
  528632
  535718
  541994
  543392
  546994
  554615
  561289
  561441
  562955
  564263
  566187
  571308
  572214
  573410
  573749
  573756
  574995
  575233
  577422
  577437
  579848
  580771
  581427
  582459
  583688
  585771
  587860
  589132
  589598
  591165
  591167
  593835
  595785
  596766
  598185
  599525
  603669
  609606
  613536
  614020
  614565
  615673
  623620
  625594
  636576
  637280
  642521
  650646
  653618
  662140
  662922
  670205
  675951
  700263
  710030
  713312
  717603
  719057
  719808
  735855
  736798
  738653
  739916
  742675
  742677
  743906
  745404
  748432
  751026
  753505
  755011
  755170
  756880
  758388
  761102
  761230
  762402
  766321
  766734
  779939
  781306
  788402
  790962
  793337
  796203
  799209
  800936
  800937
  802182
  808418
  811461
  811770
  812998
  813071
  813483
]
1.64 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "муж делится"
]
1.46 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен дел"
]
1.27 ms
(0.83%)
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.