GET https://search.jues.net/search/embeds/9?q=teen%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.24 ms
(84.03%)
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
  12573
  91248
  389093
  395550
  397425
  399737
  402458
  402969
  407489
  417318
  418005
  425474
  426441
  431979
  439233
  443590
  445182
  445872
  446489
  446508
  452400
  453829
  455641
  456936
  457043
  459326
  462769
  464518
  465991
  468190
  471172
  475772
  478998
  483814
  486692
  490786
  492355
  494058
  499774
  503117
  514942
  516024
  516035
  517793
  523300
  527711
  528947
  528950
  528966
  528970
  529027
  530480
  533767
  547731
  548785
  551183
  551477
  561306
  567965
  568251
  570538
  571924
  573852
  574508
  577376
  580307
  580695
  583984
  585475
  589761
  590795
  594505
  594947
  598798
  599447
  601524
  608233
  615400
  617026
  619762
  630279
  631187
  633238
  637025
  637783
  644321
  659297
  661287
  704298
  706930
  707347
  714050
  715102
  717543
  717826
  720445
  720699
  722190
  724169
  735130
  738641
  743137
  744099
  745725
  747497
  755109
  755995
  761155
  761193
  770532
  773907
  786330
  786790
  788272
  792246
  794331
  797731
  807301
  812922
  813285
]
28.20 ms
(11.11%)
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
  704298
  706930
  714050
  717543
  720445
  720699
  722190
  568251
  585475
  608233
  637783
  594947
  633238
  615400
  590795
  599447
  630279
  631187
  786330
  786790
  813285
  788272
  792246
  755995
  773907
  735130
  747497
  761155
  761193
  724169
  755109
  770532
  743137
  744099
  794331
  797731
  12573
  453829
  617026
  91248
  425474
  475772
  446508
  452400
  514942
  570538
  707347
  661287
  717826
  548785
  551183
  644321
  738641
  807301
  397425
  417318
  395550
  418005
  426441
  455641
  465991
  503117
  483814
  523300
  457043
  471172
  527711
  528947
  528950
  528966
  528970
  571924
  574508
  715102
  598798
  619762
  745725
  402969
  529027
  516035
  492355
  517793
  601524
  389093
  499774
  533767
  494058
  530480
  637025
  812922
  462769
  431979
  445182
  443590
  490786
  589761
  402458
  445872
  468190
  577376
  583984
  561306
  659297
  594505
  456936
  439233
  516024
  399737
  407489
  459326
  486692
  478998
  464518
  567965
  573852
  547731
  580695
  580307
  551477
  446489
]
4.76 ms
(1.88%)
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
  12573
  91248
  389093
  395550
  397425
  399737
  402458
  402969
  407489
  417318
  418005
  425474
  426441
  431979
  439233
  443590
  445182
  445872
  446489
  446508
  452400
  453829
  455641
  456936
  457043
  459326
  462769
  464518
  465991
  468190
  471172
  475772
  478998
  483814
  486692
  490786
  492355
  494058
  499774
  503117
  514942
  516024
  516035
  517793
  523300
  527711
  528947
  528950
  528966
  528970
  529027
  530480
  533767
  547731
  548785
  551183
  551477
  561306
  567965
  568251
  570538
  571924
  573852
  574508
  577376
  580307
  580695
  583984
  585475
  589761
  590795
  594505
  594947
  598798
  599447
  601524
  608233
  615400
  617026
  619762
  630279
  631187
  633238
  637025
  637783
  644321
  659297
  661287
  704298
  706930
  707347
  714050
  715102
  717543
  717826
  720445
  720699
  722190
  724169
  735130
  738641
  743137
  744099
  745725
  747497
  755109
  755995
  761155
  761193
  770532
  773907
  786330
  786790
  788272
  792246
  794331
  797731
  807301
  812922
  813285
]
2.14 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen public"
]
2.01 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen на улиц"
]
1.76 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen на улиц"
]
1.65 ms
(0.65%)
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.