GET https://search.jues.net/search/embeds/3?q=end

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.62 ms
(78.02%)
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
  341889
  389875
  394713
  403754
  409858
  429497
  437740
  454476
  460259
  464176
  502799
  506610
  506883
  507799
  511298
  518249
  535987
  538520
  540719
  542306
  543983
  552147
  554772
  555384
  555746
  561402
  561809
  562182
  562471
  564416
  567675
  572689
  577562
  577805
  578433
  579685
  580073
  583180
  584743
  602180
  604278
  606637
  608581
  610647
  613849
  614836
  620777
  623328
  632845
  639924
  641407
  643114
  659411
  676571
  695803
  701673
  705087
  706331
  713445
  718274
  724183
  724847
  726536
  730349
  730431
  731013
  733142
  735461
  735494
  736775
  737247
  740036
  740101
  740825
  742728
  750151
  751725
  752719
  755994
  759667
  759704
  760122
  760782
  761479
  762252
  765221
  765400
  767607
  769010
  770348
  772358
  772434
  773965
  775997
  778340
  780067
  783704
  785491
  787055
  792736
  793418
  793451
  794166
  794851
  795057
  795267
  795745
  796132
  800937
  801227
  806212
  807530
  807748
  808074
  809747
  810574
  810975
  815852
  820822
  824532
]
27.09 ms
(16.18%)
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
  735461
  724847
  735494
  769010
  726536
  772434
  770348
  705087
  778340
  785491
  793418
  795267
  824532
  464176
  535987
  511298
  580073
  561402
  543983
  554772
  561809
  706331
  718274
  578433
  606637
  632845
  602180
  643114
  604278
  614836
  808074
  794851
  801227
  730349
  787055
  792736
  795057
  752719
  759704
  760122
  765400
  730431
  751725
  762252
  772358
  759667
  761479
  740825
  750151
  780067
  807530
  403754
  437740
  394713
  389875
  409858
  429497
  815852
  820822
  454476
  460259
  507799
  518249
  538520
  540719
  502799
  506610
  506883
  555384
  564416
  583180
  584743
  577562
  579685
  542306
  552147
  555746
  562471
  567675
  577805
  659411
  695803
  713445
  676571
  562182
  572689
  608581
  610647
  613849
  620777
  639924
  623328
  641407
  796132
  807748
  775997
  800937
  810574
  810975
  767607
  795745
  809747
  731013
  736775
  765221
  724183
  733142
  737247
  742728
  755994
  740036
  740101
  760782
  773965
  701673
  783704
  793451
  794166
  806212
  341889
]
2.42 ms
(1.45%)
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
  341889
  389875
  394713
  403754
  409858
  429497
  437740
  454476
  460259
  464176
  502799
  506610
  506883
  507799
  511298
  518249
  535987
  538520
  540719
  542306
  543983
  552147
  554772
  555384
  555746
  561402
  561809
  562182
  562471
  564416
  567675
  572689
  577562
  577805
  578433
  579685
  580073
  583180
  584743
  602180
  604278
  606637
  608581
  610647
  613849
  614836
  620777
  623328
  632845
  639924
  641407
  643114
  659411
  676571
  695803
  701673
  705087
  706331
  713445
  718274
  724183
  724847
  726536
  730349
  730431
  731013
  733142
  735461
  735494
  736775
  737247
  740036
  740101
  740825
  742728
  750151
  751725
  752719
  755994
  759667
  759704
  760122
  760782
  761479
  762252
  765221
  765400
  767607
  769010
  770348
  772358
  772434
  773965
  775997
  778340
  780067
  783704
  785491
  787055
  792736
  793418
  793451
  794166
  794851
  795057
  795267
  795745
  796132
  800937
  801227
  806212
  807530
  807748
  808074
  809747
  810574
  810975
  815852
  820822
  824532
]
2.18 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "end"
]
1.85 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "end"
]
1.46 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "end"
]

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.