GET https://search.jues.net/search/embeds/3?q=%D0%B2%D0%B7%D1%8F%D0%BB%20%D1%80%D0%B0%D0%BA%D0%BE%D0%BC

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.02 ms
(83.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
  307940
  405156
  446988
  448083
  459524
  462098
  475980
  482525
  484372
  488596
  490852
  492169
  506429
  511469
  512903
  513431
  516263
  516890
  517092
  520346
  520573
  521243
  521428
  523045
  525870
  528217
  543061
  546786
  547242
  551259
  554778
  554790
  556577
  556735
  557021
  558223
  562368
  563479
  564009
  567522
  568072
  568328
  568382
  568741
  570277
  572495
  572774
  573486
  573557
  577421
  579062
  582631
  584703
  586180
  589665
  589721
  592347
  594819
  594830
  595178
  595471
  595588
  595871
  596467
  596627
  597125
  597256
  597559
  597831
  598046
  598449
  598887
  598953
  599359
  601856
  601867
  601976
  602397
  602483
  603981
  604541
  605105
  606016
  607045
  608242
  608364
  608448
  611477
  613282
  613316
  613396
  613401
  613970
  614573
  615623
  616787
  617039
  617370
  619308
  620124
  620216
  620320
  621203
  622248
  623260
  623378
  624731
  625404
  626541
  628273
  632569
  639159
  651937
  652236
  652592
  652594
  653557
  653559
  653560
  679076
]
16.27 ms
(10.06%)
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
  516263
  556577
  589665
  624731
  446988
  448083
  528217
  513431
  521243
  525870
  652236
  679076
  568741
  595471
  613282
  613401
  620124
  596627
  488596
  520346
  547242
  567522
  572495
  573486
  598046
  307940
  651937
  653560
  606016
  546786
  584703
  570277
  652592
  551259
  595588
  621203
  611477
  632569
  595178
  597559
  608364
  619308
  520573
  572774
  543061
  568382
  586180
  594819
  598887
  620320
  622248
  597256
  598449
  602483
  608242
  613316
  613970
  617370
  597125
  601867
  602397
  603981
  604541
  605105
  462098
  405156
  512903
  613396
  558223
  562368
  563479
  554778
  554790
  557021
  579062
  653557
  652594
  653559
  568072
  573557
  577421
  582631
  592347
  599359
  607045
  614573
  628273
  597831
  625404
  589721
  594830
  595871
  596467
  598953
  601856
  608448
  615623
  620216
  626541
  639159
  616787
  617039
  601976
  623260
  623378
  459524
  475980
  506429
  490852
  511469
  516890
  523045
  492169
  484372
  517092
  521428
  482525
  556735
  564009
  568328
]
4.35 ms
(2.69%)
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
  307940
  405156
  446988
  448083
  459524
  462098
  475980
  482525
  484372
  488596
  490852
  492169
  506429
  511469
  512903
  513431
  516263
  516890
  517092
  520346
  520573
  521243
  521428
  523045
  525870
  528217
  543061
  546786
  547242
  551259
  554778
  554790
  556577
  556735
  557021
  558223
  562368
  563479
  564009
  567522
  568072
  568328
  568382
  568741
  570277
  572495
  572774
  573486
  573557
  577421
  579062
  582631
  584703
  586180
  589665
  589721
  592347
  594819
  594830
  595178
  595471
  595588
  595871
  596467
  596627
  597125
  597256
  597559
  597831
  598046
  598449
  598887
  598953
  599359
  601856
  601867
  601976
  602397
  602483
  603981
  604541
  605105
  606016
  607045
  608242
  608364
  608448
  611477
  613282
  613316
  613396
  613401
  613970
  614573
  615623
  616787
  617039
  617370
  619308
  620124
  620216
  620320
  621203
  622248
  623260
  623378
  624731
  625404
  626541
  628273
  632569
  639159
  651937
  652236
  652592
  652594
  653557
  653559
  653560
  679076
]
1.79 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "взял раком"
]
1.57 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "взял рак"
]
1.39 ms
(0.86%)
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.