GET https://search.jues.net/search/embeds/10?q=milf%20bathroom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.87 ms
(78.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
  72766
  153311
  188335
  358398
  358942
  384124
  387556
  388542
  394773
  396758
  398968
  400994
  404279
  404464
  405482
  407509
  411419
  411588
  415342
  423764
  425578
  432692
  438109
  442970
  446646
  447721
  450377
  451795
  454415
  459630
  459970
  462198
  462574
  467560
  467628
  467920
  470498
  471648
  475316
  477691
  478520
  480398
  495228
  496851
  499587
  501996
  503989
  507003
  510930
  513516
  516712
  516728
  520395
  521168
  521875
  522249
  523848
  524424
  526044
  527144
  528215
  528562
  528627
  532484
  541551
  542742
  549066
  554143
  554199
  555963
  557965
  561027
  561213
  561563
  562145
  562542
  562887
  563066
  563233
  566686
  568728
  570892
  571698
  575279
  576245
  580251
  583522
  584481
  586411
  594566
  596845
  599617
  600170
  601163
  615721
  628747
  636568
  638165
  659426
  661023
  662897
  668330
  672421
  710833
  713017
  721870
  744912
  750387
  753713
  759129
  759135
  765863
  788882
  789054
  789068
  792060
  805154
  818502
  819816
  823738
]
23.51 ms
(14.92%)
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
  568728
  562542
  570892
  659426
  710833
  713017
  661023
  672421
  549066
  554143
  554199
  561027
  561213
  571698
  576245
  628747
  586411
  600170
  601163
  636568
  789054
  789068
  750387
  759129
  765863
  753713
  721870
  788882
  792060
  805154
  188335
  407509
  423764
  446646
  388542
  438109
  478520
  526044
  394773
  387556
  405482
  404464
  432692
  442970
  450377
  451795
  454415
  459630
  462198
  475316
  480398
  447721
  467920
  503989
  521168
  499587
  510930
  521875
  527144
  516728
  528562
  532484
  459970
  471648
  541551
  563066
  563233
  584481
  566686
  583522
  542742
  561563
  562887
  580251
  662897
  555963
  575279
  596845
  599617
  615721
  594566
  638165
  744912
  759135
  415342
  358942
  404279
  411588
  477691
  462574
  467560
  467628
  384124
  396758
  398968
  400994
  411419
  425578
  470498
  513516
  516712
  495228
  496851
  528627
  507003
  522249
  523848
  524424
  501996
  520395
  528215
  153311
  358398
  72766
  819816
  823738
  818502
  557965
  668330
  562145
]
2.73 ms
(1.73%)
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
  72766
  153311
  188335
  358398
  358942
  384124
  387556
  388542
  394773
  396758
  398968
  400994
  404279
  404464
  405482
  407509
  411419
  411588
  415342
  423764
  425578
  432692
  438109
  442970
  446646
  447721
  450377
  451795
  454415
  459630
  459970
  462198
  462574
  467560
  467628
  467920
  470498
  471648
  475316
  477691
  478520
  480398
  495228
  496851
  499587
  501996
  503989
  507003
  510930
  513516
  516712
  516728
  520395
  521168
  521875
  522249
  523848
  524424
  526044
  527144
  528215
  528562
  528627
  532484
  541551
  542742
  549066
  554143
  554199
  555963
  557965
  561027
  561213
  561563
  562145
  562542
  562887
  563066
  563233
  566686
  568728
  570892
  571698
  575279
  576245
  580251
  583522
  584481
  586411
  594566
  596845
  599617
  600170
  601163
  615721
  628747
  636568
  638165
  659426
  661023
  662897
  668330
  672421
  710833
  713017
  721870
  744912
  750387
  753713
  759129
  759135
  765863
  788882
  789054
  789068
  792060
  805154
  818502
  819816
  823738
]
1.97 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf ван"
]
1.89 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf ван"
]
1.83 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf bathroom"
]
1.76 ms
(1.11%)
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.