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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.18 ms
(82.10%)
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
  388685
  388715
  395392
  395574
  397494
  401267
  409682
  410406
  412288
  412311
  414082
  430095
  432414
  433639
  436627
  441442
  449218
  453484
  485389
  499121
  505978
  506619
  507685
  509997
  518403
  522695
  547557
  551444
  559083
  563873
  563876
  565093
  574184
  574979
  581237
  587479
  590812
  593972
  595463
  598784
  607900
  610804
  613983
  616500
  625950
  630773
  639893
  646135
  649268
  654299
  662217
  685384
  688677
  692528
  692818
  696089
  696235
  698312
  702087
  702521
  702688
  704727
  714460
  715765
  718191
  722684
  724131
  724739
  724966
  726171
  731280
  732215
  734626
  736155
  736614
  736918
  737051
  737856
  740490
  742250
  746242
  746355
  748815
  759383
  760436
  760513
  761771
  762577
  767060
  767071
  767092
  767223
  767327
  767417
  768244
  769101
  769472
  770590
  771138
  771168
  773552
  781584
  782532
  790521
  793228
  794922
  799700
  800619
  800643
  800793
  801763
  803294
  804905
  805186
  810838
  811847
  819064
  820205
  821628
  826292
]
15.87 ms
(10.16%)
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
  718191
  587479
  639893
  593972
  724966
  794922
  767092
  732215
  759383
  761771
  769101
  737051
  793228
  799700
  449218
  505978
  565093
  547557
  574184
  409682
  430095
  395574
  388715
  397494
  820205
  485389
  522695
  649268
  715765
  654299
  702087
  801763
  736155
  760436
  770590
  724131
  724739
  731280
  746355
  762577
  768244
  782532
  800643
  811847
  410406
  401267
  395392
  412311
  506619
  551444
  625950
  436627
  453484
  414082
  819064
  821628
  826292
  581237
  685384
  646135
  688677
  692818
  714460
  595463
  590812
  616500
  630773
  804905
  805186
  800793
  803294
  737856
  740490
  773552
  736614
  767417
  760513
  704727
  790521
  432414
  388685
  412288
  518403
  509997
  698312
  441442
  499121
  507685
  433639
  559083
  563873
  563876
  574979
  662217
  702521
  692528
  696089
  702688
  722684
  696235
  598784
  610804
  613983
  607900
  800619
  810838
  726171
  734626
  746242
  767223
  767327
  771138
  781584
  769472
  742250
  767060
  767071
  771168
  736918
  748815
]
3.12 ms
(2.00%)
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
  388685
  388715
  395392
  395574
  397494
  401267
  409682
  410406
  412288
  412311
  414082
  430095
  432414
  433639
  436627
  441442
  449218
  453484
  485389
  499121
  505978
  506619
  507685
  509997
  518403
  522695
  547557
  551444
  559083
  563873
  563876
  565093
  574184
  574979
  581237
  587479
  590812
  593972
  595463
  598784
  607900
  610804
  613983
  616500
  625950
  630773
  639893
  646135
  649268
  654299
  662217
  685384
  688677
  692528
  692818
  696089
  696235
  698312
  702087
  702521
  702688
  704727
  714460
  715765
  718191
  722684
  724131
  724739
  724966
  726171
  731280
  732215
  734626
  736155
  736614
  736918
  737051
  737856
  740490
  742250
  746242
  746355
  748815
  759383
  760436
  760513
  761771
  762577
  767060
  767071
  767092
  767223
  767327
  767417
  768244
  769101
  769472
  770590
  771138
  771168
  773552
  781584
  782532
  790521
  793228
  794922
  799700
  800619
  800643
  800793
  801763
  803294
  804905
  805186
  810838
  811847
  819064
  820205
  821628
  826292
]
2.91 ms
(1.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step teen"
]
2.21 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step teen"
]
2.17 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.08%)
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.