GET https://search.jues.net/search/embeds/6?q=curvy%20big%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.19 ms
(83.05%)
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
  188117
  386700
  394535
  395869
  400847
  401270
  403891
  416169
  419664
  421773
  432872
  440826
  445492
  445778
  446920
  448104
  450098
  450287
  450312
  451672
  452757
  453686
  454925
  456168
  457569
  457577
  459338
  460157
  464308
  465221
  466092
  468545
  468837
  471141
  473060
  473463
  475296
  476203
  477242
  478933
  487011
  492933
  493470
  498209
  500635
  503418
  503565
  505692
  506800
  509637
  509923
  510107
  513138
  515034
  516437
  522628
  523034
  523441
  523864
  525503
  527476
  527779
  532721
  532993
  535423
  537591
  541220
  544019
  546838
  552983
  563827
  564054
  564367
  566023
  567663
  577037
  577394
  579430
  586520
  586691
  589349
  590410
  596193
  600453
  601928
  603507
  607454
  607509
  607552
  607640
  607661
  607677
  607696
  607716
  608033
  612383
  618611
  618687
  634416
  641965
  665781
  671950
  676535
  695173
  702453
  716540
  716765
  723986
  756405
  760211
  770897
  780737
  782008
  809076
  810226
  810229
  810249
  812749
  812911
  813101
]
21.75 ms
(12.02%)
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
  468545
  468837
  473060
  509923
  516437
  523034
  532993
  537591
  460157
  493470
  546838
  579430
  541220
  567663
  564367
  695173
  577037
  634416
  589349
  603507
  612383
  601928
  607509
  607677
  590410
  809076
  760211
  782008
  810249
  812749
  723986
  607696
  608033
  780737
  810226
  419664
  432872
  445492
  465221
  466092
  394535
  446920
  450098
  492933
  188117
  416169
  445778
  477242
  510107
  716540
  586691
  607640
  618687
  770897
  813101
  600453
  607552
  607716
  535423
  473463
  403891
  452757
  459338
  464308
  515034
  525503
  509637
  563827
  544019
  665781
  607661
  596193
  618611
  812911
  702453
  395869
  401270
  421773
  476203
  513138
  498209
  454925
  453686
  506800
  456168
  386700
  400847
  440826
  450287
  478933
  448104
  450312
  451672
  457577
  471141
  457569
  475296
  487011
  503565
  505692
  522628
  523441
  532721
  500635
  503418
  523864
  527476
  527779
  566023
  552983
  577394
  671950
  716765
  676535
  564054
  607454
  586520
  810229
  756405
  641965
]
2.26 ms
(1.25%)
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
  188117
  386700
  394535
  395869
  400847
  401270
  403891
  416169
  419664
  421773
  432872
  440826
  445492
  445778
  446920
  448104
  450098
  450287
  450312
  451672
  452757
  453686
  454925
  456168
  457569
  457577
  459338
  460157
  464308
  465221
  466092
  468545
  468837
  471141
  473060
  473463
  475296
  476203
  477242
  478933
  487011
  492933
  493470
  498209
  500635
  503418
  503565
  505692
  506800
  509637
  509923
  510107
  513138
  515034
  516437
  522628
  523034
  523441
  523864
  525503
  527476
  527779
  532721
  532993
  535423
  537591
  541220
  544019
  546838
  552983
  563827
  564054
  564367
  566023
  567663
  577037
  577394
  579430
  586520
  586691
  589349
  590410
  596193
  600453
  601928
  603507
  607454
  607509
  607552
  607640
  607661
  607677
  607696
  607716
  608033
  612383
  618611
  618687
  634416
  641965
  665781
  671950
  676535
  695173
  702453
  716540
  716765
  723986
  756405
  760211
  770897
  780737
  782008
  809076
  810226
  810229
  810249
  812749
  812911
  813101
]
2.10 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "curvy big ass"
]
1.68 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "curvy большая большие жоп"
]
1.35 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "curvy большая большие жоп"
]

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.