Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.66 ms
(85.47%)
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
  427497
  435398
  438009
  446181
  450557
  462071
  468267
  478985
  479479
  480912
  482869
  483872
  485244
  499164
  501015
  501443
  503712
  504418
  504848
  505591
  507638
  511999
  514088
  518638
  519237
  519671
  523022
  528362
  529414
  541649
  542306
  549661
  552410
  556751
  559714
  560050
  563943
  574083
  577674
  577783
  579433
  580001
  580206
  584986
  586699
  587212
  587376
  587587
  589701
  592970
  597087
  597660
  602293
  603985
  604056
  604699
  605649
  617604
  619894
  627498
  662144
  676455
  682507
  688993
  689558
  693374
  693761
  696911
  704334
  706006
  706765
  709006
  713583
  714079
  714675
  716229
  717291
  718044
  718060
  720589
  727882
  729567
  732360
  736035
  741217
  748997
  749581
  753199
  756880
  757128
  764023
  765680
  772512
  772579
  777882
  777989
  782057
  782096
  784596
  784654
  786726
  787506
  787774
  790475
  790924
  792082
  792232
  793053
  796441
  801386
  803394
  803672
  808101
  809982
  810059
  810440
  811571
  824745
]
18.12 ms
(9.13%)
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
  549661
  709006
  720589
  662144
  693761
  704334
  693374
  706765
  713583
  718060
  580206
  587587
  617604
  586699
  604699
  619115
  777882
  784596
  787774
  793053
  777989
  809982
  810440
  729567
  748997
  753199
  772579
  808101
  732360
  749581
  757128
  764023
  727882
  736035
  765680
  696911
  714079
  784654
  787506
  480912
  597087
  511999
  619894
  529414
  563943
  627498
  468267
  483872
  507638
  462071
  450557
  505591
  501015
  518638
  560050
  577783
  541649
  574083
  688993
  603985
  427497
  446181
  482869
  504848
  503712
  504418
  519671
  478985
  523022
  485244
  499164
  514088
  519237
  435398
  689558
  597660
  438009
  824745
  584986
  479479
  528362
  501443
  559714
  577674
  542306
  552410
  580001
  676455
  706006
  714675
  717291
  718044
  682507
  716229
  556751
  579433
  587212
  587376
  589701
  592970
  602293
  604056
  605649
  624094
  782057
  782096
  790475
  792082
  792232
  801386
  811571
  786726
  796441
  803394
  803672
  810059
  741217
  756880
  772512
  790924
]
2.86 ms
(1.44%)
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
  427497
  435398
  438009
  446181
  450557
  462071
  468267
  478985
  479479
  480912
  482869
  483872
  485244
  499164
  501015
  501443
  503712
  504418
  504848
  505591
  507638
  511999
  514088
  518638
  519237
  519671
  523022
  528362
  529414
  541649
  542306
  549661
  552410
  556751
  559714
  560050
  563943
  574083
  577674
  577783
  579433
  580001
  580206
  584986
  586699
  587212
  587376
  587587
  589701
  592970
  597087
  597660
  602293
  603985
  604056
  604699
  605649
  617604
  619894
  627498
  662144
  676455
  682507
  688993
  689558
  693374
  693761
  696911
  704334
  706006
  706765
  709006
  713583
  714079
  714675
  716229
  717291
  718044
  718060
  720589
  727882
  729567
  732360
  736035
  741217
  748997
  749581
  753199
  756880
  757128
  764023
  765680
  772512
  772579
  777882
  777989
  782057
  782096
  784596
  784654
  786726
  787506
  787774
  790475
  790924
  792082
  792232
  793053
  796441
  801386
  803394
  803672
  808101
  809982
  810059
  810440
  811571
  824745
]
2.08 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трусик нижн бел orgasm"
]
1.98 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "panties orgasm"
]
1.78 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трусик нижн бел orgasm"
]

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.