Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.55 ms
(86.92%)
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
  315815
  385079
  385680
  395284
  396701
  401278
  405029
  411498
  417835
  419808
  422716
  424995
  428271
  432837
  434676
  437996
  440916
  441366
  441442
  446453
  447209
  447689
  448341
  451447
  453018
  455574
  456736
  457880
  459865
  464152
  472147
  475144
  480960
  481161
  481253
  481343
  486345
  486349
  486834
  488365
  490419
  491899
  497517
  499771
  504906
  505286
  516226
  516693
  517023
  518807
  520992
  521998
  524188
  527663
  533522
  534494
  538002
  538005
  538970
  543259
  546955
  546958
  549821
  549825
  549831
  549832
  549842
  549844
  549848
  549849
  552290
  556047
  559856
  561386
  563438
  565625
  566939
  569414
  573402
  574049
  574679
  584498
  584716
  585253
  590382
  592311
  596208
  604368
  609825
  612917
  624224
  631948
  652852
  685477
  685655
  695719
  695831
  696128
  699596
  714463
  715786
  718496
  721579
  723542
  730104
  731279
  741286
  742526
  761574
  761842
  761854
  769310
  790879
  794307
  796184
  797119
  800604
  806084
  809687
  827859
]
15.10 ms
(8.18%)
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
  486834
  490419
  534494
  533522
  549832
  569414
  546955
  549849
  552290
  695719
  696128
  715786
  549842
  590382
  806084
  761574
  731279
  631948
  448341
  385079
  480960
  405029
  447689
  434676
  417835
  446453
  538005
  538970
  518807
  488365
  516226
  574679
  584716
  596208
  524188
  315815
  685655
  827859
  437996
  464152
  520992
  516693
  549821
  549831
  556047
  563438
  549825
  685477
  546958
  549848
  624224
  604368
  401278
  457880
  491899
  504906
  486349
  395284
  396701
  419808
  723542
  455574
  453018
  574049
  699596
  652852
  695831
  721579
  714463
  718496
  565625
  800604
  796184
  797119
  730104
  769310
  809687
  742526
  741286
  761842
  761854
  609825
  790879
  422716
  517023
  497517
  505286
  385680
  424995
  441366
  441442
  451447
  459865
  527663
  549844
  584498
  561386
  573402
  543259
  566939
  559856
  585253
  592311
  612917
  481253
  428271
  432837
  411498
  440916
  499771
  538002
  486345
  521998
  794307
  447209
  456736
  472147
  475144
  481161
  481343
]
2.79 ms
(1.51%)
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
  315815
  385079
  385680
  395284
  396701
  401278
  405029
  411498
  417835
  419808
  422716
  424995
  428271
  432837
  434676
  437996
  440916
  441366
  441442
  446453
  447209
  447689
  448341
  451447
  453018
  455574
  456736
  457880
  459865
  464152
  472147
  475144
  480960
  481161
  481253
  481343
  486345
  486349
  486834
  488365
  490419
  491899
  497517
  499771
  504906
  505286
  516226
  516693
  517023
  518807
  520992
  521998
  524188
  527663
  533522
  534494
  538002
  538005
  538970
  543259
  546955
  546958
  549821
  549825
  549831
  549832
  549842
  549844
  549848
  549849
  552290
  556047
  559856
  561386
  563438
  565625
  566939
  569414
  573402
  574049
  574679
  584498
  584716
  585253
  590382
  592311
  596208
  604368
  609825
  612917
  624224
  631948
  652852
  685477
  685655
  695719
  695831
  696128
  699596
  714463
  715786
  718496
  721579
  723542
  730104
  731279
  741286
  742526
  761574
  761842
  761854
  769310
  790879
  794307
  796184
  797119
  800604
  806084
  809687
  827859
]
1.75 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal step"
]
1.53 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал step"
]
1.51 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал step"
]
1.49 ms
(0.81%)
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.