Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.61 ms
(82.15%)
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
  383248
  411515
  411868
  418865
  423804
  427388
  433558
  453301
  454288
  455125
  455958
  457179
  458488
  460559
  463104
  465563
  468832
  470804
  479354
  480667
  482340
  483286
  483435
  496422
  497025
  505502
  513552
  517371
  518424
  518816
  520940
  523157
  526446
  541130
  542071
  542628
  552719
  555095
  556199
  557433
  560523
  560961
  562732
  564843
  565657
  566651
  569401
  571072
  579454
  579873
  581246
  583328
  585225
  585326
  586220
  586245
  586248
  586266
  586274
  586294
  586327
  587014
  589617
  589664
  589811
  591724
  595601
  599360
  603882
  604343
  613606
  613630
  615936
  617363
  618752
  623328
  623488
  625175
  625578
  625863
  629446
  630445
  630955
  635007
  638894
  643929
  644192
  661896
  661931
  669213
  670246
  671650
  689172
  691414
  692127
  697416
  698082
  715972
  718556
  721280
  721867
  721935
  722341
  724292
  730947
  736736
  740157
  752790
  755627
  756270
  757724
  758114
  758232
  761699
  779913
  782232
  788377
  795226
  804894
  825949
]
17.31 ms
(11.23%)
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
  618752
  721280
  433558
  505502
  518816
  453301
  455958
  758232
  411868
  427388
  455125
  497025
  383248
  454288
  457179
  566651
  542628
  569401
  579454
  589664
  757724
  755627
  613606
  480667
  418865
  465563
  470804
  483286
  483435
  460559
  468832
  520940
  523157
  526446
  496422
  517371
  560523
  669213
  715972
  586274
  643929
  782232
  623488
  463104
  479354
  482340
  513552
  518424
  825949
  542071
  565657
  581246
  583328
  557433
  562732
  571072
  541130
  552719
  555095
  556199
  564843
  670246
  691414
  698082
  721935
  661896
  689172
  692127
  718556
  722341
  661931
  671650
  697416
  721867
  560961
  579873
  586220
  586245
  586294
  589811
  595601
  604343
  615936
  617363
  625863
  629446
  586266
  589617
  599360
  630445
  644192
  585225
  585326
  586248
  586327
  587014
  591724
  623328
  625175
  635007
  613630
  625578
  638894
  779913
  804894
  788377
  795226
  756270
  736736
  724292
  740157
  752790
  730947
  758114
  761699
  603882
  630955
  458488
  411515
  423804
]
3.01 ms
(1.95%)
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
  383248
  411515
  411868
  418865
  423804
  427388
  433558
  453301
  454288
  455125
  455958
  457179
  458488
  460559
  463104
  465563
  468832
  470804
  479354
  480667
  482340
  483286
  483435
  496422
  497025
  505502
  513552
  517371
  518424
  518816
  520940
  523157
  526446
  541130
  542071
  542628
  552719
  555095
  556199
  557433
  560523
  560961
  562732
  564843
  565657
  566651
  569401
  571072
  579454
  579873
  581246
  583328
  585225
  585326
  586220
  586245
  586248
  586266
  586274
  586294
  586327
  587014
  589617
  589664
  589811
  591724
  595601
  599360
  603882
  604343
  613606
  613630
  615936
  617363
  618752
  623328
  623488
  625175
  625578
  625863
  629446
  630445
  630955
  635007
  638894
  643929
  644192
  661896
  661931
  669213
  670246
  671650
  689172
  691414
  692127
  697416
  698082
  715972
  718556
  721280
  721867
  721935
  722341
  724292
  730947
  736736
  740157
  752790
  755627
  756270
  757724
  758114
  758232
  761699
  779913
  782232
  788377
  795226
  804894
  825949
]
2.07 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big neighbor"
]
1.87 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие neighbor"
]
1.49 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие neighbor"
]

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.