Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
418.46 ms
(94.18%)
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
  3599
  7086
  17093
  32977
  93079
  162212
  287979
  382384
  384390
  387130
  389926
  391590
  395531
  400681
  406381
  410524
  410823
  410950
  412179
  413050
  415246
  415946
  415956
  416297
  418418
  418488
  419012
  420607
  421107
  422395
  422970
  428933
  429088
  433983
  434003
  435428
  435726
  435942
  437712
  444550
  447373
  449478
  453431
  459895
  460936
  461710
  466190
  472568
  476207
  476905
  477549
  481963
  482953
  491804
  492414
  496516
  497022
  499900
  502214
  505812
  511327
  515603
  516048
  519905
  521642
  524533
  524999
  525082
  526264
  526805
  528074
  529392
  530572
  531720
  537870
  539416
  543334
  547881
  548525
  549699
  549702
  553362
  554411
  556958
  559845
  565219
  566322
  568989
  570896
  574434
  579633
  583039
  583174
  588481
  591174
  595328
  599257
  605689
  610686
  612995
  615608
  623126
  623615
  624843
  626283
  630013
  635219
  639209
  641910
  662653
  663914
  673845
  701388
  726848
  730999
  733417
  738012
  764820
  783508
  797290
]
15.60 ms
(3.51%)
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
  530572
  556958
  477549
  570896
  565219
  549699
  574434
  599257
  524999
  591174
  526805
  516048
  476905
  515603
  623615
  610686
  491804
  3599
  623126
  382384
  410823
  433983
  384390
  391590
  481963
  412179
  453431
  531720
  548525
  419012
  437712
  460936
  420607
  7086
  472568
  497022
  502214
  583174
  17093
  466190
  93079
  764820
  444550
  547881
  410950
  499900
  400681
  476207
  418488
  461710
  416297
  435726
  415946
  511327
  554411
  387130
  410524
  447373
  492414
  496516
  421107
  528074
  635219
  579633
  413050
  537870
  673845
  663914
  626283
  422970
  395531
  539416
  428933
  459895
  415246
  418418
  429088
  521642
  605689
  662653
  624843
  434003
  568989
  641910
  566322
  595328
  422395
  543334
  525082
  526264
  615608
  435428
  529392
  559845
  435942
  797290
  524533
  415956
  738012
  701388
  553362
  583039
  519905
  549702
  505812
  639209
  482953
  612995
  733417
  389926
  783508
  287979
  32977
  406381
  730999
  449478
  630013
  726848
  588481
  162212
]
3.14 ms
(0.71%)
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
  3599
  7086
  17093
  32977
  93079
  162212
  287979
  382384
  384390
  387130
  389926
  391590
  395531
  400681
  406381
  410524
  410823
  410950
  412179
  413050
  415246
  415946
  415956
  416297
  418418
  418488
  419012
  420607
  421107
  422395
  422970
  428933
  429088
  433983
  434003
  435428
  435726
  435942
  437712
  444550
  447373
  449478
  453431
  459895
  460936
  461710
  466190
  472568
  476207
  476905
  477549
  481963
  482953
  491804
  492414
  496516
  497022
  499900
  502214
  505812
  511327
  515603
  516048
  519905
  521642
  524533
  524999
  525082
  526264
  526805
  528074
  529392
  530572
  531720
  537870
  539416
  543334
  547881
  548525
  549699
  549702
  553362
  554411
  556958
  559845
  565219
  566322
  568989
  570896
  574434
  579633
  583039
  583174
  588481
  591174
  595328
  599257
  605689
  610686
  612995
  615608
  623126
  623615
  624843
  626283
  630013
  635219
  639209
  641910
  662653
  663914
  673845
  701388
  726848
  730999
  733417
  738012
  764820
  783508
  797290
]
2.15 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хуй соска"
]
1.82 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член соск"
]
1.58 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член соск"
]
1.58 ms
(0.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.