GET https://search.jues.net/search/embeds/8?q=18%20year

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.86 ms
(82.73%)
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
  7008
  383633
  395354
  396792
  398676
  412442
  412508
  417643
  417693
  418617
  418645
  418656
  419027
  421658
  422032
  427699
  429214
  429219
  429229
  429231
  429235
  429237
  436608
  446793
  452395
  455933
  458649
  459255
  459538
  459711
  462135
  462306
  462834
  466635
  468116
  469102
  477543
  483051
  485864
  489144
  491193
  492496
  492498
  501776
  501784
  505416
  506577
  508276
  510836
  517862
  522732
  527314
  529101
  535703
  537475
  538523
  554093
  554164
  554251
  554722
  561897
  562435
  566071
  571163
  572261
  572943
  572972
  572982
  574089
  577845
  577883
  577889
  577895
  578342
  579691
  582064
  584162
  593172
  593977
  594008
  594057
  594079
  594093
  594095
  594261
  595941
  598208
  598881
  606223
  616481
  617203
  617672
  618465
  622472
  622675
  627121
  628063
  631470
  642270
  660310
  670566
  712509
  724556
  747310
  756861
  758847
  763536
  780561
  785292
  787911
  788294
  788407
  788936
  790933
  800846
  800854
  800856
  806877
  806884
  811829
]
15.07 ms
(10.41%)
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
  595941
  785292
  780561
  787911
  756861
  800846
  806884
  622472
  622675
  631470
  489144
  577883
  572261
  554093
  606223
  594008
  617672
  788294
  811829
  747310
  758847
  800854
  429237
  468116
  485864
  510836
  419027
  574089
  462306
  491193
  7008
  412508
  537475
  712509
  660310
  594093
  594261
  763536
  800856
  418645
  429229
  429231
  398676
  466635
  501784
  492498
  501776
  418656
  427699
  422032
  436608
  458649
  452395
  459711
  529101
  538523
  535703
  505416
  462834
  571163
  572943
  572972
  577895
  554164
  561897
  566071
  577845
  578342
  562435
  582064
  584162
  670566
  554251
  554722
  572982
  577889
  579691
  594057
  598208
  616481
  593977
  627121
  642270
  594079
  598881
  628063
  593172
  594095
  617203
  618465
  788407
  788936
  790933
  806877
  724556
  421658
  459538
  477543
  417643
  429214
  412442
  462135
  417693
  446793
  455933
  517862
  508276
  506577
  522732
  483051
  492496
  527314
  383633
  395354
  396792
  418617
  429219
  429235
  469102
  459255
]
3.14 ms
(2.17%)
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
  7008
  383633
  395354
  396792
  398676
  412442
  412508
  417643
  417693
  418617
  418645
  418656
  419027
  421658
  422032
  427699
  429214
  429219
  429229
  429231
  429235
  429237
  436608
  446793
  452395
  455933
  458649
  459255
  459538
  459711
  462135
  462306
  462834
  466635
  468116
  469102
  477543
  483051
  485864
  489144
  491193
  492496
  492498
  501776
  501784
  505416
  506577
  508276
  510836
  517862
  522732
  527314
  529101
  535703
  537475
  538523
  554093
  554164
  554251
  554722
  561897
  562435
  566071
  571163
  572261
  572943
  572972
  572982
  574089
  577845
  577883
  577889
  577895
  578342
  579691
  582064
  584162
  593172
  593977
  594008
  594057
  594079
  594093
  594095
  594261
  595941
  598208
  598881
  606223
  616481
  617203
  617672
  618465
  622472
  622675
  627121
  628063
  631470
  642270
  660310
  670566
  712509
  724556
  747310
  756861
  758847
  763536
  780561
  785292
  787911
  788294
  788407
  788936
  790933
  800846
  800854
  800856
  806877
  806884
  811829
]
1.86 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 year"
]
1.68 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 year"
]
1.62 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "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.