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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
256.56 ms
(89.95%)
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
  396818
  397526
  415822
  417008
  424191
  424292
  430562
  432650
  437784
  439791
  439808
  440889
  442400
  443292
  448069
  449950
  450812
  453454
  453497
  455380
  457183
  457409
  457804
  457861
  462588
  463221
  464207
  464837
  468876
  468984
  471493
  472858
  475893
  479959
  481461
  481926
  485407
  490178
  491089
  492222
  492705
  493110
  493539
  494833
  502791
  503943
  504000
  506209
  506432
  507499
  509179
  509192
  509627
  510608
  515575
  518536
  520700
  522494
  524180
  524359
  525750
  528858
  530481
  533801
  534604
  535546
  537777
  542090
  543143
  549827
  550688
  552361
  553205
  556247
  556816
  557924
  558224
  558819
  560438
  565626
  565713
  565756
  565986
  568096
  579471
  581354
  584200
  584244
  590622
  599178
  604978
  606032
  617732
  621676
  653096
  662405
  667352
  668969
  707464
  711761
  713630
  719112
  725568
  727038
  746525
  758174
  760700
  761781
  765322
  769536
  772763
  785499
  790460
  795123
  796096
  801068
  802091
  802778
  807208
  816073
]
19.03 ms
(6.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
  796096
  802091
  802778
  760700
  761781
  807208
  769536
  758174
  765322
  772763
  725568
  727038
  746525
  604978
  617732
  711761
  719112
  785499
  790460
  795123
  801068
  457409
  462588
  475893
  417008
  455380
  424292
  471493
  479959
  481461
  430562
  457804
  468984
  415822
  424191
  453497
  481926
  502791
  503943
  524180
  490178
  492222
  509627
  506209
  506432
  507499
  509192
  485407
  491089
  493539
  518536
  524359
  528858
  565626
  443292
  439791
  439808
  504000
  520700
  492705
  396818
  397526
  437784
  440889
  442400
  432650
  816073
  449950
  453454
  457861
  463221
  464207
  448069
  450812
  457183
  468876
  494833
  530481
  533801
  535546
  525750
  510608
  515575
  522494
  509179
  534604
  537777
  464837
  472858
  493110
  542090
  550688
  557924
  558224
  558819
  560438
  565756
  565986
  584244
  543143
  552361
  556247
  565713
  549827
  553205
  579471
  653096
  662405
  667352
  668969
  707464
  713630
  556816
  568096
  581354
  584200
  606032
  590622
  599178
  621676
]
2.53 ms
(0.89%)
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
  396818
  397526
  415822
  417008
  424191
  424292
  430562
  432650
  437784
  439791
  439808
  440889
  442400
  443292
  448069
  449950
  450812
  453454
  453497
  455380
  457183
  457409
  457804
  457861
  462588
  463221
  464207
  464837
  468876
  468984
  471493
  472858
  475893
  479959
  481461
  481926
  485407
  490178
  491089
  492222
  492705
  493110
  493539
  494833
  502791
  503943
  504000
  506209
  506432
  507499
  509179
  509192
  509627
  510608
  515575
  518536
  520700
  522494
  524180
  524359
  525750
  528858
  530481
  533801
  534604
  535546
  537777
  542090
  543143
  549827
  550688
  552361
  553205
  556247
  556816
  557924
  558224
  558819
  560438
  565626
  565713
  565756
  565986
  568096
  579471
  581354
  584200
  584244
  590622
  599178
  604978
  606032
  617732
  621676
  653096
  662405
  667352
  668969
  707464
  711761
  713630
  719112
  725568
  727038
  746525
  758174
  760700
  761781
  765322
  769536
  772763
  785499
  790460
  795123
  796096
  801068
  802091
  802778
  807208
  816073
]
1.97 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf home"
]
1.82 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf home"
]
1.77 ms
(0.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf home"
]

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.