GET https://search.jues.net/search/embeds/3?q=mature%20mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.04 ms
(84.45%)
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
  11330
  79601
  305931
  391928
  402419
  408411
  415786
  422292
  442634
  450187
  459239
  467758
  472860
  475469
  476750
  478004
  479108
  495514
  495515
  510533
  511521
  513581
  516211
  532708
  549217
  550467
  552853
  557965
  564286
  565636
  571107
  586416
  597150
  626819
  636210
  636434
  641919
  644104
  659353
  660276
  660684
  668982
  697014
  707477
  712567
  714166
  714930
  716090
  717949
  718461
  724736
  725381
  726257
  726566
  726920
  728128
  729789
  729842
  731206
  731786
  734077
  734090
  739543
  739608
  740647
  742573
  742590
  742761
  743003
  744421
  744439
  745938
  747879
  749009
  758225
  762994
  766293
  769443
  788323
  788369
  791674
  792593
  792670
  793498
  793616
  795985
  796018
  796024
  800108
  800716
  800748
  800751
  801288
  801917
  802434
  816169
  816170
  820369
  820378
  823266
  823456
  824194
  824390
  825429
  825975
  826086
  826307
  826308
  826371
  826414
  826483
  826486
  826650
  826682
  826692
  826828
  827203
  827315
  827491
  827620
]
14.11 ms
(9.23%)
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
  800751
  391928
  442634
  408411
  823456
  450187
  475469
  476750
  478004
  510533
  513581
  697014
  707477
  636434
  740647
  745938
  801917
  726566
  792670
  467758
  415786
  511521
  479108
  79601
  816169
  823266
  825429
  826682
  826486
  826483
  826692
  820378
  827203
  816170
  826414
  826086
  826308
  827315
  826828
  495515
  495514
  557965
  564286
  550467
  660684
  714930
  668982
  714166
  716090
  718461
  549217
  565636
  571107
  597150
  644104
  791674
  796024
  800748
  788323
  796018
  800108
  729789
  743003
  744421
  801288
  802434
  725381
  726257
  726920
  734090
  728128
  742590
  742761
  758225
  729842
  744439
  766293
  724736
  731206
  734077
  739608
  742573
  749009
  793498
  305931
  11330
  402419
  422292
  820369
  824390
  826307
  826650
  827620
  827491
  824194
  825975
  826371
  459239
  532708
  516211
  472860
  552853
  712567
  659353
  660276
  717949
  636210
  641919
  586416
  626819
  792593
  793616
  788369
  795985
  731786
  739543
  762994
  769443
  800716
  747879
]
2.29 ms
(1.50%)
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
  11330
  79601
  305931
  391928
  402419
  408411
  415786
  422292
  442634
  450187
  459239
  467758
  472860
  475469
  476750
  478004
  479108
  495514
  495515
  510533
  511521
  513581
  516211
  532708
  549217
  550467
  552853
  557965
  564286
  565636
  571107
  586416
  597150
  626819
  636210
  636434
  641919
  644104
  659353
  660276
  660684
  668982
  697014
  707477
  712567
  714166
  714930
  716090
  717949
  718461
  724736
  725381
  726257
  726566
  726920
  728128
  729789
  729842
  731206
  731786
  734077
  734090
  739543
  739608
  740647
  742573
  742590
  742761
  743003
  744421
  744439
  745938
  747879
  749009
  758225
  762994
  766293
  769443
  788323
  788369
  791674
  792593
  792670
  793498
  793616
  795985
  796018
  796024
  800108
  800716
  800748
  800751
  801288
  801917
  802434
  816169
  816170
  820369
  820378
  823266
  823456
  824194
  824390
  825429
  825975
  826086
  826307
  826308
  826371
  826414
  826483
  826486
  826650
  826682
  826692
  826828
  827203
  827315
  827491
  827620
]
2.17 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature mouth"
]
1.88 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature mouth"
]
1.63 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature mouth"
]

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.