Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.37 ms
(84.00%)
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
  7161
  11870
  12132
  95986
  96636
  268222
  326039
  360439
  375949
  385830
  386035
  387015
  387922
  388057
  388512
  388532
  389797
  390904
  391237
  392373
  395598
  397350
  398409
  400032
  400821
  400858
  401266
  402735
  405699
  424136
  426551
  429741
  439343
  445466
  446165
  446274
  447588
  456220
  461628
  476193
  509799
  509805
  515588
  515611
  519697
  520952
  521166
  522160
  533972
  534395
  541270
  541721
  541864
  541871
  559372
  562003
  580592
  592409
  596917
  600796
  601789
  603830
  604307
  605344
  612699
  617807
  620165
  630420
  634100
  639722
  644285
  644306
  669074
  670366
  674327
  678734
  681280
  683139
  689001
  703900
  711907
  717906
  720714
  724135
  724272
  727760
  727837
  728152
  728424
  731463
  740890
  741158
  742315
  744990
  745188
  750760
  751512
  751773
  758232
  764811
  767217
  770183
  777017
  777043
  777059
  780659
  782477
  788178
  789664
  790381
  794647
  795140
  798572
  802114
  803919
  814428
  817154
  817884
  819609
  820890
]
13.79 ms
(9.39%)
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
  390904
  426551
  11870
  782477
  728152
  740890
  764811
  798572
  541721
  388532
  541270
  795140
  617807
  268222
  817884
  727837
  803919
  387922
  391237
  820890
  674327
  580592
  777059
  794647
  728424
  744990
  750760
  724135
  767217
  720714
  644285
  742315
  789664
  400032
  446274
  758232
  387015
  790381
  522160
  634100
  817154
  819609
  780659
  541864
  604307
  375949
  600796
  389797
  400821
  534395
  788178
  751773
  395598
  326039
  559372
  681280
  596917
  727760
  745188
  731463
  388512
  400858
  814428
  770183
  777017
  388057
  402735
  424136
  7161
  639722
  717906
  802114
  711907
  541871
  461628
  398409
  703900
  439343
  724272
  515611
  447588
  405699
  392373
  12132
  96636
  445466
  603830
  670366
  385830
  533972
  601789
  401266
  678734
  683139
  605344
  777043
  751512
  644306
  397350
  515588
  612699
  476193
  95986
  521166
  620165
  429741
  592409
  456220
  669074
  630420
  741158
  446165
  509799
  519697
  360439
  386035
  562003
  689001
  520952
  509805
]
2.95 ms
(2.01%)
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
  7161
  11870
  12132
  95986
  96636
  268222
  326039
  360439
  375949
  385830
  386035
  387015
  387922
  388057
  388512
  388532
  389797
  390904
  391237
  392373
  395598
  397350
  398409
  400032
  400821
  400858
  401266
  402735
  405699
  424136
  426551
  429741
  439343
  445466
  446165
  446274
  447588
  456220
  461628
  476193
  509799
  509805
  515588
  515611
  519697
  520952
  521166
  522160
  533972
  534395
  541270
  541721
  541864
  541871
  559372
  562003
  580592
  592409
  596917
  600796
  601789
  603830
  604307
  605344
  612699
  617807
  620165
  630420
  634100
  639722
  644285
  644306
  669074
  670366
  674327
  678734
  681280
  683139
  689001
  703900
  711907
  717906
  720714
  724135
  724272
  727760
  727837
  728152
  728424
  731463
  740890
  741158
  742315
  744990
  745188
  750760
  751512
  751773
  758232
  764811
  767217
  770183
  777017
  777043
  777059
  780659
  782477
  788178
  789664
  790381
  794647
  795140
  798572
  802114
  803919
  814428
  817154
  817884
  819609
  820890
]
1.84 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal stockings"
]
1.81 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал чулк нижн бел"
]
1.46 ms
(1.00%)
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.