GET https://search.jues.net/search/embeds/7?q=bbc%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.04 ms
(88.62%)
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
  396911
  402092
  412419
  417390
  420762
  422735
  423350
  425316
  425353
  430493
  443637
  446856
  446872
  447102
  452602
  461048
  463840
  464195
  465608
  465710
  469586
  475724
  477464
  478640
  490132
  491275
  491461
  494289
  498594
  512029
  512974
  522846
  525526
  525547
  527659
  529954
  530536
  531244
  531319
  532763
  536200
  537671
  537676
  539570
  540433
  540513
  540575
  540579
  542278
  542813
  543878
  543888
  550063
  551082
  555164
  566300
  566758
  569457
  571230
  573304
  576980
  586398
  590850
  594584
  604174
  604569
  606727
  612804
  614426
  619199
  621426
  630592
  630916
  633825
  647361
  650459
  650509
  653876
  656559
  669216
  675002
  681301
  681313
  684106
  708125
  719896
  720237
  720249
  720257
  727282
  728277
  731663
  732565
  733208
  735860
  737709
  741064
  745452
  747012
  750060
  758023
  770002
  780601
  793757
  796997
  804026
  805811
  810296
  813770
  816838
  817851
  818143
  819757
  820149
  822578
  825213
  826061
  828115
  828868
  828871
]
11.86 ms
(6.37%)
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
  805811
  731663
  747012
  750060
  612804
  402092
  465710
  412419
  512974
  525547
  491461
  491275
  498594
  522846
  825213
  828868
  539570
  728277
  804026
  822578
  820149
  828115
  828871
  531319
  542813
  604174
  770002
  633825
  396911
  816838
  819757
  566300
  656559
  650509
  614426
  745452
  737709
  733208
  758023
  540513
  604569
  813770
  817851
  542278
  669216
  684106
  708125
  741064
  727282
  719896
  780601
  818143
  826061
  536200
  532763
  530536
  555164
  810296
  735860
  732565
  422735
  423350
  443637
  463840
  490132
  446856
  461048
  464195
  477464
  478640
  446872
  447102
  469586
  512029
  531244
  537671
  537676
  540433
  540575
  494289
  529954
  475724
  571230
  550063
  566758
  543878
  543888
  573304
  576980
  650459
  653876
  681301
  720237
  720257
  681313
  720249
  647361
  675002
  551082
  569457
  606727
  619199
  630592
  590850
  586398
  594584
  621426
  793757
  630916
  796997
  420762
  425353
  425316
  465608
  417390
  430493
  452602
  527659
  525526
  540579
]
3.54 ms
(1.90%)
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
  396911
  402092
  412419
  417390
  420762
  422735
  423350
  425316
  425353
  430493
  443637
  446856
  446872
  447102
  452602
  461048
  463840
  464195
  465608
  465710
  469586
  475724
  477464
  478640
  490132
  491275
  491461
  494289
  498594
  512029
  512974
  522846
  525526
  525547
  527659
  529954
  530536
  531244
  531319
  532763
  536200
  537671
  537676
  539570
  540433
  540513
  540575
  540579
  542278
  542813
  543878
  543888
  550063
  551082
  555164
  566300
  566758
  569457
  571230
  573304
  576980
  586398
  590850
  594584
  604174
  604569
  606727
  612804
  614426
  619199
  621426
  630592
  630916
  633825
  647361
  650459
  650509
  653876
  656559
  669216
  675002
  681301
  681313
  684106
  708125
  719896
  720237
  720249
  720257
  727282
  728277
  731663
  732565
  733208
  735860
  737709
  741064
  745452
  747012
  750060
  758023
  770002
  780601
  793757
  796997
  804026
  805811
  810296
  813770
  816838
  817851
  818143
  819757
  820149
  822578
  825213
  826061
  828115
  828868
  828871
]
1.60 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc milf"
]
1.45 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc milf"
]
1.20 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc milf"
]

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.