GET https://search.jues.net/search/embeds/9?q=real%20webcam

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
362.40 ms
(91.60%)
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
  392665
  397903
  397904
  398582
  409156
  409795
  415815
  416399
  418858
  423849
  427790
  428083
  434817
  436626
  436756
  438978
  440711
  440745
  440747
  440895
  441943
  443161
  443371
  445664
  446081
  446456
  456405
  457146
  458269
  458443
  459061
  459252
  460046
  461022
  461830
  463442
  466799
  471431
  474792
  474806
  474809
  478986
  482774
  482922
  484118
  490261
  492337
  492365
  502849
  504246
  504748
  507823
  512485
  512488
  513024
  514609
  523866
  548085
  558196
  563052
  571769
  579218
  580238
  590485
  595365
  599072
  600227
  600936
  601741
  602189
  602262
  603948
  604221
  605393
  606254
  611037
  613172
  620566
  623961
  627308
  630736
  643380
  647060
  648918
  657177
  657543
  658223
  658224
  658226
  660834
  662164
  662391
  674263
  679306
  691787
  693799
  694157
  700299
  713208
  718044
  720078
  736470
  738175
  744774
  749978
  750809
  751958
  759014
  762743
  776141
  784655
  786048
  790188
  794416
  795075
  795262
  798473
  799957
  806534
  814374
]
24.23 ms
(6.12%)
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
  691787
  700299
  647060
  648918
  658224
  662164
  662391
  693799
  713208
  718044
  657177
  657543
  658223
  658226
  674263
  679306
  694157
  548085
  558196
  563052
  571769
  579218
  590485
  602189
  606254
  611037
  620566
  630736
  595365
  599072
  600227
  601741
  603948
  604221
  613172
  600936
  623961
  643380
  605393
  627308
  776141
  794416
  798473
  786048
  799957
  806534
  795075
  795262
  738175
  744774
  750809
  736470
  751958
  762743
  749978
  759014
  602262
  720078
  784655
  790188
  392665
  397903
  443161
  458269
  474792
  436626
  440711
  443371
  445664
  458443
  459252
  461830
  466799
  474806
  415815
  418858
  423849
  428083
  456405
  457146
  463442
  478986
  397904
  398582
  438978
  460046
  461022
  440895
  446081
  512485
  523866
  502849
  513024
  504748
  514609
  482922
  484118
  492337
  504246
  507823
  512488
  490261
  580238
  660834
  409156
  409795
  416399
  440747
  441943
  427790
  434817
  436756
  440745
  814374
  482774
  446456
  471431
  474809
  492365
  459061
]
2.40 ms
(0.61%)
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
  392665
  397903
  397904
  398582
  409156
  409795
  415815
  416399
  418858
  423849
  427790
  428083
  434817
  436626
  436756
  438978
  440711
  440745
  440747
  440895
  441943
  443161
  443371
  445664
  446081
  446456
  456405
  457146
  458269
  458443
  459061
  459252
  460046
  461022
  461830
  463442
  466799
  471431
  474792
  474806
  474809
  478986
  482774
  482922
  484118
  490261
  492337
  492365
  502849
  504246
  504748
  507823
  512485
  512488
  513024
  514609
  523866
  548085
  558196
  563052
  571769
  579218
  580238
  590485
  595365
  599072
  600227
  600936
  601741
  602189
  602262
  603948
  604221
  605393
  606254
  611037
  613172
  620566
  623961
  627308
  630736
  643380
  647060
  648918
  657177
  657543
  658223
  658224
  658226
  660834
  662164
  662391
  674263
  679306
  691787
  693799
  694157
  700299
  713208
  718044
  720078
  736470
  738175
  744774
  749978
  750809
  751958
  759014
  762743
  776141
  784655
  786048
  790188
  794416
  795075
  795262
  798473
  799957
  806534
  814374
]
2.10 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real webcam"
]
1.61 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real вебкамер"
]
1.55 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real вебкамер"
]

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.