GET https://search.jues.net/search/embeds/4?q=bdsm%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.48 ms
(85.12%)
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
  343227
  388570
  395686
  395756
  397793
  411849
  418928
  422567
  422576
  422610
  422656
  422876
  422908
  423212
  423266
  423396
  423464
  427143
  428726
  429292
  429312
  431975
  433694
  437170
  439650
  440652
  440980
  443150
  447361
  451708
  466889
  467540
  468598
  470416
  475703
  476944
  485916
  486658
  486691
  488735
  489819
  489891
  489938
  491255
  495669
  497425
  503619
  506830
  508835
  509393
  513872
  516795
  517144
  517782
  519734
  519935
  521802
  522115
  522847
  523138
  524334
  524397
  524561
  524722
  524749
  526475
  526480
  526910
  528662
  530753
  531485
  534221
  535333
  538891
  540456
  541597
  547552
  548257
  548655
  552069
  556580
  559183
  559428
  581673
  581689
  582209
  593003
  597963
  617134
  629966
  643593
  650851
  663976
  667772
  705832
  714119
  720422
  721454
  721551
  722523
  731776
  741047
  781693
  781714
  782148
  782154
  782186
  782234
  784304
  789407
  797325
  815033
  816371
  816499
  817048
  817727
  818812
  820229
  820284
  821851
]
18.80 ms
(9.17%)
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
  423464
  395756
  429312
  439650
  440980
  422567
  423396
  443150
  397793
  422610
  422876
  513872
  517782
  519734
  519935
  486658
  506830
  509393
  528662
  485916
  491255
  516795
  524722
  818812
  817727
  820229
  538891
  534221
  541597
  556580
  721454
  720422
  722523
  797325
  781693
  731776
  782186
  782234
  782148
  343227
  388570
  429292
  617134
  428726
  816371
  593003
  467540
  817048
  820284
  667772
  643593
  781714
  741047
  782154
  789407
  629966
  437170
  526480
  395686
  418928
  433694
  422656
  423212
  431975
  422576
  411849
  422908
  816499
  815033
  821851
  468598
  451708
  476944
  489938
  495669
  524334
  497425
  522847
  531485
  540456
  526475
  530753
  522115
  524749
  547552
  582209
  548655
  581673
  552069
  581689
  721551
  714119
  663976
  705832
  559428
  784304
  440652
  466889
  447361
  470416
  423266
  475703
  503619
  508835
  526910
  489819
  517144
  524561
  535333
  486691
  523138
  524397
  488735
  489891
  521802
  548257
  650851
  559183
  597963
  427143
]
3.81 ms
(1.86%)
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
  343227
  388570
  395686
  395756
  397793
  411849
  418928
  422567
  422576
  422610
  422656
  422876
  422908
  423212
  423266
  423396
  423464
  427143
  428726
  429292
  429312
  431975
  433694
  437170
  439650
  440652
  440980
  443150
  447361
  451708
  466889
  467540
  468598
  470416
  475703
  476944
  485916
  486658
  486691
  488735
  489819
  489891
  489938
  491255
  495669
  497425
  503619
  506830
  508835
  509393
  513872
  516795
  517144
  517782
  519734
  519935
  521802
  522115
  522847
  523138
  524334
  524397
  524561
  524722
  524749
  526475
  526480
  526910
  528662
  530753
  531485
  534221
  535333
  538891
  540456
  541597
  547552
  548257
  548655
  552069
  556580
  559183
  559428
  581673
  581689
  582209
  593003
  597963
  617134
  629966
  643593
  650851
  663976
  667772
  705832
  714119
  720422
  721454
  721551
  722523
  731776
  741047
  781693
  781714
  782148
  782154
  782186
  782234
  784304
  789407
  797325
  815033
  816371
  816499
  817048
  817727
  818812
  820229
  820284
  821851
]
2.63 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bdsm young"
]
1.96 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм young"
]
1.58 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм young"
]

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.