GET https://search.jues.net/search/embeds/10?q=chubby%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
186.55 ms
(87.78%)
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
  415040
  419982
  420473
  421814
  422147
  422179
  424180
  424857
  425562
  426517
  427081
  427089
  429649
  433419
  437385
  438577
  440164
  442442
  442443
  442952
  445884
  445929
  446945
  448237
  451220
  453310
  453561
  454963
  457358
  460343
  460704
  462277
  467087
  469558
  471641
  472509
  472964
  474385
  475645
  476758
  479804
  484098
  493844
  494798
  495237
  495951
  498768
  502568
  502973
  505391
  508705
  509594
  511096
  511104
  522219
  526311
  528526
  587156
  591748
  594257
  596521
  597777
  600983
  601006
  603417
  606143
  606974
  607621
  608029
  612263
  613640
  627013
  635980
  644735
  724292
  726968
  727014
  742622
  756322
  758170
  761495
  762886
  764247
  765493
  771682
  776518
  780430
  780442
  780473
  780669
  781852
  781892
  781898
  784771
  787029
  787065
  787754
  787802
  794129
  794530
  794556
  794822
  794846
  797340
  797343
  798351
  803537
  803814
  804509
  805032
  808228
  808239
  808416
  808681
  809281
  809649
  809693
  812372
  813440
  813441
]
17.43 ms
(8.20%)
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
  591748
  597777
  600983
  601006
  603417
  612263
  635980
  644735
  587156
  594257
  596521
  606143
  607621
  608029
  613640
  781898
  787754
  794846
  804509
  808228
  809649
  776518
  780442
  780473
  781852
  794530
  794556
  794822
  809693
  812372
  813441
  742622
  761495
  764247
  781892
  787065
  797343
  803537
  808239
  808416
  809281
  758170
  771682
  765493
  724292
  726968
  762886
  727014
  756322
  606974
  627013
  780430
  780669
  784771
  787029
  787802
  794129
  797340
  798351
  803814
  805032
  808681
  813440
  427089
  429649
  437385
  453310
  460704
  462277
  419982
  422147
  424180
  438577
  442443
  445929
  454963
  467087
  469558
  476758
  421814
  422179
  424857
  425562
  426517
  427081
  433419
  440164
  442442
  445884
  446945
  471641
  472964
  474385
  415040
  442952
  457358
  472509
  420473
  448237
  451220
  453561
  460343
  475645
  479804
  508705
  511104
  526311
  484098
  495951
  502568
  505391
  511096
  528526
  494798
  502973
  522219
  493844
  495237
  498768
  509594
]
2.50 ms
(1.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
  415040
  419982
  420473
  421814
  422147
  422179
  424180
  424857
  425562
  426517
  427081
  427089
  429649
  433419
  437385
  438577
  440164
  442442
  442443
  442952
  445884
  445929
  446945
  448237
  451220
  453310
  453561
  454963
  457358
  460343
  460704
  462277
  467087
  469558
  471641
  472509
  472964
  474385
  475645
  476758
  479804
  484098
  493844
  494798
  495237
  495951
  498768
  502568
  502973
  505391
  508705
  509594
  511096
  511104
  522219
  526311
  528526
  587156
  591748
  594257
  596521
  597777
  600983
  601006
  603417
  606143
  606974
  607621
  608029
  612263
  613640
  627013
  635980
  644735
  724292
  726968
  727014
  742622
  756322
  758170
  761495
  762886
  764247
  765493
  771682
  776518
  780430
  780442
  780473
  780669
  781852
  781892
  781898
  784771
  787029
  787065
  787754
  787802
  794129
  794530
  794556
  794822
  794846
  797340
  797343
  798351
  803537
  803814
  804509
  805032
  808228
  808239
  808416
  808681
  809281
  809649
  809693
  812372
  813440
  813441
]
1.80 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby pov"
]
1.65 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby пов"
]
1.13 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby пов"
]

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.