GET https://search.jues.net/search/embeds/6?q=hard%20licking

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.94 ms
(86.62%)
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
  382278
  382720
  385759
  393732
  398309
  400430
  401583
  415538
  415556
  424559
  426916
  426926
  428966
  436827
  437635
  440156
  441251
  443420
  444605
  445759
  448383
  451515
  451552
  461903
  464112
  469020
  471176
  474735
  475911
  479782
  480309
  490378
  490671
  492805
  494578
  502060
  505628
  507257
  518282
  519582
  520151
  533798
  543812
  571508
  577369
  590260
  596809
  602742
  602789
  603992
  608938
  609965
  610639
  615748
  617631
  619402
  621683
  623209
  630289
  637007
  647901
  693680
  695145
  714901
  724564
  733178
  734226
  734731
  736285
  737079
  737356
  741611
  743340
  744596
  746884
  747032
  750940
  751720
  753477
  755907
  755925
  756725
  758186
  760016
  767098
  768902
  769814
  769816
  770980
  771960
  773444
  773556
  781598
  781742
  781782
  784932
  790976
  792612
  795332
  797541
  798997
  799349
  799980
  800071
  801715
  802605
  803057
  808000
  808286
  809163
  809466
  810725
  812006
  813754
  814392
  815386
  815692
  817295
  817467
  818908
]
13.96 ms
(7.75%)
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
  693680
  609965
  590260
  617631
  608938
  619402
  630289
  781742
  781782
  790976
  799980
  803057
  809163
  781598
  798997
  808000
  724564
  734226
  734731
  743340
  755907
  760016
  771960
  800071
  801715
  802605
  808286
  810725
  736285
  744596
  750940
  751720
  753477
  733178
  755925
  756725
  758186
  768902
  769814
  770980
  773556
  737356
  767098
  773444
  737079
  741611
  746884
  747032
  769816
  602789
  623209
  714901
  795332
  799349
  812006
  401583
  415538
  464112
  428966
  436827
  444605
  451515
  424559
  494578
  443420
  814392
  474735
  492805
  479782
  505628
  533798
  502060
  520151
  518282
  461903
  543812
  647901
  695145
  571508
  577369
  596809
  602742
  610639
  621683
  637007
  784932
  792612
  809466
  603992
  615748
  797541
  445759
  471176
  475911
  480309
  426926
  448383
  469020
  426916
  437635
  440156
  451552
  490378
  519582
  490671
  507257
  385759
  393732
  382720
  382278
  398309
  400430
  415556
  441251
  817467
  818908
  813754
  815386
  815692
  817295
]
2.39 ms
(1.33%)
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
  382278
  382720
  385759
  393732
  398309
  400430
  401583
  415538
  415556
  424559
  426916
  426926
  428966
  436827
  437635
  440156
  441251
  443420
  444605
  445759
  448383
  451515
  451552
  461903
  464112
  469020
  471176
  474735
  475911
  479782
  480309
  490378
  490671
  492805
  494578
  502060
  505628
  507257
  518282
  519582
  520151
  533798
  543812
  571508
  577369
  590260
  596809
  602742
  602789
  603992
  608938
  609965
  610639
  615748
  617631
  619402
  621683
  623209
  630289
  637007
  647901
  693680
  695145
  714901
  724564
  733178
  734226
  734731
  736285
  737079
  737356
  741611
  743340
  744596
  746884
  747032
  750940
  751720
  753477
  755907
  755925
  756725
  758186
  760016
  767098
  768902
  769814
  769816
  770980
  771960
  773444
  773556
  781598
  781742
  781782
  784932
  790976
  792612
  795332
  797541
  798997
  799349
  799980
  800071
  801715
  802605
  803057
  808000
  808286
  809163
  809466
  810725
  812006
  813754
  814392
  815386
  815692
  817295
  817467
  818908
]
2.13 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard licking"
]
1.91 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard лиза"
]
1.65 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard лиза"
]

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.