Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.26 ms
(87.50%)
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
  397535
  414364
  424904
  427937
  453825
  469373
  472431
  474837
  475799
  478771
  480293
  480398
  486470
  495126
  500740
  500971
  514594
  518473
  523418
  526891
  528761
  530697
  531123
  531233
  531248
  532166
  532744
  532950
  532965
  532974
  533044
  533363
  533521
  533854
  533931
  534216
  534999
  536178
  536291
  536542
  536550
  536620
  536744
  537210
  537212
  537236
  537888
  537891
  539203
  540348
  540573
  541853
  542877
  544854
  545372
  545488
  545611
  553272
  588265
  599835
  599865
  599940
  600021
  600257
  600269
  605344
  608035
  614737
  617427
  628380
  628383
  630234
  630295
  630552
  630857
  630869
  630902
  632562
  632593
  632653
  633776
  634134
  634140
  634159
  634169
  634218
  634780
  636272
  639334
  641638
  644278
  650316
  651674
  666868
  666880
  666894
  677296
  677777
  677784
  678095
  678097
  678522
  680176
  680186
  680195
  680197
  696606
  703039
  710425
  717798
  724230
  724243
  727751
  729881
  733866
  740584
  747281
  748354
  775056
  818439
]
15.11 ms
(7.72%)
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
  634159
  634169
  641638
  630857
  632653
  633776
  636272
  600269
  605344
  608035
  630234
  630295
  630902
  632562
  775056
  724243
  740584
  727751
  729881
  724230
  733866
  747281
  748354
  632593
  644278
  703039
  710425
  717798
  424904
  397535
  427937
  537888
  539203
  540573
  537210
  537212
  537236
  500971
  518473
  536744
  514594
  531123
  533363
  541853
  545488
  545611
  553272
  651674
  677296
  677777
  678095
  678522
  680195
  696606
  650316
  666880
  666894
  678097
  680186
  666868
  677784
  680176
  680197
  545372
  614737
  634134
  634140
  639334
  600021
  599865
  617427
  628380
  628383
  630869
  588265
  599835
  600257
  630552
  634218
  634780
  478771
  599940
  526891
  414364
  818439
  486470
  453825
  469373
  475799
  480293
  480398
  474837
  495126
  528761
  530697
  533521
  534216
  536178
  536542
  531248
  532950
  532974
  533044
  533931
  536291
  536620
  500740
  523418
  531233
  532166
  532744
  536550
  540348
  532965
  533854
  534999
  537891
  472431
  542877
  544854
]
2.68 ms
(1.37%)
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
  397535
  414364
  424904
  427937
  453825
  469373
  472431
  474837
  475799
  478771
  480293
  480398
  486470
  495126
  500740
  500971
  514594
  518473
  523418
  526891
  528761
  530697
  531123
  531233
  531248
  532166
  532744
  532950
  532965
  532974
  533044
  533363
  533521
  533854
  533931
  534216
  534999
  536178
  536291
  536542
  536550
  536620
  536744
  537210
  537212
  537236
  537888
  537891
  539203
  540348
  540573
  541853
  542877
  544854
  545372
  545488
  545611
  553272
  588265
  599835
  599865
  599940
  600021
  600257
  600269
  605344
  608035
  614737
  617427
  628380
  628383
  630234
  630295
  630552
  630857
  630869
  630902
  632562
  632593
  632653
  633776
  634134
  634140
  634159
  634169
  634218
  634780
  636272
  639334
  641638
  644278
  650316
  651674
  666868
  666880
  666894
  677296
  677777
  677784
  678095
  678097
  678522
  680176
  680186
  680195
  680197
  696606
  703039
  710425
  717798
  724230
  724243
  727751
  729881
  733866
  740584
  747281
  748354
  775056
  818439
]
1.92 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кастинг с двойным"
]
1.81 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг двойн"
]
1.47 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.