GET https://search.jues.net/search/embeds/5?q=xxx%20boyfriend

Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.02 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.29 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx boyfriend"
]
3 14.66 ms
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
  779829
  780813
  782381
  782640
  785389
  786276
  789538
  792139
  792903
  805012
  805463
  813318
  778686
  788726
  797019
  801289
  743328
  743791
  746467
  764699
  764751
  765641
  768832
  781297
  783084
  785801
  788620
  790472
  791083
  794347
  794812
  799006
  724586
  724977
  732401
  739324
  745509
  745830
  747837
  751130
  758405
  762261
  766632
  724003
  726243
  728463
  738268
  738573
  739600
  740623
  743901
  749256
  751929
  751946
  756318
  758393
  764126
  768695
  769264
  737255
  739708
  748855
  763877
  768441
  725939
  727309
  728945
  731278
  738942
  750517
  752763
  753231
  764880
  771658
  772619
  773361
  773590
  606844
  706441
  718019
  720953
  781658
  782486
  784587
  787106
  789164
  802745
  808799
  809969
  6643
  228398
  420037
  391977
  398308
  466045
  443140
  760297
  385357
  396322
  426819
  818267
  821784
  817235
  818104
  818642
  818952
  820165
  823405
  827869
  827949
  456997
  459556
  484096
  532157
  505636
  535207
  511806
  535992
  512632
  484116
]
4 3.27 ms
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
  6643
  228398
  385357
  391977
  396322
  398308
  420037
  426819
  443140
  456997
  459556
  466045
  484096
  484116
  505636
  511806
  512632
  532157
  535207
  535992
  606844
  706441
  718019
  720953
  724003
  724586
  724977
  725939
  726243
  727309
  728463
  728945
  731278
  732401
  737255
  738268
  738573
  738942
  739324
  739600
  739708
  740623
  743328
  743791
  743901
  745509
  745830
  746467
  747837
  748855
  749256
  750517
  751130
  751929
  751946
  752763
  753231
  756318
  758393
  758405
  760297
  762261
  763877
  764126
  764699
  764751
  764880
  765641
  766632
  768441
  768695
  768832
  769264
  771658
  772619
  773361
  773590
  778686
  779829
  780813
  781297
  781658
  782381
  782486
  782640
  783084
  784587
  785389
  785801
  786276
  787106
  788620
  788726
  789164
  789538
  790472
  791083
  792139
  792903
  794347
  794812
  797019
  799006
  801289
  802745
  805012
  805463
  808799
  809969
  813318
  817235
  818104
  818267
  818642
  818952
  820165
  821784
  823405
  827869
  827949
]
5 115.30 ms
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
  6643
  228398
  385357
  391977
  396322
  398308
  420037
  426819
  443140
  456997
  459556
  466045
  484096
  484116
  505636
  511806
  512632
  532157
  535207
  535992
  606844
  706441
  718019
  720953
  724003
  724586
  724977
  725939
  726243
  727309
  728463
  728945
  731278
  732401
  737255
  738268
  738573
  738942
  739324
  739600
  739708
  740623
  743328
  743791
  743901
  745509
  745830
  746467
  747837
  748855
  749256
  750517
  751130
  751929
  751946
  752763
  753231
  756318
  758393
  758405
  760297
  762261
  763877
  764126
  764699
  764751
  764880
  765641
  766632
  768441
  768695
  768832
  769264
  771658
  772619
  773361
  773590
  778686
  779829
  780813
  781297
  781658
  782381
  782486
  782640
  783084
  784587
  785389
  785801
  786276
  787106
  788620
  788726
  789164
  789538
  790472
  791083
  792139
  792903
  794347
  794812
  797019
  799006
  801289
  802745
  805012
  805463
  808799
  809969
  813318
  817235
  818104
  818267
  818642
  818952
  820165
  821784
  823405
  827869
  827949
]
6 1.87 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx boyfriend"
]
7 1.64 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx boyfriend"
]

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.