GET https://search.jues.net/search/embeds/2?q=pmv%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.48 ms
(83.68%)
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
  88410
  336987
  337263
  386613
  392440
  392544
  392552
  392655
  393323
  394597
  396778
  397807
  398044
  398464
  398516
  398689
  399053
  402409
  408178
  408219
  411134
  412537
  416083
  417502
  417998
  418395
  419308
  419826
  420622
  421417
  422305
  422734
  423628
  423630
  423708
  424697
  425394
  432317
  433996
  434401
  437854
  438878
  440676
  442100
  444968
  447049
  450389
  451277
  453870
  453882
  455823
  459277
  465639
  465685
  467109
  468128
  469181
  469266
  469270
  472393
  472395
  472396
  482735
  495125
  507559
  510584
  523397
  528307
  529945
  529952
  530115
  532531
  532572
  537487
  540217
  542026
  542578
  545773
  545791
  545801
  545802
  545803
  545822
  545829
  545839
  546442
  550277
  550315
  550563
  550677
  552623
  566908
  574467
  579386
  583068
  583960
  596147
  596556
  598139
  600186
  603258
  604517
  604528
  605521
  605612
  616336
  631981
  632269
  632595
  632680
  632694
  632701
  636559
  644718
  656175
  656209
  656307
  688369
  768349
  823777
]
14.99 ms
(9.61%)
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
  546442
  631981
  636559
  596556
  596147
  632694
  644718
  542026
  545839
  545829
  537487
  545801
  550277
  616336
  468128
  532531
  583960
  545803
  545822
  545791
  604528
  688369
  605612
  532572
  540217
  632680
  393323
  545802
  550315
  603258
  604517
  566908
  412537
  768349
  632269
  392655
  552623
  545773
  632595
  408178
  823777
  632701
  392552
  605521
  656209
  392544
  421417
  398516
  420622
  411134
  656307
  495125
  386613
  398044
  419826
  399053
  550677
  465685
  523397
  550563
  397807
  433996
  417998
  482735
  88410
  337263
  469266
  579386
  440676
  510584
  442100
  459277
  398689
  447049
  450389
  453870
  453882
  465639
  469270
  469181
  472393
  336987
  437854
  434401
  451277
  598139
  408219
  423630
  419308
  467109
  656175
  444968
  423628
  528307
  472395
  392440
  396778
  402409
  416083
  418395
  438878
  472396
  583068
  574467
  425394
  455823
  424697
  394597
  432317
  422305
  398464
  417502
  507559
  530115
  529945
  542578
  422734
  529952
  423708
  600186
]
2.50 ms
(1.60%)
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
  88410
  336987
  337263
  386613
  392440
  392544
  392552
  392655
  393323
  394597
  396778
  397807
  398044
  398464
  398516
  398689
  399053
  402409
  408178
  408219
  411134
  412537
  416083
  417502
  417998
  418395
  419308
  419826
  420622
  421417
  422305
  422734
  423628
  423630
  423708
  424697
  425394
  432317
  433996
  434401
  437854
  438878
  440676
  442100
  444968
  447049
  450389
  451277
  453870
  453882
  455823
  459277
  465639
  465685
  467109
  468128
  469181
  469266
  469270
  472393
  472395
  472396
  482735
  495125
  507559
  510584
  523397
  528307
  529945
  529952
  530115
  532531
  532572
  537487
  540217
  542026
  542578
  545773
  545791
  545801
  545802
  545803
  545822
  545829
  545839
  546442
  550277
  550315
  550563
  550677
  552623
  566908
  574467
  579386
  583068
  583960
  596147
  596556
  598139
  600186
  603258
  604517
  604528
  605521
  605612
  616336
  631981
  632269
  632595
  632680
  632694
  632701
  636559
  644718
  656175
  656209
  656307
  688369
  768349
  823777
]
2.21 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pmv big"
]
2.05 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pmv большие"
]
2.01 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pmv большие"
]
1.69 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.