GET https://search.jues.net/search/embeds/5?q=hot%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.05 ms
(86.77%)
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
  392068
  409759
  421491
  459730
  489321
  511241
  511352
  525182
  536508
  553831
  561181
  565939
  569265
  569802
  572642
  573249
  579642
  584640
  585166
  587268
  588481
  588885
  590661
  593056
  599464
  601464
  605954
  608423
  616438
  617755
  618143
  621592
  625623
  630425
  635279
  636628
  650572
  651177
  656192
  662839
  671231
  678643
  680237
  682179
  683006
  683698
  684886
  705383
  709587
  715391
  731642
  746708
  755577
  757122
  764367
  764615
  765679
  767672
  767871
  772255
  777805
  778163
  778927
  779364
  779421
  779429
  779909
  781348
  785350
  785842
  787419
  787985
  788445
  788465
  789122
  789140
  789474
  790490
  791412
  791643
  791833
  792051
  792402
  792467
  793026
  793905
  793920
  794112
  795094
  796490
  797314
  797477
  797558
  798039
  799298
  799897
  799996
  800772
  800788
  801692
  801717
  801932
  801987
  802169
  803678
  804510
  804807
  806118
  807370
  807377
  807661
  809716
  809962
  810544
  810670
  812443
  813098
  813472
]
12.46 ms
(7.78%)
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
  459730
  489321
  511241
  511352
  525182
  536508
  561181
  573249
  584640
  553831
  565939
  569802
  662839
  671231
  682179
  650572
  678643
  683006
  683698
  651177
  656192
  680237
  684886
  715391
  569265
  572642
  579642
  588481
  601464
  636628
  585166
  588885
  625623
  587268
  593056
  608423
  616438
  618143
  635279
  590661
  599464
  605954
  617755
  621592
  778927
  792051
  792467
  794112
  797558
  801932
  802169
  806118
  807377
  810544
  812443
  781348
  787985
  789122
  789140
  789474
  791643
  795094
  799298
  800772
  800788
  803678
  813098
  813472
  785842
  787419
  788445
  793920
  796490
  797477
  798039
  799996
  801692
  801987
  804510
  807661
  809716
  810670
  731642
  772255
  746708
  755577
  764367
  767672
  767871
  764615
  765679
  768119
  776323
  777805
  778163
  779364
  779421
  779429
  779909
  785350
  788465
  790490
  791412
  791833
  792402
  793026
  793905
  797314
  799897
  801717
  804807
  807370
  809962
  705383
  709587
  630425
  757122
  392068
  421491
  409759
]
2.04 ms
(1.27%)
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
  392068
  409759
  421491
  459730
  489321
  511241
  511352
  525182
  536508
  553831
  561181
  565939
  569265
  569802
  572642
  573249
  579642
  584640
  585166
  587268
  588481
  588885
  590661
  593056
  599464
  601464
  605954
  608423
  616438
  617755
  618143
  621592
  625623
  630425
  635279
  636628
  650572
  651177
  656192
  662839
  671231
  678643
  680237
  682179
  683006
  683698
  684886
  705383
  709587
  715391
  731642
  746708
  755577
  757122
  764367
  764615
  765679
  767672
  767871
  772255
  777805
  778163
  778927
  779364
  779421
  779429
  779909
  781348
  785350
  785842
  787419
  787985
  788445
  788465
  789122
  789140
  789474
  790490
  791412
  791643
  791833
  792051
  792402
  792467
  793026
  793905
  793920
  794112
  795094
  796490
  797314
  797477
  797558
  798039
  799298
  799897
  799996
  800772
  800788
  801692
  801717
  801932
  801987
  802169
  803678
  804510
  804807
  806118
  807370
  807377
  807661
  809716
  809962
  810544
  810670
  812443
  813098
  813472
]
1.92 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot pov"
]
1.59 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot пов"
]
1.31 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot пов"
]

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.