GET https://search.jues.net/search/embeds/3?q=pov%20hard

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.21 ms
(54.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов hard"
]
157.88 ms
(39.85%)
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
  387874
  403134
  410663
  416116
  418389
  419661
  427655
  449454
  508102
  511352
  518495
  525299
  538055
  538081
  540931
  545131
  546321
  548202
  569416
  570701
  575269
  583418
  585909
  589467
  591870
  594419
  595071
  602595
  607394
  608152
  625623
  628912
  635279
  636628
  642851
  645662
  648393
  686996
  691614
  700715
  702288
  712409
  724048
  729871
  733995
  734424
  734932
  739389
  742734
  750124
  752109
  754703
  758741
  764696
  765743
  766283
  767314
  770645
  772447
  772738
  776642
  776769
  776970
  777385
  777699
  778096
  778716
  779364
  779487
  781067
  782571
  782834
  783445
  783634
  784434
  784805
  785343
  785554
  786761
  787070
  788838
  789140
  791773
  792355
  792420
  793043
  793113
  793635
  793865
  793914
  795863
  796111
  797565
  798887
  799996
  800924
  801693
  802671
  802773
  803057
  804550
  806118
  809353
  811204
  812717
  813832
  817785
  819432
  819505
  819680
  820538
  821126
  821386
  821556
  824846
  825163
  825623
  825696
]
15.43 ms
(3.89%)
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
  764696
  765782
  776769
  776970
  777385
  783634
  785343
  793043
  796111
  811204
  508102
  403134
  546321
  734932
  742734
  449454
  538081
  712409
  642851
  792420
  803057
  812717
  793635
  734424
  733995
  739389
  782571
  802671
  583418
  729871
  387874
  427655
  416116
  813832
  825163
  819505
  819680
  821126
  825623
  825696
  511352
  525299
  538055
  518495
  548202
  540931
  569416
  648393
  691614
  702288
  686996
  645662
  575269
  589467
  636628
  585909
  608152
  625623
  594419
  602595
  628912
  635279
  779487
  781067
  782834
  784805
  786761
  792355
  797565
  798887
  804550
  806118
  776642
  777699
  778096
  778716
  789140
  791773
  793113
  793865
  795863
  800924
  801693
  809353
  767314
  772447
  784434
  799996
  752109
  758741
  770645
  754703
  750124
  766283
  772738
  607394
  776323
  779364
  783445
  787070
  793914
  802773
  418389
  545131
  570701
  700715
  591870
  595071
  724048
  765743
  785554
  788838
  410663
  419661
  820538
  821386
  817785
  819432
  821556
  824846
]
2.82 ms
(0.71%)
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
  387874
  403134
  410663
  416116
  418389
  419661
  427655
  449454
  508102
  511352
  518495
  525299
  538055
  538081
  540931
  545131
  546321
  548202
  569416
  570701
  575269
  583418
  585909
  589467
  591870
  594419
  595071
  602595
  607394
  608152
  625623
  628912
  635279
  636628
  642851
  645662
  648393
  686996
  691614
  700715
  702288
  712409
  724048
  729871
  733995
  734424
  734932
  739389
  742734
  750124
  752109
  754703
  758741
  764696
  765743
  766283
  767314
  770645
  772447
  772738
  776642
  776769
  776970
  777385
  777699
  778096
  778716
  779364
  779487
  781067
  782571
  782834
  783445
  783634
  784434
  784805
  785343
  785554
  786761
  787070
  788838
  789140
  791773
  792355
  792420
  793043
  793113
  793635
  793865
  793914
  795863
  796111
  797565
  798887
  799996
  800924
  801693
  802671
  802773
  803057
  804550
  806118
  809353
  811204
  812717
  813832
  817785
  819432
  819505
  819680
  820538
  821126
  821386
  821556
  824846
  825163
  825623
  825696
]
2.12 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov hard"
]
1.95 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов hard"
]
1.74 ms
(0.44%)
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.