Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.97 ms
(84.82%)
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
  233353
  388557
  389351
  391472
  391477
  391583
  392601
  392602
  396758
  400813
  401952
  406648
  406882
  411340
  420652
  422246
  422299
  422824
  423979
  429945
  436393
  443692
  443951
  444131
  446958
  447098
  447485
  451498
  453606
  454129
  457510
  458152
  462019
  462170
  462546
  462737
  464185
  464668
  465964
  466306
  466677
  466929
  468888
  470183
  470381
  470642
  473761
  475543
  475882
  477007
  477176
  479044
  479046
  479053
  479055
  479083
  480857
  485695
  486363
  486894
  486915
  487048
  489084
  489874
  490885
  490893
  491907
  491975
  492234
  494386
  494402
  506077
  506419
  506659
  508568
  509439
  511879
  516258
  521528
  524368
  526734
  527978
  531707
  533125
  533743
  534631
  535593
  541727
  543584
  543762
  546716
  554235
  559059
  560400
  561885
  562963
  563038
  563104
  564363
  572765
  576391
  577834
  595443
  595516
  596657
  597498
  597601
  598033
  598452
  598753
  600279
  605742
  613871
  617115
  663254
  676825
  678915
  681782
  761949
  791445
]
18.19 ms
(9.83%)
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
  470642
  462019
  475882
  489084
  489874
  524368
  511879
  559059
  563104
  577834
  389351
  392601
  392602
  470183
  233353
  462737
  479046
  494386
  596657
  466677
  531707
  663254
  676825
  595443
  597601
  791445
  761949
  451498
  466306
  477007
  487048
  516258
  411340
  533125
  541727
  543584
  572765
  678915
  388557
  458152
  401952
  447485
  457510
  420652
  443692
  462546
  464668
  526734
  486363
  491975
  454129
  561885
  563038
  562963
  598033
  473761
  477176
  391472
  391583
  422299
  479044
  406882
  491907
  494402
  490893
  465964
  506077
  521528
  681782
  598452
  597498
  613871
  479083
  422246
  396758
  617115
  546716
  598753
  391477
  480857
  422824
  453606
  406648
  447098
  470381
  443951
  508568
  506419
  527978
  479053
  535593
  533743
  576391
  595516
  605742
  468888
  462170
  429945
  600279
  436393
  554235
  560400
  400813
  423979
  446958
  490885
  492234
  486915
  485695
  534631
  564363
  464185
  466929
  444131
  479055
  486894
  509439
  475543
  506659
  543762
]
3.22 ms
(1.74%)
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
  233353
  388557
  389351
  391472
  391477
  391583
  392601
  392602
  396758
  400813
  401952
  406648
  406882
  411340
  420652
  422246
  422299
  422824
  423979
  429945
  436393
  443692
  443951
  444131
  446958
  447098
  447485
  451498
  453606
  454129
  457510
  458152
  462019
  462170
  462546
  462737
  464185
  464668
  465964
  466306
  466677
  466929
  468888
  470183
  470381
  470642
  473761
  475543
  475882
  477007
  477176
  479044
  479046
  479053
  479055
  479083
  480857
  485695
  486363
  486894
  486915
  487048
  489084
  489874
  490885
  490893
  491907
  491975
  492234
  494386
  494402
  506077
  506419
  506659
  508568
  509439
  511879
  516258
  521528
  524368
  526734
  527978
  531707
  533125
  533743
  534631
  535593
  541727
  543584
  543762
  546716
  554235
  559059
  560400
  561885
  562963
  563038
  563104
  564363
  572765
  576391
  577834
  595443
  595516
  596657
  597498
  597601
  598033
  598452
  598753
  600279
  605742
  613871
  617115
  663254
  676825
  678915
  681782
  761949
  791445
]
1.92 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot russian"
]
1.75 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot русск"
]
1.53 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot русск"
]

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.