GET https://search.jues.net/search/embeds/9?q=dildo%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
198.64 ms
(88.42%)
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
  389602
  412855
  413381
  413641
  416000
  416511
  416596
  419352
  420277
  420295
  420742
  420816
  421369
  423487
  426144
  429598
  429608
  429905
  430066
  430365
  432179
  432299
  433001
  434309
  434313
  434361
  436132
  439117
  439150
  439688
  440723
  441907
  443209
  443249
  444052
  444548
  446778
  447198
  448012
  448257
  448414
  448570
  449677
  450274
  456705
  457214
  457948
  460540
  466637
  471693
  473395
  476434
  476675
  476707
  478514
  478720
  479204
  479544
  479990
  482307
  483735
  484907
  487008
  491007
  510271
  510280
  511455
  512116
  513000
  514220
  515490
  515542
  516618
  523181
  524075
  525112
  529154
  531352
  542987
  546762
  549804
  554826
  555565
  559784
  561192
  564961
  567062
  567604
  567908
  571042
  580190
  582281
  584421
  584806
  586002
  586136
  586199
  586821
  595339
  601792
  604059
  604909
  605851
  625177
  629287
  633485
  639119
  639338
  640152
  640270
  659451
  678950
  720206
  750907
  752700
  756840
  796057
  803557
  824745
]
17.22 ms
(7.66%)
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
  479544
  559784
  429905
  434309
  531352
  389602
  443249
  446778
  515490
  546762
  555565
  416511
  567908
  491007
  423487
  439150
  420742
  487008
  567062
  571042
  567604
  586136
  750907
  756840
  439117
  460540
  443209
  584806
  629287
  803557
  440723
  516618
  512116
  412855
  483735
  542987
  604909
  796057
  419352
  497689
  525112
  595339
  457214
  420295
  429608
  413641
  586002
  444548
  421369
  513000
  639119
  678950
  639338
  450274
  514220
  482307
  659451
  605851
  633485
  434313
  430066
  640270
  441907
  476707
  510271
  582281
  586821
  625177
  640152
  604059
  720206
  429598
  447198
  448012
  430365
  510280
  515542
  824745
  549804
  586199
  554826
  436132
  448570
  511455
  529154
  561192
  476434
  476675
  471693
  432299
  416596
  413381
  478514
  466637
  479990
  426144
  448414
  564961
  420816
  584421
  434361
  444052
  449677
  420277
  478720
  479204
  473395
  524075
  416000
  752700
  439688
  448257
  433001
  601792
  432179
  523181
  580190
  456705
  457948
  484907
]
2.17 ms
(0.97%)
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
  389602
  412855
  413381
  413641
  416000
  416511
  416596
  419352
  420277
  420295
  420742
  420816
  421369
  423487
  426144
  429598
  429608
  429905
  430066
  430365
  432179
  432299
  433001
  434309
  434313
  434361
  436132
  439117
  439150
  439688
  440723
  441907
  443209
  443249
  444052
  444548
  446778
  447198
  448012
  448257
  448414
  448570
  449677
  450274
  456705
  457214
  457948
  460540
  466637
  471693
  473395
  476434
  476675
  476707
  478514
  478720
  479204
  479544
  479990
  482307
  483735
  484907
  487008
  491007
  510271
  510280
  511455
  512116
  513000
  514220
  515490
  515542
  516618
  523181
  524075
  525112
  529154
  531352
  542987
  546762
  549804
  554826
  555565
  559784
  561192
  564961
  567062
  567604
  567908
  571042
  580190
  582281
  584421
  584806
  586002
  586136
  586199
  586821
  595339
  601792
  604059
  604909
  605851
  625177
  629287
  633485
  639119
  639338
  640152
  640270
  659451
  678950
  720206
  750907
  752700
  756840
  796057
  803557
  824745
]
1.81 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд домашн любительск"
]
1.65 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд домашн любительск"
]
1.56 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo homemade"
]

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.