GET https://search.jues.net/search/embeds/4?q=young%20sexy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.14 ms
(83.07%)
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
  45605
  75762
  153425
  187186
  187353
  233376
  387230
  389593
  390147
  395620
  395653
  397479
  407786
  411902
  412627
  415543
  415557
  415579
  416867
  417716
  420038
  423472
  428079
  428112
  428141
  428881
  440828
  443042
  443669
  443703
  443997
  444465
  445825
  447490
  447837
  449342
  453270
  453276
  453367
  456633
  456885
  460614
  460852
  462470
  471390
  474691
  479177
  479750
  482896
  483971
  487889
  495547
  498552
  506052
  516401
  519157
  519553
  520545
  520740
  521040
  525376
  528448
  543810
  545630
  547328
  555750
  555793
  557128
  559009
  559942
  560152
  563222
  564180
  564197
  568079
  568429
  577409
  579358
  580860
  587885
  595873
  596915
  601828
  605383
  606508
  606571
  607192
  619987
  622402
  629296
  631970
  642691
  643984
  664322
  664504
  665273
  665384
  666778
  680794
  687924
  714322
  714443
  714459
  714511
  718556
  718878
  720609
  742595
  746997
  770494
  785426
  786254
  786277
  789589
  790983
  807558
  814885
  814930
  816755
  823261
]
17.43 ms
(10.88%)
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
  395653
  516401
  395620
  390147
  447490
  456633
  543810
  557128
  579358
  559942
  560152
  559009
  568079
  601828
  807558
  444465
  521040
  520740
  187186
  75762
  387230
  397479
  423472
  443042
  407786
  417716
  428079
  411902
  428141
  816755
  453276
  449342
  453270
  479750
  498552
  547328
  564180
  545630
  555750
  568429
  665273
  680794
  664322
  665384
  718556
  664504
  666778
  714322
  714443
  718878
  555793
  563222
  564197
  587885
  607192
  619987
  631970
  643984
  790983
  770494
  786254
  789589
  742595
  746997
  714459
  720609
  785426
  786277
  45605
  153425
  443703
  453367
  233376
  479177
  389593
  440828
  443669
  412627
  420038
  443997
  482896
  525376
  487889
  495547
  520545
  462470
  506052
  580860
  577409
  714511
  687924
  606508
  629296
  595873
  606571
  642691
  605383
  596915
  622402
  456885
  416867
  528448
  519157
  519553
  187353
  415543
  415579
  415557
  428881
  428112
  814930
  814885
  823261
  445825
  460614
  460852
  471390
  474691
  483971
  447837
]
3.22 ms
(2.01%)
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
  45605
  75762
  153425
  187186
  187353
  233376
  387230
  389593
  390147
  395620
  395653
  397479
  407786
  411902
  412627
  415543
  415557
  415579
  416867
  417716
  420038
  423472
  428079
  428112
  428141
  428881
  440828
  443042
  443669
  443703
  443997
  444465
  445825
  447490
  447837
  449342
  453270
  453276
  453367
  456633
  456885
  460614
  460852
  462470
  471390
  474691
  479177
  479750
  482896
  483971
  487889
  495547
  498552
  506052
  516401
  519157
  519553
  520545
  520740
  521040
  525376
  528448
  543810
  545630
  547328
  555750
  555793
  557128
  559009
  559942
  560152
  563222
  564180
  564197
  568079
  568429
  577409
  579358
  580860
  587885
  595873
  596915
  601828
  605383
  606508
  606571
  607192
  619987
  622402
  629296
  631970
  642691
  643984
  664322
  664504
  665273
  665384
  666778
  680794
  687924
  714322
  714443
  714459
  714511
  718556
  718878
  720609
  742595
  746997
  770494
  785426
  786254
  786277
  789589
  790983
  807558
  814885
  814930
  816755
  823261
]
1.93 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young sexy"
]
1.60 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young sexy"
]
1.53 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young sexy"
]
1.41 ms
(0.88%)
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.