GET https://search.jues.net/search/embeds/3?q=amateur%20sleeping

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.81 ms
(85.74%)
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
  74842
  108029
  250587
  382409
  385243
  386128
  391610
  395189
  395203
  395794
  396093
  396361
  397101
  398308
  398742
  400930
  400968
  402980
  403163
  405744
  405805
  407130
  412841
  413663
  416882
  417100
  417930
  418063
  418797
  418996
  419248
  419940
  422207
  423899
  425532
  425540
  425547
  425563
  425597
  426091
  426739
  427045
  427472
  428467
  435130
  435289
  437255
  437325
  441866
  442447
  443190
  444674
  445306
  446042
  447013
  447390
  447753
  447757
  447758
  448089
  448483
  451636
  453710
  453902
  454497
  456186
  459676
  460129
  472108
  484321
  489668
  490221
  490749
  492813
  494543
  496115
  498178
  499993
  502636
  507584
  509388
  516724
  518937
  521494
  523244
  525183
  525400
  526423
  528445
  532157
  547086
  548119
  551072
  553102
  567203
  570878
  573742
  579192
  601164
  619184
  622408
  663259
  668761
  673349
  703293
  707380
  712041
  715465
  726555
  730115
  748066
  748404
  753783
  761112
  766484
  782522
  799783
  812181
  824660
  824719
]
15.24 ms
(8.90%)
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
  518937
  445306
  507584
  453710
  528445
  447390
  673349
  570878
  663259
  622408
  619184
  573742
  715465
  748404
  423899
  703293
  405805
  427472
  417930
  425597
  441866
  456186
  499993
  74842
  425563
  799783
  403163
  428467
  459676
  402980
  446042
  489668
  418063
  753783
  400930
  525183
  435289
  426091
  425547
  416882
  425540
  391610
  548119
  707380
  395189
  490221
  601164
  437255
  386128
  730115
  525400
  824660
  712041
  397101
  447757
  413663
  454497
  426739
  523244
  496115
  547086
  250587
  395794
  108029
  782522
  490749
  407130
  442447
  447013
  396093
  444674
  418797
  448089
  748066
  668761
  396361
  412841
  395203
  425532
  419940
  385243
  579192
  453902
  502636
  492813
  405744
  812181
  761112
  509388
  824719
  419248
  498178
  417100
  418996
  460129
  567203
  726555
  437325
  448483
  435130
  443190
  447758
  398308
  398742
  551072
  422207
  400968
  447753
  472108
  532157
  766484
  526423
  427045
  494543
  484321
  516724
  553102
  451636
  521494
  382409
]
2.58 ms
(1.51%)
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
  74842
  108029
  250587
  382409
  385243
  386128
  391610
  395189
  395203
  395794
  396093
  396361
  397101
  398308
  398742
  400930
  400968
  402980
  403163
  405744
  405805
  407130
  412841
  413663
  416882
  417100
  417930
  418063
  418797
  418996
  419248
  419940
  422207
  423899
  425532
  425540
  425547
  425563
  425597
  426091
  426739
  427045
  427472
  428467
  435130
  435289
  437255
  437325
  441866
  442447
  443190
  444674
  445306
  446042
  447013
  447390
  447753
  447757
  447758
  448089
  448483
  451636
  453710
  453902
  454497
  456186
  459676
  460129
  472108
  484321
  489668
  490221
  490749
  492813
  494543
  496115
  498178
  499993
  502636
  507584
  509388
  516724
  518937
  521494
  523244
  525183
  525400
  526423
  528445
  532157
  547086
  548119
  551072
  553102
  567203
  570878
  573742
  579192
  601164
  619184
  622408
  663259
  668761
  673349
  703293
  707380
  712041
  715465
  726555
  730115
  748066
  748404
  753783
  761112
  766484
  782522
  799783
  812181
  824660
  824719
]
1.79 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur sleeping"
]
1.75 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск спящ"
]
1.37 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.