GET https://search.jues.net/search/embeds/4?q=amateur%20swallows

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.32 ms
(84.27%)
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
  72666
  271496
  271756
  370332
  384440
  395793
  397389
  402735
  403695
  410251
  411090
  414099
  420426
  421984
  423352
  423939
  424068
  429937
  433404
  435453
  445702
  448198
  449937
  450127
  450129
  450152
  450156
  452208
  453497
  456121
  457004
  462277
  462669
  462721
  463699
  470086
  470823
  472591
  472870
  473754
  478724
  478730
  487950
  490058
  491889
  497298
  497808
  500965
  501320
  506902
  507083
  509120
  509565
  516963
  518048
  520873
  521722
  522199
  522325
  525397
  527845
  534602
  536989
  541016
  541582
  542433
  544517
  551645
  552602
  552948
  554064
  557807
  557901
  557922
  571074
  574236
  583146
  585569
  593977
  598230
  602540
  606298
  613208
  613608
  613848
  621226
  631691
  632749
  653330
  654230
  661613
  673862
  694139
  708082
  708148
  708894
  718864
  724720
  732142
  752677
  763378
  764307
  764486
  765266
  766628
  766634
  767769
  775004
  780936
  781397
  789783
  791610
  792904
  794090
  800565
  805292
  809702
  812866
  813046
  814272
]
15.02 ms
(9.29%)
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
  501320
  411090
  534602
  521722
  509565
  544517
  541016
  661613
  708082
  653330
  602540
  613848
  732142
  763378
  708148
  708894
  370332
  490058
  452208
  506902
  583146
  606298
  518048
  522199
  435453
  414099
  450152
  450156
  470086
  536989
  500965
  507083
  516963
  473754
  487950
  557901
  554064
  557922
  574236
  654230
  718864
  551645
  552602
  557807
  631691
  613208
  613608
  800565
  813046
  724720
  764307
  780936
  792904
  470823
  410251
  463699
  520873
  457004
  462669
  271496
  271756
  421984
  423939
  420426
  433404
  814272
  445702
  448198
  450129
  456121
  449937
  450127
  497808
  527845
  542433
  552948
  775004
  794090
  812866
  789783
  791610
  809702
  752677
  767769
  764486
  765266
  766628
  766634
  781397
  402735
  462277
  478730
  395793
  429937
  424068
  478724
  453497
  462721
  491889
  509120
  72666
  673862
  384440
  397389
  403695
  805292
  423352
  497298
  472591
  541582
  694139
  571074
  585569
  593977
  621226
  598230
  632749
  522325
  525397
  472870
]
2.97 ms
(1.84%)
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
  72666
  271496
  271756
  370332
  384440
  395793
  397389
  402735
  403695
  410251
  411090
  414099
  420426
  421984
  423352
  423939
  424068
  429937
  433404
  435453
  445702
  448198
  449937
  450127
  450129
  450152
  450156
  452208
  453497
  456121
  457004
  462277
  462669
  462721
  463699
  470086
  470823
  472591
  472870
  473754
  478724
  478730
  487950
  490058
  491889
  497298
  497808
  500965
  501320
  506902
  507083
  509120
  509565
  516963
  518048
  520873
  521722
  522199
  522325
  525397
  527845
  534602
  536989
  541016
  541582
  542433
  544517
  551645
  552602
  552948
  554064
  557807
  557901
  557922
  571074
  574236
  583146
  585569
  593977
  598230
  602540
  606298
  613208
  613608
  613848
  621226
  631691
  632749
  653330
  654230
  661613
  673862
  694139
  708082
  708148
  708894
  718864
  724720
  732142
  752677
  763378
  764307
  764486
  765266
  766628
  766634
  767769
  775004
  780936
  781397
  789783
  791610
  792904
  794090
  800565
  805292
  809702
  812866
  813046
  814272
]
2.09 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.04 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur swallows"
]
1.71 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск swallows"
]
1.60 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск swallows"
]

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.