Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.63 ms
(82.85%)
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
  21323
  25461
  100665
  107651
  134947
  169272
  191048
  312831
  381849
  383281
  383482
  385009
  386804
  390306
  411939
  415635
  418439
  425060
  427220
  433458
  433587
  438432
  439456
  441838
  442101
  446107
  448466
  451513
  452757
  453244
  454388
  454476
  455991
  458320
  458358
  458362
  458625
  458737
  458896
  459199
  460680
  460685
  463978
  464985
  466892
  468953
  471186
  488980
  488982
  488993
  490499
  503988
  506863
  507090
  509290
  515356
  519342
  520227
  522331
  525307
  529437
  532634
  536585
  547632
  554770
  562644
  575234
  582440
  630760
  640350
  663427
  663898
  663912
  663926
  664322
  664801
  667536
  667756
  668875
  669771
  716862
  725633
  726078
  728442
  735893
  747197
  758170
  770125
  772681
  775140
  776442
  777010
  781783
  781823
  781824
  781853
  781862
  781885
  781892
  781912
  781922
  782396
  782411
  794622
  794796
  803476
  805265
  807757
  807763
  808752
  810021
  812081
  812943
  813808
  814037
  814289
  824965
  828035
  828142
  828598
]
22.67 ms
(11.69%)
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
  781862
  803476
  810021
  781823
  781824
  812081
  726078
  781922
  381849
  107651
  312831
  507090
  169272
  191048
  418439
  458358
  452757
  459199
  525307
  515356
  460680
  468953
  663427
  663926
  488980
  519342
  805265
  554770
  464985
  451513
  506863
  509290
  824965
  383281
  385009
  383482
  134947
  21323
  25461
  390306
  433587
  441838
  442101
  427220
  438432
  411939
  814289
  813808
  814037
  446107
  453244
  454476
  455991
  458362
  460685
  463978
  448466
  488982
  454388
  458320
  458625
  458737
  466892
  520227
  503988
  532634
  536585
  488993
  582440
  663898
  664801
  669771
  663912
  664322
  667756
  716862
  667536
  668875
  547632
  575234
  640350
  630760
  781783
  775140
  781885
  781912
  782396
  794622
  807763
  808752
  725633
  772681
  781892
  794796
  807757
  758170
  770125
  728442
  735893
  776442
  777010
  781853
  782411
  812943
  100665
  439456
  471186
  386804
  433458
  458896
  415635
  425060
  522331
  529437
  490499
  562644
  828035
  828142
  828598
  747197
]
3.68 ms
(1.90%)
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
  21323
  25461
  100665
  107651
  134947
  169272
  191048
  312831
  381849
  383281
  383482
  385009
  386804
  390306
  411939
  415635
  418439
  425060
  427220
  433458
  433587
  438432
  439456
  441838
  442101
  446107
  448466
  451513
  452757
  453244
  454388
  454476
  455991
  458320
  458358
  458362
  458625
  458737
  458896
  459199
  460680
  460685
  463978
  464985
  466892
  468953
  471186
  488980
  488982
  488993
  490499
  503988
  506863
  507090
  509290
  515356
  519342
  520227
  522331
  525307
  529437
  532634
  536585
  547632
  554770
  562644
  575234
  582440
  630760
  640350
  663427
  663898
  663912
  663926
  664322
  664801
  667536
  667756
  668875
  669771
  716862
  725633
  726078
  728442
  735893
  747197
  758170
  770125
  772681
  775140
  776442
  777010
  781783
  781823
  781824
  781853
  781862
  781885
  781892
  781912
  781922
  782396
  782411
  794622
  794796
  803476
  805265
  807757
  807763
  808752
  810021
  812081
  812943
  813808
  814037
  814289
  824965
  828035
  828142
  828598
]
1.89 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная татуированные"
]
1.75 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "толстушки с тату"
]
1.64 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "полная татуированные"
]
1.61 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.