GET https://search.jues.net/search/embeds/3?q=dirty-talk

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.31 ms
(85.99%)
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
  294490
  417334
  436942
  437244
  444348
  444852
  447064
  450683
  451514
  453481
  454131
  455813
  458760
  460428
  460503
  471108
  472372
  479963
  481644
  486634
  488000
  492138
  493168
  502751
  502895
  506765
  508444
  517299
  517332
  518605
  526449
  531993
  533130
  543428
  550424
  552579
  552581
  555448
  560794
  562974
  569189
  574015
  574022
  574406
  578858
  579587
  580248
  584411
  584999
  585017
  586004
  590539
  591578
  595517
  595582
  596637
  597522
  599140
  607481
  610376
  616448
  623433
  624045
  625946
  629681
  631471
  636461
  638688
  640394
  643510
  652760
  663336
  667942
  672842
  683047
  687844
  688967
  700932
  706851
  709270
  709895
  710302
  717849
  719461
  723373
  729231
  730338
  733672
  739089
  742415
  742643
  750766
  769452
  770387
  776926
  777779
  778114
  778119
  778508
  778613
  783836
  787973
  789566
  791712
  791911
  791917
  792232
  798966
  799033
  799199
  799725
  803035
  803516
  810298
  810852
  812768
  819268
  819777
  825907
  826449
]
14.66 ms
(8.22%)
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
  787973
  799199
  799725
  803516
  810298
  450683
  508444
  742415
  294490
  444852
  825907
  819777
  819268
  454131
  481644
  486634
  493168
  526449
  580248
  552579
  552581
  700932
  687844
  709270
  688967
  590539
  597522
  610376
  778114
  803035
  791911
  742643
  769452
  791917
  750766
  733672
  710302
  799033
  437244
  585017
  826449
  531993
  533130
  460503
  550424
  579587
  562974
  574022
  543428
  584411
  706851
  652760
  672842
  683047
  719461
  723373
  555448
  574406
  578858
  586004
  591578
  607481
  595517
  616448
  625946
  623433
  624045
  629681
  631471
  638688
  791712
  792232
  812768
  777779
  783836
  730338
  729231
  739089
  640394
  643510
  717849
  776926
  778119
  798966
  472372
  447064
  451514
  453481
  479963
  436942
  488000
  502895
  517299
  506765
  569189
  584999
  458760
  455813
  502751
  460428
  492138
  560794
  574015
  663336
  709895
  667942
  636461
  595582
  596637
  599140
  810852
  778613
  770387
  778508
  789566
  471108
  444348
  417334
  517332
  518605
]
3.22 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
  294490
  417334
  436942
  437244
  444348
  444852
  447064
  450683
  451514
  453481
  454131
  455813
  458760
  460428
  460503
  471108
  472372
  479963
  481644
  486634
  488000
  492138
  493168
  502751
  502895
  506765
  508444
  517299
  517332
  518605
  526449
  531993
  533130
  543428
  550424
  552579
  552581
  555448
  560794
  562974
  569189
  574015
  574022
  574406
  578858
  579587
  580248
  584411
  584999
  585017
  586004
  590539
  591578
  595517
  595582
  596637
  597522
  599140
  607481
  610376
  616448
  623433
  624045
  625946
  629681
  631471
  636461
  638688
  640394
  643510
  652760
  663336
  667942
  672842
  683047
  687844
  688967
  700932
  706851
  709270
  709895
  710302
  717849
  719461
  723373
  729231
  730338
  733672
  739089
  742415
  742643
  750766
  769452
  770387
  776926
  777779
  778114
  778119
  778508
  778613
  783836
  787973
  789566
  791712
  791911
  791917
  792232
  798966
  799033
  799199
  799725
  803035
  803516
  810298
  810852
  812768
  819268
  819777
  825907
  826449
]
2.05 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dirty-talk"
]
1.61 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dirty talk"
]
1.53 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dirty talk"
]

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.