GET https://search.jues.net/search/embeds/8?q=russian%20anal%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.13 ms
(81.59%)
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
  421580
  421954
  422182
  422194
  425260
  426357
  426997
  427093
  433359
  436138
  437947
  439530
  439532
  439670
  439705
  443890
  444658
  446179
  446724
  447949
  452551
  452612
  454998
  456217
  456372
  456591
  459628
  461827
  461886
  462757
  464135
  466284
  467879
  473784
  474274
  475092
  478365
  478384
  479583
  482031
  483348
  484879
  485790
  485870
  490529
  492528
  492994
  497643
  498643
  500991
  507665
  508276
  509257
  509944
  509953
  510085
  510898
  512010
  513313
  513732
  514080
  520498
  521251
  523743
  523841
  524002
  525559
  528343
  533790
  545183
  547976
  552249
  552253
  555135
  556474
  562190
  565614
  568960
  570753
  571391
  572683
  579045
  579887
  588257
  609388
  612404
  619762
  623303
  623411
  625972
  626405
  661608
  661616
  671866
  676709
  680780
  685934
  723277
  751120
  757394
  761125
  765459
  765817
  767611
  771177
  776243
  778253
  781460
  782519
  783392
  787552
  789840
  793206
  797151
  807435
  807527
  810138
  810359
  813075
  825853
]
18.06 ms
(11.33%)
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
  492994
  685934
  793206
  426997
  579887
  464135
  482031
  484879
  507665
  509257
  520498
  562190
  556474
  579045
  789840
  422194
  483348
  525559
  437947
  570753
  626405
  439670
  444658
  452612
  467879
  478365
  421954
  454998
  426357
  433359
  447949
  427093
  513313
  513732
  485790
  456372
  825853
  490529
  459628
  568960
  545183
  547976
  671866
  680780
  723277
  552249
  555135
  612404
  588257
  807435
  807527
  765459
  783392
  751120
  765817
  609388
  623411
  810138
  810359
  452551
  462757
  478384
  461827
  461886
  466284
  479583
  436138
  443890
  456591
  473784
  422182
  446179
  456217
  446724
  509944
  485870
  508276
  512010
  521251
  497643
  510085
  523743
  498643
  500991
  509953
  524002
  492528
  565614
  778253
  571391
  552253
  572683
  439530
  439532
  421580
  439705
  514080
  523841
  528343
  510898
  533790
  661608
  661616
  676709
  619762
  623303
  625972
  813075
  781460
  787552
  797151
  767611
  757394
  771177
  761125
  776243
  782519
  474274
  475092
  425260
]
3.49 ms
(2.19%)
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
  421580
  421954
  422182
  422194
  425260
  426357
  426997
  427093
  433359
  436138
  437947
  439530
  439532
  439670
  439705
  443890
  444658
  446179
  446724
  447949
  452551
  452612
  454998
  456217
  456372
  456591
  459628
  461827
  461886
  462757
  464135
  466284
  467879
  473784
  474274
  475092
  478365
  478384
  479583
  482031
  483348
  484879
  485790
  485870
  490529
  492528
  492994
  497643
  498643
  500991
  507665
  508276
  509257
  509944
  509953
  510085
  510898
  512010
  513313
  513732
  514080
  520498
  521251
  523743
  523841
  524002
  525559
  528343
  533790
  545183
  547976
  552249
  552253
  555135
  556474
  562190
  565614
  568960
  570753
  571391
  572683
  579045
  579887
  588257
  609388
  612404
  619762
  623303
  623411
  625972
  626405
  661608
  661616
  671866
  676709
  680780
  685934
  723277
  751120
  757394
  761125
  765459
  765817
  767611
  771177
  776243
  778253
  781460
  782519
  783392
  787552
  789840
  793206
  797151
  807435
  807527
  810138
  810359
  813075
  825853
]
2.14 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал пов"
]
2.03 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian anal pov"
]
1.84 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск анал пов"
]
1.81 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.