GET https://search.jues.net/search/embeds/9?q=brunette%20saggy%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.71 ms
(83.77%)
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
  197445
  413503
  424781
  425507
  444413
  455373
  461224
  465818
  466396
  476425
  483364
  512681
  521210
  526632
  527258
  530567
  531925
  545535
  548258
  550595
  551022
  551837
  552930
  557786
  558102
  562526
  563083
  565123
  565128
  566670
  570891
  575999
  577432
  578774
  585303
  587568
  598955
  602219
  607378
  618292
  618867
  626948
  628698
  629799
  629977
  634866
  634877
  641627
  644550
  644766
  650301
  652253
  664559
  664731
  665103
  665237
  665894
  666836
  667464
  668496
  668532
  669755
  669758
  689364
  690048
  693508
  700086
  702232
  704542
  705396
  713842
  714148
  714358
  721475
  724538
  727524
  728238
  729948
  733129
  737736
  738220
  747183
  752812
  753663
  763179
  769450
  772772
  776636
  781964
  788240
  788276
  800237
  801091
  803185
  803984
  807393
  807777
  808038
  808126
  809288
  811360
  811557
  812392
  812524
  815398
  819381
  820085
  820374
  823848
  823868
  823983
  824173
  824313
  825056
  825183
  825885
  826012
  828008
  828604
]
15.94 ms
(9.56%)
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
  526632
  483364
  565128
  634866
  629799
  425507
  197445
  823983
  824313
  825056
  823848
  826012
  823868
  819381
  820085
  820374
  824173
  825885
  815398
  824734
  825183
  828008
  828604
  521210
  530567
  531925
  565123
  551837
  562526
  563083
  545535
  551022
  552930
  558102
  575999
  652253
  664731
  668532
  690048
  700086
  702232
  714358
  650301
  665103
  665894
  666836
  689364
  693508
  721475
  665237
  668496
  669755
  669758
  713842
  550595
  566670
  570891
  585303
  602219
  634877
  641627
  587568
  598955
  644550
  618292
  629977
  607378
  618867
  644766
  803185
  811360
  776636
  788240
  808038
  812392
  729948
  769450
  772772
  788276
  807393
  812524
  728238
  737736
  738220
  724538
  727524
  733129
  752812
  753663
  747183
  763179
  626948
  704542
  705396
  714148
  781964
  800237
  801091
  803984
  807777
  808126
  809288
  811557
  548258
  578774
  444413
  413503
  466396
  461224
  557786
  577432
  664559
  667464
  628698
  455373
  465818
  476425
  424781
  527258
  512681
]
3.18 ms
(1.91%)
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
  197445
  413503
  424781
  425507
  444413
  455373
  461224
  465818
  466396
  476425
  483364
  512681
  521210
  526632
  527258
  530567
  531925
  545535
  548258
  550595
  551022
  551837
  552930
  557786
  558102
  562526
  563083
  565123
  565128
  566670
  570891
  575999
  577432
  578774
  585303
  587568
  598955
  602219
  607378
  618292
  618867
  626948
  628698
  629799
  629977
  634866
  634877
  641627
  644550
  644766
  650301
  652253
  664559
  664731
  665103
  665237
  665894
  666836
  667464
  668496
  668532
  669755
  669758
  689364
  690048
  693508
  700086
  702232
  704542
  705396
  713842
  714148
  714358
  721475
  724538
  727524
  728238
  729948
  733129
  737736
  738220
  747183
  752812
  753663
  763179
  769450
  772772
  776636
  781964
  788240
  788276
  800237
  801091
  803185
  803984
  807393
  807777
  808038
  808126
  809288
  811360
  811557
  812392
  812524
  815398
  819381
  820085
  820374
  823848
  823868
  823983
  824173
  824313
  825056
  825183
  825885
  826012
  828008
  828604
]
2.19 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая saggy сиськ"
]
2.18 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette saggy tits"
]
1.82 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая saggy сиськ"
]

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.