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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.74 ms
(52.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
166.35 ms
(42.18%)
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
  394351
  422421
  438276
  458628
  474057
  489155
  500444
  514976
  515227
  527165
  533763
  536217
  536825
  537822
  539707
  540181
  540412
  543657
  552159
  554121
  554180
  556060
  558655
  563598
  575681
  582214
  583330
  590830
  597735
  603145
  603519
  605022
  605900
  608088
  608091
  613293
  613350
  615651
  616491
  618187
  618603
  621536
  622334
  622540
  627111
  628957
  630823
  636522
  642679
  644666
  649862
  651699
  659459
  661665
  661709
  664409
  669961
  674600
  676538
  678195
  682647
  687071
  696194
  702375
  704638
  708680
  711249
  711699
  712931
  714080
  714656
  715235
  716403
  716515
  717235
  718649
  721122
  721771
  723368
  724891
  732167
  740166
  743355
  748634
  748639
  749501
  749659
  749878
  756473
  765084
  765448
  766188
  773132
  773903
  773907
  777327
  781580
  782394
  784083
  784759
  785274
  785441
  785492
  786458
  789754
  790082
  792579
  795707
  806031
  810184
  810548
  811537
  812996
  814419
  817891
  818930
  819705
  819870
  821798
  827360
]
14.26 ms
(3.62%)
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
  642679
  458628
  514976
  527165
  539707
  540412
  474057
  543657
  554180
  582214
  661709
  669961
  678195
  712931
  721122
  659459
  696194
  704638
  715235
  716515
  556060
  563598
  575681
  605900
  613293
  613350
  628957
  636522
  597735
  622334
  608088
  784759
  785441
  810548
  811537
  789754
  724891
  743355
  756473
  792579
  748639
  749878
  749501
  766188
  773132
  749659
  765084
  615651
  627111
  711249
  777327
  781580
  785274
  785492
  810184
  394351
  422421
  489155
  537822
  540181
  552159
  711699
  717235
  621536
  630823
  605022
  773907
  773903
  644666
  718649
  795707
  438276
  817891
  827360
  818930
  819870
  819705
  583330
  682647
  714656
  651699
  661665
  687071
  603519
  618603
  616491
  790082
  812996
  782394
  740166
  618187
  702375
  721771
  784083
  676538
  806031
  765448
  748634
  821798
  558655
  603145
  608091
  590830
  622540
  786458
  732167
  723368
  814419
  536217
  536825
  515227
  533763
  500444
  554121
  649862
  674600
  714080
  664409
  708680
  716403
]
2.73 ms
(0.69%)
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
  394351
  422421
  438276
  458628
  474057
  489155
  500444
  514976
  515227
  527165
  533763
  536217
  536825
  537822
  539707
  540181
  540412
  543657
  552159
  554121
  554180
  556060
  558655
  563598
  575681
  582214
  583330
  590830
  597735
  603145
  603519
  605022
  605900
  608088
  608091
  613293
  613350
  615651
  616491
  618187
  618603
  621536
  622334
  622540
  627111
  628957
  630823
  636522
  642679
  644666
  649862
  651699
  659459
  661665
  661709
  664409
  669961
  674600
  676538
  678195
  682647
  687071
  696194
  702375
  704638
  708680
  711249
  711699
  712931
  714080
  714656
  715235
  716403
  716515
  717235
  718649
  721122
  721771
  723368
  724891
  732167
  740166
  743355
  748634
  748639
  749501
  749659
  749878
  756473
  765084
  765448
  766188
  773132
  773903
  773907
  777327
  781580
  782394
  784083
  784759
  785274
  785441
  785492
  786458
  789754
  790082
  792579
  795707
  806031
  810184
  810548
  811537
  812996
  814419
  817891
  818930
  819705
  819870
  821798
  827360
]
1.99 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx 18 year"
]
1.94 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx 18 year"
]
1.41 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx 18 year"
]

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.