GET https://search.jues.net/search/embeds/4?q=gape%20gangbang

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.92 ms
(82.00%)
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
  97401
  282858
  386935
  388492
  389765
  397293
  404368
  406290
  406304
  408439
  420471
  423655
  483542
  485147
  507696
  510180
  512453
  522142
  525864
  530054
  530636
  530643
  530766
  530771
  530789
  531183
  531206
  532804
  532989
  533003
  533051
  534151
  534381
  534650
  536287
  536344
  537917
  541201
  542213
  542860
  542877
  544439
  545387
  550176
  550199
  550200
  565263
  565418
  571230
  573761
  574247
  583707
  583933
  597199
  597243
  597269
  597275
  597876
  599851
  599893
  600175
  600219
  600270
  600297
  600355
  600366
  601512
  601593
  606590
  616338
  623519
  630678
  630857
  630902
  632046
  632638
  632658
  632660
  633776
  634154
  634161
  634786
  635210
  635225
  636316
  637042
  637089
  637116
  637120
  639335
  641413
  641705
  644971
  644972
  645973
  648238
  660422
  666585
  666903
  666912
  678135
  679025
  679761
  679798
  680120
  680142
  680192
  680202
  695125
  696998
  697025
  701337
  704715
  725598
  733838
  772038
  775985
  801958
  801975
  805275
]
17.55 ms
(11.25%)
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
  408439
  406290
  485147
  510180
  530636
  542877
  550176
  550200
  565418
  645973
  666585
  666912
  679025
  648238
  660422
  679761
  545387
  583933
  616338
  630678
  632638
  634154
  635225
  639335
  597243
  606590
  632658
  637089
  637120
  600175
  632660
  636316
  599851
  635210
  641413
  775985
  801958
  733838
  725598
  634786
  597199
  632046
  522142
  600297
  406304
  532989
  530771
  530789
  541201
  666903
  386935
  772038
  483542
  525864
  678135
  637116
  597876
  600355
  701337
  97401
  388492
  420471
  644972
  533003
  534151
  544439
  573761
  565263
  574247
  680192
  680202
  679798
  680120
  680142
  696998
  704715
  695125
  697025
  599893
  600366
  641705
  630857
  634161
  597269
  597275
  633776
  601593
  630902
  805275
  801975
  601512
  623519
  397293
  282858
  389765
  404368
  507696
  600270
  637042
  600219
  512453
  423655
  644971
  531206
  532804
  534650
  536287
  530766
  533051
  536344
  530054
  531183
  534381
  537917
  530643
  542860
  550199
  571230
  583707
  542213
]
3.40 ms
(2.18%)
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
  97401
  282858
  386935
  388492
  389765
  397293
  404368
  406290
  406304
  408439
  420471
  423655
  483542
  485147
  507696
  510180
  512453
  522142
  525864
  530054
  530636
  530643
  530766
  530771
  530789
  531183
  531206
  532804
  532989
  533003
  533051
  534151
  534381
  534650
  536287
  536344
  537917
  541201
  542213
  542860
  542877
  544439
  545387
  550176
  550199
  550200
  565263
  565418
  571230
  573761
  574247
  583707
  583933
  597199
  597243
  597269
  597275
  597876
  599851
  599893
  600175
  600219
  600270
  600297
  600355
  600366
  601512
  601593
  606590
  616338
  623519
  630678
  630857
  630902
  632046
  632638
  632658
  632660
  633776
  634154
  634161
  634786
  635210
  635225
  636316
  637042
  637089
  637116
  637120
  639335
  641413
  641705
  644971
  644972
  645973
  648238
  660422
  666585
  666903
  666912
  678135
  679025
  679761
  679798
  680120
  680142
  680192
  680202
  695125
  696998
  697025
  701337
  704715
  725598
  733838
  772038
  775985
  801958
  801975
  805275
]
2.05 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gape gangbang"
]
1.88 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие дырк gangbang"
]
1.64 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие дырк gangbang"
]

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.