GET https://search.jues.net/search/embeds/3?q=mom%20ass%20kissing

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.18 ms
(86.21%)
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
  233670
  405806
  407516
  413472
  413475
  415346
  428822
  431376
  446622
  451434
  457199
  458012
  463160
  464389
  467638
  512999
  519984
  531434
  532980
  532991
  533211
  534851
  538865
  539480
  539839
  543792
  544960
  550050
  550223
  559074
  564818
  570146
  570183
  590903
  596788
  597101
  598837
  599997
  601843
  617190
  620134
  621319
  621323
  622377
  634849
  640403
  641138
  643095
  643352
  647984
  649939
  650494
  651077
  671701
  673582
  673649
  678016
  683541
  683826
  685646
  693849
  699025
  705738
  717724
  718552
  718560
  719016
  719112
  721611
  724633
  725568
  725581
  726640
  726831
  726982
  728798
  732600
  736393
  740154
  741308
  743811
  753204
  756246
  757244
  760002
  766743
  770630
  787443
  789480
  789689
  795033
  797646
  800278
  801182
  801475
  802741
  802832
  802849
  803081
  803088
  808115
  808626
  813530
  815237
  815508
  815555
  815693
  815769
  815829
  815866
  816502
  817295
  817843
  817915
  817928
  818386
  818463
  821194
  821384
  823358
]
15.72 ms
(8.36%)
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
  464389
  550050
  673582
  673649
  634849
  622377
  789689
  808626
  756246
  770630
  519984
  815508
  815769
  816502
  821384
  815866
  817295
  538865
  570146
  543792
  671701
  678016
  544960
  597101
  801182
  789480
  802849
  766743
  795033
  803088
  808115
  726831
  732600
  753204
  736393
  757244
  640403
  428822
  467638
  233670
  699025
  617190
  813530
  823358
  533211
  718560
  800278
  413475
  413472
  415346
  815693
  818386
  815555
  815829
  817915
  817843
  457199
  446622
  458012
  534851
  539839
  532980
  532991
  539480
  531434
  559074
  550223
  564818
  650494
  683541
  717724
  683826
  685646
  647984
  649939
  651077
  693849
  621319
  643352
  596788
  598837
  599997
  601843
  643095
  801475
  802832
  740154
  760002
  803081
  724633
  726982
  725568
  725581
  743811
  726640
  728798
  741308
  621323
  641138
  705738
  718552
  719016
  719112
  787443
  797646
  802741
  463160
  405806
  451434
  512999
  431376
  620134
  407516
  818463
  821194
  817928
  815237
  570183
  721611
  590903
]
3.06 ms
(1.63%)
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
  233670
  405806
  407516
  413472
  413475
  415346
  428822
  431376
  446622
  451434
  457199
  458012
  463160
  464389
  467638
  512999
  519984
  531434
  532980
  532991
  533211
  534851
  538865
  539480
  539839
  543792
  544960
  550050
  550223
  559074
  564818
  570146
  570183
  590903
  596788
  597101
  598837
  599997
  601843
  617190
  620134
  621319
  621323
  622377
  634849
  640403
  641138
  643095
  643352
  647984
  649939
  650494
  651077
  671701
  673582
  673649
  678016
  683541
  683826
  685646
  693849
  699025
  705738
  717724
  718552
  718560
  719016
  719112
  721611
  724633
  725568
  725581
  726640
  726831
  726982
  728798
  732600
  736393
  740154
  741308
  743811
  753204
  756246
  757244
  760002
  766743
  770630
  787443
  789480
  789689
  795033
  797646
  800278
  801182
  801475
  802741
  802832
  802849
  803081
  803088
  808115
  808626
  813530
  815237
  815508
  815555
  815693
  815769
  815829
  815866
  816502
  817295
  817843
  817915
  817928
  818386
  818463
  821194
  821384
  823358
]
2.17 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom ass kissing"
]
1.80 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom жоп kissing"
]
1.65 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom жоп kissing"
]
1.55 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.