GET https://search.jues.net/search/embeds/6?q=painful%20big%20cock

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.00 ms
(81.69%)
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
  390508
  391423
  392517
  396334
  396699
  408240
  422074
  422382
  424646
  427592
  432692
  432790
  437204
  441519
  443333
  445050
  446028
  447007
  447116
  447951
  453544
  453690
  454145
  454534
  460663
  462757
  464837
  465267
  467910
  468956
  469403
  471190
  471300
  471330
  471996
  472399
  472692
  473222
  473476
  473748
  473974
  476975
  478712
  478833
  479141
  480714
  480767
  482925
  484087
  484423
  486204
  488948
  489271
  490171
  490250
  490518
  490742
  490879
  492495
  495607
  496149
  498423
  503644
  505803
  508052
  510456
  510990
  513552
  514024
  518451
  522053
  523330
  526466
  533409
  533948
  534494
  535431
  537960
  541629
  545814
  546752
  547865
  552395
  554552
  556973
  557930
  558490
  561844
  561988
  562883
  563031
  566557
  569980
  576516
  578492
  580418
  589278
  592956
  593787
  595549
  602553
  608725
  608751
  614689
  615903
  620291
  622932
  623388
  665923
  720132
  725119
  736470
  741656
  743068
  750668
  789868
  794135
  810697
  814944
  826874
]
17.19 ms
(11.42%)
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
  725119
  736470
  741656
  743068
  750668
  720132
  489271
  505803
  589278
  488948
  490742
  533409
  546752
  547865
  814944
  460663
  569980
  557930
  592956
  794135
  608725
  513552
  464837
  492495
  562883
  623388
  810697
  514024
  427592
  441519
  422074
  447007
  465267
  472399
  486204
  454534
  473476
  478833
  490171
  510990
  526466
  535431
  480714
  615903
  789868
  424646
  447116
  453690
  462757
  472692
  473222
  471300
  391423
  478712
  523330
  482925
  490250
  503644
  537960
  490518
  490879
  496149
  533948
  495607
  522053
  476975
  422382
  510456
  396699
  443333
  454145
  552395
  541629
  665923
  554552
  561844
  561988
  576516
  578492
  620291
  593787
  595549
  602553
  396334
  467910
  471330
  484087
  473974
  446028
  471190
  453544
  498423
  480767
  558490
  447951
  479141
  432790
  580418
  445050
  390508
  408240
  469403
  556973
  563031
  566557
  608751
  614689
  468956
  545814
  471996
  437204
  484423
  622932
  392517
  432692
  826874
  473748
  534494
  508052
  518451
]
3.06 ms
(2.03%)
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
  390508
  391423
  392517
  396334
  396699
  408240
  422074
  422382
  424646
  427592
  432692
  432790
  437204
  441519
  443333
  445050
  446028
  447007
  447116
  447951
  453544
  453690
  454145
  454534
  460663
  462757
  464837
  465267
  467910
  468956
  469403
  471190
  471300
  471330
  471996
  472399
  472692
  473222
  473476
  473748
  473974
  476975
  478712
  478833
  479141
  480714
  480767
  482925
  484087
  484423
  486204
  488948
  489271
  490171
  490250
  490518
  490742
  490879
  492495
  495607
  496149
  498423
  503644
  505803
  508052
  510456
  510990
  513552
  514024
  518451
  522053
  523330
  526466
  533409
  533948
  534494
  535431
  537960
  541629
  545814
  546752
  547865
  552395
  554552
  556973
  557930
  558490
  561844
  561988
  562883
  563031
  566557
  569980
  576516
  578492
  580418
  589278
  592956
  593787
  595549
  602553
  608725
  608751
  614689
  615903
  620291
  622932
  623388
  665923
  720132
  725119
  736470
  741656
  743068
  750668
  789868
  794135
  810697
  814944
  826874
]
2.15 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "painful big cock"
]
1.78 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "крича вперв большие cock"
]
1.72 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "крича вперв большие cock"
]

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.