GET https://search.jues.net/search/embeds/6?q=pussy%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.32 ms
(83.70%)
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
  66747
  309223
  353299
  388715
  396569
  406308
  410657
  414146
  417482
  425320
  430290
  433883
  445946
  449595
  451372
  456685
  460194
  467632
  482727
  492484
  498626
  506143
  530486
  530838
  533498
  537007
  537144
  537654
  537670
  538042
  540405
  543890
  544706
  545615
  559162
  563284
  565161
  567343
  572642
  577654
  586320
  589232
  596574
  597681
  601040
  603138
  604515
  613469
  614110
  615440
  615846
  630526
  631132
  633922
  634062
  638555
  639078
  643934
  646029
  646246
  654188
  654973
  656633
  659576
  661901
  661969
  674116
  676024
  679002
  687594
  693946
  694904
  694905
  698048
  705718
  710051
  712065
  715350
  717171
  717219
  719783
  719896
  719955
  724609
  729822
  730517
  732646
  733586
  735285
  737300
  737729
  739016
  739566
  741481
  742171
  750884
  752809
  753073
  753281
  762250
  764748
  765485
  774248
  778056
  786464
  788689
  789187
  796282
  801592
  808214
  817112
  817851
  819046
  819721
  820601
  822888
  822990
  823540
  827878
]
13.32 ms
(9.50%)
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
  537144
  537007
  544706
  705718
  661901
  674116
  694904
  710051
  563284
  613469
  603138
  778056
  737729
  739016
  753281
  788689
  762250
  752809
  724582
  735285
  631132
  717171
  353299
  66747
  445946
  456685
  661969
  646246
  715350
  638555
  614110
  604515
  615846
  724609
  753073
  396569
  460194
  406308
  410657
  449595
  482727
  451372
  530486
  537654
  498626
  506143
  537670
  540405
  559162
  545615
  567343
  565161
  676024
  646029
  589232
  601040
  615440
  630526
  425320
  467632
  417482
  388715
  414146
  817112
  817851
  822888
  822990
  819046
  820601
  819721
  823540
  827878
  533498
  538042
  530838
  543890
  656633
  659576
  693946
  694905
  654188
  654973
  679002
  687594
  698048
  712065
  717219
  719783
  572642
  577654
  596574
  634062
  639078
  597681
  586320
  633922
  643934
  786464
  801592
  796282
  774248
  733586
  741481
  750884
  765485
  737300
  742171
  729822
  730517
  732646
  739566
  764748
  719896
  719955
  789187
  808214
  309223
  430290
  433883
  492484
]
2.64 ms
(1.88%)
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
  66747
  309223
  353299
  388715
  396569
  406308
  410657
  414146
  417482
  425320
  430290
  433883
  445946
  449595
  451372
  456685
  460194
  467632
  482727
  492484
  498626
  506143
  530486
  530838
  533498
  537007
  537144
  537654
  537670
  538042
  540405
  543890
  544706
  545615
  559162
  563284
  565161
  567343
  572642
  577654
  586320
  589232
  596574
  597681
  601040
  603138
  604515
  613469
  614110
  615440
  615846
  630526
  631132
  633922
  634062
  638555
  639078
  643934
  646029
  646246
  654188
  654973
  656633
  659576
  661901
  661969
  674116
  676024
  679002
  687594
  693946
  694904
  694905
  698048
  705718
  710051
  712065
  715350
  717171
  717219
  719783
  719896
  719955
  724609
  729822
  730517
  732646
  733586
  735285
  737300
  737729
  739016
  739566
  741481
  742171
  750884
  752809
  753073
  753281
  762250
  764748
  765485
  774248
  778056
  786464
  788689
  789187
  796282
  801592
  808214
  817112
  817851
  819046
  819721
  820601
  822888
  822990
  823540
  827878
]
2.36 ms
(1.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy bbc"
]
1.60 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy bbc"
]
1.58 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy bbc"
]
1.35 ms
(0.97%)
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.