GET https://search.jues.net/search/embeds/6?q=homemade%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.11 ms
(85.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
  3793
  4123
  91433
  392225
  397115
  397652
  442429
  447779
  450285
  451225
  452320
  460933
  467603
  469898
  471086
  476892
  484234
  494313
  494893
  500182
  501435
  502934
  504219
  508650
  511652
  525714
  525788
  526683
  532200
  533269
  537765
  539145
  550268
  555685
  557919
  560276
  562544
  562709
  565676
  565833
  566926
  568025
  578135
  579721
  581927
  583743
  586607
  591939
  592654
  593701
  593785
  597678
  598594
  600537
  602635
  603564
  605765
  610477
  612987
  617953
  618360
  622894
  639083
  639124
  644524
  650649
  660454
  663721
  671901
  674387
  680302
  689048
  692345
  698780
  701879
  705428
  707149
  712449
  712610
  718332
  719772
  723302
  725656
  726897
  727874
  729115
  730361
  732500
  733786
  735276
  736198
  740815
  740961
  742648
  742754
  748846
  749621
  751842
  752046
  752083
  752487
  757943
  762622
  763475
  764095
  769296
  771316
  777009
  777757
  778415
  778847
  779360
  779659
  787011
  795195
  796055
  799830
  809755
  814696
]
15.38 ms
(8.45%)
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
  692345
  809755
  539145
  603564
  600537
  639124
  639083
  799830
  796055
  452320
  500182
  593701
  392225
  718332
  752046
  757943
  593785
  3793
  469898
  533269
  557919
  562544
  581927
  674387
  671901
  689048
  568025
  583743
  591939
  612987
  622894
  592654
  610477
  725656
  735276
  644524
  701879
  723302
  787011
  618360
  752487
  795195
  4123
  707149
  476892
  511652
  532200
  494313
  566926
  550268
  565833
  555685
  560276
  663721
  712449
  680302
  562709
  579721
  617953
  586607
  597678
  602635
  598594
  749621
  501435
  504219
  525714
  508650
  763475
  565676
  705428
  698780
  397115
  537765
  712610
  748846
  762622
  764095
  778415
  442429
  526683
  502934
  578135
  650649
  660454
  719772
  605765
  777757
  779360
  779659
  769296
  783461
  733786
  736198
  726897
  730361
  752083
  729115
  740961
  751842
  771316
  727874
  732500
  740815
  742648
  742754
  777009
  778847
  447779
  450285
  467603
  451225
  525788
  494893
  91433
  397652
  814696
  471086
  484234
  460933
]
2.89 ms
(1.59%)
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
  3793
  4123
  91433
  392225
  397115
  397652
  442429
  447779
  450285
  451225
  452320
  460933
  467603
  469898
  471086
  476892
  484234
  494313
  494893
  500182
  501435
  502934
  504219
  508650
  511652
  525714
  525788
  526683
  532200
  533269
  537765
  539145
  550268
  555685
  557919
  560276
  562544
  562709
  565676
  565833
  566926
  568025
  578135
  579721
  581927
  583743
  586607
  591939
  592654
  593701
  593785
  597678
  598594
  600537
  602635
  603564
  605765
  610477
  612987
  617953
  618360
  622894
  639083
  639124
  644524
  650649
  660454
  663721
  671901
  674387
  680302
  689048
  692345
  698780
  701879
  705428
  707149
  712449
  712610
  718332
  719772
  723302
  725656
  726897
  727874
  729115
  730361
  732500
  733786
  735276
  736198
  740815
  740961
  742648
  742754
  748846
  749621
  751842
  752046
  752083
  752487
  757943
  762622
  763475
  764095
  769296
  771316
  777009
  777757
  778415
  778847
  779360
  779659
  787011
  795195
  796055
  799830
  809755
  814696
]
2.18 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade doggy"
]
1.96 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск рак"
]
1.85 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.89%)
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.