GET https://search.jues.net/search/embeds/4?q=milf%20doggy%20creampie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
192.46 ms
(88.84%)
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
  388780
  390954
  407903
  428090
  435523
  439484
  439724
  440393
  441280
  441359
  445651
  446179
  452305
  453195
  455991
  465164
  465405
  468373
  478611
  488475
  489322
  497509
  507427
  511688
  516226
  516489
  519611
  521999
  534828
  536416
  548256
  549714
  552644
  553858
  556075
  569580
  579471
  583560
  591923
  592066
  592379
  598297
  605057
  605625
  630668
  630840
  632193
  633855
  634204
  635450
  635845
  640442
  647882
  653807
  655132
  662889
  666414
  666955
  680346
  680434
  696104
  696334
  697203
  707310
  717072
  726240
  726983
  727736
  727859
  728779
  730359
  730407
  734331
  734960
  740166
  742728
  746171
  749009
  751513
  753552
  755147
  759874
  759891
  759931
  759941
  760877
  761031
  761601
  763510
  766652
  767116
  767159
  767269
  768001
  768388
  775054
  775640
  776995
  780731
  783992
  784764
  787639
  791403
  791573
  791815
  791856
  792733
  795301
  795900
  796196
  796879
  797163
  797444
  801000
  801529
  804524
  805241
  806307
  816607
  824096
]
14.43 ms
(6.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
  824096
  511688
  666414
  696334
  696104
  662889
  548256
  552644
  553858
  583560
  640442
  605625
  634204
  776995
  780731
  796196
  775640
  787639
  791856
  795900
  759931
  792733
  797163
  726983
  734331
  766652
  726240
  759874
  740166
  749009
  753552
  755147
  707310
  791573
  797444
  801000
  801529
  516226
  598297
  439724
  452305
  388780
  439484
  455991
  465164
  468373
  497509
  507427
  680434
  647882
  630840
  796879
  759891
  727736
  761031
  767116
  742728
  751513
  759941
  746171
  804524
  440393
  441359
  435523
  441280
  445651
  489322
  579471
  730359
  783992
  428090
  407903
  446179
  465405
  453195
  516489
  519611
  521999
  816607
  534828
  536416
  488475
  549714
  569580
  653807
  666955
  697203
  655132
  680346
  717072
  556075
  592066
  630668
  635450
  592379
  635845
  591923
  605057
  775054
  805241
  784764
  761601
  791403
  806307
  727859
  763510
  768388
  730407
  734960
  760877
  728779
  767159
  767269
  768001
  632193
  633855
  791815
  795301
  390954
  478611
]
2.67 ms
(1.23%)
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
  388780
  390954
  407903
  428090
  435523
  439484
  439724
  440393
  441280
  441359
  445651
  446179
  452305
  453195
  455991
  465164
  465405
  468373
  478611
  488475
  489322
  497509
  507427
  511688
  516226
  516489
  519611
  521999
  534828
  536416
  548256
  549714
  552644
  553858
  556075
  569580
  579471
  583560
  591923
  592066
  592379
  598297
  605057
  605625
  630668
  630840
  632193
  633855
  634204
  635450
  635845
  640442
  647882
  653807
  655132
  662889
  666414
  666955
  680346
  680434
  696104
  696334
  697203
  707310
  717072
  726240
  726983
  727736
  727859
  728779
  730359
  730407
  734331
  734960
  740166
  742728
  746171
  749009
  751513
  753552
  755147
  759874
  759891
  759931
  759941
  760877
  761031
  761601
  763510
  766652
  767116
  767159
  767269
  768001
  768388
  775054
  775640
  776995
  780731
  783992
  784764
  787639
  791403
  791573
  791815
  791856
  792733
  795301
  795900
  796196
  796879
  797163
  797444
  801000
  801529
  804524
  805241
  806307
  816607
  824096
]
1.88 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf рак creampie"
]
1.82 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf doggy creampie"
]
1.57 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf рак creampie"
]

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.