Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.12 ms
(85.49%)
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
  233488
  383987
  420267
  429762
  429898
  430081
  430357
  430504
  431962
  432131
  442398
  442830
  443103
  443636
  446633
  447803
  447851
  448034
  448987
  451804
  456690
  460412
  463764
  464623
  467613
  468433
  470527
  471165
  472784
  475194
  477339
  477470
  477554
  478832
  483536
  484636
  484818
  485597
  486685
  486706
  487746
  491473
  491664
  492273
  494276
  495397
  497866
  505398
  506195
  507241
  508156
  509810
  509879
  512447
  512538
  513155
  515329
  516141
  516752
  516763
  516765
  516769
  516776
  517033
  517464
  517847
  518003
  518206
  518558
  519108
  519572
  519985
  520037
  521738
  522130
  522871
  523567
  524948
  528791
  529855
  530053
  530487
  532912
  533844
  534334
  537584
  537595
  543868
  545785
  550093
  550097
  556774
  557941
  558601
  561136
  561140
  561142
  561814
  566135
  567347
  572005
  576219
  583670
  583722
  593863
  605636
  610692
  610786
  621962
  624290
  640770
  644691
  649542
  650380
  652263
  688369
  724823
  766146
  789862
  815275
]
17.61 ms
(9.34%)
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
  518003
  491664
  383987
  431962
  815275
  483536
  519108
  522130
  515329
  517464
  532912
  477470
  550093
  566135
  610692
  766146
  451804
  429898
  507241
  516141
  523567
  430504
  429762
  447851
  494276
  516776
  460412
  556774
  561142
  557941
  583722
  448034
  448987
  561140
  621962
  644691
  470527
  446633
  430357
  513155
  442830
  432131
  509879
  522871
  572005
  517033
  789862
  463764
  495397
  512447
  567347
  471165
  650380
  558601
  610786
  233488
  520037
  652263
  420267
  516763
  576219
  528791
  530053
  467613
  724823
  468433
  475194
  486706
  497866
  492273
  524948
  516765
  550097
  583670
  624290
  593863
  605636
  472784
  430081
  505398
  443103
  477554
  519985
  506195
  517847
  530487
  533844
  688369
  561814
  640770
  447803
  518206
  477339
  464623
  529855
  516752
  521738
  545785
  561136
  484636
  484818
  508156
  443636
  534334
  537595
  518558
  478832
  485597
  512538
  649542
  487746
  516769
  543868
  456690
  537584
  509810
  491473
  442398
  486685
  519572
]
2.96 ms
(1.57%)
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
  233488
  383987
  420267
  429762
  429898
  430081
  430357
  430504
  431962
  432131
  442398
  442830
  443103
  443636
  446633
  447803
  447851
  448034
  448987
  451804
  456690
  460412
  463764
  464623
  467613
  468433
  470527
  471165
  472784
  475194
  477339
  477470
  477554
  478832
  483536
  484636
  484818
  485597
  486685
  486706
  487746
  491473
  491664
  492273
  494276
  495397
  497866
  505398
  506195
  507241
  508156
  509810
  509879
  512447
  512538
  513155
  515329
  516141
  516752
  516763
  516765
  516769
  516776
  517033
  517464
  517847
  518003
  518206
  518558
  519108
  519572
  519985
  520037
  521738
  522130
  522871
  523567
  524948
  528791
  529855
  530053
  530487
  532912
  533844
  534334
  537584
  537595
  543868
  545785
  550093
  550097
  556774
  557941
  558601
  561136
  561140
  561142
  561814
  566135
  567347
  572005
  576219
  583670
  583722
  593863
  605636
  610692
  610786
  621962
  624290
  640770
  644691
  649542
  650380
  652263
  688369
  724823
  766146
  789862
  815275
]
1.93 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome bdsm"
]
1.77 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро бдсм"
]
1.33 ms
(0.70%)
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.