GET https://search.jues.net/search/embeds/10?q=sex-couple

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
330.34 ms
(58.01%)
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
  172752
  212793
  279212
  390592
  393833
  395784
  397191
  398370
  399139
  400096
  412136
  421390
  433983
  436020
  437918
  438736
  453646
  463254
  466304
  467133
  471610
  474050
  476698
  482770
  494609
  500182
  507547
  509508
  511995
  515990
  522631
  526758
  530617
  533649
  537613
  537767
  538081
  539533
  548373
  552184
  589102
  592123
  600526
  601819
  606150
  619363
  623385
  626431
  633334
  636232
  637176
  641693
  646052
  647253
  650825
  652555
  654204
  660340
  663405
  669737
  674091
  674355
  690032
  692150
  693484
  693796
  696279
  701221
  708718
  713392
  715438
  721070
  723264
  724265
  724516
  732802
  733437
  734259
  737196
  737203
  737207
  745565
  748920
  750070
  750894
  753043
  753058
  753093
  753226
  756231
  760374
  762739
  765829
  773501
  776194
  776389
  778804
  778844
  782582
  784102
  785574
  786072
  786137
  786389
  786718
  787090
  800975
  802849
  804120
  806754
  807686
  808074
  809706
  810134
  812669
  813842
  813884
  819334
  824690
]
215.10 ms
(37.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс couple"
]
15.18 ms
(2.67%)
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
  806754
  397191
  412136
  463254
  390592
  395784
  474050
  494609
  515990
  652555
  696279
  713392
  600526
  636232
  601819
  606150
  782582
  786389
  786137
  762739
  765829
  724265
  750894
  641693
  400096
  212793
  466304
  507547
  509508
  732802
  393833
  438736
  437918
  813884
  819334
  471610
  530617
  537767
  552184
  646052
  660340
  690032
  715438
  619363
  592123
  800975
  778844
  737203
  810134
  724516
  753058
  753226
  737207
  753043
  776194
  785574
  809706
  467133
  476698
  421390
  433983
  279212
  539533
  650825
  654204
  692150
  647253
  674091
  802849
  807686
  398370
  669737
  674355
  693484
  721070
  808074
  756231
  773501
  399139
  172752
  436020
  813842
  824690
  482770
  453646
  511995
  522631
  533649
  538081
  500182
  526758
  537613
  549533
  548373
  663405
  701221
  723264
  693796
  708718
  626431
  633334
  637176
  589102
  776389
  812669
  778804
  786718
  737196
  753093
  760374
  786072
  787090
  734259
  733437
  745565
  750070
  748920
  623385
  784102
  804120
]
2.86 ms
(0.50%)
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
  172752
  212793
  279212
  390592
  393833
  395784
  397191
  398370
  399139
  400096
  412136
  421390
  433983
  436020
  437918
  438736
  453646
  463254
  466304
  467133
  471610
  474050
  476698
  482770
  494609
  500182
  507547
  509508
  511995
  515990
  522631
  526758
  530617
  533649
  537613
  537767
  538081
  539533
  548373
  552184
  589102
  592123
  600526
  601819
  606150
  619363
  623385
  626431
  633334
  636232
  637176
  641693
  646052
  647253
  650825
  652555
  654204
  660340
  663405
  669737
  674091
  674355
  690032
  692150
  693484
  693796
  696279
  701221
  708718
  713392
  715438
  721070
  723264
  724265
  724516
  732802
  733437
  734259
  737196
  737203
  737207
  745565
  748920
  750070
  750894
  753043
  753058
  753093
  753226
  756231
  760374
  762739
  765829
  773501
  776194
  776389
  778804
  778844
  782582
  784102
  785574
  786072
  786137
  786389
  786718
  787090
  800975
  802849
  804120
  806754
  807686
  808074
  809706
  810134
  812669
  813842
  813884
  819334
  824690
]
2.12 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex-couple"
]
1.97 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс couple"
]
1.83 ms
(0.32%)
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.