GET https://search.jues.net/search/embeds/7?q=%D0%B4%D0%B2%D0%BE%D0%B9%D0%BD%D0%B0%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.83 ms
(88.54%)
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
  417066
  426390
  432944
  435407
  465253
  469084
  471132
  476186
  486161
  505637
  507814
  508213
  518052
  521345
  525710
  526160
  531188
  531200
  532174
  532363
  532916
  533003
  533653
  534566
  534808
  536207
  536286
  536614
  537936
  539013
  544439
  547470
  550294
  550665
  555091
  555752
  556795
  561416
  564495
  570118
  572226
  581281
  583688
  585294
  587605
  589071
  590741
  596815
  597242
  597269
  597275
  599893
  601593
  601622
  605337
  609121
  609802
  615459
  619408
  620316
  623263
  623296
  630679
  637664
  637721
  639254
  647311
  648937
  649147
  649180
  650827
  656502
  661891
  665662
  666470
  666879
  666886
  671749
  671756
  671759
  672999
  677958
  681271
  684014
  685667
  686658
  699596
  706939
  708110
  708449
  710412
  713014
  715795
  716745
  719841
  720050
  720711
  721445
  723560
  775479
  775744
  775836
  775846
  777012
  782452
  782653
  790962
  795593
  798948
  801931
  803392
  804765
  806113
  806140
  806384
  811425
  814361
  814556
  815080
  815132
]
14.22 ms
(7.08%)
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
  426390
  432944
  435407
  417066
  723560
  814361
  815132
  814556
  815080
  465253
  469084
  476186
  486161
  471132
  507814
  531200
  536207
  508213
  521345
  525710
  526160
  532174
  532363
  533003
  536286
  536614
  505637
  531188
  533653
  534566
  534808
  518052
  532916
  537936
  539013
  544439
  550665
  583688
  547470
  570118
  581281
  550294
  555091
  555752
  561416
  564495
  648937
  649147
  666470
  666886
  671756
  671759
  677958
  699596
  647311
  649180
  650827
  656502
  666879
  671749
  681271
  686658
  706939
  713014
  715795
  716745
  719841
  720711
  661891
  665662
  672999
  684014
  685667
  708110
  708449
  710412
  720050
  721445
  556795
  572226
  599893
  609121
  609802
  619408
  623263
  597242
  615459
  637664
  585294
  587605
  589071
  590741
  597269
  597275
  623296
  637721
  596815
  601593
  601622
  605337
  620316
  630679
  639254
  775836
  775846
  782653
  790962
  795593
  798948
  801931
  803392
  804765
  806113
  806140
  806384
  811425
  775479
  775744
  777012
  782452
]
2.47 ms
(1.23%)
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
  417066
  426390
  432944
  435407
  465253
  469084
  471132
  476186
  486161
  505637
  507814
  508213
  518052
  521345
  525710
  526160
  531188
  531200
  532174
  532363
  532916
  533003
  533653
  534566
  534808
  536207
  536286
  536614
  537936
  539013
  544439
  547470
  550294
  550665
  555091
  555752
  556795
  561416
  564495
  570118
  572226
  581281
  583688
  585294
  587605
  589071
  590741
  596815
  597242
  597269
  597275
  599893
  601593
  601622
  605337
  609121
  609802
  615459
  619408
  620316
  623263
  623296
  630679
  637664
  637721
  639254
  647311
  648937
  649147
  649180
  650827
  656502
  661891
  665662
  666470
  666879
  666886
  671749
  671756
  671759
  672999
  677958
  681271
  684014
  685667
  686658
  699596
  706939
  708110
  708449
  710412
  713014
  715795
  716745
  719841
  720050
  720711
  721445
  723560
  775479
  775744
  775836
  775846
  777012
  782452
  782653
  790962
  795593
  798948
  801931
  803392
  804765
  806113
  806140
  806384
  811425
  814361
  814556
  815080
  815132
]
2.10 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "двойная"
]
1.54 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "двойн"
]
1.47 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.21 ms
(0.60%)
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.