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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.32 ms
(82.63%)
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
  391059
  391944
  400928
  414103
  417553
  419218
  423980
  424283
  426962
  427267
  445745
  447464
  448089
  448263
  451100
  453164
  453731
  461870
  463034
  466405
  466553
  467778
  482494
  493402
  494575
  499964
  501960
  506787
  514660
  515994
  516936
  519505
  520174
  527905
  529293
  532482
  541216
  549864
  576005
  579178
  582277
  590088
  591940
  593105
  599538
  600779
  602146
  604651
  614671
  620757
  624201
  624204
  624207
  625208
  626616
  675084
  675461
  681514
  699554
  700915
  714927
  726320
  727459
  728924
  730722
  730803
  733217
  733271
  734283
  740070
  741577
  742747
  747431
  747474
  750729
  751178
  755138
  758787
  772360
  780419
  781962
  786880
  788132
  790817
  792348
  793837
  793841
  794488
  796307
  796372
  796480
  800017
  801164
  801922
  802716
  803599
  808021
  808290
  808691
  815196
  816397
  819338
  820022
  823175
  823598
  823689
  823754
  823860
  824077
  824085
  824509
  824598
  824645
  824790
  825260
  826651
  826739
  827377
]
15.74 ms
(10.38%)
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
  593105
  602146
  808691
  482494
  516936
  579178
  600779
  499964
  675084
  742747
  815196
  599538
  576005
  591940
  424283
  453164
  796372
  391059
  532482
  614671
  467778
  788132
  604651
  391944
  730722
  419218
  451100
  453731
  758787
  423980
  493402
  461870
  448263
  549864
  780419
  519505
  400928
  414103
  466405
  426962
  515994
  541216
  520174
  506787
  501960
  590088
  445745
  463034
  447464
  514660
  527905
  699554
  582277
  681514
  529293
  626616
  620757
  824790
  790817
  819419
  823754
  824645
  819338
  824077
  796307
  730803
  826651
  823860
  800017
  772360
  728924
  824598
  801164
  727459
  427267
  417553
  827377
  792348
  733271
  494575
  747431
  786880
  808021
  624207
  726320
  823689
  823598
  803599
  823175
  824085
  816397
  751178
  826739
  700915
  793837
  741577
  747474
  714927
  794488
  625208
  624201
  624204
  820022
  734283
  755138
  802716
  750729
  733217
  448089
  466553
  828594
  740070
  793841
  808290
  824509
  825260
  675461
  796480
  801922
  781962
]
2.96 ms
(1.95%)
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
  391059
  391944
  400928
  414103
  417553
  419218
  423980
  424283
  426962
  427267
  445745
  447464
  448089
  448263
  451100
  453164
  453731
  461870
  463034
  466405
  466553
  467778
  482494
  493402
  494575
  499964
  501960
  506787
  514660
  515994
  516936
  519505
  520174
  527905
  529293
  532482
  541216
  549864
  576005
  579178
  582277
  590088
  591940
  593105
  599538
  600779
  602146
  604651
  614671
  620757
  624201
  624204
  624207
  625208
  626616
  675084
  675461
  681514
  699554
  700915
  714927
  726320
  727459
  728924
  730722
  730803
  733217
  733271
  734283
  740070
  741577
  742747
  747431
  747474
  750729
  751178
  755138
  758787
  772360
  780419
  781962
  786880
  788132
  790817
  792348
  793837
  793841
  794488
  796307
  796372
  796480
  800017
  801164
  801922
  802716
  803599
  808021
  808290
  808691
  815196
  816397
  819338
  820022
  823175
  823598
  823689
  823754
  823860
  824077
  824085
  824509
  824598
  824645
  824790
  825260
  826651
  826739
  827377
]
2.25 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy and ass"
]
1.85 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy жоп"
]
1.79 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "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.