Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.82 ms
(80.87%)
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
  402724
  418886
  420675
  422389
  422398
  424523
  426062
  429898
  439777
  439854
  443222
  443971
  448034
  448035
  448046
  448221
  448377
  450910
  450966
  451563
  451572
  451786
  457527
  459099
  459532
  459534
  459703
  463066
  466294
  466572
  467476
  467868
  470527
  470985
  472396
  472891
  474487
  475009
  477043
  480526
  481780
  482358
  484818
  488051
  490507
  491029
  491463
  491664
  492972
  494185
  497534
  499159
  499978
  501426
  503121
  503153
  503336
  505888
  507241
  510290
  512073
  512610
  512766
  513061
  513710
  513869
  514030
  515371
  516786
  516819
  516875
  518003
  518206
  518920
  519039
  519671
  519752
  520262
  520555
  520570
  521241
  521426
  522220
  522441
  522460
  523825
  524989
  525087
  525835
  526238
  526941
  528662
  529497
  533760
  535597
  540723
  543652
  543659
  545772
  546326
  549584
  552267
  552272
  555884
  560831
  561361
  565247
  565825
  567848
  573904
  590482
  594835
  594886
  598877
  608541
  614867
  648575
  651836
  680183
  718745
]
18.47 ms
(12.57%)
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
  475009
  459532
  448046
  450910
  450966
  420675
  459534
  503153
  503336
  488051
  503121
  514030
  521241
  524989
  501426
  497534
  467868
  480526
  466572
  418886
  522460
  526238
  518003
  533760
  443222
  448377
  429898
  512073
  507241
  499159
  523825
  422389
  560831
  543659
  552267
  546326
  565247
  424523
  426062
  439854
  470527
  520262
  513061
  525835
  491664
  494185
  512766
  526941
  518920
  535597
  573904
  448034
  459099
  402724
  451572
  459703
  516786
  515371
  490507
  594886
  590482
  484818
  482358
  470985
  510290
  651836
  718745
  565825
  598877
  608541
  477043
  466294
  448035
  472891
  505888
  525087
  491463
  492972
  499978
  516819
  519752
  522441
  513710
  521426
  540723
  648575
  594835
  451786
  463066
  467476
  512610
  439777
  448221
  519671
  520570
  513869
  520555
  552272
  614867
  443971
  422398
  491029
  528662
  549584
  680183
  545772
  518206
  529497
  555884
  561361
  543652
  567848
  451563
  457527
  516875
  522220
  519039
  474487
  481780
  472396
]
2.47 ms
(1.68%)
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
  402724
  418886
  420675
  422389
  422398
  424523
  426062
  429898
  439777
  439854
  443222
  443971
  448034
  448035
  448046
  448221
  448377
  450910
  450966
  451563
  451572
  451786
  457527
  459099
  459532
  459534
  459703
  463066
  466294
  466572
  467476
  467868
  470527
  470985
  472396
  472891
  474487
  475009
  477043
  480526
  481780
  482358
  484818
  488051
  490507
  491029
  491463
  491664
  492972
  494185
  497534
  499159
  499978
  501426
  503121
  503153
  503336
  505888
  507241
  510290
  512073
  512610
  512766
  513061
  513710
  513869
  514030
  515371
  516786
  516819
  516875
  518003
  518206
  518920
  519039
  519671
  519752
  520262
  520555
  520570
  521241
  521426
  522220
  522441
  522460
  523825
  524989
  525087
  525835
  526238
  526941
  528662
  529497
  533760
  535597
  540723
  543652
  543659
  545772
  546326
  549584
  552267
  552272
  555884
  560831
  561361
  565247
  565825
  567848
  573904
  590482
  594835
  594886
  598877
  608541
  614867
  648575
  651836
  680183
  718745
]
1.88 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian slave girl"
]
1.83 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск доминирован девушк"
]
1.75 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.