GET https://search.jues.net/search/embeds/8?q=%D0%BC%D0%B6%D0%BC%202009

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.96 ms
(82.84%)
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
  95788
  96819
  100449
  103696
  193662
  251147
  337190
  382697
  386194
  388821
  393673
  396709
  476838
  479067
  516646
  530289
  532717
  533034
  533646
  533689
  534133
  537005
  537104
  538141
  538814
  538883
  539018
  540122
  547980
  549312
  554876
  559212
  562588
  562591
  566394
  606535
  622116
  623525
  633965
  638654
  639075
  643927
  646240
  648996
  649947
  650815
  650852
  651313
  651423
  653603
  653624
  653628
  653634
  654481
  654574
  655994
  656677
  659589
  663902
  663977
  665114
  666798
  666841
  679079
  691497
  692336
  694555
  697447
  699531
  699779
  702877
  703070
  710212
  712887
  715534
  716202
  716829
  732597
  733020
  733179
  741207
  743414
  745208
  748384
  748436
  749269
  749639
  752076
  758298
  758599
  759910
  761506
  766568
  770840
  771723
  773947
  775899
  775904
  776528
  784331
  787575
  789708
  789961
  800007
  801093
  805304
  809941
  814946
  815667
  817341
  817618
  818932
  819311
  821857
  823976
  824228
  825690
  827873
  827896
  828865
]
15.09 ms
(10.08%)
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
  784331
  743414
  758599
  800007
  805304
  752076
  745208
  773947
  748436
  643927
  702877
  715534
  809941
  382697
  386194
  100449
  251147
  393673
  95788
  396709
  817341
  819311
  814946
  818932
  533689
  538814
  539018
  559212
  562588
  646240
  649947
  650815
  653634
  654574
  679079
  650852
  651313
  653628
  663977
  691497
  694555
  699531
  699779
  653603
  656677
  666841
  692336
  697447
  710212
  712887
  716202
  716829
  639075
  606535
  622116
  633965
  638654
  775904
  789708
  801093
  775899
  749639
  758298
  759910
  766568
  787575
  732597
  749269
  733020
  733179
  761506
  770840
  741207
  748384
  771723
  623525
  703070
  776528
  789961
  96819
  476838
  388821
  103696
  193662
  337190
  817618
  815667
  823976
  824228
  821857
  825690
  828865
  827873
  827896
  530289
  532717
  540122
  533034
  534133
  537005
  537104
  538883
  533646
  538141
  516646
  479067
  547980
  566394
  549312
  554876
  562591
  648996
  651423
  653624
  654481
  655994
  659589
  663902
  665114
  666798
]
3.14 ms
(2.10%)
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
  95788
  96819
  100449
  103696
  193662
  251147
  337190
  382697
  386194
  388821
  393673
  396709
  476838
  479067
  516646
  530289
  532717
  533034
  533646
  533689
  534133
  537005
  537104
  538141
  538814
  538883
  539018
  540122
  547980
  549312
  554876
  559212
  562588
  562591
  566394
  606535
  622116
  623525
  633965
  638654
  639075
  643927
  646240
  648996
  649947
  650815
  650852
  651313
  651423
  653603
  653624
  653628
  653634
  654481
  654574
  655994
  656677
  659589
  663902
  663977
  665114
  666798
  666841
  679079
  691497
  692336
  694555
  697447
  699531
  699779
  702877
  703070
  710212
  712887
  715534
  716202
  716829
  732597
  733020
  733179
  741207
  743414
  745208
  748384
  748436
  749269
  749639
  752076
  758298
  758599
  759910
  761506
  766568
  770840
  771723
  773947
  775899
  775904
  776528
  784331
  787575
  789708
  789961
  800007
  801093
  805304
  809941
  814946
  815667
  817341
  817618
  818932
  819311
  821857
  823976
  824228
  825690
  827873
  827896
  828865
]
2.14 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мжм 2009"
]
1.87 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мжм секс втро"
]
1.78 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мжм секс втро"
]
1.66 ms
(1.11%)
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.