Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.75 ms
(81.70%)
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
  391092
  392820
  395723
  395753
  395757
  396234
  403464
  404412
  404459
  404612
  407089
  412299
  424505
  425809
  431361
  434676
  441019
  442387
  443963
  445500
  446743
  447890
  449384
  451552
  452324
  452641
  455596
  456745
  457770
  460392
  461394
  462280
  462547
  462886
  463456
  464737
  469073
  470280
  470482
  470654
  472300
  473179
  473308
  473594
  474016
  474025
  474473
  474942
  476419
  479064
  479593
  482292
  483440
  484721
  485066
  485475
  486435
  487313
  492336
  497052
  497185
  500636
  504196
  504232
  506141
  506148
  507275
  509913
  510558
  512086
  512274
  512369
  513445
  518334
  518357
  520025
  520972
  523395
  523954
  523992
  524729
  524833
  524838
  525377
  526006
  527340
  527560
  527731
  542770
  550232
  552220
  556520
  556851
  558474
  559386
  559532
  559692
  560019
  562311
  568349
  568733
  569895
  570407
  571618
  572120
  573501
  573810
  574520
  574878
  575511
  576364
  597154
  599055
  607389
  625677
  653463
  654739
  655725
  657368
  659593
]
20.75 ms
(12.31%)
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
  574878
  575511
  597154
  455596
  463456
  473308
  474942
  476419
  396234
  403464
  461394
  462547
  462886
  479593
  395723
  470280
  404412
  434676
  472300
  456745
  500636
  504196
  504232
  523954
  524833
  497052
  513445
  518334
  525377
  486435
  497185
  506141
  507275
  512274
  520025
  524729
  524838
  487313
  510558
  520972
  392820
  404612
  404459
  464737
  474025
  452641
  473179
  462280
  512369
  559532
  560019
  570407
  576364
  556851
  552220
  654739
  550232
  599055
  625677
  395753
  479064
  460392
  412299
  441019
  451552
  470482
  470654
  523992
  506148
  512086
  485475
  518357
  526006
  527340
  527731
  407089
  446743
  449384
  445500
  457770
  482292
  559386
  568733
  569895
  542770
  559692
  571618
  568349
  657368
  659593
  556520
  562311
  607389
  391092
  474016
  424505
  443963
  442387
  447890
  452324
  473594
  527560
  484721
  492336
  509913
  483440
  485066
  523395
  395757
  431361
  425809
  474473
  469073
  573501
  574520
  558474
  572120
  573810
  653463
  655725
]
2.74 ms
(1.62%)
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
  391092
  392820
  395723
  395753
  395757
  396234
  403464
  404412
  404459
  404612
  407089
  412299
  424505
  425809
  431361
  434676
  441019
  442387
  443963
  445500
  446743
  447890
  449384
  451552
  452324
  452641
  455596
  456745
  457770
  460392
  461394
  462280
  462547
  462886
  463456
  464737
  469073
  470280
  470482
  470654
  472300
  473179
  473308
  473594
  474016
  474025
  474473
  474942
  476419
  479064
  479593
  482292
  483440
  484721
  485066
  485475
  486435
  487313
  492336
  497052
  497185
  500636
  504196
  504232
  506141
  506148
  507275
  509913
  510558
  512086
  512274
  512369
  513445
  518334
  518357
  520025
  520972
  523395
  523954
  523992
  524729
  524833
  524838
  525377
  526006
  527340
  527560
  527731
  542770
  550232
  552220
  556520
  556851
  558474
  559386
  559532
  559692
  560019
  562311
  568349
  568733
  569895
  570407
  571618
  572120
  573501
  573810
  574520
  574878
  575511
  576364
  597154
  599055
  607389
  625677
  653463
  654739
  655725
  657368
  659593
]
2.21 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "парочка"
]
1.83 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парочк"
]
1.60 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.