GET https://search.jues.net/search/embeds/4?q=teen%20uniform

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.66 ms
(80.13%)
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
  381776
  389110
  406312
  414870
  416288
  416797
  417308
  422575
  422686
  425832
  428381
  433748
  447125
  451450
  452382
  453248
  456591
  458868
  464916
  466298
  467812
  468267
  468617
  469750
  472951
  474748
  475601
  479492
  479726
  484792
  486422
  486651
  486658
  487722
  489436
  491190
  491393
  492163
  492595
  492719
  494695
  498023
  506522
  509464
  510464
  512781
  512806
  515269
  515279
  518085
  518541
  518939
  526492
  527519
  528840
  531108
  531256
  532307
  533747
  538542
  540316
  543494
  544867
  546200
  548594
  550060
  550085
  550091
  550092
  555858
  559091
  559093
  562511
  565046
  565061
  565847
  569663
  572891
  574244
  586691
  596753
  597063
  597781
  597785
  598032
  598138
  598614
  598745
  599433
  600565
  600586
  607021
  608878
  624231
  636268
  659439
  668377
  671753
  675381
  680167
  683310
  687370
  698302
  699804
  699808
  702460
  705907
  706269
  706280
  706286
  714473
  714652
  719001
  720823
  728386
  730098
  734842
  741578
  752164
  784756
]
19.46 ms
(12.61%)
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
  734842
  730098
  741578
  624231
  702460
  705907
  706286
  784756
  475601
  389110
  428381
  433748
  414870
  456591
  467812
  451450
  515279
  486651
  487722
  515269
  484792
  474748
  680167
  494695
  533747
  548594
  546200
  598745
  492163
  381776
  406312
  458868
  469750
  466298
  479492
  498023
  518939
  532307
  512781
  540316
  506522
  512806
  531256
  527519
  464916
  479726
  559091
  559093
  565847
  687370
  698302
  706269
  719001
  659439
  683310
  714652
  720823
  668377
  671753
  699804
  714473
  550060
  550091
  597063
  597781
  598032
  598138
  600565
  600586
  608878
  586691
  597785
  599433
  596753
  598614
  607021
  752164
  728386
  699808
  706280
  468617
  417308
  472951
  452382
  468267
  486422
  486658
  510464
  491393
  491190
  492595
  492719
  574244
  636268
  509464
  416288
  425832
  416797
  422575
  422686
  453248
  447125
  489436
  518085
  518541
  531108
  538542
  528840
  526492
  555858
  562511
  565046
  543494
  550085
  550092
  565061
  569663
  572891
  544867
  675381
]
3.31 ms
(2.15%)
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
  381776
  389110
  406312
  414870
  416288
  416797
  417308
  422575
  422686
  425832
  428381
  433748
  447125
  451450
  452382
  453248
  456591
  458868
  464916
  466298
  467812
  468267
  468617
  469750
  472951
  474748
  475601
  479492
  479726
  484792
  486422
  486651
  486658
  487722
  489436
  491190
  491393
  492163
  492595
  492719
  494695
  498023
  506522
  509464
  510464
  512781
  512806
  515269
  515279
  518085
  518541
  518939
  526492
  527519
  528840
  531108
  531256
  532307
  533747
  538542
  540316
  543494
  544867
  546200
  548594
  550060
  550085
  550091
  550092
  555858
  559091
  559093
  562511
  565046
  565061
  565847
  569663
  572891
  574244
  586691
  596753
  597063
  597781
  597785
  598032
  598138
  598614
  598745
  599433
  600565
  600586
  607021
  608878
  624231
  636268
  659439
  668377
  671753
  675381
  680167
  683310
  687370
  698302
  699804
  699808
  702460
  705907
  706269
  706280
  706286
  714473
  714652
  719001
  720823
  728386
  730098
  734842
  741578
  752164
  784756
]
2.21 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen uniform"
]
2.09 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen униформ"
]
1.66 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "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.