Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.74 ms
(88.36%)
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
  11718
  12307
  12326
  12775
  33284
  130126
  177440
  187171
  188066
  359062
  385079
  385925
  386959
  388343
  388429
  388965
  389511
  389609
  390518
  390728
  391328
  395887
  396261
  397104
  404474
  411408
  413687
  420423
  421432
  421824
  424582
  428051
  432611
  435507
  443249
  448648
  448955
  452183
  453332
  453852
  456819
  457073
  457224
  457821
  458027
  459649
  460621
  460805
  462039
  466281
  468887
  469501
  470572
  474912
  475005
  475350
  476613
  478588
  481447
  482113
  483210
  483237
  487607
  489322
  493195
  494867
  496780
  503317
  506274
  507225
  507329
  508741
  520810
  521036
  521565
  522602
  523457
  525697
  526854
  527358
  528255
  535037
  536455
  543559
  551198
  551787
  553941
  556722
  557253
  559079
  559094
  560289
  565033
  567833
  570194
  570279
  573846
  573897
  585330
  587974
  592098
  593890
  594784
  606757
  626699
  642367
  649559
  665366
  675127
  675441
  682463
  685588
  687440
  688335
  705144
  752569
  755627
  780140
  813242
  821363
]
14.35 ms
(7.10%)
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
  606757
  386959
  390728
  424582
  507329
  385079
  421824
  448955
  459649
  496780
  388965
  821363
  682463
  688335
  705144
  626699
  752569
  780140
  460805
  462039
  460621
  420423
  458027
  413687
  428051
  456819
  470572
  536455
  553941
  559079
  551787
  665366
  675127
  592098
  585330
  755627
  475350
  411408
  478588
  503317
  443249
  457821
  468887
  466281
  508741
  527358
  525697
  493195
  570194
  573897
  594784
  520810
  421432
  452183
  453332
  494867
  557253
  560289
  481447
  526854
  483210
  489322
  675441
  587974
  476613
  432611
  573846
  469501
  523457
  482113
  565033
  506274
  474912
  556722
  483237
  487607
  528255
  507225
  687440
  453852
  642367
  593890
  11718
  396261
  521565
  475005
  390518
  188066
  543559
  813242
  12326
  457224
  385925
  391328
  397104
  448648
  457073
  522602
  685588
  33284
  435507
  130126
  187171
  177440
  395887
  359062
  12775
  12307
  388343
  389609
  388429
  389511
  404474
  521036
  535037
  559094
  567833
  570279
  551198
  649559
]
2.37 ms
(1.17%)
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
  11718
  12307
  12326
  12775
  33284
  130126
  177440
  187171
  188066
  359062
  385079
  385925
  386959
  388343
  388429
  388965
  389511
  389609
  390518
  390728
  391328
  395887
  396261
  397104
  404474
  411408
  413687
  420423
  421432
  421824
  424582
  428051
  432611
  435507
  443249
  448648
  448955
  452183
  453332
  453852
  456819
  457073
  457224
  457821
  458027
  459649
  460621
  460805
  462039
  466281
  468887
  469501
  470572
  474912
  475005
  475350
  476613
  478588
  481447
  482113
  483210
  483237
  487607
  489322
  493195
  494867
  496780
  503317
  506274
  507225
  507329
  508741
  520810
  521036
  521565
  522602
  523457
  525697
  526854
  527358
  528255
  535037
  536455
  543559
  551198
  551787
  553941
  556722
  557253
  559079
  559094
  560289
  565033
  567833
  570194
  570279
  573846
  573897
  585330
  587974
  592098
  593890
  594784
  606757
  626699
  642367
  649559
  665366
  675127
  675441
  682463
  685588
  687440
  688335
  705144
  752569
  755627
  780140
  813242
  821363
]
2.19 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс рак"
]
1.80 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трахают раком"
]
1.56 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.27 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.