GET https://search.jues.net/search/embeds/4?q=compilation%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.71 ms
(88.37%)
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
  390845
  401491
  401700
  402021
  423963
  435239
  439175
  453882
  462899
  468290
  468996
  469279
  475691
  476798
  496808
  500943
  500945
  511688
  512946
  517441
  522277
  525202
  525791
  528387
  529394
  535871
  545861
  558757
  559412
  577626
  578824
  580624
  583949
  588317
  591756
  617398
  629558
  645076
  662931
  680654
  680673
  681938
  682359
  689028
  691385
  700689
  701445
  705322
  710329
  712101
  714095
  715359
  716735
  717149
  717181
  718875
  720235
  724152
  724729
  725025
  725479
  726442
  728131
  730088
  731054
  733356
  734696
  738114
  738898
  738911
  739920
  739987
  740246
  740609
  741318
  746432
  746580
  746612
  750224
  752499
  753172
  755959
  757006
  760562
  761104
  761160
  761546
  763475
  767798
  769366
  772863
  773691
  773883
  777033
  778221
  778270
  779084
  783355
  783937
  785313
  786160
  793853
  794569
  794587
  794762
  795960
  796117
  797045
  798821
  799481
  801300
  801987
  804301
  807849
  809640
  812157
  813211
  824143
  825969
]
12.93 ms
(6.89%)
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
  807849
  777033
  779084
  793853
  794569
  799481
  804301
  725479
  726442
  733356
  753172
  757006
  760562
  772863
  783355
  785313
  786160
  794587
  794762
  795960
  801987
  809640
  813211
  725025
  730088
  731054
  738898
  739920
  746612
  755959
  761104
  763475
  724729
  728131
  738911
  740246
  746432
  746580
  750224
  752499
  773691
  773883
  724152
  769366
  734696
  738114
  739987
  740609
  741318
  761160
  761546
  767798
  629558
  700689
  717149
  717181
  778221
  778270
  783937
  796117
  797045
  801300
  812157
  559412
  525202
  517441
  793822
  528387
  645076
  705322
  798821
  710329
  390845
  423963
  435239
  475691
  453882
  462899
  468996
  496808
  500943
  525791
  529394
  512946
  500945
  522277
  580624
  583949
  558757
  578824
  588317
  591756
  617398
  439175
  401700
  825969
  824143
  401491
  402021
  469279
  476798
  511688
  535871
  468290
  577626
  545861
  680654
  689028
  701445
  712101
  714095
  715359
  716735
  718875
  720235
  662931
  680673
  681938
  682359
  691385
]
2.66 ms
(1.42%)
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
  390845
  401491
  401700
  402021
  423963
  435239
  439175
  453882
  462899
  468290
  468996
  469279
  475691
  476798
  496808
  500943
  500945
  511688
  512946
  517441
  522277
  525202
  525791
  528387
  529394
  535871
  545861
  558757
  559412
  577626
  578824
  580624
  583949
  588317
  591756
  617398
  629558
  645076
  662931
  680654
  680673
  681938
  682359
  689028
  691385
  700689
  701445
  705322
  710329
  712101
  714095
  715359
  716735
  717149
  717181
  718875
  720235
  724152
  724729
  725025
  725479
  726442
  728131
  730088
  731054
  733356
  734696
  738114
  738898
  738911
  739920
  739987
  740246
  740609
  741318
  746432
  746580
  746612
  750224
  752499
  753172
  755959
  757006
  760562
  761104
  761160
  761546
  763475
  767798
  769366
  772863
  773691
  773883
  777033
  778221
  778270
  779084
  783355
  783937
  785313
  786160
  793853
  794569
  794587
  794762
  795960
  796117
  797045
  798821
  799481
  801300
  801987
  804301
  807849
  809640
  812157
  813211
  824143
  825969
]
1.84 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation wife"
]
1.56 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк жен"
]
1.45 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подборк жен"
]
1.38 ms
(0.74%)
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.