Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.90 ms
(86.34%)
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
  228737
  359723
  398783
  401973
  408905
  413227
  414229
  414924
  415107
  415311
  416455
  417471
  420900
  421390
  422231
  422256
  426376
  427045
  427367
  427517
  428093
  428303
  429117
  429707
  433879
  437918
  441936
  444193
  444232
  444614
  445671
  445855
  446233
  447020
  448011
  452220
  452853
  453604
  453829
  455423
  457134
  457979
  458408
  458743
  459282
  459323
  459431
  460883
  460956
  461085
  462102
  466361
  471920
  473751
  473951
  473991
  478112
  492086
  492347
  504711
  532628
  536720
  549087
  552145
  552184
  552186
  552187
  552239
  552905
  558327
  560103
  561630
  561660
  561689
  562280
  564419
  569868
  570037
  570041
  570507
  570571
  570637
  571196
  571264
  572098
  572501
  572801
  573855
  574886
  580829
  581964
  593157
  593903
  594615
  595859
  597065
  597156
  597976
  598145
  602113
  603278
  603428
  603712
  630823
  644666
  650267
  700711
  703369
  703379
  703506
  719040
  738537
  739780
  750571
  757112
  758239
  785492
  797087
  806894
  811632
]
12.54 ms
(8.15%)
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
  785492
  797087
  415311
  401973
  422256
  429117
  444193
  444232
  444614
  426376
  427045
  437918
  441936
  428303
  429707
  417471
  428093
  422231
  445855
  457134
  459282
  459431
  492086
  492347
  445671
  448011
  462102
  473751
  458408
  459323
  504711
  532628
  536720
  466361
  549087
  552184
  560103
  564419
  570571
  571264
  580829
  552187
  552905
  558327
  570637
  572801
  581964
  552145
  552186
  561660
  562280
  569868
  570037
  570507
  571196
  572098
  719040
  650267
  703369
  703506
  700711
  552239
  561630
  561689
  570041
  572501
  573855
  574886
  593157
  598145
  594615
  595859
  630823
  597156
  597976
  602113
  603278
  593903
  597065
  811632
  806894
  739780
  757112
  738537
  758239
  750571
  603428
  603712
  644666
  703379
  413227
  473951
  433879
  446233
  453829
  455423
  460883
  478112
  359723
  414229
  416455
  420900
  427367
  452853
  460956
  461085
  473991
  228737
  398783
  408905
  421390
  427517
  452220
  457979
  471920
  414924
  415107
  447020
  453604
  458743
]
2.16 ms
(1.40%)
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
  228737
  359723
  398783
  401973
  408905
  413227
  414229
  414924
  415107
  415311
  416455
  417471
  420900
  421390
  422231
  422256
  426376
  427045
  427367
  427517
  428093
  428303
  429117
  429707
  433879
  437918
  441936
  444193
  444232
  444614
  445671
  445855
  446233
  447020
  448011
  452220
  452853
  453604
  453829
  455423
  457134
  457979
  458408
  458743
  459282
  459323
  459431
  460883
  460956
  461085
  462102
  466361
  471920
  473751
  473951
  473991
  478112
  492086
  492347
  504711
  532628
  536720
  549087
  552145
  552184
  552186
  552187
  552239
  552905
  558327
  560103
  561630
  561660
  561689
  562280
  564419
  569868
  570037
  570041
  570507
  570571
  570637
  571196
  571264
  572098
  572501
  572801
  573855
  574886
  580829
  581964
  593157
  593903
  594615
  595859
  597065
  597156
  597976
  598145
  602113
  603278
  603428
  603712
  630823
  644666
  650267
  700711
  703369
  703379
  703506
  719040
  738537
  739780
  750571
  757112
  758239
  785492
  797087
  806894
  811632
]
1.75 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18-19"
]
1.56 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 19 лет"
]
1.53 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 19 лет"
]
1.51 ms
(0.98%)
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.