Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.84 ms
(88.98%)
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
  9953
  13373
  21210
  33795
  58636
  89347
  96250
  122062
  149815
  173963
  186823
  194530
  197511
  202901
  212750
  214302
  233618
  307342
  313978
  362712
  381844
  382480
  382592
  382750
  384924
  384974
  385216
  385408
  387566
  389926
  390225
  390284
  391217
  391841
  392552
  392655
  392943
  393267
  397772
  398514
  401390
  403076
  409050
  413453
  413677
  414749
  422321
  424910
  425392
  428380
  429157
  433622
  447197
  457567
  460142
  462149
  470592
  471576
  474163
  490801
  500389
  504032
  542406
  548016
  552141
  556165
  556743
  562548
  569876
  570333
  587473
  590326
  593110
  601494
  605496
  605643
  611383
  630205
  637828
  638570
  646114
  646353
  652231
  659100
  661685
  667517
  676983
  681805
  683709
  688417
  692472
  693759
  697731
  699970
  709098
  709225
  709633
  711212
  718162
  718272
  729960
  732963
  734730
  744349
  744552
  746036
  746396
  749045
  750784
  757832
  762010
  770808
  774091
  779695
  782721
  793535
  794512
  796809
  796963
  798519
]
13.88 ms
(6.27%)
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
  683709
  688417
  709225
  646353
  652231
  661685
  681805
  692472
  697731
  709098
  711212
  699970
  709633
  718162
  638570
  593110
  601494
  587473
  782721
  794512
  796809
  729960
  749045
  796963
  744552
  746396
  750784
  762010
  732963
  734730
  744349
  746036
  770808
  757832
  774091
  637828
  779695
  793535
  798519
  89347
  385216
  385408
  392655
  392943
  414749
  447197
  33795
  233618
  307342
  428380
  21210
  194530
  214302
  122062
  390225
  390284
  413677
  429157
  470592
  605496
  96250
  382750
  384924
  384974
  197511
  202901
  149815
  212750
  186823
  173963
  393267
  391841
  392552
  313978
  362712
  382480
  381844
  382592
  58636
  13373
  9953
  389926
  387566
  391217
  397772
  398514
  403076
  401390
  413453
  422321
  425392
  433622
  409050
  424910
  457567
  462149
  471576
  500389
  504032
  460142
  474163
  490801
  556165
  556743
  569876
  542406
  570333
  667517
  676983
  693759
  718272
  646114
  659100
  548016
  552141
  562548
  590326
  605643
  611383
  630205
]
3.01 ms
(1.36%)
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
  9953
  13373
  21210
  33795
  58636
  89347
  96250
  122062
  149815
  173963
  186823
  194530
  197511
  202901
  212750
  214302
  233618
  307342
  313978
  362712
  381844
  382480
  382592
  382750
  384924
  384974
  385216
  385408
  387566
  389926
  390225
  390284
  391217
  391841
  392552
  392655
  392943
  393267
  397772
  398514
  401390
  403076
  409050
  413453
  413677
  414749
  422321
  424910
  425392
  428380
  429157
  433622
  447197
  457567
  460142
  462149
  470592
  471576
  474163
  490801
  500389
  504032
  542406
  548016
  552141
  556165
  556743
  562548
  569876
  570333
  587473
  590326
  593110
  601494
  605496
  605643
  611383
  630205
  637828
  638570
  646114
  646353
  652231
  659100
  661685
  667517
  676983
  681805
  683709
  688417
  692472
  693759
  697731
  699970
  709098
  709225
  709633
  711212
  718162
  718272
  729960
  732963
  734730
  744349
  744552
  746036
  746396
  749045
  750784
  757832
  762010
  770808
  774091
  779695
  782721
  793535
  794512
  796809
  796963
  798519
]
2.13 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "диван"
]
2.11 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "диване"
]
1.72 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "диван"
]
1.54 ms
(0.70%)
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.