GET https://search.jues.net/search/embeds/5?q=russian%20bathroom%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.22 ms
(85.76%)
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
  365898
  390931
  391077
  391489
  391772
  391928
  392604
  435064
  438109
  438735
  442612
  443262
  444139
  446904
  450920
  452181
  452548
  455738
  456499
  460857
  461499
  462992
  465222
  466311
  468094
  470281
  470287
  470459
  471542
  471772
  473269
  474992
  475885
  477949
  479091
  481102
  481191
  482909
  483654
  484105
  485441
  487612
  493164
  495298
  496030
  496357
  498192
  498879
  499059
  499302
  501747
  502388
  502670
  502762
  504233
  505372
  508164
  509088
  509430
  517355
  521999
  522305
  522732
  522792
  523974
  525984
  526044
  526147
  527737
  528215
  528805
  541550
  544552
  548732
  549825
  551278
  553665
  559020
  560380
  563233
  565863
  568728
  569301
  575200
  579075
  584890
  591130
  597159
  601877
  621499
  654032
  658376
  663293
  666472
  670977
  685514
  686331
  693371
  706705
  713940
  721461
  726164
  739441
  741699
  742409
  753365
  758993
  761022
  766811
  770442
  777963
  779535
  782131
  786732
  790263
  794428
  811653
  812287
  817998
  818830
]
16.04 ms
(8.64%)
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
  526147
  541550
  812287
  770442
  527737
  713940
  391772
  474992
  446904
  509430
  782131
  559020
  481191
  466311
  461499
  471542
  495298
  487612
  496030
  686331
  761022
  438735
  504233
  502670
  575200
  693371
  811653
  766811
  790263
  553665
  565863
  584890
  666472
  685514
  601877
  468094
  443262
  508164
  521999
  482909
  528805
  484105
  753365
  477949
  741699
  452548
  475885
  460857
  544552
  758993
  726164
  779535
  786732
  470459
  442612
  579075
  549825
  591130
  365898
  569301
  470281
  481102
  450920
  462992
  499059
  522305
  502762
  483654
  597159
  391077
  444139
  465222
  509088
  548732
  391489
  471772
  485441
  499302
  470287
  523974
  817998
  621499
  438109
  526044
  794428
  498879
  670977
  663293
  777963
  706705
  517355
  391928
  528215
  560380
  498192
  493164
  390931
  505372
  435064
  522792
  502388
  818830
  568728
  654032
  721461
  739441
  742409
  658376
  551278
  392604
  455738
  456499
  452181
  473269
  479091
  522732
  496357
  501747
  525984
  563233
]
3.31 ms
(1.78%)
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
  365898
  390931
  391077
  391489
  391772
  391928
  392604
  435064
  438109
  438735
  442612
  443262
  444139
  446904
  450920
  452181
  452548
  455738
  456499
  460857
  461499
  462992
  465222
  466311
  468094
  470281
  470287
  470459
  471542
  471772
  473269
  474992
  475885
  477949
  479091
  481102
  481191
  482909
  483654
  484105
  485441
  487612
  493164
  495298
  496030
  496357
  498192
  498879
  499059
  499302
  501747
  502388
  502670
  502762
  504233
  505372
  508164
  509088
  509430
  517355
  521999
  522305
  522732
  522792
  523974
  525984
  526044
  526147
  527737
  528215
  528805
  541550
  544552
  548732
  549825
  551278
  553665
  559020
  560380
  563233
  565863
  568728
  569301
  575200
  579075
  584890
  591130
  597159
  601877
  621499
  654032
  658376
  663293
  666472
  670977
  685514
  686331
  693371
  706705
  713940
  721461
  726164
  739441
  741699
  742409
  753365
  758993
  761022
  766811
  770442
  777963
  779535
  782131
  786732
  790263
  794428
  811653
  812287
  817998
  818830
]
2.16 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian bathroom sex"
]
1.78 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск ван секс"
]
1.58 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.