Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.46 ms
(55.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "игрушк дилд"
]
136.95 ms
(36.36%)
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
  31492
  96259
  113794
  154187
  155144
  272725
  382141
  382294
  384336
  386798
  386896
  388460
  390670
  398302
  401126
  401793
  402626
  410346
  410690
  413432
  414132
  414269
  415874
  415958
  416000
  416508
  416561
  416596
  416624
  416626
  416681
  416701
  416703
  416746
  416751
  417967
  418817
  419200
  420174
  423933
  425294
  425895
  426283
  426301
  427722
  430366
  431385
  432299
  434376
  434497
  434849
  438940
  441049
  441355
  443255
  444531
  444535
  444548
  446026
  447575
  448257
  452948
  453470
  454384
  454695
  455078
  457486
  458109
  460351
  463693
  465651
  467052
  468680
  469096
  469741
  470838
  476164
  476663
  477759
  478523
  479544
  483315
  483705
  483762
  485546
  495211
  495737
  495751
  498483
  500339
  500787
  505798
  513221
  513842
  514867
  516527
  522264
  532856
  534953
  555119
  556885
  559784
  560337
  561072
  565707
  571091
  572774
  601071
  613326
  650246
  658796
  695887
  740409
  754776
  785966
  786876
  788598
  794312
  808611
  827967
]
21.16 ms
(5.62%)
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
  398302
  444535
  415874
  468680
  438940
  423933
  457486
  469741
  452948
  532856
  513221
  534953
  500787
  695887
  601071
  740409
  425294
  425895
  470838
  388460
  416681
  444548
  430366
  447575
  113794
  155144
  788598
  386798
  402626
  416624
  416561
  416703
  441355
  444531
  410690
  483705
  477759
  514867
  476164
  479544
  559784
  555119
  556885
  382141
  410346
  416508
  426301
  455078
  465651
  498483
  483315
  485546
  522264
  560337
  96259
  272725
  416751
  446026
  495751
  384336
  827967
  31492
  453470
  794312
  154187
  413432
  416000
  434376
  426283
  448257
  401793
  434849
  516527
  414269
  417967
  415958
  416746
  427722
  414132
  420174
  476663
  495737
  469096
  483762
  658796
  613326
  786876
  467052
  386896
  416701
  434497
  460351
  401126
  418817
  454384
  463693
  500339
  513842
  505798
  390670
  458109
  495211
  454695
  478523
  572774
  565707
  754776
  382294
  571091
  561072
  650246
  808611
  785966
  432299
  416596
  431385
  416626
  419200
  441049
  443255
]
3.42 ms
(0.91%)
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
  31492
  96259
  113794
  154187
  155144
  272725
  382141
  382294
  384336
  386798
  386896
  388460
  390670
  398302
  401126
  401793
  402626
  410346
  410690
  413432
  414132
  414269
  415874
  415958
  416000
  416508
  416561
  416596
  416624
  416626
  416681
  416701
  416703
  416746
  416751
  417967
  418817
  419200
  420174
  423933
  425294
  425895
  426283
  426301
  427722
  430366
  431385
  432299
  434376
  434497
  434849
  438940
  441049
  441355
  443255
  444531
  444535
  444548
  446026
  447575
  448257
  452948
  453470
  454384
  454695
  455078
  457486
  458109
  460351
  463693
  465651
  467052
  468680
  469096
  469741
  470838
  476164
  476663
  477759
  478523
  479544
  483315
  483705
  483762
  485546
  495211
  495737
  495751
  498483
  500339
  500787
  505798
  513221
  513842
  514867
  516527
  522264
  532856
  534953
  555119
  556885
  559784
  560337
  561072
  565707
  571091
  572774
  601071
  613326
  650246
  658796
  695887
  740409
  754776
  785966
  786876
  788598
  794312
  808611
  827967
]
2.03 ms
(0.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "игрушки дилдо"
]
1.75 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.