Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.64 ms
(83.79%)
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
  409585
  445551
  467656
  473586
  473596
  473597
  483847
  497117
  505978
  507789
  514263
  521359
  528623
  531984
  532095
  532116
  534513
  536297
  538279
  539739
  542211
  543565
  547115
  548040
  551444
  554608
  559173
  559533
  561209
  567319
  576194
  576609
  576768
  579440
  579952
  580580
  591099
  594974
  599085
  599090
  615769
  616530
  616677
  618184
  622558
  626169
  636117
  638743
  643792
  645773
  646522
  646668
  650573
  650650
  651167
  653754
  668584
  673841
  676591
  680853
  683426
  688849
  695741
  708146
  709574
  709587
  710305
  714327
  714385
  714546
  716517
  716840
  716995
  718400
  730547
  732800
  734940
  735572
  739664
  742527
  743667
  747629
  748039
  753127
  754134
  755009
  757322
  761101
  761878
  775767
  775778
  775782
  776171
  776241
  778022
  780101
  780379
  780469
  787375
  787854
  787882
  793028
  793041
  794402
  802050
  817654
  819745
  823975
  824716
  825718
  826679
  826772
  828167
  828253
  828439
  828454
  828464
  828545
  828768
]
12.86 ms
(8.86%)
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
  828545
  793041
  591099
  825666
  819745
  775767
  409585
  507789
  714385
  646522
  599085
  599090
  467656
  521359
  532095
  505978
  514263
  559173
  473597
  473586
  473596
  445551
  497117
  824716
  828253
  828464
  828439
  793028
  755009
  732800
  761101
  676591
  826772
  828454
  780379
  734940
  730547
  778022
  534513
  528623
  547115
  576768
  716840
  650650
  718400
  594974
  743667
  817654
  539739
  551444
  543565
  576609
  787375
  739664
  826679
  825718
  823975
  828167
  761878
  787882
  802050
  828768
  794402
  776171
  780469
  787854
  747629
  754134
  748039
  757322
  742527
  735572
  753127
  780101
  483847
  532116
  531984
  536297
  538279
  542211
  579440
  561209
  567319
  580580
  576194
  579952
  710305
  716517
  651167
  653754
  683426
  688849
  709574
  709587
  714546
  716995
  645773
  646668
  650573
  668584
  673841
  680853
  695741
  708146
  714327
  548040
  554608
  559533
  616530
  616677
  636117
  618184
  626169
  643792
  615769
  622558
  638743
  776241
  775778
  775782
]
3.37 ms
(2.32%)
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
  409585
  445551
  467656
  473586
  473596
  473597
  483847
  497117
  505978
  507789
  514263
  521359
  528623
  531984
  532095
  532116
  534513
  536297
  538279
  539739
  542211
  543565
  547115
  548040
  551444
  554608
  559173
  559533
  561209
  567319
  576194
  576609
  576768
  579440
  579952
  580580
  591099
  594974
  599085
  599090
  615769
  616530
  616677
  618184
  622558
  626169
  636117
  638743
  643792
  645773
  646522
  646668
  650573
  650650
  651167
  653754
  668584
  673841
  676591
  680853
  683426
  688849
  695741
  708146
  709574
  709587
  710305
  714327
  714385
  714546
  716517
  716840
  716995
  718400
  730547
  732800
  734940
  735572
  739664
  742527
  743667
  747629
  748039
  753127
  754134
  755009
  757322
  761101
  761878
  775767
  775778
  775782
  776171
  776241
  778022
  780101
  780379
  780469
  787375
  787854
  787882
  793028
  793041
  794402
  802050
  817654
  819745
  823975
  824716
  825718
  826679
  826772
  828167
  828253
  828439
  828454
  828464
  828545
  828768
]
2.04 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step любительск"
]
1.78 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step amateur"
]
1.73 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step любительск"
]

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.