GET https://search.jues.net/search/embeds/3?q=sex%20oral

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.06 ms
(86.56%)
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
  1117
  314397
  381735
  385892
  388630
  395388
  398009
  407159
  412880
  420001
  420425
  422110
  434539
  452996
  458127
  459771
  482569
  499621
  512390
  531340
  534580
  538822
  542967
  546434
  551585
  580512
  584664
  600098
  601705
  609675
  626267
  626800
  635117
  635755
  636143
  636835
  649561
  663098
  666391
  669890
  675509
  677347
  692734
  692829
  694130
  703445
  715981
  716603
  716648
  718530
  719113
  720217
  720221
  724014
  724560
  730382
  730482
  734461
  734705
  736407
  739258
  739437
  739989
  742084
  742126
  742567
  742592
  743439
  748876
  748921
  756055
  756295
  757804
  760787
  761546
  762443
  763502
  764790
  767555
  767836
  769556
  771343
  771359
  772280
  773363
  775168
  775625
  778079
  778741
  779339
  779548
  779729
  779814
  779845
  779966
  780022
  780770
  781361
  781602
  787040
  787156
  790268
  790618
  790771
  790997
  791217
  791585
  791825
  792659
  792717
  793347
  795055
  796051
  796556
  797507
  811462
  819000
  824972
  825759
  827189
]
13.77 ms
(7.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
  795055
  395388
  538822
  694130
  720217
  635755
  775168
  790268
  797507
  767555
  743439
  763502
  739258
  790771
  791825
  792717
  385892
  420425
  819000
  730482
  742126
  407159
  825759
  542967
  584664
  692734
  779966
  792659
  760787
  742084
  767836
  762443
  742567
  742592
  420001
  499621
  796556
  720221
  636143
  779339
  748921
  724560
  716648
  663098
  434539
  452996
  531340
  546434
  719113
  649561
  580512
  626800
  636835
  790618
  791217
  778079
  779814
  779845
  791585
  757804
  739437
  736407
  771343
  703445
  718530
  398009
  459771
  512390
  692829
  551585
  600098
  635117
  779729
  739989
  748876
  764790
  769556
  771359
  626267
  787040
  787156
  790997
  412880
  422110
  482569
  534580
  669890
  609675
  780770
  796051
  793347
  724014
  756055
  756295
  761546
  314397
  1117
  781602
  781361
  772280
  778741
  715981
  601705
  775625
  779548
  381735
  388630
  827189
  824972
  458127
  675509
  677347
  716603
  666391
  780022
  734461
  734705
  773363
  811462
  730382
]
2.55 ms
(1.41%)
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
  1117
  314397
  381735
  385892
  388630
  395388
  398009
  407159
  412880
  420001
  420425
  422110
  434539
  452996
  458127
  459771
  482569
  499621
  512390
  531340
  534580
  538822
  542967
  546434
  551585
  580512
  584664
  600098
  601705
  609675
  626267
  626800
  635117
  635755
  636143
  636835
  649561
  663098
  666391
  669890
  675509
  677347
  692734
  692829
  694130
  703445
  715981
  716603
  716648
  718530
  719113
  720217
  720221
  724014
  724560
  730382
  730482
  734461
  734705
  736407
  739258
  739437
  739989
  742084
  742126
  742567
  742592
  743439
  748876
  748921
  756055
  756295
  757804
  760787
  761546
  762443
  763502
  764790
  767555
  767836
  769556
  771343
  771359
  772280
  773363
  775168
  775625
  778079
  778741
  779339
  779548
  779729
  779814
  779845
  779966
  780022
  780770
  781361
  781602
  787040
  787156
  790268
  790618
  790771
  790997
  791217
  791585
  791825
  792659
  792717
  793347
  795055
  796051
  796556
  797507
  811462
  819000
  824972
  825759
  827189
]
2.16 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex oral"
]
2.14 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс oral"
]
2.01 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс oral"
]

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.