GET https://search.jues.net/search/embeds/3?q=%D0%BD%D0%B0%20%D0%BA%D1%83%D1%85%D0%BD%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
194.92 ms
(87.44%)
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
  326017
  327638
  365875
  381917
  382444
  384030
  388878
  389798
  391106
  391114
  392028
  394329
  396024
  396171
  400497
  400811
  407791
  408179
  409390
  415636
  415797
  417875
  419552
  422339
  434251
  446293
  447962
  450220
  452015
  455378
  455428
  456960
  461989
  462943
  465771
  482029
  488224
  494642
  495369
  497005
  497441
  498939
  500576
  503985
  505622
  506079
  510573
  511605
  511787
  511789
  512577
  512739
  517282
  519653
  520359
  520698
  521407
  522770
  523170
  532138
  537006
  543306
  546631
  549534
  549669
  551960
  552340
  554985
  555582
  555593
  556684
  557327
  558160
  558461
  561401
  562341
  563016
  564398
  565774
  566107
  566880
  567405
  567418
  567419
  567884
  569023
  571138
  572882
  579811
  580214
  580866
  584639
  590501
  590975
  590977
  591011
  591028
  591059
  591061
  591218
  591452
  591468
  591485
  591494
  591519
  591536
  591566
  591735
  599720
  604999
  609197
  610112
  621687
  622722
  631750
  636249
  645939
  656672
  660457
  691221
]
16.42 ms
(7.36%)
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
  555593
  591519
  591536
  591735
  631750
  590977
  591011
  591485
  591494
  604999
  391106
  465771
  417875
  511605
  551960
  580866
  434251
  452015
  622722
  365875
  388878
  549534
  571138
  656672
  384030
  381917
  389798
  396024
  497005
  562341
  455378
  495369
  512577
  494642
  511787
  510573
  519653
  537006
  565774
  567418
  645939
  591028
  591566
  590501
  591452
  591468
  488224
  506079
  523170
  500576
  512739
  517282
  520359
  522770
  503985
  532138
  543306
  558160
  584639
  555582
  563016
  569023
  572882
  599720
  610112
  394329
  327638
  382444
  396171
  407791
  415636
  456960
  566107
  392028
  409390
  462943
  419552
  455428
  450220
  400811
  554985
  557327
  552340
  566880
  579811
  546631
  660457
  590975
  591059
  621687
  636249
  591218
  391114
  564398
  497441
  567884
  498939
  415797
  561401
  567405
  691221
  400497
  408179
  447962
  446293
  511789
  558461
  422339
  326017
  461989
  482029
  505622
  520698
  521407
  549669
  556684
  567419
  580214
  591061
  609197
]
3.85 ms
(1.73%)
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
  326017
  327638
  365875
  381917
  382444
  384030
  388878
  389798
  391106
  391114
  392028
  394329
  396024
  396171
  400497
  400811
  407791
  408179
  409390
  415636
  415797
  417875
  419552
  422339
  434251
  446293
  447962
  450220
  452015
  455378
  455428
  456960
  461989
  462943
  465771
  482029
  488224
  494642
  495369
  497005
  497441
  498939
  500576
  503985
  505622
  506079
  510573
  511605
  511787
  511789
  512577
  512739
  517282
  519653
  520359
  520698
  521407
  522770
  523170
  532138
  537006
  543306
  546631
  549534
  549669
  551960
  552340
  554985
  555582
  555593
  556684
  557327
  558160
  558461
  561401
  562341
  563016
  564398
  565774
  566107
  566880
  567405
  567418
  567419
  567884
  569023
  571138
  572882
  579811
  580214
  580866
  584639
  590501
  590975
  590977
  591011
  591028
  591059
  591061
  591218
  591452
  591468
  591485
  591494
  591519
  591536
  591566
  591735
  599720
  604999
  609197
  610112
  621687
  622722
  631750
  636249
  645939
  656672
  660457
  691221
]
2.22 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на кухня"
]
2.16 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на кухн"
]
1.55 ms
(0.69%)
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.