GET https://search.jues.net/search/embeds/8?q=dildo%20in%20bathroom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
290.74 ms
(90.90%)
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
  81734
  394514
  414062
  418713
  427174
  427232
  427395
  431962
  434107
  437925
  440526
  444594
  447431
  452968
  457007
  463929
  464916
  470568
  473869
  474538
  487405
  488733
  495138
  496240
  496725
  496744
  497225
  505504
  508786
  510200
  510425
  510581
  511545
  511838
  514660
  515878
  516332
  519825
  522307
  522310
  522763
  525483
  527122
  528283
  530110
  532152
  533998
  534791
  535823
  536691
  540535
  541602
  548921
  554742
  556539
  557676
  566025
  566363
  571034
  574049
  577023
  579947
  583866
  586102
  586199
  587235
  590145
  590664
  592206
  598105
  598649
  601358
  604109
  604824
  615697
  617865
  623135
  629298
  631243
  633445
  633454
  635234
  637087
  647872
  663412
  663730
  664972
  665107
  666867
  673612
  678713
  680816
  687339
  691797
  712475
  713125
  715786
  716550
  728684
  731105
  748521
  751265
  765479
  771082
  776481
  780181
  782452
  783460
  787365
  792343
  795398
  798647
  799705
  811808
  812757
  812874
  814777
  814783
  815789
  821600
]
18.99 ms
(5.94%)
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
  680816
  557676
  633445
  437925
  434107
  814783
  525483
  535823
  515878
  474538
  566363
  583866
  574049
  663412
  687339
  691797
  712475
  716550
  647872
  663730
  673612
  713125
  664972
  579947
  604824
  604109
  586102
  792343
  782452
  783460
  798647
  812757
  731105
  771082
  795398
  811808
  748521
  765479
  617865
  427395
  444594
  488733
  487405
  821600
  473869
  427232
  530110
  678713
  787365
  516332
  522307
  534791
  511838
  540535
  536691
  598649
  665107
  815789
  452968
  470568
  495138
  519825
  528283
  464916
  556539
  666867
  715786
  633454
  590145
  631243
  637087
  776481
  751265
  623135
  418713
  447431
  511545
  522310
  522763
  510581
  440526
  615697
  505504
  514660
  601358
  394514
  586199
  577023
  548921
  780181
  496240
  527122
  496725
  510200
  496744
  554742
  571034
  635234
  497225
  508786
  81734
  510425
  799705
  431962
  814777
  532152
  541602
  629298
  590664
  587235
  812874
  457007
  463929
  592206
  414062
  728684
  598105
  427174
  566025
  533998
]
2.39 ms
(0.75%)
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
  81734
  394514
  414062
  418713
  427174
  427232
  427395
  431962
  434107
  437925
  440526
  444594
  447431
  452968
  457007
  463929
  464916
  470568
  473869
  474538
  487405
  488733
  495138
  496240
  496725
  496744
  497225
  505504
  508786
  510200
  510425
  510581
  511545
  511838
  514660
  515878
  516332
  519825
  522307
  522310
  522763
  525483
  527122
  528283
  530110
  532152
  533998
  534791
  535823
  536691
  540535
  541602
  548921
  554742
  556539
  557676
  566025
  566363
  571034
  574049
  577023
  579947
  583866
  586102
  586199
  587235
  590145
  590664
  592206
  598105
  598649
  601358
  604109
  604824
  615697
  617865
  623135
  629298
  631243
  633445
  633454
  635234
  637087
  647872
  663412
  663730
  664972
  665107
  666867
  673612
  678713
  680816
  687339
  691797
  712475
  713125
  715786
  716550
  728684
  731105
  748521
  751265
  765479
  771082
  776481
  780181
  782452
  783460
  787365
  792343
  795398
  798647
  799705
  811808
  812757
  812874
  814777
  814783
  815789
  821600
]
2.36 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд ван"
]
1.86 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo in bathroom"
]
1.58 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд ван"
]

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.