GET https://search.jues.net/search/embeds/10?q=doggy%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.19 ms
(84.85%)
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
  89
  12904
  58636
  233521
  240594
  262435
  304428
  322187
  382045
  383891
  383985
  385479
  388200
  388771
  390580
  390646
  391577
  396217
  399062
  400484
  411125
  415757
  421853
  424114
  427009
  427250
  433866
  440606
  441597
  457443
  459986
  463991
  465724
  469495
  470635
  478362
  480415
  481217
  483025
  483351
  485599
  487599
  488529
  492754
  498363
  498762
  508385
  514202
  518182
  518411
  519205
  520366
  521470
  522625
  524993
  526346
  526528
  531973
  532140
  532396
  533617
  537963
  538109
  541320
  549981
  551520
  557479
  562093
  564967
  565603
  568163
  577739
  578916
  580932
  582040
  583009
  583344
  585385
  592315
  597892
  601463
  608311
  618360
  620423
  624073
  626002
  626996
  641890
  654263
  656522
  663202
  667897
  669589
  680453
  706785
  711560
  711577
  724139
  734332
  737303
  737360
  738566
  742758
  745942
  746165
  757909
  765341
  768962
  769452
  773369
  781994
  790444
  795948
  796935
  808223
  811736
  812935
  814724
  814990
  825671
]
12.95 ms
(8.50%)
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
  519205
  498762
  521470
  487599
  568163
  583344
  551520
  557479
  580932
  564967
  618360
  597892
  811736
  724139
  478362
  383985
  427009
  427250
  457443
  480415
  421853
  508385
  526346
  526528
  537963
  485599
  520366
  488529
  518411
  532140
  483025
  498363
  385479
  549981
  562093
  654263
  578916
  12904
  233521
  240594
  322187
  58636
  89
  388771
  415757
  524993
  663202
  680453
  626996
  812935
  765341
  796935
  304428
  411125
  470635
  388200
  433866
  465724
  773369
  738566
  781994
  400484
  391577
  382045
  399062
  424114
  814990
  459986
  463991
  481217
  514202
  531973
  538109
  532396
  483351
  541320
  577739
  583009
  582040
  667897
  711577
  656522
  711560
  669589
  706785
  565603
  608311
  620423
  641890
  585385
  592315
  624073
  626002
  601463
  795948
  808223
  734332
  737360
  769452
  745942
  757909
  768962
  737303
  746165
  742758
  790444
  440606
  262435
  396217
  441597
  492754
  469495
  390646
  383891
  390580
  814724
  825671
  522625
  533617
  518182
]
3.46 ms
(2.27%)
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
  89
  12904
  58636
  233521
  240594
  262435
  304428
  322187
  382045
  383891
  383985
  385479
  388200
  388771
  390580
  390646
  391577
  396217
  399062
  400484
  411125
  415757
  421853
  424114
  427009
  427250
  433866
  440606
  441597
  457443
  459986
  463991
  465724
  469495
  470635
  478362
  480415
  481217
  483025
  483351
  485599
  487599
  488529
  492754
  498363
  498762
  508385
  514202
  518182
  518411
  519205
  520366
  521470
  522625
  524993
  526346
  526528
  531973
  532140
  532396
  533617
  537963
  538109
  541320
  549981
  551520
  557479
  562093
  564967
  565603
  568163
  577739
  578916
  580932
  582040
  583009
  583344
  585385
  592315
  597892
  601463
  608311
  618360
  620423
  624073
  626002
  626996
  641890
  654263
  656522
  663202
  667897
  669589
  680453
  706785
  711560
  711577
  724139
  734332
  737303
  737360
  738566
  742758
  745942
  746165
  757909
  765341
  768962
  769452
  773369
  781994
  790444
  795948
  796935
  808223
  811736
  812935
  814724
  814990
  825671
]
1.87 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy ass"
]
1.64 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак жоп"
]
1.43 ms
(0.94%)
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.