GET https://search.jues.net/search/embeds/3?q=skinny%20ugly

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.32 ms
(87.15%)
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
  383419
  390413
  400490
  401025
  411697
  414157
  414581
  415205
  415223
  416252
  417456
  419579
  420398
  421974
  422500
  422582
  422603
  422617
  422705
  422834
  422908
  422970
  423010
  423018
  423037
  423040
  423266
  423271
  423283
  423400
  423412
  423821
  423825
  423829
  424658
  426789
  429256
  434624
  436358
  442691
  443247
  445933
  446260
  446266
  459395
  461056
  462504
  464043
  464281
  470344
  471505
  473168
  473797
  473798
  473848
  474008
  474916
  475072
  475303
  476898
  477034
  477966
  478459
  479060
  479679
  479684
  481792
  481817
  485899
  489003
  492396
  493231
  495647
  496080
  497950
  499365
  499374
  499378
  500125
  509024
  509403
  510420
  510938
  511058
  511502
  512934
  515142
  520159
  520174
  520176
  523423
  523540
  523825
  524015
  528884
  531594
  534771
  541725
  543460
  543821
  544477
  544493
  549314
  554805
  555847
  555850
  555873
  558983
  559897
  565556
  569129
  579517
  600599
  605094
  615636
  626405
  644674
  663503
  668747
  693078
]
13.45 ms
(7.80%)
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
  417456
  429256
  473797
  479679
  476898
  481817
  475303
  479060
  481792
  492396
  511502
  531594
  510938
  515142
  509403
  520159
  534771
  528884
  464281
  471505
  479684
  569129
  543821
  579517
  668747
  693078
  549314
  555847
  555873
  559897
  615636
  605094
  423271
  411697
  415205
  400490
  422970
  473168
  524015
  489003
  499378
  383419
  422834
  422908
  423283
  445933
  446260
  464043
  477034
  459395
  509024
  520176
  523540
  493231
  541725
  544477
  543460
  663503
  555850
  558983
  565556
  600599
  626405
  644674
  416252
  473848
  423412
  473798
  390413
  423821
  423825
  424658
  420398
  423266
  500125
  510420
  499374
  511058
  499365
  512934
  401025
  414581
  422617
  423010
  423037
  436358
  415223
  422603
  422500
  434624
  414157
  423018
  443247
  422582
  442691
  462504
  446266
  520174
  523423
  544493
  423400
  477966
  421974
  422705
  423829
  426789
  470344
  474916
  523825
  419579
  423040
  461056
  474008
  485899
  475072
  478459
  497950
  495647
  496080
  554805
]
2.42 ms
(1.40%)
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
  383419
  390413
  400490
  401025
  411697
  414157
  414581
  415205
  415223
  416252
  417456
  419579
  420398
  421974
  422500
  422582
  422603
  422617
  422705
  422834
  422908
  422970
  423010
  423018
  423037
  423040
  423266
  423271
  423283
  423400
  423412
  423821
  423825
  423829
  424658
  426789
  429256
  434624
  436358
  442691
  443247
  445933
  446260
  446266
  459395
  461056
  462504
  464043
  464281
  470344
  471505
  473168
  473797
  473798
  473848
  474008
  474916
  475072
  475303
  476898
  477034
  477966
  478459
  479060
  479679
  479684
  481792
  481817
  485899
  489003
  492396
  493231
  495647
  496080
  497950
  499365
  499374
  499378
  500125
  509024
  509403
  510420
  510938
  511058
  511502
  512934
  515142
  520159
  520174
  520176
  523423
  523540
  523825
  524015
  528884
  531594
  534771
  541725
  543460
  543821
  544477
  544493
  549314
  554805
  555847
  555850
  555873
  558983
  559897
  565556
  569129
  579517
  600599
  605094
  615636
  626405
  644674
  663503
  668747
  693078
]
1.84 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny ugly"
]
1.71 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые ugly"
]
1.22 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые ugly"
]

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.