GET https://search.jues.net/search/embeds/4?q=hidden%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
183.22 ms
(85.79%)
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
  230243
  391543
  393253
  399473
  416288
  426480
  429794
  432782
  436758
  456889
  459378
  459558
  462959
  467418
  467445
  469303
  470716
  472695
  475122
  482102
  491750
  498024
  498064
  504765
  506522
  506665
  507115
  511523
  513280
  516402
  517256
  520982
  524025
  525881
  530544
  530554
  531553
  531903
  533636
  534339
  534342
  534353
  540098
  550505
  550507
  551627
  552083
  553723
  557983
  560157
  560169
  565046
  566047
  569427
  571464
  571466
  571468
  572827
  574162
  574186
  575726
  584673
  590710
  594770
  594833
  594929
  598382
  598614
  605930
  611880
  611920
  617216
  623874
  624241
  625552
  671927
  675381
  679472
  682047
  682599
  686710
  687542
  687551
  689622
  693023
  698289
  698302
  699023
  699334
  699335
  699804
  699808
  700426
  704010
  704561
  704726
  704735
  706280
  706290
  706984
  712973
  712978
  715061
  715194
  720612
  722437
  722523
  730926
  733832
  734630
  743414
  744372
  758283
  764593
  790029
  792760
  800084
  800373
  817429
  818833
]
19.35 ms
(9.06%)
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
  506522
  516402
  520982
  531903
  540098
  491750
  550505
  551627
  553723
  572827
  550507
  575726
  698302
  699023
  699335
  706290
  687542
  693023
  698289
  682047
  682599
  689622
  699804
  704726
  704735
  712973
  571468
  594833
  617216
  594929
  611880
  623874
  598614
  624241
  800373
  699808
  700426
  704010
  706280
  462959
  475122
  429794
  456889
  459558
  399473
  467445
  470716
  506665
  511523
  498064
  513280
  391543
  818833
  817429
  531553
  571466
  715194
  671927
  679472
  720612
  722523
  625552
  734630
  733832
  758283
  764593
  715061
  393253
  517256
  525881
  426480
  472695
  524025
  534342
  436758
  469303
  533636
  230243
  534339
  507115
  530544
  530554
  534353
  482102
  574186
  722437
  598382
  611920
  605930
  590710
  800084
  730926
  743414
  744372
  792760
  790029
  416288
  432782
  459378
  467418
  498024
  504765
  552083
  560157
  565046
  571464
  557983
  569427
  574162
  584673
  675381
  699334
  706984
  712978
  704561
  686710
  687551
  560169
  566047
  594770
]
3.59 ms
(1.68%)
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
  230243
  391543
  393253
  399473
  416288
  426480
  429794
  432782
  436758
  456889
  459378
  459558
  462959
  467418
  467445
  469303
  470716
  472695
  475122
  482102
  491750
  498024
  498064
  504765
  506522
  506665
  507115
  511523
  513280
  516402
  517256
  520982
  524025
  525881
  530544
  530554
  531553
  531903
  533636
  534339
  534342
  534353
  540098
  550505
  550507
  551627
  552083
  553723
  557983
  560157
  560169
  565046
  566047
  569427
  571464
  571466
  571468
  572827
  574162
  574186
  575726
  584673
  590710
  594770
  594833
  594929
  598382
  598614
  605930
  611880
  611920
  617216
  623874
  624241
  625552
  671927
  675381
  679472
  682047
  682599
  686710
  687542
  687551
  689622
  693023
  698289
  698302
  699023
  699334
  699335
  699804
  699808
  700426
  704010
  704561
  704726
  704735
  706280
  706290
  706984
  712973
  712978
  715061
  715194
  720612
  722437
  722523
  730926
  733832
  734630
  743414
  744372
  758283
  764593
  790029
  792760
  800084
  800373
  817429
  818833
]
1.97 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden young"
]
1.94 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт young"
]
1.81 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт young"
]

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.