Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.09 ms
(84.13%)
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
  226082
  392002
  399088
  417721
  417722
  417723
  417725
  417730
  417739
  417745
  420013
  421586
  422501
  422853
  424529
  424534
  424739
  424753
  424755
  429232
  440700
  445702
  446698
  449792
  453306
  455011
  455445
  455825
  456261
  456267
  456298
  462285
  468985
  470480
  480611
  481421
  482675
  484545
  487842
  488131
  488286
  496869
  498083
  498924
  499184
  499778
  500225
  504365
  504599
  505857
  506538
  506551
  506552
  506556
  511047
  512877
  512935
  514718
  519883
  520741
  523943
  523951
  524536
  525638
  527896
  528689
  528714
  538905
  540143
  547735
  550024
  550826
  551177
  551450
  551451
  553001
  553632
  559236
  559998
  560901
  565355
  565363
  565372
  566576
  567133
  567585
  571221
  578153
  582514
  585086
  589015
  589561
  589806
  594875
  595029
  595842
  599758
  599761
  599883
  600302
  601910
  602561
  605443
  615605
  619478
  659460
  662556
  680572
  681546
  721012
  738641
  751971
  758899
  761490
  778297
  778894
  795832
  802568
  806228
  809493
]
18.18 ms
(10.47%)
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
  594875
  758899
  802568
  420013
  421586
  424739
  505857
  487842
  424755
  424529
  417721
  484545
  520741
  553632
  547735
  560901
  809493
  761490
  795832
  455445
  468985
  422501
  553001
  551451
  392002
  424753
  424534
  445702
  456261
  500225
  538905
  550024
  578153
  680572
  589806
  595842
  778894
  751971
  456298
  226082
  453306
  523943
  528689
  582514
  571221
  601910
  417723
  417730
  449792
  470480
  550826
  738641
  446698
  456267
  417722
  417745
  519883
  496869
  417725
  482675
  480611
  511047
  506538
  512877
  599758
  523951
  498083
  504599
  524536
  422853
  429232
  514718
  565372
  481421
  585086
  455825
  506552
  512935
  567133
  721012
  681546
  615605
  602561
  778297
  527896
  499184
  399088
  506556
  567585
  662556
  559998
  566576
  605443
  462285
  488131
  498924
  559236
  551177
  551450
  599761
  488286
  417739
  540143
  506551
  525638
  659460
  589561
  600302
  440700
  504365
  589015
  565363
  455011
  565355
  499778
  528714
  599883
  595029
  619478
  806228
]
3.07 ms
(1.77%)
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
  226082
  392002
  399088
  417721
  417722
  417723
  417725
  417730
  417739
  417745
  420013
  421586
  422501
  422853
  424529
  424534
  424739
  424753
  424755
  429232
  440700
  445702
  446698
  449792
  453306
  455011
  455445
  455825
  456261
  456267
  456298
  462285
  468985
  470480
  480611
  481421
  482675
  484545
  487842
  488131
  488286
  496869
  498083
  498924
  499184
  499778
  500225
  504365
  504599
  505857
  506538
  506551
  506552
  506556
  511047
  512877
  512935
  514718
  519883
  520741
  523943
  523951
  524536
  525638
  527896
  528689
  528714
  538905
  540143
  547735
  550024
  550826
  551177
  551450
  551451
  553001
  553632
  559236
  559998
  560901
  565355
  565363
  565372
  566576
  567133
  567585
  571221
  578153
  582514
  585086
  589015
  589561
  589806
  594875
  595029
  595842
  599758
  599761
  599883
  600302
  601910
  602561
  605443
  615605
  619478
  659460
  662556
  680572
  681546
  721012
  738641
  751971
  758899
  761490
  778297
  778894
  795832
  802568
  806228
  809493
]
1.73 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "street girl"
]
1.58 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "street девушк"
]
1.46 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "street девушк"
]

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.