GET https://search.jues.net/search/embeds/3?q=cum%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.56 ms
(81.76%)
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
  8164
  73204
  386266
  388127
  391009
  392478
  392772
  394013
  397867
  398686
  398930
  415039
  421653
  421762
  423459
  423471
  423942
  427233
  427911
  432470
  440721
  441301
  452731
  455165
  455540
  458313
  459083
  460076
  463501
  472971
  487216
  491046
  491462
  493402
  493755
  495032
  496243
  497174
  509170
  519598
  522749
  524134
  539913
  545114
  546893
  548991
  573915
  575539
  578207
  578809
  579977
  584722
  588531
  589383
  590818
  605675
  609634
  617732
  617780
  618629
  620828
  621183
  626839
  627326
  628596
  641524
  653117
  666468
  675581
  691411
  691982
  700379
  702280
  705705
  707183
  727649
  731345
  739906
  740175
  746342
  746358
  746605
  748609
  750458
  758023
  758780
  759913
  760241
  760301
  763518
  765962
  768577
  771931
  773601
  778786
  779266
  779948
  791797
  794377
  795198
  796137
  800906
  800994
  803301
  808104
  810706
  816808
  818097
  819334
  819830
  823718
  823841
  824494
  826575
  827034
  827632
  828442
  828549
  828781
]
16.07 ms
(10.72%)
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
  493402
  386266
  816808
  819830
  823841
  509170
  618629
  727649
  765962
  768577
  808104
  73204
  388127
  427233
  421653
  423459
  423942
  427911
  421762
  423471
  495032
  546893
  545114
  700379
  702280
  666468
  707183
  620828
  588531
  589383
  779266
  779948
  746605
  760241
  795198
  739906
  740175
  759913
  763518
  609634
  800994
  392478
  398930
  440721
  459083
  455165
  491462
  391009
  397867
  460076
  524134
  496243
  691411
  590818
  627326
  810706
  758780
  731345
  748609
  746358
  617732
  800906
  3793
  432470
  472971
  519598
  493755
  491046
  584722
  823718
  826575
  827034
  824494
  828549
  573915
  641524
  794377
  796137
  803301
  548991
  415039
  441301
  819334
  455540
  497174
  487216
  579977
  675581
  628596
  621183
  746342
  791797
  760301
  617780
  705705
  394013
  8164
  398686
  392772
  818097
  828781
  827632
  828442
  522749
  578809
  653117
  691982
  750458
  773601
  758023
  771931
  778786
  458313
  452731
  539913
  463501
  575539
  578207
  605675
  626839
]
3.61 ms
(2.41%)
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
  8164
  73204
  386266
  388127
  391009
  392478
  392772
  394013
  397867
  398686
  398930
  415039
  421653
  421762
  423459
  423471
  423942
  427233
  427911
  432470
  440721
  441301
  452731
  455165
  455540
  458313
  459083
  460076
  463501
  472971
  487216
  491046
  491462
  493402
  493755
  495032
  496243
  497174
  509170
  519598
  522749
  524134
  539913
  545114
  546893
  548991
  573915
  575539
  578207
  578809
  579977
  584722
  588531
  589383
  590818
  605675
  609634
  617732
  617780
  618629
  620828
  621183
  626839
  627326
  628596
  641524
  653117
  666468
  675581
  691411
  691982
  700379
  702280
  705705
  707183
  727649
  731345
  739906
  740175
  746342
  746358
  746605
  748609
  750458
  758023
  758780
  759913
  760241
  760301
  763518
  765962
  768577
  771931
  773601
  778786
  779266
  779948
  791797
  794377
  795198
  796137
  800906
  800994
  803301
  808104
  810706
  816808
  818097
  819334
  819830
  823718
  823841
  824494
  826575
  827034
  827632
  828442
  828549
  828781
]
2.24 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum doggy"
]
2.03 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum рак"
]
1.60 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum рак"
]

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.