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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.18 ms
(89.49%)
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
  27514
  386671
  404018
  420015
  448712
  461123
  471184
  481068
  500086
  504101
  510145
  523044
  525642
  525734
  526000
  530397
  533711
  534127
  534958
  535617
  537548
  541793
  542487
  543683
  543946
  544807
  545798
  554684
  555615
  558264
  560166
  567936
  575663
  585071
  586921
  599785
  600499
  603338
  612007
  616839
  621230
  625679
  628623
  629257
  631879
  633182
  647203
  648905
  662864
  669857
  669899
  669903
  669905
  671905
  680614
  692112
  696052
  707812
  723078
  725483
  730719
  732931
  736485
  743993
  744167
  745784
  746098
  748126
  749181
  751390
  752765
  753620
  758064
  758176
  766692
  767428
  768207
  769019
  769094
  770054
  777591
  786388
  788836
  789678
  790434
  791312
  791318
  791497
  795951
  795990
  798447
  798706
  798837
  798848
  803773
  809767
  812239
  814715
  819817
  820139
  821525
  823776
  823801
  824539
  827348
  828035
  828055
  828142
  828175
  828181
  828255
  828259
  828273
  828310
  828312
  828351
  828374
  828500
]
10.84 ms
(5.67%)
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
  730719
  767428
  753620
  770054
  603338
  404018
  822987
  823776
  819817
  824539
  827348
  823801
  820139
  828035
  828374
  828312
  828273
  828142
  828055
  828259
  828181
  828351
  828255
  828500
  526000
  535617
  537548
  500086
  567936
  671905
  586921
  600499
  612007
  732931
  745784
  386671
  814715
  530397
  525734
  533711
  504101
  523044
  560166
  546559
  575663
  669857
  669899
  696052
  669905
  628623
  616839
  786388
  791497
  769094
  798837
  798848
  769019
  758176
  621230
  633182
  481068
  27514
  471184
  543946
  544807
  723078
  648905
  662864
  692112
  599785
  790434
  554684
  545798
  669903
  791318
  809767
  752765
  746098
  707812
  461123
  749181
  448712
  420015
  585071
  821525
  828310
  828175
  510145
  534958
  534127
  525642
  541793
  543683
  558264
  542487
  647203
  680614
  555615
  631879
  625679
  629257
  788836
  795990
  798447
  798706
  725483
  743993
  744167
  758064
  791312
  812239
  766692
  768207
  736485
  748126
  751390
  777591
  789678
  795951
  803773
]
2.63 ms
(1.37%)
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
  27514
  386671
  404018
  420015
  448712
  461123
  471184
  481068
  500086
  504101
  510145
  523044
  525642
  525734
  526000
  530397
  533711
  534127
  534958
  535617
  537548
  541793
  542487
  543683
  543946
  544807
  545798
  554684
  555615
  558264
  560166
  567936
  575663
  585071
  586921
  599785
  600499
  603338
  612007
  616839
  621230
  625679
  628623
  629257
  631879
  633182
  647203
  648905
  662864
  669857
  669899
  669903
  669905
  671905
  680614
  692112
  696052
  707812
  723078
  725483
  730719
  732931
  736485
  743993
  744167
  745784
  746098
  748126
  749181
  751390
  752765
  753620
  758064
  758176
  766692
  767428
  768207
  769019
  769094
  770054
  777591
  786388
  788836
  789678
  790434
  791312
  791318
  791497
  795951
  795990
  798447
  798706
  798837
  798848
  803773
  809767
  812239
  814715
  819817
  820139
  821525
  823776
  823801
  824539
  827348
  828035
  828055
  828142
  828175
  828181
  828255
  828259
  828273
  828310
  828312
  828351
  828374
  828500
]
1.90 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf public oral"
]
1.61 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf на oral улиц"
]
1.54 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf на oral улиц"
]

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.