GET https://search.jues.net/search/embeds/7?q=games%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.72 ms
(81.94%)
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
  34382
  394941
  396770
  417363
  419631
  420369
  420459
  421732
  421982
  424965
  431871
  431882
  431918
  432928
  441176
  451073
  452890
  453018
  453030
  453032
  453043
  453098
  453228
  455735
  457971
  459293
  459490
  460806
  460863
  461234
  463084
  464155
  464989
  465027
  465052
  465208
  465611
  469983
  469989
  470437
  470532
  470538
  470858
  472085
  472813
  475537
  476274
  477104
  482145
  482314
  482937
  484271
  486383
  489833
  493552
  495016
  495940
  507042
  510247
  515747
  521559
  523975
  530452
  535732
  542572
  545854
  548243
  550314
  550692
  560513
  563986
  565280
  566656
  569020
  572689
  578028
  580159
  580188
  581231
  581500
  582301
  582966
  583035
  583098
  590205
  590767
  606892
  621501
  627709
  632668
  659321
  670662
  689750
  711685
  715365
  718928
  719765
  741151
  752148
  766825
  770136
  774709
  784157
  784754
  786444
  788258
  788527
  788562
  788903
  788920
  790219
  792552
  792553
  795406
  801377
  807208
  809191
  810991
  815194
  816565
]
15.60 ms
(10.59%)
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
  788527
  523975
  394941
  431882
  431918
  417363
  472813
  482145
  453043
  470538
  465027
  580159
  580188
  582966
  572689
  621501
  627709
  807208
  752148
  810991
  452890
  396770
  420369
  457971
  469983
  472085
  489833
  34382
  431871
  815194
  470858
  535732
  542572
  711685
  719765
  809191
  792552
  455735
  432928
  470437
  453228
  482937
  530452
  521559
  582301
  718928
  659321
  563986
  581231
  606892
  788920
  420459
  470532
  419631
  421982
  453032
  465052
  469989
  486383
  465611
  476274
  569020
  581500
  550692
  583035
  689750
  560513
  590767
  788258
  788903
  801377
  784157
  784754
  766825
  632668
  790219
  463084
  441176
  459490
  460806
  464989
  495940
  507042
  510247
  421732
  816565
  453098
  475537
  484271
  453030
  495016
  566656
  545854
  548243
  550314
  565280
  670662
  715365
  578028
  583098
  590205
  786444
  788562
  795406
  741151
  770136
  774709
  792553
  451073
  465208
  477104
  424965
  460863
  464155
  515747
  493552
  453018
  461234
  459293
  482314
]
3.24 ms
(2.20%)
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
  34382
  394941
  396770
  417363
  419631
  420369
  420459
  421732
  421982
  424965
  431871
  431882
  431918
  432928
  441176
  451073
  452890
  453018
  453030
  453032
  453043
  453098
  453228
  455735
  457971
  459293
  459490
  460806
  460863
  461234
  463084
  464155
  464989
  465027
  465052
  465208
  465611
  469983
  469989
  470437
  470532
  470538
  470858
  472085
  472813
  475537
  476274
  477104
  482145
  482314
  482937
  484271
  486383
  489833
  493552
  495016
  495940
  507042
  510247
  515747
  521559
  523975
  530452
  535732
  542572
  545854
  548243
  550314
  550692
  560513
  563986
  565280
  566656
  569020
  572689
  578028
  580159
  580188
  581231
  581500
  582301
  582966
  583035
  583098
  590205
  590767
  606892
  621501
  627709
  632668
  659321
  670662
  689750
  711685
  715365
  718928
  719765
  741151
  752148
  766825
  770136
  774709
  784157
  784754
  786444
  788258
  788527
  788562
  788903
  788920
  790219
  792552
  792553
  795406
  801377
  807208
  809191
  810991
  815194
  816565
]
2.42 ms
(1.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "games sex"
]
1.78 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "games секс"
]
1.71 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "games секс"
]

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.