Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.30 ms
(87.20%)
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
  2926
  80230
  133294
  150124
  153440
  187590
  204124
  300984
  329296
  384106
  384416
  385751
  389711
  395434
  405854
  413805
  416299
  422810
  425846
  434664
  449478
  452288
  453677
  454114
  455389
  455997
  457157
  483749
  485168
  486822
  493578
  494293
  505283
  505904
  507395
  517614
  517880
  520230
  521601
  524187
  525182
  531806
  532185
  536978
  537233
  537581
  537858
  538538
  539392
  539622
  539881
  540137
  540753
  544336
  547097
  547216
  549818
  551734
  556359
  556858
  558010
  558384
  560012
  565835
  565967
  567874
  568032
  570229
  570333
  574423
  581059
  584031
  586834
  589309
  591863
  591914
  592285
  594220
  595121
  595229
  596056
  599754
  602068
  602769
  602976
  611031
  618942
  651205
  651917
  654749
  654784
  655950
  656958
  656988
  658419
  658715
  659601
  660328
  661270
  663937
  665247
  666810
  667270
  667998
  688880
  688979
  698249
  703248
  741273
  754582
  775420
  775442
  782972
  783129
  783139
  790194
  795917
  796004
  813795
  813796
]
14.42 ms
(7.51%)
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
  790194
  384416
  425846
  422810
  524187
  595121
  384106
  187590
  300984
  80230
  434664
  454114
  532185
  505283
  505904
  531806
  537858
  539622
  520230
  539392
  540137
  507395
  537581
  565835
  567874
  570229
  581059
  558384
  565967
  584031
  544336
  551734
  556359
  558010
  568032
  570333
  574423
  651917
  655950
  656988
  666810
  667998
  688979
  658419
  658715
  667270
  688880
  703248
  651205
  654749
  654784
  656958
  659601
  660328
  661270
  663937
  665247
  698249
  547097
  547216
  549818
  556858
  560012
  586834
  591863
  599754
  602769
  602976
  611031
  589309
  591914
  595229
  596056
  618942
  594220
  592285
  775442
  754582
  782972
  783139
  795917
  741273
  602068
  775420
  783129
  796004
  413805
  455389
  204124
  329296
  449478
  385751
  150124
  133294
  395434
  153440
  2926
  389711
  405854
  416299
  813795
  813796
  455997
  486822
  452288
  453677
  457157
  483749
  485168
  493578
  494293
  517614
  517880
  525182
  538538
  539881
  521601
  536978
  537233
  540753
]
2.65 ms
(1.38%)
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
  2926
  80230
  133294
  150124
  153440
  187590
  204124
  300984
  329296
  384106
  384416
  385751
  389711
  395434
  405854
  413805
  416299
  422810
  425846
  434664
  449478
  452288
  453677
  454114
  455389
  455997
  457157
  483749
  485168
  486822
  493578
  494293
  505283
  505904
  507395
  517614
  517880
  520230
  521601
  524187
  525182
  531806
  532185
  536978
  537233
  537581
  537858
  538538
  539392
  539622
  539881
  540137
  540753
  544336
  547097
  547216
  549818
  551734
  556359
  556858
  558010
  558384
  560012
  565835
  565967
  567874
  568032
  570229
  570333
  574423
  581059
  584031
  586834
  589309
  591863
  591914
  592285
  594220
  595121
  595229
  596056
  599754
  602068
  602769
  602976
  611031
  618942
  651205
  651917
  654749
  654784
  655950
  656958
  656988
  658419
  658715
  659601
  660328
  661270
  663937
  665247
  666810
  667270
  667998
  688880
  688979
  698249
  703248
  741273
  754582
  775420
  775442
  782972
  783129
  783139
  790194
  795917
  796004
  813795
  813796
]
2.29 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хорошо скачет"
]
1.83 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скачет"
]
1.73 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.85%)
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.