GET https://search.jues.net/search/embeds/3?q=black%20masturbation

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.79 ms
(85.63%)
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
  88591
  129722
  154491
  329912
  384272
  385341
  385855
  387218
  389640
  397973
  400802
  416583
  418031
  419998
  420116
  420383
  421051
  421761
  423663
  429855
  429869
  430549
  437733
  441901
  444695
  446994
  449161
  467588
  480541
  483079
  493001
  493763
  496456
  510330
  519712
  521238
  521631
  529634
  536182
  536527
  538725
  556788
  560738
  567063
  568257
  571194
  574391
  576503
  580329
  583093
  584425
  584685
  587214
  588697
  595194
  598504
  600907
  602296
  604571
  605074
  605129
  605196
  605244
  608516
  610101
  615447
  620147
  638477
  641806
  666490
  668663
  669062
  669357
  669771
  681643
  695464
  698407
  709885
  720186
  722488
  738826
  738926
  739089
  739961
  743935
  745111
  751309
  751822
  757232
  757402
  760211
  768692
  769476
  770544
  774029
  776035
  783053
  784959
  785552
  785580
  785877
  786412
  788863
  793151
  793923
  796629
  796650
  796696
  796871
  797051
  798601
  807173
  808580
  809000
  811696
  811727
  812372
  812738
  812743
  814459
]
16.64 ms
(8.92%)
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
  605244
  638477
  796871
  807173
  809000
  812743
  793923
  796629
  798601
  811727
  745111
  751309
  738926
  743935
  768692
  770544
  774029
  783053
  797051
  812738
  419998
  446994
  420116
  521631
  400802
  421761
  430549
  418031
  444695
  605196
  760211
  785877
  602296
  421051
  429855
  519712
  385855
  385341
  154491
  329912
  389640
  397973
  420383
  441901
  814459
  449161
  480541
  493763
  493001
  536527
  529634
  538725
  496456
  536182
  556788
  560738
  568257
  576503
  584425
  584685
  571194
  574391
  668663
  669062
  669357
  669771
  681643
  666490
  695464
  698407
  720186
  722488
  583093
  595194
  620147
  598504
  604571
  605129
  610101
  587214
  600907
  608516
  641806
  785580
  796650
  796696
  808580
  811696
  784959
  785552
  786412
  793151
  812372
  738826
  739961
  751822
  769476
  757402
  739089
  757232
  709885
  776035
  788863
  437733
  510330
  605074
  387218
  416583
  423663
  567063
  615447
  588697
  429869
  467588
  521238
  483079
  580329
  384272
  129722
  88591
]
2.54 ms
(1.36%)
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
  88591
  129722
  154491
  329912
  384272
  385341
  385855
  387218
  389640
  397973
  400802
  416583
  418031
  419998
  420116
  420383
  421051
  421761
  423663
  429855
  429869
  430549
  437733
  441901
  444695
  446994
  449161
  467588
  480541
  483079
  493001
  493763
  496456
  510330
  519712
  521238
  521631
  529634
  536182
  536527
  538725
  556788
  560738
  567063
  568257
  571194
  574391
  576503
  580329
  583093
  584425
  584685
  587214
  588697
  595194
  598504
  600907
  602296
  604571
  605074
  605129
  605196
  605244
  608516
  610101
  615447
  620147
  638477
  641806
  666490
  668663
  669062
  669357
  669771
  681643
  695464
  698407
  709885
  720186
  722488
  738826
  738926
  739089
  739961
  743935
  745111
  751309
  751822
  757232
  757402
  760211
  768692
  769476
  770544
  774029
  776035
  783053
  784959
  785552
  785580
  785877
  786412
  788863
  793151
  793923
  796629
  796650
  796696
  796871
  797051
  798601
  807173
  808580
  809000
  811696
  811727
  812372
  812738
  812743
  814459
]
2.15 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black мастурбац"
]
1.90 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black masturbation"
]
1.66 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black мастурбац"
]

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.