GET https://search.jues.net/search/embeds/5?q=pantyhose%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.58 ms
(83.52%)
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
  6656
  382898
  388568
  389351
  390206
  390775
  428823
  428872
  432381
  432428
  432583
  432601
  433033
  433429
  433441
  433746
  442803
  457348
  465822
  465894
  465895
  465910
  465911
  466038
  466047
  466053
  470965
  472898
  485354
  485363
  485364
  491960
  491974
  491980
  491981
  494248
  508817
  511071
  515598
  515620
  515712
  518797
  518809
  518817
  521478
  522058
  523419
  524170
  525071
  529437
  534964
  536440
  537162
  539318
  540713
  540746
  542979
  543312
  544079
  545485
  545486
  545496
  546977
  547828
  548644
  553655
  553658
  553660
  556472
  560064
  562978
  564379
  564380
  564381
  564393
  564394
  568330
  570927
  584483
  588781
  591972
  592536
  600794
  604270
  615392
  618589
  672842
  695777
  696389
  717681
  718876
  725460
  727040
  731104
  732825
  742880
  755141
  757099
  758158
  763187
  765403
  767968
  767982
  768031
  776856
  782065
  784213
  795876
  796555
  800417
  800658
  805198
  806534
  812448
  814906
  816755
  828051
  828567
  828791
]
17.31 ms
(10.21%)
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
  758158
  767982
  757099
  717681
  718876
  382898
  388568
  428823
  6656
  390206
  442803
  457348
  465895
  466038
  485364
  518797
  508817
  521478
  539318
  537162
  795876
  784213
  390775
  432601
  432428
  433441
  433746
  432381
  814906
  816755
  465911
  525071
  534964
  536440
  540746
  523419
  540713
  465910
  543312
  544079
  545485
  546977
  553655
  556472
  560064
  562978
  564379
  542979
  545486
  564394
  545496
  548644
  553660
  564393
  568330
  570927
  672842
  695777
  696389
  547828
  553658
  564380
  564381
  584483
  604270
  615392
  588781
  591972
  592536
  600794
  776856
  800658
  812448
  796555
  805198
  806534
  725460
  742880
  731104
  763187
  767968
  768031
  755141
  765403
  727040
  732825
  618589
  782065
  432583
  433429
  465822
  389351
  466047
  466053
  472898
  465894
  428872
  433033
  470965
  511071
  515598
  518809
  485354
  491960
  491974
  524170
  529437
  485363
  491980
  491981
  494248
  515620
  522058
  515712
  518817
  822273
  828051
  828791
  828567
  800417
]
3.70 ms
(2.18%)
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
  6656
  382898
  388568
  389351
  390206
  390775
  428823
  428872
  432381
  432428
  432583
  432601
  433033
  433429
  433441
  433746
  442803
  457348
  465822
  465894
  465895
  465910
  465911
  466038
  466047
  466053
  470965
  472898
  485354
  485363
  485364
  491960
  491974
  491980
  491981
  494248
  508817
  511071
  515598
  515620
  515712
  518797
  518809
  518817
  521478
  522058
  523419
  524170
  525071
  529437
  534964
  536440
  537162
  539318
  540713
  540746
  542979
  543312
  544079
  545485
  545486
  545496
  546977
  547828
  548644
  553655
  553658
  553660
  556472
  560064
  562978
  564379
  564380
  564381
  564393
  564394
  568330
  570927
  584483
  588781
  591972
  592536
  600794
  604270
  615392
  618589
  672842
  695777
  696389
  717681
  718876
  725460
  727040
  731104
  732825
  742880
  755141
  757099
  758158
  763187
  765403
  767968
  767982
  768031
  776856
  782065
  784213
  795876
  796555
  800417
  800658
  805198
  806534
  812448
  814906
  816755
  828051
  828567
  828791
]
2.05 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pantyhose milf"
]
1.70 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pantyhose milf"
]
1.60 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pantyhose milf"
]
1.59 ms
(0.94%)
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.