GET https://search.jues.net/search/embeds/2?q=%D0%BD%D0%B0%20%D0%B2%D0%B5%D1%81%D1%83%20%D0%B5%D1%91

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.75 ms
(81.32%)
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
  448924
  468010
  468586
  469595
  473216
  473541
  475660
  477581
  477587
  478301
  481615
  485279
  488751
  489424
  495066
  495647
  496802
  499789
  500600
  505504
  507296
  511368
  513882
  519171
  521412
  523860
  524534
  525248
  526853
  527198
  529198
  529405
  530024
  530382
  530832
  531106
  531187
  531436
  533557
  538023
  538360
  541661
  541919
  543456
  543844
  543860
  545382
  545615
  546201
  546800
  550315
  553494
  555509
  555789
  558027
  558217
  565038
  565153
  565172
  568347
  568502
  568561
  577409
  581320
  581712
  582012
  583507
  584740
  590155
  591618
  593373
  593835
  594899
  596054
  597227
  598118
  598249
  599414
  600880
  601324
  602935
  602939
  604483
  612335
  612439
  613463
  622714
  624142
  624221
  624832
  625244
  625526
  628126
  628383
  630193
  632006
  632314
  632563
  633423
  634212
  642766
  647355
  649838
  649893
  653870
  660710
  663789
  667646
  667695
  672713
  673965
  677784
  678522
  680183
  680193
  680709
  680859
  682909
  684343
  691221
]
19.66 ms
(12.32%)
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
  495066
  511368
  477581
  543456
  581712
  672713
  680709
  598249
  477587
  499789
  481615
  568561
  448924
  663789
  500600
  525248
  602935
  582012
  691221
  590155
  612439
  594899
  558027
  568347
  568502
  680859
  680193
  591618
  599414
  600880
  684343
  553494
  581320
  624142
  478301
  546800
  649838
  524534
  667695
  667646
  541919
  473216
  565038
  473541
  682909
  604483
  597227
  598118
  624221
  485279
  523860
  531436
  507296
  555509
  584740
  558217
  632314
  625244
  624832
  660710
  546201
  593835
  625526
  622714
  673965
  521412
  529405
  538023
  529198
  612335
  496802
  531106
  545615
  634212
  488751
  495647
  632006
  593373
  468586
  468010
  545382
  577409
  680183
  630193
  649893
  613463
  527198
  647355
  565172
  505504
  519171
  526853
  530832
  538360
  513882
  602939
  550315
  541661
  489424
  469595
  565153
  653870
  633423
  583507
  543860
  543844
  530024
  531187
  678522
  628383
  677784
  555789
  628126
  642766
  530382
  601324
  596054
  632563
  533557
  475660
]
3.31 ms
(2.07%)
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
  448924
  468010
  468586
  469595
  473216
  473541
  475660
  477581
  477587
  478301
  481615
  485279
  488751
  489424
  495066
  495647
  496802
  499789
  500600
  505504
  507296
  511368
  513882
  519171
  521412
  523860
  524534
  525248
  526853
  527198
  529198
  529405
  530024
  530382
  530832
  531106
  531187
  531436
  533557
  538023
  538360
  541661
  541919
  543456
  543844
  543860
  545382
  545615
  546201
  546800
  550315
  553494
  555509
  555789
  558027
  558217
  565038
  565153
  565172
  568347
  568502
  568561
  577409
  581320
  581712
  582012
  583507
  584740
  590155
  591618
  593373
  593835
  594899
  596054
  597227
  598118
  598249
  599414
  600880
  601324
  602935
  602939
  604483
  612335
  612439
  613463
  622714
  624142
  624221
  624832
  625244
  625526
  628126
  628383
  630193
  632006
  632314
  632563
  633423
  634212
  642766
  647355
  649838
  649893
  653870
  660710
  663789
  667646
  667695
  672713
  673965
  677784
  678522
  680183
  680193
  680709
  680859
  682909
  684343
  691221
]
2.16 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на весу её"
]
1.67 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на вес"
]
1.52 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.94%)
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.