GET https://search.jues.net/search/embeds/10?q=19%20year%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.00 ms
(85.15%)
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
  383633
  387652
  395354
  396792
  399874
  406010
  418617
  418661
  420301
  427044
  429160
  429188
  429219
  429226
  429235
  435304
  451708
  456627
  459255
  462984
  465736
  469102
  470056
  480420
  487049
  492495
  493470
  494126
  497805
  499415
  501732
  510112
  511670
  515800
  519307
  524823
  526965
  526980
  528888
  529090
  535259
  538478
  542531
  543929
  551180
  551384
  554093
  557099
  557324
  559938
  563573
  564055
  564139
  567608
  570748
  571509
  573923
  574267
  577160
  577805
  577883
  577884
  577899
  578333
  579223
  584126
  586689
  588546
  589472
  593927
  593955
  593964
  593971
  593988
  594008
  594036
  594038
  594114
  594115
  595941
  597276
  606223
  617489
  617672
  622472
  622675
  624099
  624729
  625121
  626381
  630977
  631470
  634221
  643396
  648927
  650228
  659217
  671410
  681039
  681370
  684211
  701292
  708655
  715575
  747310
  756861
  758847
  761495
  777646
  780561
  784731
  785292
  787911
  788294
  789028
  799336
  800846
  800854
  806884
  811829
]
16.89 ms
(9.28%)
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
  577883
  551180
  564139
  577805
  577884
  579223
  671410
  681039
  701292
  554093
  557099
  584126
  589472
  594114
  606223
  593955
  593964
  594008
  617489
  643396
  586689
  594115
  597276
  624099
  625121
  630977
  634221
  588546
  593927
  593988
  594038
  595941
  617672
  777646
  785292
  788294
  789028
  780561
  787911
  799336
  756861
  761495
  784731
  800846
  806884
  811829
  747310
  758847
  622472
  622675
  631470
  708655
  715575
  800854
  387652
  429188
  462984
  406010
  429226
  529090
  499415
  429160
  451708
  684211
  480420
  535259
  418661
  497805
  528888
  526980
  494126
  519307
  538478
  564055
  570748
  542531
  557324
  559938
  567608
  681370
  648927
  650228
  659217
  571509
  573923
  577160
  624729
  593971
  594036
  626381
  427044
  470056
  435304
  465736
  501732
  510112
  515800
  399874
  456627
  383633
  395354
  396792
  418617
  429219
  420301
  429235
  469102
  487049
  459255
  511670
  526965
  524823
  492495
  493470
  551384
  563573
  543929
  574267
  577899
  578333
]
2.84 ms
(1.56%)
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
  383633
  387652
  395354
  396792
  399874
  406010
  418617
  418661
  420301
  427044
  429160
  429188
  429219
  429226
  429235
  435304
  451708
  456627
  459255
  462984
  465736
  469102
  470056
  480420
  487049
  492495
  493470
  494126
  497805
  499415
  501732
  510112
  511670
  515800
  519307
  524823
  526965
  526980
  528888
  529090
  535259
  538478
  542531
  543929
  551180
  551384
  554093
  557099
  557324
  559938
  563573
  564055
  564139
  567608
  570748
  571509
  573923
  574267
  577160
  577805
  577883
  577884
  577899
  578333
  579223
  584126
  586689
  588546
  589472
  593927
  593955
  593964
  593971
  593988
  594008
  594036
  594038
  594114
  594115
  595941
  597276
  606223
  617489
  617672
  622472
  622675
  624099
  624729
  625121
  626381
  630977
  631470
  634221
  643396
  648927
  650228
  659217
  671410
  681039
  681370
  684211
  701292
  708655
  715575
  747310
  756861
  758847
  761495
  777646
  780561
  784731
  785292
  787911
  788294
  789028
  799336
  800846
  800854
  806884
  811829
]
2.22 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "19 year old"
]
1.88 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "19 year old"
]
1.53 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "19 year old"
]

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.