Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.66 ms
(85.45%)
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
  61369
  229105
  298519
  338039
  341622
  365924
  382386
  382530
  384179
  394167
  395449
  397493
  410799
  414022
  417956
  418057
  418128
  418551
  419666
  420117
  423548
  424734
  425359
  428693
  428937
  432963
  440856
  442618
  444130
  448137
  448925
  449952
  450840
  452287
  452406
  453479
  453629
  455387
  457843
  457967
  460020
  460501
  461306
  464502
  465483
  465841
  468137
  468298
  473483
  475687
  477467
  478081
  479081
  481335
  484008
  484923
  490846
  492397
  492432
  494090
  495188
  495666
  497389
  497753
  499439
  501970
  506221
  507113
  513144
  514234
  514426
  517660
  520968
  522860
  523361
  524038
  526542
  527776
  530705
  531901
  533595
  535541
  537227
  547352
  549191
  552159
  552176
  552206
  559034
  559672
  562814
  566365
  570246
  571780
  573954
  574967
  578752
  583942
  588318
  589265
  591404
  593227
  595389
  604418
  614018
  633185
  636568
  670251
  672245
  693049
  723468
  748949
  756234
  759485
  769416
  785764
  818247
  821855
  823920
  826763
]
16.06 ms
(9.29%)
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
  818247
  533595
  475687
  552159
  552206
  559672
  552176
  547352
  672245
  614018
  591404
  465841
  448925
  338039
  444130
  562814
  61369
  414022
  428693
  468298
  513144
  499439
  570246
  566365
  571780
  574967
  578752
  670251
  583942
  633185
  595389
  604418
  636568
  785764
  769416
  756234
  759485
  418128
  418057
  448137
  417956
  453479
  494090
  495188
  497389
  384179
  229105
  341622
  397493
  424734
  440856
  826763
  450840
  460501
  465483
  479081
  452287
  468137
  530705
  531901
  537227
  559034
  573954
  723468
  693049
  549191
  593227
  589265
  748949
  442618
  452406
  425359
  432963
  453629
  455387
  365924
  410799
  423548
  449952
  506221
  490846
  588318
  394167
  395449
  298519
  382530
  382386
  418551
  428937
  419666
  420117
  823920
  821855
  464502
  477467
  492432
  457967
  460020
  461306
  473483
  484008
  457843
  478081
  481335
  484923
  492397
  495666
  507113
  522860
  526542
  535541
  501970
  523361
  524038
  497753
  520968
  527776
  514234
  514426
  517660
]
2.91 ms
(1.68%)
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
  61369
  229105
  298519
  338039
  341622
  365924
  382386
  382530
  384179
  394167
  395449
  397493
  410799
  414022
  417956
  418057
  418128
  418551
  419666
  420117
  423548
  424734
  425359
  428693
  428937
  432963
  440856
  442618
  444130
  448137
  448925
  449952
  450840
  452287
  452406
  453479
  453629
  455387
  457843
  457967
  460020
  460501
  461306
  464502
  465483
  465841
  468137
  468298
  473483
  475687
  477467
  478081
  479081
  481335
  484008
  484923
  490846
  492397
  492432
  494090
  495188
  495666
  497389
  497753
  499439
  501970
  506221
  507113
  513144
  514234
  514426
  517660
  520968
  522860
  523361
  524038
  526542
  527776
  530705
  531901
  533595
  535541
  537227
  547352
  549191
  552159
  552176
  552206
  559034
  559672
  562814
  566365
  570246
  571780
  573954
  574967
  578752
  583942
  588318
  589265
  591404
  593227
  595389
  604418
  614018
  633185
  636568
  670251
  672245
  693049
  723468
  748949
  756234
  759485
  769416
  785764
  818247
  821855
  823920
  826763
]
1.82 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пять"
]
1.65 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пят"
]
1.22 ms
(0.70%)
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.