GET https://search.jues.net/search/embeds/4?q=sex%20quickie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.99 ms
(83.16%)
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
  398447
  398698
  403381
  418195
  418221
  420505
  422089
  424843
  428890
  432597
  435277
  435740
  437625
  442626
  447016
  450715
  453234
  453246
  453979
  454508
  458383
  461245
  461759
  461774
  463029
  463895
  465066
  470354
  471973
  472410
  472601
  477790
  480993
  487656
  487657
  489657
  492946
  493551
  495246
  495324
  495868
  496376
  497234
  497518
  501667
  503193
  504152
  505564
  506094
  506868
  507077
  511256
  518988
  525071
  528529
  534736
  537449
  538967
  539252
  539638
  541333
  544535
  545183
  546568
  548880
  553320
  557322
  557559
  557955
  561393
  564223
  574040
  579220
  579746
  579868
  581578
  582722
  584333
  585163
  588941
  592093
  592152
  592153
  594505
  597887
  597925
  599233
  599455
  600539
  600704
  602482
  602510
  603955
  606949
  607657
  613630
  615287
  615367
  615963
  616674
  618533
  621443
  624933
  627578
  627841
  628982
  634736
  635050
  640941
  641897
  647813
  660351
  668459
  672744
  693949
  707177
  724183
  764029
  766734
  768123
]
14.87 ms
(9.90%)
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
  471973
  525071
  548880
  588941
  592152
  603955
  599455
  627578
  403381
  557322
  668459
  615287
  615367
  600539
  615963
  768123
  420505
  422089
  437625
  503193
  539638
  505564
  627841
  764029
  506868
  424843
  453234
  453246
  534736
  581578
  597925
  634736
  600704
  616674
  707177
  506094
  497234
  458383
  463029
  544535
  579868
  579220
  541333
  647813
  660351
  613630
  618533
  641897
  492946
  640941
  724183
  453979
  418221
  497518
  553320
  585163
  602510
  621443
  504152
  495868
  477790
  489657
  672744
  592093
  480993
  454508
  538967
  398447
  435740
  537449
  557955
  599233
  635050
  461774
  418195
  495246
  398698
  487657
  450715
  470354
  472601
  511256
  539252
  546568
  564223
  628982
  766734
  461245
  507077
  496376
  461759
  545183
  557559
  602482
  487656
  472410
  447016
  528529
  574040
  693949
  607657
  606949
  495324
  592153
  594505
  435277
  493551
  463895
  561393
  582722
  624933
  597887
  432597
  442626
  579746
  428890
  465066
  501667
  518988
  584333
]
4.08 ms
(2.71%)
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
  398447
  398698
  403381
  418195
  418221
  420505
  422089
  424843
  428890
  432597
  435277
  435740
  437625
  442626
  447016
  450715
  453234
  453246
  453979
  454508
  458383
  461245
  461759
  461774
  463029
  463895
  465066
  470354
  471973
  472410
  472601
  477790
  480993
  487656
  487657
  489657
  492946
  493551
  495246
  495324
  495868
  496376
  497234
  497518
  501667
  503193
  504152
  505564
  506094
  506868
  507077
  511256
  518988
  525071
  528529
  534736
  537449
  538967
  539252
  539638
  541333
  544535
  545183
  546568
  548880
  553320
  557322
  557559
  557955
  561393
  564223
  574040
  579220
  579746
  579868
  581578
  582722
  584333
  585163
  588941
  592093
  592152
  592153
  594505
  597887
  597925
  599233
  599455
  600539
  600704
  602482
  602510
  603955
  606949
  607657
  613630
  615287
  615367
  615963
  616674
  618533
  621443
  624933
  627578
  627841
  628982
  634736
  635050
  640941
  641897
  647813
  660351
  668459
  672744
  693949
  707177
  724183
  764029
  766734
  768123
]
2.02 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex quickie"
]
1.59 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс quickie"
]
1.31 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс quickie"
]

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.