Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.46 ms
(82.83%)
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
  30967
  36844
  46870
  58313
  58554
  72305
  79524
  86926
  114536
  146341
  147173
  185873
  197574
  201885
  234200
  304761
  308297
  329296
  381767
  382439
  382488
  382854
  383139
  384541
  386097
  386449
  386828
  388144
  389304
  390163
  390445
  391216
  392436
  392584
  396476
  397416
  398504
  398771
  398982
  400955
  401386
  401641
  401727
  402045
  404021
  404072
  405845
  406986
  410008
  410079
  412158
  414711
  417034
  418497
  421154
  421408
  422293
  426234
  427087
  428623
  432370
  432425
  432481
  432871
  432897
  433480
  433822
  434899
  441241
  444057
  445511
  446352
  446527
  447461
  452288
  453706
  455389
  456978
  457205
  457671
  459843
  460487
  460553
  460971
  461463
  461916
  462248
  467659
  468808
  474164
  475339
  477793
  478183
  478984
  481701
  483669
  483724
  486582
  486684
  486848
  490151
  491213
  505165
  508131
  509395
  509772
  510634
  511395
  538233
  561304
  570571
  623727
  652587
  655725
  712201
  726539
  781687
  781758
  791054
  802155
]
15.61 ms
(9.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
  538233
  561304
  509395
  382488
  453706
  86926
  58313
  447461
  201885
  432871
  623727
  398504
  412158
  712201
  781758
  791054
  392584
  185873
  455389
  329296
  483669
  404072
  405845
  432425
  456978
  402045
  655725
  382439
  391216
  457671
  432370
  390163
  432897
  386828
  382854
  400955
  414711
  460971
  781687
  58554
  401727
  384541
  406986
  508131
  486582
  197574
  460553
  421408
  510634
  460487
  72305
  30967
  46870
  389304
  390445
  398982
  418497
  434899
  457205
  490151
  478183
  478984
  459843
  726539
  401386
  114536
  467659
  475339
  477793
  481701
  652587
  427087
  410008
  509772
  392436
  401641
  444057
  79524
  426234
  398771
  441241
  36844
  505165
  446527
  511395
  147173
  308297
  397416
  404021
  410079
  432481
  381767
  422293
  452288
  802155
  146341
  234200
  396476
  421154
  570571
  433480
  388144
  417034
  445511
  486684
  462248
  474164
  486848
  483724
  383139
  433822
  446352
  468808
  461463
  461916
  428623
  491213
  386097
  386449
  304761
]
5.19 ms
(3.22%)
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
  30967
  36844
  46870
  58313
  58554
  72305
  79524
  86926
  114536
  146341
  147173
  185873
  197574
  201885
  234200
  304761
  308297
  329296
  381767
  382439
  382488
  382854
  383139
  384541
  386097
  386449
  386828
  388144
  389304
  390163
  390445
  391216
  392436
  392584
  396476
  397416
  398504
  398771
  398982
  400955
  401386
  401641
  401727
  402045
  404021
  404072
  405845
  406986
  410008
  410079
  412158
  414711
  417034
  418497
  421154
  421408
  422293
  426234
  427087
  428623
  432370
  432425
  432481
  432871
  432897
  433480
  433822
  434899
  441241
  444057
  445511
  446352
  446527
  447461
  452288
  453706
  455389
  456978
  457205
  457671
  459843
  460487
  460553
  460971
  461463
  461916
  462248
  467659
  468808
  474164
  475339
  477793
  478183
  478984
  481701
  483669
  483724
  486582
  486684
  486848
  490151
  491213
  505165
  508131
  509395
  509772
  510634
  511395
  538233
  561304
  570571
  623727
  652587
  655725
  712201
  726539
  781687
  781758
  791054
  802155
]
1.82 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член парен мужскойрод"
]
1.81 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "член ухажера"
]
1.74 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.93%)
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.