GET https://search.jues.net/search/embeds/10?q=fucking%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.64 ms
(85.37%)
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
  4229
  53556
  143195
  148028
  191690
  323352
  381811
  401491
  404078
  404590
  407558
  408493
  411009
  411805
  417565
  428874
  433463
  443143
  445238
  445714
  445796
  448592
  448740
  453452
  460193
  460933
  488456
  494920
  496332
  499832
  503851
  507248
  507254
  522177
  524282
  527159
  530095
  531827
  532536
  534919
  534983
  538880
  545130
  545210
  545905
  553156
  553241
  554846
  559709
  559756
  563749
  564006
  564022
  568265
  572739
  573362
  580662
  609042
  621971
  623948
  645235
  645912
  647080
  649367
  649772
  654239
  656104
  661311
  662920
  668895
  676571
  677133
  680282
  681646
  692475
  693349
  712632
  713486
  714443
  715981
  717259
  717378
  719957
  721826
  725411
  731254
  733274
  735578
  750072
  754223
  758910
  775228
  784000
  795918
  796139
  797637
  799256
  806132
  807597
  809354
  813666
  815481
  815671
  815837
  817549
  817785
  818368
  818448
  818455
  818503
  818657
  818694
  818898
  819146
  819533
  823895
  824530
  824541
  825497
  825841
]
12.90 ms
(8.43%)
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
  818455
  818368
  445714
  445796
  453452
  448740
  507248
  507254
  545905
  553156
  580662
  645235
  719957
  676571
  714443
  573362
  609042
  621971
  623948
  775228
  784000
  795918
  797637
  799256
  806132
  807597
  809354
  733274
  735578
  796139
  758910
  750072
  754223
  725411
  731254
  4229
  428874
  460193
  148028
  404590
  411805
  445238
  143195
  191690
  323352
  381811
  53556
  401491
  404078
  407558
  408493
  411009
  417565
  433463
  443143
  815481
  815671
  815837
  818448
  819533
  817549
  817785
  818694
  818898
  823895
  825497
  825841
  813666
  818657
  824530
  824541
  818503
  819146
  448592
  460933
  503851
  524282
  494920
  496332
  534983
  538880
  499832
  522177
  527159
  531827
  532536
  534919
  530095
  488456
  559756
  564006
  545130
  559709
  568265
  572739
  545210
  553241
  554846
  563749
  564022
  649772
  654239
  677133
  680282
  693349
  712632
  713486
  717259
  721826
  647080
  649367
  661311
  662920
  668895
  681646
  692475
  715981
  717378
  645912
  656104
]
2.76 ms
(1.80%)
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
  4229
  53556
  143195
  148028
  191690
  323352
  381811
  401491
  404078
  404590
  407558
  408493
  411009
  411805
  417565
  428874
  433463
  443143
  445238
  445714
  445796
  448592
  448740
  453452
  460193
  460933
  488456
  494920
  496332
  499832
  503851
  507248
  507254
  522177
  524282
  527159
  530095
  531827
  532536
  534919
  534983
  538880
  545130
  545210
  545905
  553156
  553241
  554846
  559709
  559756
  563749
  564006
  564022
  568265
  572739
  573362
  580662
  609042
  621971
  623948
  645235
  645912
  647080
  649367
  649772
  654239
  656104
  661311
  662920
  668895
  676571
  677133
  680282
  681646
  692475
  693349
  712632
  713486
  714443
  715981
  717259
  717378
  719957
  721826
  725411
  731254
  733274
  735578
  750072
  754223
  758910
  775228
  784000
  795918
  796139
  797637
  799256
  806132
  807597
  809354
  813666
  815481
  815671
  815837
  817549
  817785
  818368
  818448
  818455
  818503
  818657
  818694
  818898
  819146
  819533
  823895
  824530
  824541
  825497
  825841
]
1.76 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucking milf"
]
1.72 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucking milf"
]
1.62 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucking milf"
]

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.