GET https://search.jues.net/search/embeds/10?q=skinny%20webcam

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
289.32 ms
(88.39%)
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
  396302
  455433
  463255
  476733
  478348
  485301
  490125
  496828
  498331
  501134
  502365
  504735
  506197
  508552
  510934
  511428
  512081
  513015
  516150
  517100
  526864
  529825
  530415
  530559
  535661
  536208
  537086
  537959
  538261
  538505
  538709
  539350
  539680
  540134
  540401
  542656
  542874
  545930
  546418
  550356
  551252
  552378
  553136
  553550
  553692
  557879
  557906
  558317
  559811
  560003
  560734
  560755
  562115
  562215
  563463
  563691
  564666
  566267
  566841
  569221
  570677
  576426
  576450
  576603
  579658
  581589
  582518
  582910
  583625
  584093
  584185
  585036
  585043
  645745
  646127
  652706
  653319
  653571
  659477
  660601
  661522
  661540
  667152
  667435
  670316
  671534
  672206
  673154
  673910
  678224
  678250
  678261
  683026
  698161
  700267
  709046
  713767
  722944
  816131
  818241
  819090
  820069
  824204
  824255
  825020
  825133
  825174
  825370
  825478
  825656
  826288
  826461
  826628
  826631
  826737
  826851
  826953
  827084
  827526
  827741
]
23.49 ms
(7.18%)
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
  496828
  506197
  508552
  511428
  513015
  485301
  504735
  512081
  517100
  526864
  396302
  818241
  825020
  825174
  825370
  825656
  585036
  585043
  826628
  826631
  826737
  816131
  824255
  826851
  826953
  827084
  827741
  824204
  819090
  820069
  825133
  825478
  826288
  826461
  827526
  476733
  455433
  490125
  498331
  502365
  530559
  536208
  538261
  538709
  540401
  501134
  529825
  535661
  537086
  537959
  538505
  539350
  510934
  516150
  539680
  540134
  530415
  463255
  478348
  545930
  546418
  550356
  557906
  560755
  562115
  563691
  564666
  576426
  583625
  584093
  584185
  542874
  553692
  558317
  559811
  560003
  566267
  566841
  570677
  576450
  581589
  542656
  551252
  552378
  553136
  553550
  557879
  560734
  562215
  563463
  569221
  576603
  579658
  582518
  582910
  645745
  646127
  652706
  653571
  661540
  667152
  667435
  670316
  671534
  672206
  673154
  673910
  678224
  678250
  678261
  683026
  698161
  700267
  709046
  713767
  722944
  653319
  659477
  660601
  661522
]
7.27 ms
(2.22%)
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
  396302
  455433
  463255
  476733
  478348
  485301
  490125
  496828
  498331
  501134
  502365
  504735
  506197
  508552
  510934
  511428
  512081
  513015
  516150
  517100
  526864
  529825
  530415
  530559
  535661
  536208
  537086
  537959
  538261
  538505
  538709
  539350
  539680
  540134
  540401
  542656
  542874
  545930
  546418
  550356
  551252
  552378
  553136
  553550
  553692
  557879
  557906
  558317
  559811
  560003
  560734
  560755
  562115
  562215
  563463
  563691
  564666
  566267
  566841
  569221
  570677
  576426
  576450
  576603
  579658
  581589
  582518
  582910
  583625
  584093
  584185
  585036
  585043
  645745
  646127
  652706
  653319
  653571
  659477
  660601
  661522
  661540
  667152
  667435
  670316
  671534
  672206
  673154
  673910
  678224
  678250
  678261
  683026
  698161
  700267
  709046
  713767
  722944
  816131
  818241
  819090
  820069
  824204
  824255
  825020
  825133
  825174
  825370
  825478
  825656
  826288
  826461
  826628
  826631
  826737
  826851
  826953
  827084
  827526
  827741
]
2.00 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny webcam"
]
1.91 ms
(0.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые вебкамер"
]
1.60 ms
(0.49%)
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.