Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.44 ms
(82.73%)
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
  115206
  383595
  388198
  394309
  397679
  416795
  418714
  421742
  421968
  425712
  430796
  436523
  438410
  439300
  440671
  443162
  445779
  446997
  449891
  452751
  453987
  454679
  454901
  454905
  456606
  456900
  457146
  457940
  458331
  458533
  458872
  459002
  459016
  462287
  464400
  464833
  467066
  468833
  471672
  473177
  476592
  476911
  478537
  480780
  481788
  487854
  499484
  500506
  500594
  501334
  505591
  506861
  512121
  512876
  516874
  520615
  520800
  520980
  521546
  522313
  525615
  526319
  526517
  526812
  526815
  526942
  529207
  529919
  536940
  541479
  543879
  546754
  549513
  553732
  555191
  556010
  558643
  559799
  560748
  566255
  568064
  568077
  568445
  568637
  568654
  569084
  571261
  571735
  574913
  576262
  582072
  582704
  584611
  584799
  589469
  589513
  589568
  591767
  591916
  591990
  592619
  600466
  603997
  608716
  612080
  623835
  631676
  641096
  645300
  647721
  668463
  709816
  723369
  724869
  756694
  761136
  786005
  801790
  804259
]
17.00 ms
(11.39%)
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
  555191
  645300
  647721
  631676
  756694
  476911
  568637
  543879
  589513
  641096
  506861
  499484
  589568
  529919
  591990
  394309
  397679
  478537
  505591
  476592
  568445
  623835
  589469
  425712
  526812
  584799
  553732
  582704
  560748
  723369
  804259
  724869
  568077
  571261
  761136
  383595
  458533
  526815
  584611
  574913
  591916
  801790
  462287
  445779
  521546
  436523
  416795
  453987
  454901
  480780
  536940
  568654
  582072
  546754
  709816
  786005
  458872
  464400
  452751
  457146
  471672
  439300
  501334
  529207
  549513
  541345
  443162
  459002
  500594
  566255
  568064
  458331
  576262
  468833
  516874
  440671
  456606
  481788
  457940
  512876
  473177
  559799
  541479
  592619
  418714
  526319
  115206
  421742
  430796
  438410
  421968
  454905
  487854
  525615
  526942
  569084
  668463
  556010
  558643
  571735
  591767
  603997
  612080
  454679
  456900
  464833
  446997
  388198
  520615
  522313
  520980
  467066
  608716
  520800
  449891
  500506
  600466
  459016
  526517
  512121
]
2.22 ms
(1.49%)
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
  115206
  383595
  388198
  394309
  397679
  416795
  418714
  421742
  421968
  425712
  430796
  436523
  438410
  439300
  440671
  443162
  445779
  446997
  449891
  452751
  453987
  454679
  454901
  454905
  456606
  456900
  457146
  457940
  458331
  458533
  458872
  459002
  459016
  462287
  464400
  464833
  467066
  468833
  471672
  473177
  476592
  476911
  478537
  480780
  481788
  487854
  499484
  500506
  500594
  501334
  505591
  506861
  512121
  512876
  516874
  520615
  520800
  520980
  521546
  522313
  525615
  526319
  526517
  526812
  526815
  526942
  529207
  529919
  536940
  541479
  543879
  546754
  549513
  553732
  555191
  556010
  558643
  559799
  560748
  566255
  568064
  568077
  568445
  568637
  568654
  569084
  571261
  571735
  574913
  576262
  582072
  582704
  584611
  584799
  589469
  589513
  589568
  591767
  591916
  591990
  592619
  600466
  603997
  608716
  612080
  623835
  631676
  641096
  645300
  647721
  668463
  709816
  723369
  724869
  756694
  761136
  786005
  801790
  804259
]
1.78 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на йоге"
]
1.64 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на йог"
]
1.53 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.