Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.14 ms
(87.14%)
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
  34369
  105224
  182139
  186041
  186858
  310725
  314552
  382203
  383237
  384133
  384478
  385379
  388012
  388770
  389273
  391114
  391944
  392971
  394355
  394630
  397861
  398973
  400865
  401964
  404615
  412222
  412299
  413098
  413185
  416032
  420016
  421823
  421838
  421840
  421857
  421874
  421897
  421913
  422165
  422207
  425052
  425251
  425861
  426515
  429602
  432644
  434350
  435558
  435563
  438506
  439572
  441131
  441160
  442814
  443278
  446757
  449080
  452815
  452880
  457155
  458708
  462925
  463779
  467108
  471023
  471664
  473446
  475908
  477691
  479253
  481501
  484363
  486322
  488947
  489357
  490030
  493749
  493838
  497665
  516028
  523885
  531892
  536296
  556769
  561492
  576906
  604967
  607228
  619070
  638565
  665802
  666378
  666398
  702268
  718040
  718581
  718746
  725556
  728708
  736674
  744200
  753461
  754312
  758166
  765060
  765497
  765634
  768419
  777789
  780778
  782027
  786095
  788193
  794777
  794782
  800712
  805738
  812356
  813819
  821377
]
16.56 ms
(8.19%)
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
  441160
  471664
  452880
  449080
  452815
  493838
  486322
  516028
  604967
  413185
  412299
  186858
  182139
  382203
  458708
  385379
  438506
  388012
  391944
  429602
  435563
  434350
  421838
  394630
  561492
  389273
  497665
  398973
  490030
  493749
  473446
  718040
  638565
  744200
  718581
  383237
  105224
  488947
  666398
  619070
  800712
  794777
  736674
  768419
  475908
  314552
  412222
  420016
  782027
  435558
  821377
  753461
  665802
  777789
  536296
  754312
  394355
  384133
  467108
  404615
  400865
  421874
  442814
  425052
  392971
  813819
  531892
  556769
  576906
  666378
  725556
  788193
  794782
  812356
  728708
  765497
  765634
  765060
  310725
  397861
  421857
  439572
  443278
  441131
  425861
  426515
  432644
  481501
  421823
  421840
  422165
  422207
  388770
  477691
  479253
  421897
  421913
  416032
  446757
  489357
  718746
  607228
  702268
  523885
  805738
  391114
  384478
  463779
  484363
  780778
  413098
  425251
  186041
  34369
  401964
  457155
  462925
  471023
  786095
  758166
]
2.77 ms
(1.37%)
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
  34369
  105224
  182139
  186041
  186858
  310725
  314552
  382203
  383237
  384133
  384478
  385379
  388012
  388770
  389273
  391114
  391944
  392971
  394355
  394630
  397861
  398973
  400865
  401964
  404615
  412222
  412299
  413098
  413185
  416032
  420016
  421823
  421838
  421840
  421857
  421874
  421897
  421913
  422165
  422207
  425052
  425251
  425861
  426515
  429602
  432644
  434350
  435558
  435563
  438506
  439572
  441131
  441160
  442814
  443278
  446757
  449080
  452815
  452880
  457155
  458708
  462925
  463779
  467108
  471023
  471664
  473446
  475908
  477691
  479253
  481501
  484363
  486322
  488947
  489357
  490030
  493749
  493838
  497665
  516028
  523885
  531892
  536296
  556769
  561492
  576906
  604967
  607228
  619070
  638565
  665802
  666378
  666398
  702268
  718040
  718581
  718746
  725556
  728708
  736674
  744200
  753461
  754312
  758166
  765060
  765497
  765634
  768419
  777789
  780778
  782027
  786095
  788193
  794777
  794782
  800712
  805738
  812356
  813819
  821377
]
1.99 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother girl"
]
1.70 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин девушк"
]
1.60 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин девушк"
]
1.39 ms
(0.69%)
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.