GET https://search.jues.net/search/embeds/3?q=quickie%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.43 ms
(87.59%)
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
  392279
  397533
  397613
  401250
  401386
  417255
  419253
  427771
  436825
  436838
  438053
  441336
  455261
  464870
  469492
  476698
  488640
  494931
  500095
  505564
  507141
  510223
  514444
  515615
  522190
  529384
  533479
  534736
  539353
  539638
  541021
  541203
  542122
  544536
  546268
  547884
  548395
  550787
  554314
  559654
  568728
  571374
  576800
  578787
  581578
  582678
  582852
  582941
  584944
  587983
  588325
  588399
  588433
  588941
  592073
  592083
  592105
  592133
  592145
  592147
  592323
  595117
  597925
  599455
  600539
  600704
  600865
  600876
  607041
  612035
  612233
  613630
  615963
  616674
  618533
  620547
  622886
  626843
  627774
  627841
  628824
  633253
  634895
  635009
  635064
  638117
  638859
  641897
  645736
  647813
  648424
  654129
  660351
  666669
  667469
  678217
  684898
  691229
  697390
  704425
  709952
  732543
  732783
  733516
  739963
  748707
  749318
  752147
  764029
  768197
  771514
  774007
  780619
  783722
  787317
  787830
  789597
  791625
  804326
  819449
]
14.73 ms
(7.57%)
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
  771514
  789597
  397613
  401386
  638859
  541021
  582941
  542122
  678217
  684898
  709952
  547884
  578787
  588325
  600876
  634895
  612233
  584944
  791625
  739963
  515615
  507141
  438053
  582852
  645736
  697390
  704425
  787830
  774007
  633253
  476698
  401250
  514444
  427771
  455261
  469492
  587983
  732783
  748707
  732543
  768197
  533479
  550787
  576800
  648424
  666669
  592147
  620547
  622886
  588433
  592073
  592133
  733516
  510223
  539353
  582678
  628824
  397533
  819449
  417255
  441336
  522190
  548395
  667469
  559654
  592083
  592145
  595117
  592323
  626843
  787317
  638117
  392279
  419253
  500095
  691229
  464870
  554314
  568728
  600865
  783722
  804326
  436838
  494931
  505564
  544536
  654129
  546268
  592105
  607041
  635009
  627774
  529384
  635064
  541203
  571374
  752147
  749318
  612035
  581578
  613630
  615963
  539638
  488640
  588399
  627841
  780619
  764029
  436825
  534736
  647813
  660351
  588941
  597925
  599455
  600704
  600539
  616674
  618533
  641897
]
3.26 ms
(1.67%)
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
  392279
  397533
  397613
  401250
  401386
  417255
  419253
  427771
  436825
  436838
  438053
  441336
  455261
  464870
  469492
  476698
  488640
  494931
  500095
  505564
  507141
  510223
  514444
  515615
  522190
  529384
  533479
  534736
  539353
  539638
  541021
  541203
  542122
  544536
  546268
  547884
  548395
  550787
  554314
  559654
  568728
  571374
  576800
  578787
  581578
  582678
  582852
  582941
  584944
  587983
  588325
  588399
  588433
  588941
  592073
  592083
  592105
  592133
  592145
  592147
  592323
  595117
  597925
  599455
  600539
  600704
  600865
  600876
  607041
  612035
  612233
  613630
  615963
  616674
  618533
  620547
  622886
  626843
  627774
  627841
  628824
  633253
  634895
  635009
  635064
  638117
  638859
  641897
  645736
  647813
  648424
  654129
  660351
  666669
  667469
  678217
  684898
  691229
  697390
  704425
  709952
  732543
  732783
  733516
  739963
  748707
  749318
  752147
  764029
  768197
  771514
  774007
  780619
  783722
  787317
  787830
  789597
  791625
  804326
  819449
]
1.78 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "quickie amateur"
]
1.53 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "quickie любительск"
]
1.41 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "quickie любительск"
]

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.