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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.39 ms
(51.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum пов"
]
178.95 ms
(42.97%)
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
  124519
  419281
  421144
  458995
  459368
  459404
  462616
  463501
  465405
  499995
  506246
  517908
  519173
  523154
  529460
  540429
  545254
  547372
  557922
  559317
  560793
  564336
  567081
  572956
  577676
  578207
  582832
  590604
  597187
  599448
  606886
  614597
  614832
  614847
  617061
  641764
  666683
  687140
  703699
  710108
  720057
  720337
  724698
  727984
  727985
  761307
  763413
  763955
  765267
  765365
  766966
  767339
  767449
  767652
  767678
  768533
  771324
  776030
  778634
  781553
  782661
  785996
  786681
  787071
  787693
  789352
  792462
  793028
  794117
  796008
  796046
  796735
  797208
  797283
  797307
  797668
  800608
  800840
  803181
  804132
  808104
  808840
  808908
  809309
  809486
  813112
  814325
  816811
  817447
  819312
  819758
  819793
  819828
  820207
  821533
  823546
  823981
  824140
  824323
  824334
  825352
  825464
  825850
  826252
  826346
  826580
  828121
  828193
  828235
  828351
  828439
  828704
  828778
  828781
  828806
  828811
]
14.02 ms
(3.37%)
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
  606886
  599448
  617061
  597187
  797668
  808840
  763955
  419281
  459368
  828806
  797283
  804132
  767652
  767678
  462616
  517908
  540429
  564336
  557922
  720057
  614847
  796008
  800608
  808908
  771324
  614597
  614832
  809486
  421144
  641764
  821533
  817447
  824323
  828351
  828580
  547372
  529460
  820207
  814325
  780811
  800840
  787693
  796735
  766966
  823546
  823981
  828811
  828121
  828704
  794117
  796046
  808104
  825850
  823840
  824746
  809309
  819793
  825464
  828778
  828235
  828439
  710108
  782661
  793028
  761307
  776030
  559317
  720337
  797307
  727985
  767449
  781553
  792462
  797208
  803181
  763413
  767339
  768533
  787071
  463501
  572956
  567081
  578207
  560793
  590604
  765267
  724698
  778634
  813112
  458995
  459404
  465405
  499995
  519173
  506246
  816811
  826252
  824140
  826580
  819758
  819828
  825352
  828781
  828193
  582832
  703699
  786681
  727984
  785996
  789352
  826346
  824334
  819312
  124519
  765365
  523154
  577676
  545254
  687140
  666683
]
3.18 ms
(0.76%)
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
  124519
  419281
  421144
  458995
  459368
  459404
  462616
  463501
  465405
  499995
  506246
  517908
  519173
  523154
  529460
  540429
  545254
  547372
  557922
  559317
  560793
  564336
  567081
  572956
  577676
  578207
  582832
  590604
  597187
  599448
  606886
  614597
  614832
  614847
  617061
  641764
  666683
  687140
  703699
  710108
  720057
  720337
  724698
  727984
  727985
  761307
  763413
  763955
  765267
  765365
  766966
  767339
  767449
  767652
  767678
  768533
  771324
  776030
  778634
  781553
  782661
  785996
  786681
  787071
  787693
  789352
  792462
  793028
  794117
  796008
  796046
  796735
  797208
  797283
  797307
  797668
  800608
  800840
  803181
  804132
  808104
  808840
  808908
  809309
  809486
  813112
  814325
  816811
  817447
  819312
  819758
  819793
  819828
  820207
  821533
  823546
  823981
  824140
  824323
  824334
  825352
  825464
  825850
  826252
  826346
  826580
  828121
  828193
  828235
  828351
  828439
  828704
  828778
  828781
  828806
  828811
]
2.03 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum пов"
]
1.95 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum pov"
]
1.92 ms
(0.46%)
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.