GET https://search.jues.net/search/embeds/3?q=skinny%20saggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.48 ms
(86.68%)
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
  421238
  444499
  492459
  519980
  526981
  530991
  536670
  540829
  544649
  546703
  546820
  547215
  554031
  557352
  558369
  560884
  561920
  562450
  562595
  566324
  566618
  567430
  569736
  572611
  576621
  578979
  583827
  588096
  588748
  589702
  591753
  592419
  593884
  596980
  600183
  602936
  603367
  606672
  607316
  607382
  608074
  610470
  617051
  622024
  622845
  634452
  636028
  644333
  651809
  656484
  663871
  664539
  672879
  674738
  675371
  677860
  678879
  686064
  691527
  697168
  704867
  707882
  718874
  718916
  723335
  725328
  725403
  726457
  728010
  730102
  730341
  730987
  733539
  734239
  736760
  739705
  741682
  742427
  742462
  743696
  746470
  746653
  747564
  754546
  755096
  756931
  757205
  770434
  771805
  774711
  775496
  776050
  778347
  779852
  780843
  781489
  781505
  785285
  785644
  785729
  788025
  788038
  789424
  791325
  792873
  792925
  793289
  793458
  794798
  794949
  797287
  798200
  798901
  802073
  803633
  808150
  810814
  811446
  818291
  824972
]
13.92 ms
(7.66%)
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
  697168
  723335
  691527
  718916
  546703
  572611
  622024
  644333
  596980
  610470
  593884
  606672
  607382
  600183
  791325
  792873
  793458
  781505
  785644
  798200
  725403
  730987
  736760
  746653
  756931
  757205
  785285
  788025
  788038
  808150
  811446
  741682
  728010
  734239
  743696
  746470
  733539
  742462
  608074
  707882
  778347
  492459
  519980
  566324
  421238
  444499
  540829
  818291
  824972
  536670
  530991
  526981
  547215
  560884
  583827
  558369
  544649
  546820
  554031
  562595
  566618
  567430
  569736
  576621
  651809
  664539
  674738
  677860
  678879
  704867
  718874
  656484
  663871
  675371
  672879
  686064
  557352
  561920
  562450
  578979
  589702
  603367
  588096
  588748
  591753
  592419
  622845
  634452
  602936
  617051
  774711
  775496
  798901
  776050
  779852
  780843
  785729
  793289
  794949
  797287
  803633
  810814
  725328
  789424
  792925
  794798
  739705
  770434
  726457
  730102
  742427
  747564
  754546
  730341
  755096
  771805
  607316
  636028
  781489
  802073
]
4.00 ms
(2.20%)
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
  421238
  444499
  492459
  519980
  526981
  530991
  536670
  540829
  544649
  546703
  546820
  547215
  554031
  557352
  558369
  560884
  561920
  562450
  562595
  566324
  566618
  567430
  569736
  572611
  576621
  578979
  583827
  588096
  588748
  589702
  591753
  592419
  593884
  596980
  600183
  602936
  603367
  606672
  607316
  607382
  608074
  610470
  617051
  622024
  622845
  634452
  636028
  644333
  651809
  656484
  663871
  664539
  672879
  674738
  675371
  677860
  678879
  686064
  691527
  697168
  704867
  707882
  718874
  718916
  723335
  725328
  725403
  726457
  728010
  730102
  730341
  730987
  733539
  734239
  736760
  739705
  741682
  742427
  742462
  743696
  746470
  746653
  747564
  754546
  755096
  756931
  757205
  770434
  771805
  774711
  775496
  776050
  778347
  779852
  780843
  781489
  781505
  785285
  785644
  785729
  788025
  788038
  789424
  791325
  792873
  792925
  793289
  793458
  794798
  794949
  797287
  798200
  798901
  802073
  803633
  808150
  810814
  811446
  818291
  824972
]
1.86 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny saggy"
]
1.46 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые saggy"
]
1.21 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые saggy"
]

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.