GET https://search.jues.net/search/embeds/6?q=webcam%20interracial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.58 ms
(86.68%)
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
  386492
  418061
  418829
  424901
  425083
  429221
  434392
  443332
  459000
  467915
  470399
  470427
  473186
  477387
  479071
  481446
  484231
  485027
  489953
  492488
  496378
  503271
  504753
  505057
  505094
  506595
  506776
  507009
  529318
  530164
  531556
  534843
  534848
  535628
  535841
  536757
  536971
  536990
  539170
  540524
  541965
  542306
  542345
  544779
  545713
  547074
  551940
  572008
  577498
  577525
  581264
  583009
  584094
  584385
  585304
  586460
  593571
  594077
  595129
  597670
  603370
  605407
  607018
  616561
  626351
  651594
  652586
  660059
  661306
  663214
  671210
  675585
  675934
  676432
  677267
  682248
  694126
  695337
  695343
  695347
  695387
  698108
  707374
  712777
  716708
  717369
  718877
  719862
  719934
  724841
  734794
  737213
  738025
  738043
  738046
  738053
  738056
  738216
  738854
  739574
  742149
  745548
  748658
  751469
  753047
  759635
  765472
  775661
  775662
  776479
  780620
  790753
  793469
  798309
  801619
  806587
  808072
  812086
  817252
  824162
]
12.89 ms
(7.62%)
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
  583009
  584385
  675585
  677267
  682248
  718877
  695337
  712777
  660059
  695343
  593571
  595129
  607018
  597670
  603370
  626351
  594077
  605407
  585304
  586460
  616561
  775661
  776479
  793469
  806587
  775662
  790753
  798309
  812086
  734794
  737213
  738043
  751469
  801619
  742149
  738854
  745548
  753047
  765472
  738216
  739574
  748658
  724841
  738025
  738046
  738053
  738056
  759635
  716708
  780620
  808072
  386492
  506595
  418829
  424901
  418061
  434392
  443332
  425083
  429221
  817252
  824162
  459000
  467915
  470399
  470427
  473186
  484231
  481446
  485027
  489953
  492488
  504753
  505094
  507009
  530164
  531556
  534848
  539170
  529318
  534843
  496378
  503271
  536757
  536971
  536990
  505057
  506776
  535628
  535841
  540524
  477387
  479071
  544779
  545713
  547074
  577498
  577525
  584094
  572008
  581264
  541965
  542306
  542345
  551940
  663214
  671210
  675934
  695387
  698108
  717369
  719934
  651594
  652586
  661306
  695347
  707374
  719862
  676432
  694126
]
3.20 ms
(1.89%)
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
  386492
  418061
  418829
  424901
  425083
  429221
  434392
  443332
  459000
  467915
  470399
  470427
  473186
  477387
  479071
  481446
  484231
  485027
  489953
  492488
  496378
  503271
  504753
  505057
  505094
  506595
  506776
  507009
  529318
  530164
  531556
  534843
  534848
  535628
  535841
  536757
  536971
  536990
  539170
  540524
  541965
  542306
  542345
  544779
  545713
  547074
  551940
  572008
  577498
  577525
  581264
  583009
  584094
  584385
  585304
  586460
  593571
  594077
  595129
  597670
  603370
  605407
  607018
  616561
  626351
  651594
  652586
  660059
  661306
  663214
  671210
  675585
  675934
  676432
  677267
  682248
  694126
  695337
  695343
  695347
  695387
  698108
  707374
  712777
  716708
  717369
  718877
  719862
  719934
  724841
  734794
  737213
  738025
  738043
  738046
  738053
  738056
  738216
  738854
  739574
  742149
  745548
  748658
  751469
  753047
  759635
  765472
  775661
  775662
  776479
  780620
  790753
  793469
  798309
  801619
  806587
  808072
  812086
  817252
  824162
]
1.88 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam interracial"
]
1.56 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер межрасов"
]
1.50 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер межрасов"
]
1.50 ms
(0.89%)
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.