GET https://search.jues.net/search/embeds/5?q=black%20cock%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.16 ms
(86.53%)
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
  14806
  14940
  32766
  33236
  33260
  37495
  81565
  130060
  161318
  161358
  382362
  382468
  387160
  389315
  390832
  392797
  393087
  395989
  396570
  396575
  396745
  399393
  402153
  402350
  403293
  408508
  414001
  417081
  420499
  424937
  430380
  432105
  433516
  445730
  446351
  453194
  457295
  457494
  461718
  462802
  463845
  465669
  468064
  468475
  484054
  486736
  490267
  496308
  511378
  512683
  529202
  529404
  531126
  533372
  533382
  533681
  534995
  540393
  540433
  543199
  554834
  558304
  578778
  590165
  599955
  600019
  604952
  617428
  617437
  619487
  620210
  622582
  623960
  623965
  629412
  630913
  631192
  632635
  633806
  635202
  635490
  637687
  641075
  641678
  651607
  662043
  663367
  669171
  669566
  669695
  673731
  674100
  676623
  681301
  701309
  701406
  704184
  704185
  720388
  722549
  724283
  732345
  732745
  732767
  732892
  742439
  743066
  744668
  746846
  755698
  757458
  767598
  805112
  805487
  806036
  806089
  807541
  813074
  814130
  826232
]
15.29 ms
(8.53%)
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
  387160
  390832
  37495
  704185
  533372
  599955
  600019
  632635
  529404
  540433
  681301
  631192
  806036
  635490
  669695
  805487
  633806
  529202
  130060
  161318
  33260
  14940
  402153
  402350
  403293
  432105
  417081
  424937
  814130
  445730
  453194
  457295
  462802
  540393
  511378
  461718
  465669
  543199
  669566
  663367
  674100
  704184
  662043
  701309
  620210
  590165
  619487
  637687
  629412
  630913
  805112
  813074
  732892
  744668
  732745
  701406
  806089
  382468
  396570
  399393
  420499
  468064
  14806
  392797
  395989
  414001
  33236
  496308
  533382
  531126
  534995
  651607
  676623
  641678
  617437
  617428
  161358
  393087
  382362
  32766
  389315
  396575
  396745
  408508
  430380
  433516
  826232
  446351
  457494
  484054
  463845
  468475
  490267
  486736
  533681
  512683
  554834
  558304
  578778
  669171
  673731
  720388
  635202
  604952
  622582
  623960
  623965
  641075
  807541
  743066
  732767
  746846
  755698
  724283
  732345
  757458
  767598
  742439
  722549
  81565
]
2.38 ms
(1.33%)
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
  14806
  14940
  32766
  33236
  33260
  37495
  81565
  130060
  161318
  161358
  382362
  382468
  387160
  389315
  390832
  392797
  393087
  395989
  396570
  396575
  396745
  399393
  402153
  402350
  403293
  408508
  414001
  417081
  420499
  424937
  430380
  432105
  433516
  445730
  446351
  453194
  457295
  457494
  461718
  462802
  463845
  465669
  468064
  468475
  484054
  486736
  490267
  496308
  511378
  512683
  529202
  529404
  531126
  533372
  533382
  533681
  534995
  540393
  540433
  543199
  554834
  558304
  578778
  590165
  599955
  600019
  604952
  617428
  617437
  619487
  620210
  622582
  623960
  623965
  629412
  630913
  631192
  632635
  633806
  635202
  635490
  637687
  641075
  641678
  651607
  662043
  663367
  669171
  669566
  669695
  673731
  674100
  676623
  681301
  701309
  701406
  704184
  704185
  720388
  722549
  724283
  732345
  732745
  732767
  732892
  742439
  743066
  744668
  746846
  755698
  757458
  767598
  805112
  805487
  806036
  806089
  807541
  813074
  814130
  826232
]
1.88 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black cock bbc"
]
1.63 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black cock bbc"
]
1.56 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black cock bbc"
]
1.41 ms
(0.79%)
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.