Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.17 ms
(85.24%)
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
  476825
  479988
  482003
  494756
  496841
  500953
  504655
  506049
  507921
  514724
  515368
  516648
  517309
  519040
  519920
  520113
  520299
  522334
  522380
  522936
  523216
  526112
  526857
  527036
  527583
  529515
  530201
  530259
  532684
  534713
  535226
  537063
  539071
  539216
  539614
  540384
  541434
  542488
  542820
  543913
  545060
  545076
  546876
  550189
  550214
  552121
  552393
  552726
  553705
  554458
  554835
  555417
  555766
  555958
  556695
  557726
  559247
  559928
  559985
  560171
  561419
  564913
  565573
  566528
  566723
  568106
  569787
  571320
  571454
  571743
  571817
  572509
  574415
  574993
  575441
  575694
  577535
  577950
  578971
  580974
  581175
  581217
  581552
  581729
  581854
  583692
  584401
  584948
  587493
  590932
  591125
  591157
  593739
  594036
  595054
  596559
  601351
  601413
  602763
  603232
  605714
  609179
  612684
  617030
  617075
  617650
  618473
  630257
  631285
  635752
  638049
  645976
  649989
  650955
  652669
  654673
  655465
  670470
  676664
  772417
]
14.65 ms
(8.60%)
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
  539614
  500953
  522334
  530259
  539216
  552726
  555766
  557726
  559247
  566528
  571817
  572509
  583692
  546876
  550189
  566723
  574415
  574993
  542488
  552393
  553705
  554458
  561419
  569787
  571320
  575694
  577950
  649989
  652669
  655465
  676664
  645976
  654673
  670470
  545060
  550214
  571454
  601413
  630257
  591125
  596559
  602763
  609179
  618473
  635752
  587493
  593739
  617075
  638049
  590932
  591157
  601351
  603232
  605714
  612684
  631285
  617030
  617650
  526857
  772417
  514724
  520299
  522380
  532684
  519040
  519920
  515368
  516648
  575441
  577535
  581552
  541434
  545076
  650955
  578971
  595054
  594036
  476825
  479988
  482003
  522936
  529515
  530201
  534713
  504655
  507921
  537063
  540384
  517309
  523216
  527036
  539071
  494756
  496841
  506049
  520113
  526112
  527583
  535226
  542820
  543913
  552121
  554835
  555958
  556695
  560171
  564913
  565573
  568106
  580974
  581175
  581217
  581729
  581854
  584948
  555417
  559928
  559985
  571743
  584401
]
3.41 ms
(2.00%)
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
  476825
  479988
  482003
  494756
  496841
  500953
  504655
  506049
  507921
  514724
  515368
  516648
  517309
  519040
  519920
  520113
  520299
  522334
  522380
  522936
  523216
  526112
  526857
  527036
  527583
  529515
  530201
  530259
  532684
  534713
  535226
  537063
  539071
  539216
  539614
  540384
  541434
  542488
  542820
  543913
  545060
  545076
  546876
  550189
  550214
  552121
  552393
  552726
  553705
  554458
  554835
  555417
  555766
  555958
  556695
  557726
  559247
  559928
  559985
  560171
  561419
  564913
  565573
  566528
  566723
  568106
  569787
  571320
  571454
  571743
  571817
  572509
  574415
  574993
  575441
  575694
  577535
  577950
  578971
  580974
  581175
  581217
  581552
  581729
  581854
  583692
  584401
  584948
  587493
  590932
  591125
  591157
  593739
  594036
  595054
  596559
  601351
  601413
  602763
  603232
  605714
  609179
  612684
  617030
  617075
  617650
  618473
  630257
  631285
  635752
  638049
  645976
  649989
  650955
  652669
  654673
  655465
  670470
  676664
  772417
]
1.92 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сосёт и себя дрочит"
]
1.77 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сосет дрочк"
]
1.75 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.95%)
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.