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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.08 ms
(87.32%)
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
  188269
  233733
  310758
  385314
  389973
  391926
  409877
  424414
  424426
  424462
  426434
  428752
  429416
  432852
  432939
  441864
  443787
  443894
  443953
  445736
  446533
  448793
  450802
  450965
  453096
  459804
  459997
  462019
  462911
  464302
  466499
  467885
  468479
  469396
  471035
  477068
  477555
  483745
  486537
  493754
  494755
  495507
  496066
  500941
  502108
  509218
  511375
  522882
  526082
  529331
  530142
  535855
  538937
  541321
  541357
  545325
  547860
  555225
  555243
  555252
  555274
  555279
  555400
  555413
  562791
  563533
  565308
  570394
  576607
  576641
  576644
  582029
  585110
  593608
  596134
  597018
  606425
  610961
  613004
  620156
  620159
  629898
  656920
  657489
  660383
  661915
  664166
  669276
  670109
  671466
  681223
  699744
  706935
  721166
  728215
  729082
  737870
  740721
  752703
  756642
  766677
  783777
  791550
  800396
  803543
  813115
  815111
  815117
  815250
  815279
  815375
  815511
  815806
  816062
  816952
  816959
  817526
  817794
  819410
  824689
]
15.02 ms
(7.36%)
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
  657489
  681223
  593608
  706935
  529331
  541357
  448793
  426434
  459997
  453096
  565308
  443953
  188269
  477555
  483745
  471035
  424462
  496066
  450965
  469396
  570394
  816952
  815111
  815279
  816062
  815250
  817526
  819410
  824689
  815375
  815511
  816959
  530142
  522882
  576641
  671466
  721166
  670109
  656920
  555274
  596134
  597018
  620159
  813115
  800396
  740721
  803543
  766677
  729082
  756642
  728215
  699744
  783777
  509218
  424426
  443787
  477068
  660383
  389973
  428752
  585110
  468479
  446533
  462911
  500941
  538937
  486537
  541321
  555413
  562791
  555400
  563533
  582029
  669276
  661915
  791550
  391926
  495507
  511375
  459804
  385314
  310758
  409877
  432852
  441864
  432939
  815806
  815117
  817794
  450802
  464302
  466499
  445736
  493754
  502108
  535855
  494755
  526082
  547860
  555243
  576644
  545325
  555225
  555279
  576607
  664166
  555252
  610961
  613004
  620156
  606425
  737870
  752703
  629898
  233733
  467885
  424414
  443894
  429416
  462019
]
3.28 ms
(1.61%)
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
  188269
  233733
  310758
  385314
  389973
  391926
  409877
  424414
  424426
  424462
  426434
  428752
  429416
  432852
  432939
  441864
  443787
  443894
  443953
  445736
  446533
  448793
  450802
  450965
  453096
  459804
  459997
  462019
  462911
  464302
  466499
  467885
  468479
  469396
  471035
  477068
  477555
  483745
  486537
  493754
  494755
  495507
  496066
  500941
  502108
  509218
  511375
  522882
  526082
  529331
  530142
  535855
  538937
  541321
  541357
  545325
  547860
  555225
  555243
  555252
  555274
  555279
  555400
  555413
  562791
  563533
  565308
  570394
  576607
  576641
  576644
  582029
  585110
  593608
  596134
  597018
  606425
  610961
  613004
  620156
  620159
  629898
  656920
  657489
  660383
  661915
  664166
  669276
  670109
  671466
  681223
  699744
  706935
  721166
  728215
  729082
  737870
  740721
  752703
  756642
  766677
  783777
  791550
  800396
  803543
  813115
  815111
  815117
  815250
  815279
  815375
  815511
  815806
  816062
  816952
  816959
  817526
  817794
  819410
  824689
]
2.22 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal milf hairy"
]
1.92 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал milf волосатая"
]
1.74 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал 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.