GET https://search.jues.net/search/embeds/9?q=cock%20fucking

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.52 ms
(52.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock fucking"
]
171.12 ms
(42.82%)
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
  389199
  398166
  441978
  450271
  468872
  478065
  488119
  492693
  507595
  515096
  517588
  521860
  523212
  525299
  530170
  530527
  530553
  532243
  532811
  533224
  533288
  533398
  537624
  539333
  541107
  542573
  543176
  544462
  545924
  546272
  546296
  547917
  549148
  550483
  553781
  554916
  556091
  559861
  559976
  560910
  561265
  562232
  566216
  571112
  571400
  571863
  574159
  578427
  582638
  583641
  635351
  647032
  647070
  651301
  651865
  656551
  657159
  660106
  660738
  663966
  665696
  666390
  666978
  669216
  675356
  677050
  677914
  678369
  679647
  680581
  683467
  690321
  694692
  695547
  698859
  701207
  701443
  701581
  704442
  704785
  705339
  708743
  709539
  710210
  710335
  711616
  715144
  715907
  716468
  716483
  716487
  716929
  717076
  718446
  719439
  719850
  720432
  723731
  727328
  747390
  757366
  814920
  815497
  816904
  817224
  817544
  817883
  818381
  818786
  820101
  820744
  821567
  821997
  823451
  823620
  824454
  825842
  827253
  828648
  828798
]
10.46 ms
(2.62%)
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
  723731
  727328
  747390
  757366
  635351
  523212
  478065
  389199
  398166
  441978
  817224
  817544
  824454
  814920
  817883
  818786
  823620
  827253
  815497
  818381
  816904
  820101
  820744
  821567
  821997
  823451
  825842
  828798
  828648
  488119
  450271
  492693
  507595
  515096
  517588
  521860
  530170
  532243
  532811
  533288
  530553
  525299
  530527
  533224
  533398
  539333
  537624
  468872
  541107
  542573
  544462
  547917
  549148
  559861
  561265
  574159
  583641
  543176
  546272
  546296
  556091
  559976
  560910
  571400
  571863
  578427
  582638
  545924
  550483
  553781
  554916
  562232
  566216
  571112
  647032
  651301
  660106
  660738
  663966
  666390
  666978
  677050
  679647
  680581
  683467
  690321
  704785
  705339
  708743
  709539
  710335
  711616
  716468
  716487
  719439
  647070
  651865
  656551
  657159
  665696
  669216
  675356
  677914
  678369
  694692
  695547
  698859
  701207
  701443
  701581
  704442
  710210
  715144
  715907
  716483
  716929
  717076
  718446
  719850
  720432
]
2.86 ms
(0.71%)
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
  389199
  398166
  441978
  450271
  468872
  478065
  488119
  492693
  507595
  515096
  517588
  521860
  523212
  525299
  530170
  530527
  530553
  532243
  532811
  533224
  533288
  533398
  537624
  539333
  541107
  542573
  543176
  544462
  545924
  546272
  546296
  547917
  549148
  550483
  553781
  554916
  556091
  559861
  559976
  560910
  561265
  562232
  566216
  571112
  571400
  571863
  574159
  578427
  582638
  583641
  635351
  647032
  647070
  651301
  651865
  656551
  657159
  660106
  660738
  663966
  665696
  666390
  666978
  669216
  675356
  677050
  677914
  678369
  679647
  680581
  683467
  690321
  694692
  695547
  698859
  701207
  701443
  701581
  704442
  704785
  705339
  708743
  709539
  710210
  710335
  711616
  715144
  715907
  716468
  716483
  716487
  716929
  717076
  718446
  719439
  719850
  720432
  723731
  727328
  747390
  757366
  814920
  815497
  816904
  817224
  817544
  817883
  818381
  818786
  820101
  820744
  821567
  821997
  823451
  823620
  824454
  825842
  827253
  828648
  828798
]
2.02 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock fucking"
]
1.89 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock fucking"
]
1.80 ms
(0.45%)
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.