GET https://search.jues.net/search/embeds/7?q=best%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.63 ms
(85.51%)
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
  395856
  417064
  417891
  418879
  419867
  419880
  424569
  425523
  428509
  429369
  431429
  431962
  432149
  433231
  439598
  441191
  442864
  443153
  445668
  446735
  446984
  447625
  449311
  449778
  449784
  452097
  454107
  462904
  465353
  465354
  465844
  466972
  467036
  467721
  468957
  469200
  480719
  483569
  484127
  484129
  486237
  487902
  492921
  496784
  496862
  496870
  496935
  500375
  500482
  500504
  503376
  505460
  505693
  507961
  508516
  510365
  512514
  514309
  514645
  517612
  518072
  518917
  523537
  523636
  526588
  526718
  527454
  527989
  532419
  533541
  539288
  542754
  544261
  545444
  545538
  545545
  548606
  552588
  554388
  561351
  564867
  571958
  572711
  575472
  575532
  576325
  578531
  578587
  579368
  581852
  584461
  591413
  593742
  596556
  601669
  602562
  602928
  604061
  604097
  606482
  615735
  615774
  619516
  622981
  623212
  623306
  623792
  625000
  634484
  641644
  641901
  645918
  653458
  670955
  673522
  674064
  693269
  711283
  790223
  807707
]
16.55 ms
(9.58%)
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
  670955
  693269
  673522
  622981
  623212
  602562
  593742
  615774
  807707
  790223
  641901
  469200
  447625
  466972
  417891
  442864
  449311
  510365
  514309
  492921
  484127
  496784
  496935
  503376
  526588
  507961
  523636
  572711
  417064
  431962
  433231
  445668
  486237
  517612
  527454
  500504
  518917
  500482
  542754
  548606
  575532
  544261
  545545
  561351
  578531
  579368
  581852
  674064
  554388
  571958
  575472
  604097
  596556
  604061
  615735
  591413
  625000
  623792
  418879
  395856
  424569
  439598
  443153
  465353
  468957
  505693
  512514
  487902
  500375
  584461
  429369
  431429
  484129
  446735
  467036
  527989
  532419
  505460
  462904
  545538
  576325
  564867
  653458
  578587
  619516
  623306
  641644
  432149
  465354
  467721
  428509
  441191
  446984
  465844
  508516
  483569
  496862
  496870
  449784
  452097
  480719
  454107
  518072
  523537
  533541
  552588
  711283
  601669
  606482
  634484
  602928
  449778
  425523
  419867
  419880
  514645
  539288
  526718
  545444
  645918
]
2.33 ms
(1.35%)
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
  395856
  417064
  417891
  418879
  419867
  419880
  424569
  425523
  428509
  429369
  431429
  431962
  432149
  433231
  439598
  441191
  442864
  443153
  445668
  446735
  446984
  447625
  449311
  449778
  449784
  452097
  454107
  462904
  465353
  465354
  465844
  466972
  467036
  467721
  468957
  469200
  480719
  483569
  484127
  484129
  486237
  487902
  492921
  496784
  496862
  496870
  496935
  500375
  500482
  500504
  503376
  505460
  505693
  507961
  508516
  510365
  512514
  514309
  514645
  517612
  518072
  518917
  523537
  523636
  526588
  526718
  527454
  527989
  532419
  533541
  539288
  542754
  544261
  545444
  545538
  545545
  548606
  552588
  554388
  561351
  564867
  571958
  572711
  575472
  575532
  576325
  578531
  578587
  579368
  581852
  584461
  591413
  593742
  596556
  601669
  602562
  602928
  604061
  604097
  606482
  615735
  615774
  619516
  622981
  623212
  623306
  623792
  625000
  634484
  641644
  641901
  645918
  653458
  670955
  673522
  674064
  693269
  711283
  790223
  807707
]
1.78 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "best pussy"
]
1.51 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "best pussy"
]
1.25 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "best pussy"
]

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.