GET https://search.jues.net/search/embeds/7?q=stockings%20interracial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.49 ms
(78.95%)
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
  129640
  382485
  383801
  387344
  387562
  388746
  396336
  399738
  403141
  404175
  405061
  405181
  408332
  408458
  408462
  410076
  410353
  414364
  418897
  419483
  420762
  422732
  422735
  425004
  425892
  430161
  430975
  435454
  443043
  443232
  445513
  445733
  446555
  446870
  447452
  452109
  456120
  457077
  465034
  467030
  468849
  472849
  475262
  478534
  481047
  482811
  488894
  491771
  495273
  503105
  508426
  512029
  512057
  512937
  517609
  518766
  522160
  522196
  523536
  527408
  529320
  538276
  539147
  543613
  545857
  550563
  551222
  551748
  553296
  556480
  558199
  559946
  573113
  590165
  593444
  595805
  601039
  604537
  604569
  605606
  610292
  610563
  625444
  625804
  630913
  633171
  636539
  663367
  663438
  679856
  681053
  690786
  697368
  710872
  714549
  715553
  720406
  723509
  732468
  738854
  740617
  741307
  750062
  751817
  771827
  774029
  775833
  780620
  785686
  787608
  788234
  790988
  795516
  798399
  805112
  805827
  812673
  817131
  817344
  821739
]
25.35 ms
(12.71%)
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
  382485
  399738
  410353
  482811
  387562
  446870
  435454
  491771
  472849
  551748
  559946
  543613
  430161
  527408
  512937
  573113
  446555
  551222
  556480
  604569
  495273
  129640
  388746
  404175
  422735
  443232
  422732
  443043
  452109
  456120
  445733
  475262
  478534
  512029
  539147
  503105
  512057
  517609
  538276
  553296
  625444
  595805
  604537
  420762
  457077
  481047
  419483
  425004
  405061
  518766
  445513
  387344
  403141
  408332
  414364
  408458
  488894
  714549
  430975
  468849
  408462
  508426
  405181
  447452
  383801
  396336
  410076
  418897
  425892
  817131
  821739
  817344
  467030
  465034
  522196
  523536
  522160
  529320
  545857
  550563
  663438
  663367
  679856
  681053
  690786
  710872
  697368
  720406
  723509
  558199
  605606
  610563
  633171
  593444
  636539
  590165
  601039
  610292
  625804
  630913
  775833
  790988
  795516
  798399
  805112
  805827
  788234
  812673
  740617
  787608
  741307
  738854
  751817
  732468
  750062
  771827
  774029
  715553
  780620
  785686
]
7.96 ms
(3.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.91 ms
(1.46%)
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
  129640
  382485
  383801
  387344
  387562
  388746
  396336
  399738
  403141
  404175
  405061
  405181
  408332
  408458
  408462
  410076
  410353
  414364
  418897
  419483
  420762
  422732
  422735
  425004
  425892
  430161
  430975
  435454
  443043
  443232
  445513
  445733
  446555
  446870
  447452
  452109
  456120
  457077
  465034
  467030
  468849
  472849
  475262
  478534
  481047
  482811
  488894
  491771
  495273
  503105
  508426
  512029
  512057
  512937
  517609
  518766
  522160
  522196
  523536
  527408
  529320
  538276
  539147
  543613
  545857
  550563
  551222
  551748
  553296
  556480
  558199
  559946
  573113
  590165
  593444
  595805
  601039
  604537
  604569
  605606
  610292
  610563
  625444
  625804
  630913
  633171
  636539
  663367
  663438
  679856
  681053
  690786
  697368
  710872
  714549
  715553
  720406
  723509
  732468
  738854
  740617
  741307
  750062
  751817
  771827
  774029
  775833
  780620
  785686
  787608
  788234
  790988
  795516
  798399
  805112
  805827
  812673
  817131
  817344
  821739
]
2.58 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings interracial"
]
1.63 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел межрасов"
]
1.57 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.