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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.61 ms
(82.64%)
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
  3607
  11254
  323352
  388950
  397513
  397586
  398125
  399545
  401564
  401875
  405701
  408894
  411072
  417600
  417788
  418621
  420359
  420829
  421390
  421553
  421617
  426103
  426728
  426730
  426731
  428885
  431718
  441301
  441347
  441424
  443176
  443652
  446994
  448786
  448911
  449572
  450364
  451717
  452407
  454586
  454766
  454789
  457017
  464369
  467059
  469194
  473095
  478916
  479839
  482573
  486106
  486461
  486741
  487556
  488693
  489765
  496893
  498156
  500625
  502999
  506306
  507835
  509517
  512751
  512814
  515548
  515670
  516159
  518508
  518561
  521760
  522455
  533803
  535990
  539367
  548185
  550041
  550045
  560337
  564652
  579234
  581774
  585067
  591582
  595684
  597498
  597507
  598549
  598867
  600190
  600213
  601820
  602113
  603015
  618424
  620267
  621183
  629407
  646656
  666934
  671848
  671881
  683251
  690891
  692014
  698338
  730838
  735307
  736587
  739408
  748448
  760656
  764201
  781319
  787069
  789209
  806849
  819932
  826333
  828182
]
16.72 ms
(10.66%)
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
  500625
  521760
  522455
  533803
  3607
  11254
  401875
  426728
  448786
  479839
  666934
  579234
  601820
  401564
  441347
  451717
  431718
  478916
  618424
  591582
  443176
  449572
  426730
  748448
  452407
  548185
  446994
  518561
  443652
  690891
  730838
  418621
  441301
  585067
  482573
  488693
  489765
  506306
  502999
  535990
  560337
  646656
  550041
  550045
  564652
  581774
  595684
  603015
  620267
  597507
  598549
  598867
  600190
  602113
  621183
  600213
  629407
  421390
  516159
  509517
  498156
  507835
  512751
  512814
  515670
  826333
  828182
  515548
  428885
  323352
  397513
  398125
  411072
  426103
  441424
  421617
  417600
  417788
  420829
  464369
  486106
  486461
  454789
  496893
  518508
  467059
  486741
  683251
  760656
  781319
  787069
  736587
  764201
  739408
  735307
  789209
  806849
  399545
  408894
  405701
  457017
  469194
  397586
  450364
  454766
  426731
  473095
  420359
  487556
  597498
  539367
  671881
  692014
  671848
  698338
  388950
  421553
  819932
  454586
  448911
]
3.26 ms
(2.08%)
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
  3607
  11254
  323352
  388950
  397513
  397586
  398125
  399545
  401564
  401875
  405701
  408894
  411072
  417600
  417788
  418621
  420359
  420829
  421390
  421553
  421617
  426103
  426728
  426730
  426731
  428885
  431718
  441301
  441347
  441424
  443176
  443652
  446994
  448786
  448911
  449572
  450364
  451717
  452407
  454586
  454766
  454789
  457017
  464369
  467059
  469194
  473095
  478916
  479839
  482573
  486106
  486461
  486741
  487556
  488693
  489765
  496893
  498156
  500625
  502999
  506306
  507835
  509517
  512751
  512814
  515548
  515670
  516159
  518508
  518561
  521760
  522455
  533803
  535990
  539367
  548185
  550041
  550045
  560337
  564652
  579234
  581774
  585067
  591582
  595684
  597498
  597507
  598549
  598867
  600190
  600213
  601820
  602113
  603015
  618424
  620267
  621183
  629407
  646656
  666934
  671848
  671881
  683251
  690891
  692014
  698338
  730838
  735307
  736587
  739408
  748448
  760656
  764201
  781319
  787069
  789209
  806849
  819932
  826333
  828182
]
2.31 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade webcam"
]
1.74 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск вебкамер"
]
1.70 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.95%)
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.