GET https://search.jues.net/search/embeds/3?q=fuck%20bdsm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.73 ms
(49.00%)
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
  79082
  386416
  391868
  395405
  395654
  413112
  417319
  417486
  420384
  422483
  424652
  429300
  429519
  436066
  442642
  443461
  444195
  444828
  447788
  448399
  451410
  451671
  451742
  456212
  457367
  462356
  462357
  462366
  471935
  475930
  477036
  477401
  480425
  480941
  482804
  483159
  483387
  484466
  484468
  484486
  487115
  491115
  493275
  494997
  497021
  497386
  500122
  501232
  506501
  508989
  509557
  509862
  510115
  510802
  512170
  512459
  512857
  512860
  513114
  513119
  514710
  515936
  517746
  518005
  519729
  521181
  522352
  522379
  522869
  523183
  525703
  527880
  529708
  533138
  533657
  533983
  536690
  537192
  539518
  540115
  546256
  550010
  558640
  560426
  568525
  569698
  595965
  612178
  617620
  623868
  626735
  641345
  650450
  664459
  668545
  685626
  705530
  716728
  720308
  720739
  722101
  731814
  737473
  751150
  758448
  758456
  763624
  765148
  768989
  774174
  786049
  788887
  791100
  798671
  801273
  802126
  805459
  810192
  813253
  813455
]
191.67 ms
(45.21%)
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
  79082
  386416
  391868
  395405
  395654
  413112
  417319
  417486
  420384
  422483
  424652
  429300
  429519
  436066
  442642
  443461
  444195
  444828
  447788
  448399
  451410
  451671
  451742
  456212
  457367
  462356
  462357
  462366
  471935
  475930
  477036
  477401
  480425
  480941
  482804
  483159
  483387
  484466
  484468
  484486
  487115
  491115
  493275
  494997
  497021
  497386
  500122
  501232
  506501
  508989
  509557
  509862
  510115
  510802
  512170
  512459
  512857
  512860
  513114
  513119
  514710
  515936
  517746
  518005
  519729
  521181
  522352
  522379
  522869
  523183
  525703
  527880
  529708
  533138
  533657
  533983
  536690
  537192
  539518
  540115
  546256
  550010
  558640
  560426
  568525
  569698
  595965
  612178
  617620
  623868
  626735
  641345
  650450
  664459
  668545
  685626
  705530
  716728
  720308
  720739
  722101
  731814
  737473
  751150
  758448
  758456
  763624
  765148
  768989
  774174
  786049
  788887
  791100
  798671
  801273
  802126
  805459
  810192
  813253
  813455
]
16.97 ms
(4.00%)
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
  768989
  491115
  475930
  664459
  569698
  788887
  705530
  560426
  451410
  512459
  523183
  417486
  810192
  517746
  685626
  521181
  522869
  522379
  802126
  813455
  758456
  720308
  518005
  436066
  716728
  758448
  801273
  79082
  395654
  429300
  422483
  443461
  451671
  462366
  484466
  462357
  522352
  533657
  506501
  510802
  513119
  650450
  774174
  751150
  386416
  442642
  484486
  513114
  519729
  420384
  429519
  413112
  424652
  444828
  482804
  451742
  457367
  483387
  512860
  529708
  512170
  539518
  668545
  722101
  720739
  617620
  626735
  641345
  786049
  798671
  477401
  395405
  509862
  510115
  514710
  525703
  501232
  444195
  447788
  462356
  484468
  533983
  536690
  494997
  537192
  540115
  550010
  595965
  623868
  805459
  791100
  731814
  765148
  448399
  391868
  497386
  487115
  763624
  483159
  471935
  533138
  500122
  737473
  497021
  477036
  456212
  527880
  568525
  612178
  813253
  493275
  515936
  508989
  512857
  417319
  509557
  480941
  480425
  558640
  546256
]
2.30 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс бдсм"
]
1.85 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck bdsm"
]
1.77 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс бдсм"
]
1.63 ms
(0.38%)
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.