GET https://search.jues.net/search/embeds/5?q=love%20xxx

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.87 ms
(86.34%)
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
  130641
  209941
  384906
  392075
  506283
  515311
  521659
  531928
  532081
  534799
  534892
  535680
  539528
  547021
  549417
  554310
  564677
  570821
  573195
  585761
  594576
  596542
  596558
  597905
  613715
  618184
  621290
  623123
  625577
  630880
  636866
  637858
  641331
  641549
  643801
  654701
  655099
  655201
  655352
  656055
  657052
  657063
  657652
  658736
  666308
  668417
  677975
  678243
  683426
  689048
  693350
  693700
  694347
  696293
  697695
  698803
  699121
  700635
  706857
  707515
  707726
  718123
  719248
  719283
  719401
  721568
  731141
  735334
  738654
  746113
  753661
  759671
  764286
  766090
  771139
  773462
  773803
  775407
  777855
  779147
  781030
  782716
  784173
  790121
  791207
  792647
  793554
  794626
  796910
  799576
  800170
  800259
  801032
  801945
  803638
  804810
  810135
  814560
  817003
  817016
  817403
  817631
  818412
  818676
  818880
  819792
  821491
  821805
  822475
  823158
  823166
  823379
  825035
  825082
  825111
  826131
  827438
  828361
  828463
]
9.58 ms
(7.08%)
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
  823379
  821491
  819792
  822475
  823166
  825111
  828361
  506283
  532081
  539528
  554310
  547021
  658736
  697695
  718123
  719248
  666308
  678243
  689048
  698803
  706857
  625577
  637858
  621290
  794626
  779147
  790121
  793554
  796910
  799576
  731141
  766090
  792647
  801945
  759671
  738654
  764286
  771167
  753661
  771139
  773462
  735334
  746113
  773803
  707515
  719283
  784173
  800170
  801032
  810135
  384906
  209941
  130641
  392075
  817403
  817631
  818412
  818880
  821805
  817016
  827438
  814560
  818676
  817003
  823158
  825035
  825082
  826131
  828463
  515311
  534892
  535680
  521659
  531928
  534799
  570821
  573195
  549417
  564677
  654701
  655201
  668417
  707726
  719401
  656055
  657063
  657652
  683426
  693350
  694347
  699121
  655099
  655352
  657052
  677975
  693700
  696293
  700635
  721568
  585761
  597905
  613715
  618184
  623123
  594576
  630880
  636866
  596542
  596558
  641331
  641549
  643801
  777855
  775407
  781030
  782716
  791207
  800259
  803638
  804810
]
2.02 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "love xxx"
]
1.97 ms
(1.46%)
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
  130641
  209941
  384906
  392075
  506283
  515311
  521659
  531928
  532081
  534799
  534892
  535680
  539528
  547021
  549417
  554310
  564677
  570821
  573195
  585761
  594576
  596542
  596558
  597905
  613715
  618184
  621290
  623123
  625577
  630880
  636866
  637858
  641331
  641549
  643801
  654701
  655099
  655201
  655352
  656055
  657052
  657063
  657652
  658736
  666308
  668417
  677975
  678243
  683426
  689048
  693350
  693700
  694347
  696293
  697695
  698803
  699121
  700635
  706857
  707515
  707726
  718123
  719248
  719283
  719401
  721568
  731141
  735334
  738654
  746113
  753661
  759671
  764286
  766090
  771139
  773462
  773803
  775407
  777855
  779147
  781030
  782716
  784173
  790121
  791207
  792647
  793554
  794626
  796910
  799576
  800170
  800259
  801032
  801945
  803638
  804810
  810135
  814560
  817003
  817016
  817403
  817631
  818412
  818676
  818880
  819792
  821491
  821805
  822475
  823158
  823166
  823379
  825035
  825082
  825111
  826131
  827438
  828361
  828463
]
1.85 ms
(1.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "love xxx"
]
1.54 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "love xxx"
]

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.