Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.45 ms
(87.45%)
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
  412262
  418879
  419880
  424329
  424498
  425523
  426408
  429089
  430548
  432254
  437686
  438844
  439531
  441191
  442864
  442918
  443963
  444346
  446431
  446735
  446894
  447732
  448216
  454993
  461221
  462904
  465712
  467721
  469649
  470449
  473980
  475595
  478525
  482506
  482824
  483239
  483244
  484644
  485204
  486020
  490005
  492040
  492528
  492921
  496259
  498043
  500504
  504718
  504757
  504909
  505818
  506816
  507767
  509312
  512558
  513215
  513408
  513940
  514809
  516659
  517190
  517269
  519016
  519560
  521077
  523016
  523035
  523212
  523535
  528264
  528456
  543536
  546347
  554313
  561480
  563441
  567050
  568062
  568349
  570700
  578531
  586864
  587651
  587855
  591249
  591415
  591646
  601231
  603663
  608206
  609922
  611477
  613268
  616683
  617234
  620699
  621239
  621277
  622778
  624840
  625215
  627338
  628426
  645918
  646001
  654474
  671403
  700949
  794963
  810902
]
15.55 ms
(7.98%)
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
  442918
  447732
  438844
  492040
  492528
  492921
  486020
  500504
  587855
  620699
  570700
  483244
  568349
  603663
  617234
  443963
  523016
  424498
  516659
  528264
  509312
  490005
  506816
  523035
  654474
  429089
  454993
  513408
  586864
  627338
  794963
  810902
  439531
  478525
  432254
  442864
  470449
  513476
  496259
  505818
  613268
  484644
  519560
  517269
  578531
  624840
  418879
  448216
  504909
  517190
  523535
  483239
  554313
  513940
  482506
  528456
  591249
  446735
  519016
  462904
  543536
  482824
  430548
  437686
  426408
  412262
  504757
  461221
  700949
  646001
  591646
  473980
  475595
  507767
  521077
  441191
  485204
  444346
  513215
  611477
  425523
  609922
  467721
  504718
  419880
  424329
  446894
  591415
  601231
  512558
  561480
  563441
  622778
  671403
  446431
  469649
  523212
  645918
  546347
  616683
  625215
  587651
  621239
  608206
  498043
  514809
  568062
  465712
  621277
  567050
  628426
]
2.51 ms
(1.29%)
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
  412262
  418879
  419880
  424329
  424498
  425523
  426408
  429089
  430548
  432254
  437686
  438844
  439531
  441191
  442864
  442918
  443963
  444346
  446431
  446735
  446894
  447732
  448216
  454993
  461221
  462904
  465712
  467721
  469649
  470449
  473980
  475595
  478525
  482506
  482824
  483239
  483244
  484644
  485204
  486020
  490005
  492040
  492528
  492921
  496259
  498043
  500504
  504718
  504757
  504909
  505818
  506816
  507767
  509312
  512558
  513215
  513408
  513940
  514809
  516659
  517190
  517269
  519016
  519560
  521077
  523016
  523035
  523212
  523535
  528264
  528456
  543536
  546347
  554313
  561480
  563441
  567050
  568062
  568349
  570700
  578531
  586864
  587651
  587855
  591249
  591415
  591646
  601231
  603663
  608206
  609922
  611477
  613268
  616683
  617234
  620699
  621239
  621277
  622778
  624840
  625215
  627338
  628426
  645918
  646001
  654474
  671403
  700949
  794963
  810902
]
1.74 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк парен friend"
]
1.62 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl boy friend"
]
1.37 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк парен friend"
]

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.