GET https://search.jues.net/search/embeds/2?q=extreme%20fucking

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.57 ms
(85.72%)
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
  6853
  88182
  118370
  181851
  346173
  382302
  384293
  385595
  392207
  394661
  396157
  398078
  398166
  425894
  430353
  434569
  451559
  458966
  463495
  467712
  470142
  484457
  493264
  494146
  501238
  507880
  511920
  515246
  518997
  524325
  524928
  529741
  530369
  530587
  531238
  532369
  532743
  532952
  533644
  537138
  539239
  540067
  540679
  541195
  545454
  547470
  548448
  548946
  550807
  559234
  568328
  571841
  573193
  580620
  589330
  590444
  593270
  598010
  598866
  616616
  621612
  633444
  633773
  643187
  643213
  648583
  649504
  650158
  669390
  677295
  677773
  689013
  697108
  709593
  710194
  713168
  716321
  716611
  716681
  716986
  717261
  719765
  723831
  734424
  738824
  740288
  742929
  748382
  750775
  760895
  766837
  769636
  770805
  772046
  773533
  775496
  777577
  783785
  785075
  786454
  788246
  792693
  793411
  794090
  794305
  795157
  797435
  799721
  800289
  800565
  809188
  809805
  810615
  811121
  815264
  817324
  821033
  824341
  825121
  827872
]
15.11 ms
(8.55%)
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
  6853
  717261
  589330
  809805
  772046
  740288
  769636
  532369
  815264
  88182
  811121
  766837
  689013
  669390
  738824
  394661
  385595
  590444
  621612
  537138
  573193
  568328
  458966
  434569
  530369
  425894
  532743
  532952
  541195
  794090
  800565
  770805
  797435
  760895
  716321
  533644
  547470
  511920
  719765
  598010
  593270
  501238
  598866
  777577
  786454
  392207
  677295
  493264
  518997
  494146
  531238
  545454
  649504
  430353
  539239
  648583
  580620
  633444
  515246
  633773
  799721
  524325
  451559
  524928
  677773
  463495
  484457
  507880
  650158
  571841
  748382
  723831
  396157
  716611
  800289
  118370
  643213
  809188
  793411
  750775
  824341
  540679
  783785
  181851
  734424
  467712
  382302
  398166
  742929
  384293
  825121
  817324
  550807
  794305
  810615
  346173
  616616
  470142
  709593
  713168
  775496
  773533
  697108
  716681
  788246
  795157
  540067
  716986
  398078
  821033
  827872
  530587
  529741
  559234
  548448
  710194
  548946
  643187
  792693
  785075
]
2.59 ms
(1.46%)
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
  6853
  88182
  118370
  181851
  346173
  382302
  384293
  385595
  392207
  394661
  396157
  398078
  398166
  425894
  430353
  434569
  451559
  458966
  463495
  467712
  470142
  484457
  493264
  494146
  501238
  507880
  511920
  515246
  518997
  524325
  524928
  529741
  530369
  530587
  531238
  532369
  532743
  532952
  533644
  537138
  539239
  540067
  540679
  541195
  545454
  547470
  548448
  548946
  550807
  559234
  568328
  571841
  573193
  580620
  589330
  590444
  593270
  598010
  598866
  616616
  621612
  633444
  633773
  643187
  643213
  648583
  649504
  650158
  669390
  677295
  677773
  689013
  697108
  709593
  710194
  713168
  716321
  716611
  716681
  716986
  717261
  719765
  723831
  734424
  738824
  740288
  742929
  748382
  750775
  760895
  766837
  769636
  770805
  772046
  773533
  775496
  777577
  783785
  785075
  786454
  788246
  792693
  793411
  794090
  794305
  795157
  797435
  799721
  800289
  800565
  809188
  809805
  810615
  811121
  815264
  817324
  821033
  824341
  825121
  827872
]
2.06 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme fucking"
]
1.85 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор fucking"
]
1.57 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор fucking"
]

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.