GET https://search.jues.net/search/embeds/5?q=milf%20beauty%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.32 ms
(82.31%)
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
  261144
  388856
  395276
  395805
  396662
  398909
  399688
  400931
  401148
  401621
  407881
  410393
  415151
  416056
  418865
  420259
  425653
  430783
  431314
  433302
  436393
  447516
  449358
  458438
  459803
  460226
  465664
  469487
  469513
  473148
  475780
  478652
  479856
  480415
  483150
  485125
  486702
  489871
  491275
  493221
  496340
  497881
  498803
  500339
  504970
  511500
  512818
  515511
  517013
  517932
  518218
  518504
  519233
  519268
  519465
  519548
  519726
  519962
  522881
  522923
  525664
  532746
  533958
  534990
  535533
  544120
  550363
  556950
  557522
  586644
  586917
  597834
  599572
  605337
  609165
  613432
  619645
  634546
  642346
  646279
  646290
  649108
  650846
  655295
  656266
  666869
  674269
  692049
  697449
  705277
  712940
  720117
  725596
  730759
  750549
  756103
  765817
  770901
  775473
  775858
  777003
  780659
  783392
  786094
  787272
  788119
  794366
  800344
  801896
  803046
  806060
  809421
  809463
  815704
  816793
  816985
  817217
  817330
  818051
  822121
]
16.11 ms
(10.84%)
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
  646290
  692049
  599572
  786094
  496340
  815704
  818051
  817330
  822121
  794366
  655295
  803046
  532746
  535533
  515511
  519465
  534990
  511500
  550363
  557522
  646279
  649108
  666869
  705277
  712940
  656266
  619645
  605337
  642346
  806060
  775473
  775858
  809421
  750549
  783392
  788119
  809463
  770901
  756103
  765817
  613432
  777003
  787272
  395805
  401621
  410393
  469487
  407881
  420259
  479856
  396662
  400931
  401148
  415151
  430783
  261144
  418865
  425653
  431314
  459803
  465664
  480415
  519726
  500339
  518218
  489871
  512818
  525664
  504970
  522923
  817217
  697449
  730759
  720117
  433302
  493221
  517932
  483150
  816985
  816793
  800344
  801896
  725596
  780659
  609165
  519962
  650846
  517013
  634546
  447516
  458438
  485125
  469513
  498803
  544120
  674269
  556950
  597834
  586644
  586917
  388856
  436393
  399688
  460226
  395276
  398909
  449358
  473148
  478652
  416056
  475780
  518504
  519233
  533958
  486702
  519268
  522881
  491275
  497881
  519548
]
3.14 ms
(2.11%)
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
  261144
  388856
  395276
  395805
  396662
  398909
  399688
  400931
  401148
  401621
  407881
  410393
  415151
  416056
  418865
  420259
  425653
  430783
  431314
  433302
  436393
  447516
  449358
  458438
  459803
  460226
  465664
  469487
  469513
  473148
  475780
  478652
  479856
  480415
  483150
  485125
  486702
  489871
  491275
  493221
  496340
  497881
  498803
  500339
  504970
  511500
  512818
  515511
  517013
  517932
  518218
  518504
  519233
  519268
  519465
  519548
  519726
  519962
  522881
  522923
  525664
  532746
  533958
  534990
  535533
  544120
  550363
  556950
  557522
  586644
  586917
  597834
  599572
  605337
  609165
  613432
  619645
  634546
  642346
  646279
  646290
  649108
  650846
  655295
  656266
  666869
  674269
  692049
  697449
  705277
  712940
  720117
  725596
  730759
  750549
  756103
  765817
  770901
  775473
  775858
  777003
  780659
  783392
  786094
  787272
  788119
  794366
  800344
  801896
  803046
  806060
  809421
  809463
  815704
  816793
  816985
  817217
  817330
  818051
  822121
]
2.10 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf beauty anal"
]
1.67 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf beauty анал"
]
1.47 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf beauty анал"
]

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.