GET https://search.jues.net/search/embeds/7?q=huge%20white%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.68 ms
(83.31%)
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
  7213
  172164
  383158
  383270
  384139
  390345
  397350
  398188
  400850
  400975
  404491
  404722
  405897
  406921
  408765
  411471
  411899
  412015
  413567
  413795
  415553
  415919
  416286
  417313
  417875
  418867
  419124
  419807
  420143
  421734
  422382
  425478
  425816
  427326
  430290
  430683
  438970
  440758
  443229
  444336
  446737
  448826
  450371
  452227
  452398
  453030
  453270
  454328
  456211
  457174
  458137
  459228
  459879
  460073
  460554
  462362
  462602
  463084
  465193
  467275
  468772
  469011
  469014
  469831
  469945
  470304
  472166
  473459
  474443
  474444
  474752
  475314
  477892
  480411
  482733
  485159
  486782
  486855
  488885
  489598
  498671
  502609
  506783
  509429
  509636
  511283
  512923
  514273
  517356
  521056
  521152
  522203
  523101
  524247
  524468
  526980
  529542
  530372
  531269
  531403
  532851
  535591
  536604
  536884
  542486
  542689
  547567
  560106
  561313
  568365
  574355
  574372
  647302
  658110
  714675
  729999
  808863
  815772
  818680
]
15.08 ms
(10.24%)
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
  523101
  542689
  400850
  404722
  417313
  422382
  416286
  469011
  470304
  411899
  419124
  459879
  469014
  509429
  517356
  384139
  172164
  7213
  404491
  405897
  408765
  421734
  430290
  425478
  427326
  446737
  450371
  462362
  465193
  448826
  457174
  468772
  469831
  472166
  474444
  486782
  453030
  454328
  458137
  462602
  467275
  474752
  475314
  477892
  482733
  532851
  535591
  536884
  521056
  529542
  506783
  512923
  524468
  531403
  474443
  480411
  488885
  547567
  560106
  542486
  561313
  574355
  647302
  658110
  729999
  808863
  400975
  413567
  459228
  463084
  469945
  398188
  418867
  419807
  443229
  411471
  425816
  438970
  444336
  383158
  397350
  413795
  415553
  430683
  456211
  417875
  512847
  509636
  514273
  524247
  485159
  489598
  498671
  526980
  521152
  502609
  415919
  452227
  511283
  486855
  568365
  460554
  522203
  383270
  390345
  420143
  406921
  412015
  440758
  815772
  818680
  452398
  473459
  453270
  460073
  531269
  536604
  530372
  574372
  714675
]
2.77 ms
(1.88%)
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
  7213
  172164
  383158
  383270
  384139
  390345
  397350
  398188
  400850
  400975
  404491
  404722
  405897
  406921
  408765
  411471
  411899
  412015
  413567
  413795
  415553
  415919
  416286
  417313
  417875
  418867
  419124
  419807
  420143
  421734
  422382
  425478
  425816
  427326
  430290
  430683
  438970
  440758
  443229
  444336
  446737
  448826
  450371
  452227
  452398
  453030
  453270
  454328
  456211
  457174
  458137
  459228
  459879
  460073
  460554
  462362
  462602
  463084
  465193
  467275
  468772
  469011
  469014
  469831
  469945
  470304
  472166
  473459
  474443
  474444
  474752
  475314
  477892
  480411
  482733
  485159
  486782
  486855
  488885
  489598
  498671
  502609
  506783
  509429
  509636
  511283
  512923
  514273
  517356
  521056
  521152
  522203
  523101
  524247
  524468
  526980
  529542
  530372
  531269
  531403
  532851
  535591
  536604
  536884
  542486
  542689
  547567
  560106
  561313
  568365
  574355
  574372
  647302
  658110
  714675
  729999
  808863
  815772
  818680
]
1.91 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge white tits"
]
1.59 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные white сиськ"
]
1.44 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные white сиськ"
]

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.