Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.45 ms
(86.79%)
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
  14105
  21221
  34342
  163135
  187443
  382295
  400951
  408894
  413929
  415126
  415610
  423732
  425359
  425506
  426522
  428356
  433380
  435326
  442336
  445641
  445881
  445908
  446017
  446600
  447699
  447702
  447916
  448552
  449717
  452286
  454179
  454444
  457762
  457782
  458427
  459316
  461271
  465717
  466059
  466469
  466827
  468909
  472544
  474644
  475595
  475731
  476312
  484236
  484781
  495863
  506302
  510619
  511570
  516605
  517652
  520984
  526536
  529525
  529780
  530144
  530922
  531791
  531867
  532827
  534624
  535145
  535885
  536009
  537352
  537604
  541737
  546623
  559744
  568765
  569345
  580914
  595508
  597633
  599733
  603330
  610101
  611795
  617816
  620330
  622950
  624171
  634713
  636071
  638947
  645623
  647076
  649507
  651637
  664221
  664593
  709865
  725206
  732939
  738043
  739174
  748593
  749883
  749929
  750828
  763545
  771205
  777997
  785263
  794223
  798131
  802597
  806944
  806966
  807048
  807134
  808499
  808810
  809284
  810471
  814970
]
14.31 ms
(7.84%)
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
  664593
  415126
  415610
  445908
  457782
  510619
  423732
  428356
  461271
  442336
  382295
  400951
  580914
  516605
  725206
  454444
  458427
  466059
  546623
  433380
  474644
  454179
  472544
  459316
  448552
  526536
  475595
  446600
  449717
  447916
  435326
  452286
  620330
  457762
  445881
  520984
  413929
  624171
  445641
  517652
  21221
  531867
  651637
  426522
  569345
  664221
  808499
  810471
  806944
  532827
  806966
  777997
  732939
  749883
  645623
  595508
  748593
  802597
  534624
  763545
  709865
  495863
  537604
  807134
  530922
  798131
  163135
  14105
  447699
  750828
  529525
  739174
  476312
  617816
  465717
  771205
  638947
  636071
  187443
  749929
  425506
  785263
  506302
  535145
  597633
  611795
  808810
  511570
  634713
  814970
  536009
  647076
  807048
  809284
  408894
  559744
  425359
  794223
  537352
  603330
  34342
  529780
  568765
  541737
  622950
  475731
  535885
  484236
  738043
  530144
  531791
  468909
  649507
  599733
  610101
  484781
  447702
  446017
  466827
  466469
]
2.99 ms
(1.64%)
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
  14105
  21221
  34342
  163135
  187443
  382295
  400951
  408894
  413929
  415126
  415610
  423732
  425359
  425506
  426522
  428356
  433380
  435326
  442336
  445641
  445881
  445908
  446017
  446600
  447699
  447702
  447916
  448552
  449717
  452286
  454179
  454444
  457762
  457782
  458427
  459316
  461271
  465717
  466059
  466469
  466827
  468909
  472544
  474644
  475595
  475731
  476312
  484236
  484781
  495863
  506302
  510619
  511570
  516605
  517652
  520984
  526536
  529525
  529780
  530144
  530922
  531791
  531867
  532827
  534624
  535145
  535885
  536009
  537352
  537604
  541737
  546623
  559744
  568765
  569345
  580914
  595508
  597633
  599733
  603330
  610101
  611795
  617816
  620330
  622950
  624171
  634713
  636071
  638947
  645623
  647076
  649507
  651637
  664221
  664593
  709865
  725206
  732939
  738043
  739174
  748593
  749883
  749929
  750828
  763545
  771205
  777997
  785263
  794223
  798131
  802597
  806944
  806966
  807048
  807134
  808499
  808810
  809284
  810471
  814970
]
1.88 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трясет сиськи"
]
1.72 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трясет сиськ"
]
1.55 ms
(0.85%)
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.