GET https://search.jues.net/search/embeds/7?q=hairy%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.45 ms
(83.87%)
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
  96269
  382465
  384491
  385448
  386735
  390125
  395759
  396694
  397867
  399868
  405191
  406179
  408620
  409316
  412238
  414498
  415029
  415584
  417898
  419292
  423243
  424407
  426868
  427480
  429261
  431599
  433610
  434532
  441933
  443183
  445051
  445930
  449100
  450147
  454725
  457947
  458498
  458937
  462807
  466459
  466630
  470734
  470764
  474096
  477409
  477553
  479920
  480806
  482662
  483339
  484277
  485363
  487618
  491634
  492325
  492406
  493283
  493886
  498668
  499850
  504054
  504492
  505326
  505353
  507675
  512051
  521486
  521599
  527524
  529033
  538936
  554435
  557363
  565479
  566297
  571187
  571214
  576339
  576692
  577268
  581696
  588759
  593167
  603425
  621298
  623268
  643426
  648896
  650551
  652890
  661063
  661092
  670751
  671721
  682543
  683854
  687199
  697290
  709577
  711875
  721806
  725137
  735795
  738166
  743241
  760778
  768173
  768367
  770867
  776412
  803079
  813300
  816158
  816854
  817185
  822430
  823545
  827864
  827937
  827972
]
16.42 ms
(9.47%)
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
  822430
  823545
  816854
  817185
  827972
  827937
  827864
  527524
  571187
  577268
  554435
  652890
  661063
  661092
  697290
  711875
  670751
  682543
  683854
  687199
  648896
  650551
  603425
  623268
  760778
  768173
  770867
  768367
  725137
  735795
  743241
  738166
  643426
  709577
  721806
  776412
  803079
  813300
  382465
  408620
  507675
  499850
  529033
  385448
  384491
  395759
  397867
  423243
  426868
  434532
  427480
  429261
  443183
  445051
  412238
  816158
  450147
  466459
  491634
  445930
  477553
  482662
  454725
  458498
  474096
  492406
  493283
  521599
  505353
  487618
  493886
  557363
  576339
  576692
  671721
  565479
  571214
  588759
  409316
  414498
  415029
  419292
  477409
  386735
  399868
  424407
  441933
  462807
  466630
  415584
  396694
  470734
  479920
  457947
  470764
  504054
  521486
  483339
  498668
  505326
  512051
  485363
  484277
  405191
  449100
  406179
  433610
  492325
  504492
  431599
  538936
  566297
  581696
  621298
  593167
  96269
  417898
  390125
  458937
  480806
]
4.06 ms
(2.34%)
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
  96269
  382465
  384491
  385448
  386735
  390125
  395759
  396694
  397867
  399868
  405191
  406179
  408620
  409316
  412238
  414498
  415029
  415584
  417898
  419292
  423243
  424407
  426868
  427480
  429261
  431599
  433610
  434532
  441933
  443183
  445051
  445930
  449100
  450147
  454725
  457947
  458498
  458937
  462807
  466459
  466630
  470734
  470764
  474096
  477409
  477553
  479920
  480806
  482662
  483339
  484277
  485363
  487618
  491634
  492325
  492406
  493283
  493886
  498668
  499850
  504054
  504492
  505326
  505353
  507675
  512051
  521486
  521599
  527524
  529033
  538936
  554435
  557363
  565479
  566297
  571187
  571214
  576339
  576692
  577268
  581696
  588759
  593167
  603425
  621298
  623268
  643426
  648896
  650551
  652890
  661063
  661092
  670751
  671721
  682543
  683854
  687199
  697290
  709577
  711875
  721806
  725137
  735795
  738166
  743241
  760778
  768173
  768367
  770867
  776412
  803079
  813300
  816158
  816854
  817185
  822430
  823545
  827864
  827937
  827972
]
2.19 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy beautiful"
]
1.89 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая красивая"
]
1.80 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.93%)
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.