GET https://search.jues.net/search/embeds/6?q=step%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.02 ms
(88.66%)
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
  385079
  389563
  397369
  400181
  400233
  401278
  405029
  409222
  411498
  413889
  414938
  416039
  417839
  418440
  419417
  425003
  425065
  432034
  432440
  433078
  433140
  433220
  433531
  433584
  433591
  433770
  433792
  433966
  434670
  434676
  435022
  435613
  437914
  439226
  441447
  443482
  443563
  443963
  444279
  445883
  446453
  447209
  447689
  447780
  449678
  450418
  450426
  450514
  450814
  456480
  457880
  461359
  462897
  463935
  465792
  469731
  472147
  475144
  480960
  481253
  481343
  485180
  485998
  488408
  489627
  490093
  496980
  499581
  499771
  501148
  504906
  513776
  514357
  516693
  517388
  518085
  518807
  520992
  520994
  521537
  521998
  523125
  524188
  524203
  525142
  526601
  527072
  527982
  533623
  538273
  540968
  543609
  550611
  556047
  557124
  557128
  558458
  562985
  565659
  567000
  569232
  575713
  580214
  584716
  587397
  588642
  596208
  599725
  604368
  611266
  621543
  622987
  624224
  652289
  682497
  685477
  728452
  737134
  760958
  784304
]
14.13 ms
(6.59%)
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
  465792
  469731
  481253
  385079
  389563
  417839
  433220
  433584
  461359
  463935
  480960
  405029
  425065
  433078
  433591
  437914
  444279
  447689
  416039
  432440
  434676
  435022
  435613
  449678
  450814
  462897
  411498
  446453
  499771
  489627
  518807
  488408
  499581
  521998
  575713
  400233
  418440
  441447
  409222
  433770
  443563
  433792
  445883
  450426
  450418
  472147
  475144
  481343
  485180
  518085
  520992
  520994
  516693
  526601
  527072
  485998
  543609
  550611
  556047
  562985
  567000
  569232
  558458
  580214
  685477
  584716
  599725
  611266
  621543
  624224
  596208
  587397
  784304
  737134
  604368
  419417
  439226
  425003
  433531
  456480
  400181
  414938
  401278
  433140
  433966
  434670
  443482
  447780
  457880
  450514
  540968
  490093
  504906
  513776
  521537
  527982
  538273
  524188
  514357
  517388
  523125
  622987
  496980
  501148
  533623
  525142
  524203
  557128
  557124
  565659
  682497
  652289
  588642
  760958
  728452
  413889
  447209
  432034
  443963
  397369
]
3.18 ms
(1.48%)
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
  385079
  389563
  397369
  400181
  400233
  401278
  405029
  409222
  411498
  413889
  414938
  416039
  417839
  418440
  419417
  425003
  425065
  432034
  432440
  433078
  433140
  433220
  433531
  433584
  433591
  433770
  433792
  433966
  434670
  434676
  435022
  435613
  437914
  439226
  441447
  443482
  443563
  443963
  444279
  445883
  446453
  447209
  447689
  447780
  449678
  450418
  450426
  450514
  450814
  456480
  457880
  461359
  462897
  463935
  465792
  469731
  472147
  475144
  480960
  481253
  481343
  485180
  485998
  488408
  489627
  490093
  496980
  499581
  499771
  501148
  504906
  513776
  514357
  516693
  517388
  518085
  518807
  520992
  520994
  521537
  521998
  523125
  524188
  524203
  525142
  526601
  527072
  527982
  533623
  538273
  540968
  543609
  550611
  556047
  557124
  557128
  558458
  562985
  565659
  567000
  569232
  575713
  580214
  584716
  587397
  588642
  596208
  599725
  604368
  611266
  621543
  622987
  624224
  652289
  682497
  685477
  728452
  737134
  760958
  784304
]
2.02 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step teen"
]
1.88 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step teen"
]
1.59 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step teen"
]

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.