GET https://search.jues.net/search/embeds/8?q=%D0%BF%D1%8B%D1%88%D0%BA%D1%83%20%D0%B2%20%D0%B4%D1%83%D1%88%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.67 ms
(87.49%)
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
  187268
  247381
  294327
  389257
  391592
  391653
  391980
  394737
  396780
  397998
  404483
  411330
  411347
  424084
  424517
  426294
  430134
  451464
  453072
  453153
  453244
  453767
  457420
  461031
  466201
  469314
  472568
  474116
  474851
  483628
  483639
  485697
  490402
  496887
  500874
  506931
  509599
  511510
  512138
  514902
  518855
  521270
  523034
  523241
  525507
  525508
  527140
  530013
  530270
  531799
  532019
  534255
  534258
  536939
  542285
  545905
  547009
  549250
  549652
  549826
  559040
  561529
  561572
  563036
  563656
  564191
  565732
  566363
  572303
  577388
  577572
  579707
  583096
  584136
  586360
  587896
  591272
  591317
  597849
  600799
  601134
  604412
  604556
  607673
  618622
  641115
  643380
  651887
  658470
  664972
  673651
  677892
  687430
  695386
  701260
  702364
  716205
  728605
  731124
  732940
  735905
  759570
  778558
  787029
  788544
  794202
  794240
  794248
  796862
  796919
  797170
  797171
  802631
  808005
  808228
  819511
  823767
  824174
  824725
  826335
]
15.95 ms
(7.99%)
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
  530013
  512138
  523241
  525507
  534255
  461031
  469314
  561529
  561572
  542285
  545905
  563656
  547009
  564191
  577388
  583096
  695386
  716205
  651887
  687430
  563036
  572303
  591317
  604412
  586360
  601134
  607673
  643380
  597849
  600799
  794240
  796919
  797171
  802631
  808228
  778558
  794202
  808005
  728605
  731124
  796862
  759570
  604556
  641115
  701260
  787029
  788544
  794248
  391653
  247381
  397998
  411330
  453767
  391980
  294327
  394737
  411347
  424084
  466201
  587896
  591272
  389257
  824725
  732940
  496887
  532019
  527140
  514902
  579707
  549826
  584136
  618622
  797170
  404483
  451464
  457420
  536939
  483628
  483639
  485697
  453244
  826335
  735905
  187268
  391592
  396780
  426294
  430134
  424517
  823767
  819511
  824174
  474116
  453072
  453153
  474851
  472568
  490402
  511510
  518855
  500874
  506931
  523034
  530270
  531799
  534258
  521270
  525508
  509599
  549250
  549652
  565732
  559040
  566363
  577572
  658470
  673651
  677892
  702364
  664972
]
2.75 ms
(1.38%)
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
  187268
  247381
  294327
  389257
  391592
  391653
  391980
  394737
  396780
  397998
  404483
  411330
  411347
  424084
  424517
  426294
  430134
  451464
  453072
  453153
  453244
  453767
  457420
  461031
  466201
  469314
  472568
  474116
  474851
  483628
  483639
  485697
  490402
  496887
  500874
  506931
  509599
  511510
  512138
  514902
  518855
  521270
  523034
  523241
  525507
  525508
  527140
  530013
  530270
  531799
  532019
  534255
  534258
  536939
  542285
  545905
  547009
  549250
  549652
  549826
  559040
  561529
  561572
  563036
  563656
  564191
  565732
  566363
  572303
  577388
  577572
  579707
  583096
  584136
  586360
  587896
  591272
  591317
  597849
  600799
  601134
  604412
  604556
  607673
  618622
  641115
  643380
  651887
  658470
  664972
  673651
  677892
  687430
  695386
  701260
  702364
  716205
  728605
  731124
  732940
  735905
  759570
  778558
  787029
  788544
  794202
  794240
  794248
  796862
  796919
  797170
  797171
  802631
  808005
  808228
  819511
  823767
  824174
  824725
  826335
]
1.84 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пышку в душе"
]
1.62 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная ван"
]
1.59 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.22 ms
(0.61%)
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.