Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.44 ms
(82.82%)
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
  388401
  389980
  398307
  418808
  443120
  446873
  447686
  451741
  459437
  460770
  473914
  473931
  477734
  478489
  484434
  488700
  491736
  496087
  511739
  512295
  526463
  527630
  535465
  539278
  543548
  545711
  552145
  552176
  552228
  556911
  561730
  561813
  563647
  565162
  565274
  565953
  566031
  573577
  573839
  574502
  574585
  574841
  575131
  575162
  575484
  576407
  576412
  580236
  587858
  590821
  591349
  591841
  594381
  595359
  596459
  596583
  597233
  597566
  597828
  598554
  598796
  600167
  603584
  623203
  629029
  635742
  640806
  644674
  649166
  652591
  652605
  652882
  655096
  656684
  659412
  659836
  660562
  661270
  662833
  672677
  675037
  678897
  699026
  699587
  700176
  702432
  703280
  712731
  714449
  715652
  718934
  721264
  723487
  724727
  727824
  730678
  731893
  735957
  742144
  743157
  743221
  747576
  751750
  753031
  753307
  753339
  753395
  753418
  753854
  754182
  760919
  785772
  793893
  798784
  810280
  810841
  819198
  827324
  828324
  828626
]
22.46 ms
(12.05%)
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
  699026
  731893
  512295
  623203
  828324
  702432
  828626
  659836
  721264
  723487
  649166
  652591
  655096
  656684
  660562
  661270
  675037
  678897
  712731
  573839
  594381
  597828
  629029
  810280
  810841
  724727
  730678
  751750
  743157
  715652
  798784
  662833
  819198
  652605
  652882
  718934
  700176
  703280
  699587
  591841
  598796
  793893
  785772
  747576
  753031
  753307
  735957
  742144
  753854
  754182
  760919
  753339
  753395
  753418
  727824
  388401
  539278
  556911
  561813
  565953
  566031
  574841
  561730
  565274
  575131
  575162
  580236
  659412
  587858
  603584
  597566
  590821
  591349
  596583
  597233
  600167
  595359
  640806
  644674
  714449
  576412
  565162
  398307
  451741
  446873
  460770
  535465
  543548
  576407
  545711
  563647
  574502
  574585
  596459
  598554
  473914
  459437
  477734
  478489
  473931
  418808
  447686
  443120
  511739
  484434
  527630
  488700
  496087
  526463
  491736
  672677
  827324
  635742
  743221
  575484
  389980
  552228
  552176
  573577
  552145
]
3.37 ms
(1.81%)
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
  388401
  389980
  398307
  418808
  443120
  446873
  447686
  451741
  459437
  460770
  473914
  473931
  477734
  478489
  484434
  488700
  491736
  496087
  511739
  512295
  526463
  527630
  535465
  539278
  543548
  545711
  552145
  552176
  552228
  556911
  561730
  561813
  563647
  565162
  565274
  565953
  566031
  573577
  573839
  574502
  574585
  574841
  575131
  575162
  575484
  576407
  576412
  580236
  587858
  590821
  591349
  591841
  594381
  595359
  596459
  596583
  597233
  597566
  597828
  598554
  598796
  600167
  603584
  623203
  629029
  635742
  640806
  644674
  649166
  652591
  652605
  652882
  655096
  656684
  659412
  659836
  660562
  661270
  662833
  672677
  675037
  678897
  699026
  699587
  700176
  702432
  703280
  712731
  714449
  715652
  718934
  721264
  723487
  724727
  727824
  730678
  731893
  735957
  742144
  743157
  743221
  747576
  751750
  753031
  753307
  753339
  753395
  753418
  753854
  754182
  760919
  785772
  793893
  798784
  810280
  810841
  819198
  827324
  828324
  828626
]
1.69 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen small"
]
1.52 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen маленькая"
]
1.34 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen маленькая"
]

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.