Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.98 ms
(84.44%)
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
  439855
  494861
  497507
  499902
  500538
  500916
  501477
  504810
  506769
  509679
  510882
  513826
  513975
  516043
  517114
  519388
  519865
  519872
  520820
  522387
  522433
  522784
  523279
  527072
  527463
  527928
  530646
  533333
  539331
  539372
  553227
  555479
  557102
  557361
  557735
  558574
  559300
  562966
  563633
  565033
  566337
  572235
  576520
  576776
  577147
  578290
  578599
  579947
  580597
  582944
  584005
  585787
  586574
  586897
  586981
  587899
  587950
  588082
  589647
  590941
  591315
  591550
  591735
  591928
  591940
  591966
  592580
  593609
  593824
  595358
  597110
  597666
  599339
  600540
  602016
  602526
  603615
  604238
  605381
  605391
  608414
  610085
  612235
  612237
  612254
  613921
  615908
  616005
  619040
  620117
  621186
  621375
  623972
  626165
  627674
  630670
  631119
  631245
  632198
  647027
  654165
  656158
  660030
  662152
  664241
  664497
  666188
  667344
  680400
  690281
  692124
  716969
  727782
  730359
  742747
  747964
  749150
  761137
  771918
  775724
]
13.83 ms
(9.57%)
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
  591315
  591735
  600540
  619040
  626165
  588082
  595358
  597110
  612254
  615908
  632198
  513975
  520820
  555479
  660030
  716969
  666188
  557735
  563633
  591940
  630670
  775724
  730359
  742747
  749150
  761137
  566337
  572235
  680400
  579947
  623972
  558574
  587899
  621186
  533333
  519872
  539331
  539372
  497507
  565033
  576776
  578290
  562966
  654165
  604238
  605381
  439855
  580597
  592580
  499902
  500538
  500916
  501477
  516043
  519388
  523279
  519865
  504810
  522433
  557102
  557361
  553227
  576520
  578599
  582944
  664241
  647027
  656158
  662152
  690281
  577147
  585787
  593609
  593824
  589647
  590941
  591928
  597666
  605391
  610085
  616005
  620117
  599339
  613921
  631119
  586574
  586897
  591550
  608414
  612237
  627674
  603615
  621375
  513826
  587950
  631245
  727782
  771918
  494861
  506769
  667344
  664497
  602016
  612235
  692124
  559300
  586981
  747964
  510882
  584005
  591966
  602526
  522784
  517114
  527463
  522387
  527072
  527928
  509679
  530646
]
2.26 ms
(1.56%)
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
  439855
  494861
  497507
  499902
  500538
  500916
  501477
  504810
  506769
  509679
  510882
  513826
  513975
  516043
  517114
  519388
  519865
  519872
  520820
  522387
  522433
  522784
  523279
  527072
  527463
  527928
  530646
  533333
  539331
  539372
  553227
  555479
  557102
  557361
  557735
  558574
  559300
  562966
  563633
  565033
  566337
  572235
  576520
  576776
  577147
  578290
  578599
  579947
  580597
  582944
  584005
  585787
  586574
  586897
  586981
  587899
  587950
  588082
  589647
  590941
  591315
  591550
  591735
  591928
  591940
  591966
  592580
  593609
  593824
  595358
  597110
  597666
  599339
  600540
  602016
  602526
  603615
  604238
  605381
  605391
  608414
  610085
  612235
  612237
  612254
  613921
  615908
  616005
  619040
  620117
  621186
  621375
  623972
  626165
  627674
  630670
  631119
  631245
  632198
  647027
  654165
  656158
  660030
  662152
  664241
  664497
  666188
  667344
  680400
  690281
  692124
  716969
  727782
  730359
  742747
  747964
  749150
  761137
  771918
  775724
]
1.81 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с кримпаем"
]
1.77 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кремпа сперм"
]
1.46 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.93%)
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.