GET https://search.jues.net/search/embeds/9?q=couple%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.14 ms
(84.47%)
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
  389150
  390684
  391492
  395784
  396378
  410062
  425574
  436020
  436644
  438493
  438694
  438729
  448903
  453646
  453661
  454732
  457193
  458210
  459205
  462522
  462575
  462731
  463181
  463254
  466304
  474050
  474216
  477933
  482601
  485392
  490293
  490306
  496162
  498890
  498900
  499494
  501450
  504167
  505226
  510995
  514299
  515845
  515990
  520637
  521962
  521991
  525687
  525867
  529159
  532339
  533649
  535205
  535664
  544971
  547653
  551723
  552248
  556562
  557254
  566892
  567922
  568276
  569476
  572714
  583392
  588529
  589102
  589996
  593690
  594282
  594365
  594448
  594602
  598623
  605451
  605875
  608512
  613732
  620218
  636232
  641693
  647253
  650825
  662022
  674948
  694715
  718810
  719811
  721939
  729217
  732793
  733437
  734259
  735753
  737196
  737206
  738036
  738626
  741710
  743349
  743353
  750070
  750894
  754260
  761513
  762739
  763527
  768144
  769004
  775384
  776389
  779427
  781591
  782582
  786718
  787090
  804120
  806754
  826238
  827370
]
16.49 ms
(9.66%)
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
  738626
  768144
  737206
  750894
  761513
  620218
  641693
  719811
  804120
  438694
  453661
  474216
  466304
  498900
  499494
  544971
  390684
  463181
  438493
  515990
  662022
  588529
  589102
  781591
  782582
  786718
  737196
  762739
  787090
  735753
  738036
  763527
  806754
  462575
  462731
  389150
  410062
  490293
  718810
  510995
  391492
  482601
  535205
  569476
  425574
  436020
  438729
  826238
  827370
  453646
  454732
  485392
  459205
  533649
  532339
  566892
  605875
  636232
  605451
  775384
  776389
  741710
  743349
  729217
  732793
  734259
  733437
  750070
  754260
  743353
  721939
  448903
  458210
  436644
  463254
  395784
  462522
  474050
  477933
  520637
  567922
  613732
  457193
  521991
  498890
  583392
  547653
  674948
  647253
  551723
  568276
  594365
  594602
  594448
  608512
  589996
  594282
  593690
  515845
  557254
  552248
  598623
  769004
  504167
  396378
  694715
  779427
  490306
  535664
  496162
  501450
  505226
  521962
  525867
  514299
  525687
  529159
  572714
  556562
  650825
]
2.66 ms
(1.56%)
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
  389150
  390684
  391492
  395784
  396378
  410062
  425574
  436020
  436644
  438493
  438694
  438729
  448903
  453646
  453661
  454732
  457193
  458210
  459205
  462522
  462575
  462731
  463181
  463254
  466304
  474050
  474216
  477933
  482601
  485392
  490293
  490306
  496162
  498890
  498900
  499494
  501450
  504167
  505226
  510995
  514299
  515845
  515990
  520637
  521962
  521991
  525687
  525867
  529159
  532339
  533649
  535205
  535664
  544971
  547653
  551723
  552248
  556562
  557254
  566892
  567922
  568276
  569476
  572714
  583392
  588529
  589102
  589996
  593690
  594282
  594365
  594448
  594602
  598623
  605451
  605875
  608512
  613732
  620218
  636232
  641693
  647253
  650825
  662022
  674948
  694715
  718810
  719811
  721939
  729217
  732793
  733437
  734259
  735753
  737196
  737206
  738036
  738626
  741710
  743349
  743353
  750070
  750894
  754260
  761513
  762739
  763527
  768144
  769004
  775384
  776389
  779427
  781591
  782582
  786718
  787090
  804120
  806754
  826238
  827370
]
2.05 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "couple homemade"
]
1.79 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "couple домашн любительск"
]
1.79 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "couple домашн любительск"
]
1.73 ms
(1.02%)
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.