Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.79 ms
(85.08%)
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
  32937
  68383
  123416
  185464
  187856
  188028
  278472
  310679
  314496
  337134
  358857
  365314
  380426
  381757
  382812
  385357
  389500
  389785
  394780
  395450
  396181
  396275
  397851
  398917
  398995
  402257
  405045
  406501
  411688
  416181
  422525
  422543
  422578
  422631
  423007
  423263
  423301
  423401
  424427
  425884
  426718
  428018
  428500
  431969
  432685
  434045
  434673
  435000
  435662
  441022
  442781
  443793
  444243
  446977
  452727
  452828
  460280
  460398
  462192
  463762
  463815
  467394
  467445
  467496
  470954
  471505
  473965
  474645
  476838
  477444
  484309
  487027
  490942
  492153
  496269
  498128
  499147
  500236
  504850
  516470
  518349
  518873
  519725
  520002
  520803
  523741
  523803
  527465
  534178
  538848
  544150
  545518
  547930
  557802
  561880
  563066
  563196
  581349
  587052
  597575
  597585
  600074
  601312
  601444
  614621
  617004
  624851
  651313
  667510
  668189
  714938
  726962
  727898
  731379
  741248
  741484
  788739
  789233
  798901
  807638
]
12.79 ms
(8.20%)
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
  557802
  624851
  789233
  741484
  365314
  500236
  423301
  727898
  405045
  402257
  487027
  597575
  617004
  527465
  520803
  538848
  581349
  600074
  601312
  463815
  496269
  523741
  463762
  544150
  411688
  423401
  185464
  492153
  422631
  423007
  474645
  504850
  523803
  545518
  423263
  428018
  432685
  422543
  534178
  518873
  446977
  518349
  385357
  188028
  394780
  395450
  381757
  278472
  435662
  477444
  668189
  587052
  597585
  798901
  788739
  726962
  731379
  741248
  314496
  460280
  460398
  444243
  389785
  426718
  462192
  484309
  498128
  68383
  382812
  396275
  428500
  434673
  422578
  434045
  561880
  601444
  396181
  442781
  443793
  467496
  424427
  435000
  467445
  516470
  490942
  499147
  519725
  389500
  406501
  452828
  614621
  441022
  520002
  187856
  380426
  310679
  337134
  358857
  425884
  651313
  667510
  476838
  123416
  32937
  398917
  398995
  807638
  397851
  473965
  416181
  431969
  422525
  452727
  467394
  470954
  471505
  563066
  563196
  547930
  714938
]
2.86 ms
(1.83%)
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
  32937
  68383
  123416
  185464
  187856
  188028
  278472
  310679
  314496
  337134
  358857
  365314
  380426
  381757
  382812
  385357
  389500
  389785
  394780
  395450
  396181
  396275
  397851
  398917
  398995
  402257
  405045
  406501
  411688
  416181
  422525
  422543
  422578
  422631
  423007
  423263
  423301
  423401
  424427
  425884
  426718
  428018
  428500
  431969
  432685
  434045
  434673
  435000
  435662
  441022
  442781
  443793
  444243
  446977
  452727
  452828
  460280
  460398
  462192
  463762
  463815
  467394
  467445
  467496
  470954
  471505
  473965
  474645
  476838
  477444
  484309
  487027
  490942
  492153
  496269
  498128
  499147
  500236
  504850
  516470
  518349
  518873
  519725
  520002
  520803
  523741
  523803
  527465
  534178
  538848
  544150
  545518
  547930
  557802
  561880
  563066
  563196
  581349
  587052
  597575
  597585
  600074
  601312
  601444
  614621
  617004
  624851
  651313
  667510
  668189
  714938
  726962
  727898
  731379
  741248
  741484
  788739
  789233
  798901
  807638
]
2.21 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мужики трахают парня"
]
1.86 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин секс парен"
]
1.79 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мужчин секс парен"
]
1.78 ms
(1.14%)
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.