Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.45 ms
(83.03%)
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
  213
  3895
  29292
  29677
  35067
  41912
  50537
  53386
  79952
  105093
  109041
  112637
  146341
  176941
  182754
  184909
  198253
  205443
  336986
  351047
  365861
  382115
  382448
  383791
  384291
  384519
  384552
  385426
  385938
  386996
  387318
  387453
  387680
  389787
  390052
  391485
  395644
  396909
  396924
  397145
  397482
  398643
  398738
  398742
  400072
  400346
  402021
  402080
  402960
  403862
  404633
  405904
  407910
  408798
  408875
  409494
  409566
  413943
  414682
  415003
  415633
  416177
  416921
  417610
  418552
  418708
  419983
  420371
  421653
  422337
  422730
  425676
  427204
  431603
  434025
  434877
  438012
  438848
  441578
  441744
  444486
  444499
  444500
  444619
  445227
  446341
  453850
  453958
  454021
  457719
  458423
  458818
  459679
  460164
  461069
  465676
  466468
  471016
  471018
  472808
  478354
  479717
  480272
  483779
  485070
  485235
  487768
  489728
  490345
  491242
  492018
  492996
  493007
  493462
  493885
  506697
  506779
  596466
  618793
  813616
]
15.01 ms
(10.34%)
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
  416177
  453850
  457719
  458818
  29292
  213
  146341
  365861
  389787
  391485
  398742
  416921
  418708
  112637
  176941
  198253
  205443
  351047
  386996
  413943
  427204
  459679
  385938
  387318
  402960
  414682
  478354
  492018
  493007
  483779
  491242
  506697
  485070
  487768
  493462
  493885
  506779
  596466
  618793
  385426
  383791
  384519
  384552
  384291
  105093
  109041
  182754
  184909
  395644
  336986
  382115
  382448
  79952
  35067
  41912
  53386
  50537
  29677
  3895
  387453
  387680
  390052
  396909
  396924
  397145
  397482
  398738
  400072
  400346
  398643
  402021
  402080
  404633
  403862
  405904
  407910
  415003
  417610
  418552
  434025
  434877
  441578
  408798
  408875
  420371
  422337
  425676
  438012
  444486
  415633
  441744
  444500
  409494
  409566
  421653
  422730
  431603
  438848
  444619
  445227
  419983
  444499
  813616
  453958
  461069
  466468
  471016
  472808
  480272
  490345
  446341
  454021
  458423
  460164
  465676
  471018
  479717
  485235
  489728
  492996
]
2.84 ms
(1.96%)
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
  213
  3895
  29292
  29677
  35067
  41912
  50537
  53386
  79952
  105093
  109041
  112637
  146341
  176941
  182754
  184909
  198253
  205443
  336986
  351047
  365861
  382115
  382448
  383791
  384291
  384519
  384552
  385426
  385938
  386996
  387318
  387453
  387680
  389787
  390052
  391485
  395644
  396909
  396924
  397145
  397482
  398643
  398738
  398742
  400072
  400346
  402021
  402080
  402960
  403862
  404633
  405904
  407910
  408798
  408875
  409494
  409566
  413943
  414682
  415003
  415633
  416177
  416921
  417610
  418552
  418708
  419983
  420371
  421653
  422337
  422730
  425676
  427204
  431603
  434025
  434877
  438012
  438848
  441578
  441744
  444486
  444499
  444500
  444619
  445227
  446341
  453850
  453958
  454021
  457719
  458423
  458818
  459679
  460164
  461069
  465676
  466468
  471016
  471018
  472808
  478354
  479717
  480272
  483779
  485070
  485235
  487768
  489728
  490345
  491242
  492018
  492996
  493007
  493462
  493885
  506697
  506779
  596466
  618793
  813616
]
2.12 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "теле"
]
1.65 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тел"
]
1.40 ms
(0.96%)
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.