Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.64 ms
(80.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
  81065
  191189
  271756
  388688
  396088
  397299
  402169
  403703
  412220
  413472
  422426
  428104
  436523
  439446
  439450
  447830
  448843
  449146
  450779
  452388
  452429
  456707
  457008
  458639
  461984
  462362
  467068
  469988
  471478
  473650
  474813
  487575
  487950
  491175
  492115
  495280
  496124
  497766
  501699
  503082
  512631
  513704
  517132
  523272
  524395
  529542
  531308
  540647
  543507
  546870
  547031
  549142
  549508
  556553
  556766
  556936
  558318
  559312
  564688
  566358
  576117
  579664
  579849
  579877
  585838
  587575
  590057
  593381
  593382
  593669
  612467
  612951
  613837
  613848
  614045
  618104
  636116
  636449
  636462
  645265
  646435
  652010
  653330
  665740
  667909
  686284
  705226
  707698
  708450
  708894
  709292
  709819
  719837
  720074
  723155
  723432
  726907
  728741
  731037
  733534
  734521
  736425
  744494
  752876
  759653
  761459
  761949
  763378
  764923
  774534
  775009
  775013
  780936
  795483
  803258
  804210
  808095
  811906
  814111
  814675
]
20.54 ms
(12.45%)
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
  469988
  517132
  473650
  667909
  708450
  645265
  709292
  579664
  612951
  614045
  752876
  728741
  388688
  523272
  436523
  413472
  448843
  495280
  487950
  556766
  543507
  547031
  707698
  579849
  593381
  795483
  804210
  736425
  774534
  780936
  808095
  81065
  449146
  503082
  496124
  559312
  549508
  566358
  686284
  723432
  556936
  613837
  587575
  775009
  775013
  733534
  764923
  744494
  412220
  271756
  402169
  422426
  814675
  457008
  452429
  447830
  540647
  497766
  720074
  709819
  811906
  734521
  759653
  458639
  396088
  403703
  191189
  461984
  512631
  491175
  524395
  462362
  612467
  636449
  467068
  471478
  487575
  593669
  731037
  474813
  492115
  501699
  439450
  439446
  579877
  705226
  723155
  653330
  665740
  564688
  585838
  613848
  618104
  636116
  726907
  763378
  761949
  636462
  708894
  803258
  450779
  397299
  814111
  576117
  646435
  761459
  428104
  452388
  513704
  456707
  531308
  529542
  556553
  558318
  546870
  549142
  652010
  719837
  590057
  593382
]
2.75 ms
(1.67%)
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
  81065
  191189
  271756
  388688
  396088
  397299
  402169
  403703
  412220
  413472
  422426
  428104
  436523
  439446
  439450
  447830
  448843
  449146
  450779
  452388
  452429
  456707
  457008
  458639
  461984
  462362
  467068
  469988
  471478
  473650
  474813
  487575
  487950
  491175
  492115
  495280
  496124
  497766
  501699
  503082
  512631
  513704
  517132
  523272
  524395
  529542
  531308
  540647
  543507
  546870
  547031
  549142
  549508
  556553
  556766
  556936
  558318
  559312
  564688
  566358
  576117
  579664
  579849
  579877
  585838
  587575
  590057
  593381
  593382
  593669
  612467
  612951
  613837
  613848
  614045
  618104
  636116
  636449
  636462
  645265
  646435
  652010
  653330
  665740
  667909
  686284
  705226
  707698
  708450
  708894
  709292
  709819
  719837
  720074
  723155
  723432
  726907
  728741
  731037
  733534
  734521
  736425
  744494
  752876
  759653
  761459
  761949
  763378
  764923
  774534
  775009
  775013
  780936
  795483
  803258
  804210
  808095
  811906
  814111
  814675
]
2.61 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big load"
]
1.97 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие load"
]
1.63 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие load"
]

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.