Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.93 ms
(84.18%)
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
  2808
  37980
  72285
  159865
  185208
  185335
  188028
  190204
  233335
  325253
  382840
  385934
  386264
  386449
  387539
  391125
  397641
  398012
  398656
  398874
  400409
  401646
  401790
  402164
  403478
  403862
  404024
  405744
  407141
  407165
  408705
  409349
  409353
  411009
  413316
  414248
  415529
  415633
  417559
  418497
  418708
  421567
  425420
  426633
  426635
  426782
  427204
  428938
  429494
  430553
  431568
  432200
  432467
  434674
  434877
  434886
  437178
  438682
  439470
  440681
  440918
  441424
  441750
  443144
  443186
  444474
  444512
  444619
  444649
  445033
  445227
  446893
  448702
  449283
  452197
  452934
  453487
  455796
  456725
  459842
  460652
  461069
  461285
  461935
  463236
  464029
  464291
  464655
  464991
  465591
  468446
  468785
  469400
  477085
  477308
  477550
  479883
  480272
  483990
  485991
  487246
  489671
  490789
  491038
  493007
  502328
  505651
  506062
  523690
  525368
  537999
  546649
  547389
  548719
  550442
  565792
  570373
  585692
  789623
  811473
]
17.48 ms
(9.44%)
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
  405744
  428938
  429494
  415529
  432467
  444512
  407141
  407165
  408705
  438682
  444474
  443144
  413316
  432200
  441750
  459842
  452934
  448702
  452197
  460652
  469400
  506062
  477308
  546649
  547389
  565792
  570373
  585692
  789623
  811473
  159865
  185335
  382840
  398012
  426782
  464029
  468785
  37980
  398874
  400409
  418708
  425420
  437178
  463236
  465591
  403478
  427204
  2808
  190204
  233335
  414248
  434886
  444649
  445033
  449283
  453487
  461935
  464991
  479883
  523690
  525368
  483990
  487246
  489671
  493007
  505651
  490789
  485991
  491038
  550442
  548719
  468446
  430553
  537999
  502328
  386449
  385934
  386264
  188028
  185208
  325253
  72285
  387539
  391125
  397641
  398656
  402164
  401790
  401646
  403862
  404024
  418497
  426635
  431568
  434674
  434877
  439470
  441424
  409353
  440681
  411009
  415633
  443186
  417559
  440918
  444619
  445227
  409349
  421567
  426633
  446893
  455796
  456725
  461069
  461285
  464291
  464655
  477085
  477550
  480272
]
3.46 ms
(1.87%)
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
  2808
  37980
  72285
  159865
  185208
  185335
  188028
  190204
  233335
  325253
  382840
  385934
  386264
  386449
  387539
  391125
  397641
  398012
  398656
  398874
  400409
  401646
  401790
  402164
  403478
  403862
  404024
  405744
  407141
  407165
  408705
  409349
  409353
  411009
  413316
  414248
  415529
  415633
  417559
  418497
  418708
  421567
  425420
  426633
  426635
  426782
  427204
  428938
  429494
  430553
  431568
  432200
  432467
  434674
  434877
  434886
  437178
  438682
  439470
  440681
  440918
  441424
  441750
  443144
  443186
  444474
  444512
  444619
  444649
  445033
  445227
  446893
  448702
  449283
  452197
  452934
  453487
  455796
  456725
  459842
  460652
  461069
  461285
  461935
  463236
  464029
  464291
  464655
  464991
  465591
  468446
  468785
  469400
  477085
  477308
  477550
  479883
  480272
  483990
  485991
  487246
  489671
  490789
  491038
  493007
  502328
  505651
  506062
  523690
  525368
  537999
  546649
  547389
  548719
  550442
  565792
  570373
  585692
  789623
  811473
]
2.85 ms
(1.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "легл"
]
1.97 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "легла"
]
1.91 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "легл"
]
1.62 ms
(0.88%)
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.