GET https://search.jues.net/search/embeds/3?q=hot%20brunette

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
416.47 ms
(70.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot черноволосая"
]
149.03 ms
(25.25%)
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
  395170
  409894
  415388
  422464
  423332
  423535
  431812
  435716
  444337
  445738
  448216
  448354
  449048
  449358
  451108
  452650
  452916
  452928
  456226
  461221
  465827
  469475
  471316
  472536
  476761
  476981
  477232
  478905
  479457
  483564
  485249
  487534
  489906
  490458
  490931
  493269
  494419
  500789
  501841
  502508
  502587
  506315
  513431
  514570
  516601
  517363
  518216
  519227
  519354
  522647
  523890
  524027
  524504
  526659
  534106
  542097
  543445
  552411
  561113
  561451
  565462
  566758
  569495
  571062
  573473
  578774
  580288
  584431
  584451
  584463
  591073
  592440
  593935
  597042
  598921
  599080
  602636
  603783
  603786
  604093
  604803
  607432
  615672
  615979
  621742
  623402
  623416
  644065
  665110
  667644
  673126
  684383
  685613
  692859
  698386
  719228
  723848
  731821
  734481
  752112
  756016
  761133
  762638
  773257
  777057
  787101
  787586
  790213
  790490
  790930
  797106
  798039
  800533
  805429
  811449
  814878
  816459
  821745
  825335
  826459
]
15.97 ms
(2.71%)
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
  821745
  452650
  487534
  502508
  500789
  472536
  584431
  584463
  552411
  561451
  685613
  684383
  580288
  602636
  623416
  777057
  790930
  800533
  762638
  761133
  621742
  623402
  790213
  465827
  477232
  490931
  523890
  490458
  667644
  603783
  607432
  452928
  395170
  506315
  489906
  542097
  569495
  571062
  561113
  573473
  431812
  423535
  514570
  543445
  826459
  814878
  451108
  517363
  692859
  604093
  604803
  805429
  734481
  773257
  476981
  449358
  476761
  519354
  422464
  485249
  501841
  526659
  665110
  479457
  483564
  493269
  524504
  565462
  591073
  456226
  478905
  502587
  524027
  534106
  423332
  469475
  566758
  599080
  603786
  787586
  516601
  415388
  409894
  445738
  522647
  578774
  592440
  615979
  644065
  435716
  494419
  449048
  518216
  519227
  471316
  444337
  448216
  752112
  756016
  448354
  461221
  598921
  513431
  584451
  593935
  816459
  452916
  719228
  673126
  811449
  723848
  825335
  787101
  798039
  731821
  698386
  790490
  797106
  597042
  615672
]
3.07 ms
(0.52%)
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
  395170
  409894
  415388
  422464
  423332
  423535
  431812
  435716
  444337
  445738
  448216
  448354
  449048
  449358
  451108
  452650
  452916
  452928
  456226
  461221
  465827
  469475
  471316
  472536
  476761
  476981
  477232
  478905
  479457
  483564
  485249
  487534
  489906
  490458
  490931
  493269
  494419
  500789
  501841
  502508
  502587
  506315
  513431
  514570
  516601
  517363
  518216
  519227
  519354
  522647
  523890
  524027
  524504
  526659
  534106
  542097
  543445
  552411
  561113
  561451
  565462
  566758
  569495
  571062
  573473
  578774
  580288
  584431
  584451
  584463
  591073
  592440
  593935
  597042
  598921
  599080
  602636
  603783
  603786
  604093
  604803
  607432
  615672
  615979
  621742
  623402
  623416
  644065
  665110
  667644
  673126
  684383
  685613
  692859
  698386
  719228
  723848
  731821
  734481
  752112
  756016
  761133
  762638
  773257
  777057
  787101
  787586
  790213
  790490
  790930
  797106
  798039
  800533
  805429
  811449
  814878
  816459
  821745
  825335
  826459
]
1.97 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot brunette"
]
1.91 ms
(0.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot черноволосая"
]
1.73 ms
(0.29%)
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.