Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.28 ms
(83.77%)
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
  587268
  603516
  605541
  613664
  615215
  619299
  619689
  629256
  637259
  637363
  640293
  640325
  641263
  645529
  663377
  663391
  663468
  663881
  666104
  668812
  670732
  670902
  672252
  675462
  675755
  677180
  678349
  679706
  679974
  683034
  689478
  697937
  701962
  702231
  709150
  709480
  709865
  710204
  714383
  718494
  718523
  719201
  721691
  723724
  723750
  723988
  724016
  724433
  726141
  726456
  729012
  732939
  734051
  734356
  735659
  735681
  737767
  738497
  739818
  740448
  741177
  742713
  743887
  744556
  747562
  747625
  748382
  748414
  748419
  750966
  754619
  756204
  757287
  759037
  760620
  761207
  765219
  767684
  767704
  768706
  769030
  770835
  771484
  771487
  772255
  772261
  775678
  780332
  781158
  781245
  784457
  784930
  785020
  785738
  787475
  789459
  790050
  792014
  792067
  792384
  793487
  793706
  794715
  797194
  798711
  800171
  800481
  800603
  800912
  802798
  803640
  803895
  806129
  806787
  807161
  807758
  808991
  810853
  812558
]
12.65 ms
(9.27%)
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
  670732
  672252
  675462
  677180
  679706
  701962
  709150
  718494
  721691
  645529
  663377
  663391
  663468
  663881
  666104
  670902
  675755
  678349
  709865
  710204
  714383
  719201
  668812
  679974
  683034
  689478
  697937
  702231
  709480
  718523
  603516
  605541
  615215
  629256
  640293
  619689
  637259
  637363
  640325
  587268
  619299
  641263
  613664
  775678
  781158
  784930
  790050
  792014
  792067
  792384
  794715
  798711
  802798
  780332
  781245
  785020
  789459
  793706
  800171
  803895
  806787
  807161
  807758
  808991
  810853
  812558
  723724
  723988
  726141
  729012
  741177
  747625
  748419
  757287
  759037
  760620
  768706
  771484
  771487
  772261
  784457
  785738
  787475
  793487
  797194
  800481
  800603
  800912
  803640
  806129
  724433
  726456
  734356
  737767
  750966
  754619
  756204
  767704
  769030
  772255
  772829
  723750
  724016
  732939
  734051
  735659
  738497
  740448
  742713
  743887
  748414
  765219
  767684
  770835
  735681
  739818
  744556
  747562
  748382
  761207
]
2.50 ms
(1.83%)
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
  587268
  603516
  605541
  613664
  615215
  619299
  619689
  629256
  637259
  637363
  640293
  640325
  641263
  645529
  663377
  663391
  663468
  663881
  666104
  668812
  670732
  670902
  672252
  675462
  675755
  677180
  678349
  679706
  679974
  683034
  689478
  697937
  701962
  702231
  709150
  709480
  709865
  710204
  714383
  718494
  718523
  719201
  721691
  723724
  723750
  723988
  724016
  724433
  726141
  726456
  729012
  732939
  734051
  734356
  735659
  735681
  737767
  738497
  739818
  740448
  741177
  742713
  743887
  744556
  747562
  747625
  748382
  748414
  748419
  750966
  754619
  756204
  757287
  759037
  760620
  761207
  765219
  767684
  767704
  768706
  769030
  770835
  771484
  771487
  772255
  772261
  775678
  780332
  781158
  781245
  784457
  784930
  785020
  785738
  787475
  789459
  790050
  792014
  792067
  792384
  793487
  793706
  794715
  797194
  798711
  800171
  800481
  800603
  800912
  802798
  803640
  803895
  806129
  806787
  807161
  807758
  808991
  810853
  812558
]
2.04 ms
(1.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "езд"
]
1.87 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "езда"
]
1.60 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.09%)
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.