GET https://search.jues.net/search/embeds/2?q=huge%20gape

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.23 ms
(85.72%)
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
  154187
  154516
  154573
  154692
  154694
  154844
  340613
  352189
  382813
  386226
  393047
  393314
  398089
  398940
  402632
  403439
  411211
  413641
  413789
  414099
  414122
  416695
  421369
  429601
  445969
  446799
  455915
  469567
  476184
  479818
  482293
  487275
  487425
  497471
  506105
  526902
  529738
  530368
  530698
  530943
  531869
  531877
  531888
  532634
  532837
  532838
  534764
  536621
  536628
  541442
  544848
  547484
  550314
  550892
  554978
  561887
  562797
  574391
  576484
  576637
  580069
  580130
  582076
  584425
  590234
  607638
  607965
  609804
  617577
  624405
  625779
  627194
  627224
  629281
  634114
  638477
  644273
  655242
  660375
  660417
  664149
  669067
  669080
  670366
  671044
  672901
  673719
  687398
  695757
  700975
  706024
  713196
  713506
  713508
  722328
  738280
  742066
  742360
  742702
  745248
  752651
  758248
  758322
  770049
  770219
  770263
  770264
  774667
  780653
  782791
  787510
  792693
  796872
  799789
  805261
  808964
  809600
  811477
  827290
]
16.03 ms
(8.74%)
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
  742066
  722328
  154187
  526902
  530368
  487275
  561887
  673719
  638477
  758248
  340613
  629281
  670366
  770263
  770264
  529738
  627224
  758322
  413641
  455915
  534764
  530943
  541442
  660375
  411211
  482293
  469567
  479818
  792693
  154573
  554978
  576484
  582076
  550892
  687398
  695757
  607965
  609804
  590234
  774667
  805261
  770049
  742702
  809600
  530698
  580069
  154844
  393314
  398089
  414099
  429601
  827290
  531877
  531888
  532634
  531869
  487425
  544848
  547484
  584425
  562797
  576637
  574391
  660417
  655242
  713508
  580130
  607638
  634114
  780653
  787510
  811477
  742360
  752651
  154694
  536628
  386226
  416695
  550314
  700975
  402632
  413789
  393047
  713506
  799789
  624405
  398940
  671044
  664149
  669067
  669080
  154516
  445969
  497471
  713196
  672901
  617577
  627194
  738280
  808964
  770219
  625779
  706024
  782791
  796872
  382813
  154692
  745248
  403439
  446799
  532838
  536621
  532837
  644273
  414122
  476184
  630427
  421369
  506105
  352189
]
2.72 ms
(1.48%)
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
  154187
  154516
  154573
  154692
  154694
  154844
  340613
  352189
  382813
  386226
  393047
  393314
  398089
  398940
  402632
  403439
  411211
  413641
  413789
  414099
  414122
  416695
  421369
  429601
  445969
  446799
  455915
  469567
  476184
  479818
  482293
  487275
  487425
  497471
  506105
  526902
  529738
  530368
  530698
  530943
  531869
  531877
  531888
  532634
  532837
  532838
  534764
  536621
  536628
  541442
  544848
  547484
  550314
  550892
  554978
  561887
  562797
  574391
  576484
  576637
  580069
  580130
  582076
  584425
  590234
  607638
  607965
  609804
  617577
  624405
  625779
  627194
  627224
  629281
  634114
  638477
  644273
  655242
  660375
  660417
  664149
  669067
  669080
  670366
  671044
  672901
  673719
  687398
  695757
  700975
  706024
  713196
  713506
  713508
  722328
  738280
  742066
  742360
  742702
  745248
  752651
  758248
  758322
  770049
  770219
  770263
  770264
  774667
  780653
  782791
  787510
  792693
  796872
  799789
  805261
  808964
  809600
  811477
  827290
]
2.33 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge gape"
]
1.92 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные большая большие дырк"
]
1.77 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.78%)
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.