GET https://search.jues.net/search/embeds/3?q=young%20amateur%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.77 ms
(86.52%)
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
  239808
  391072
  392691
  395651
  396245
  397102
  399551
  400461
  400698
  403258
  408429
  411125
  415978
  416153
  416668
  416689
  416701
  417940
  418649
  421072
  421443
  422929
  423464
  424173
  427246
  432685
  432802
  453793
  456215
  463266
  465237
  466966
  474626
  475453
  479759
  485085
  485228
  492794
  494322
  496076
  504303
  504393
  504479
  511836
  515744
  516695
  525058
  527049
  530576
  531767
  534127
  543659
  544206
  544368
  564066
  571215
  571219
  572176
  574606
  574911
  584295
  597820
  603285
  604051
  605325
  605326
  605851
  606102
  608425
  608765
  609878
  611299
  617128
  617660
  619367
  656575
  661652
  671396
  672766
  672767
  692001
  694028
  694131
  696218
  696280
  721999
  723927
  728675
  729256
  733138
  739913
  747687
  748541
  748686
  750410
  753971
  757182
  757906
  759581
  760938
  763522
  766852
  766874
  777551
  780363
  781568
  788198
  790394
  790867
  791521
  796532
  804373
  807301
  814265
  816595
  817378
  823808
  825133
  826728
  827942
]
15.04 ms
(8.20%)
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
  766874
  760938
  721999
  790867
  424173
  432802
  475453
  494322
  827942
  605326
  759581
  415978
  525058
  400698
  791521
  728675
  408429
  617660
  574911
  584295
  617128
  597820
  391072
  696280
  544368
  748541
  423464
  527049
  516695
  604051
  826728
  825133
  534127
  780363
  739913
  753971
  757182
  777551
  781568
  788198
  392691
  416689
  574606
  400461
  422929
  530576
  807301
  418649
  814265
  456215
  572176
  656575
  694028
  564066
  606102
  611299
  608425
  605851
  608765
  723927
  747687
  733138
  748686
  763522
  466966
  474626
  432685
  492794
  485085
  239808
  395651
  396245
  504479
  571215
  672767
  671396
  672766
  571219
  609878
  605325
  790394
  750410
  729256
  399551
  504393
  603285
  427246
  694131
  692001
  543659
  485228
  661652
  397102
  816595
  817378
  796532
  766852
  411125
  403258
  421443
  453793
  416701
  479759
  416668
  823808
  416153
  421072
  511836
  544206
  696218
  619367
  804373
  757906
  417940
  465237
  463266
  504303
  515744
  496076
  531767
]
2.88 ms
(1.57%)
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
  239808
  391072
  392691
  395651
  396245
  397102
  399551
  400461
  400698
  403258
  408429
  411125
  415978
  416153
  416668
  416689
  416701
  417940
  418649
  421072
  421443
  422929
  423464
  424173
  427246
  432685
  432802
  453793
  456215
  463266
  465237
  466966
  474626
  475453
  479759
  485085
  485228
  492794
  494322
  496076
  504303
  504393
  504479
  511836
  515744
  516695
  525058
  527049
  530576
  531767
  534127
  543659
  544206
  544368
  564066
  571215
  571219
  572176
  574606
  574911
  584295
  597820
  603285
  604051
  605325
  605326
  605851
  606102
  608425
  608765
  609878
  611299
  617128
  617660
  619367
  656575
  661652
  671396
  672766
  672767
  692001
  694028
  694131
  696218
  696280
  721999
  723927
  728675
  729256
  733138
  739913
  747687
  748541
  748686
  750410
  753971
  757182
  757906
  759581
  760938
  763522
  766852
  766874
  777551
  780363
  781568
  788198
  790394
  790867
  791521
  796532
  804373
  807301
  814265
  816595
  817378
  823808
  825133
  826728
  827942
]
2.10 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young amateur teen"
]
1.64 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young любительск teen"
]
1.57 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young любительск teen"
]
1.50 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.