Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
275.05 ms
(91.13%)
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
  118086
  385021
  385225
  386522
  397251
  401003
  408911
  414132
  414601
  420254
  423953
  428171
  428220
  428255
  441057
  441063
  441093
  441111
  441207
  441269
  441925
  442978
  443309
  446492
  447100
  449075
  454926
  456050
  457698
  458086
  459659
  464042
  476728
  477532
  479530
  481441
  487970
  489946
  491583
  493735
  494495
  495067
  500724
  509063
  511255
  512922
  514946
  517634
  517717
  519722
  521835
  522705
  528346
  529331
  530956
  531561
  533557
  533724
  535277
  535308
  535458
  536421
  536440
  537264
  537452
  539559
  541540
  541797
  544200
  551892
  552131
  552603
  554862
  555282
  557268
  558098
  560939
  565909
  566914
  567947
  568770
  569072
  569247
  571126
  571846
  574089
  575665
  575928
  579471
  581050
  582088
  584402
  590271
  592009
  592245
  594300
  594775
  596350
  601367
  604322
  604815
  606651
  609244
  613494
  618844
  619108
  631145
  634602
  636428
  636592
  636956
  642700
  650726
  671205
  676642
  680440
  686576
  688980
  689415
  727560
]
15.11 ms
(5.01%)
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
  491583
  454926
  464042
  539559
  560939
  575665
  680440
  606651
  594300
  613494
  541540
  642700
  441093
  441111
  443309
  441057
  428220
  428255
  441063
  688980
  446492
  458086
  493735
  456050
  487970
  476728
  489946
  500724
  494495
  536440
  537264
  537452
  495067
  519722
  514946
  522705
  528346
  530956
  533724
  535458
  536421
  552131
  567947
  581050
  544200
  555282
  558098
  569247
  551892
  568770
  689415
  650726
  671205
  676642
  592245
  596350
  636956
  601367
  604322
  619108
  631145
  727560
  397251
  449075
  441207
  447100
  428171
  441925
  459659
  512922
  521835
  386522
  408911
  442978
  457698
  531561
  535277
  541797
  594775
  618844
  479530
  401003
  385225
  420254
  414601
  509063
  441269
  414132
  477532
  511255
  517717
  535308
  517634
  529331
  481441
  571846
  575928
  582088
  552603
  565909
  571126
  574089
  579471
  584402
  686576
  557268
  569072
  636592
  590271
  604815
  636428
  609244
  592009
  634602
  118086
  423953
  385021
  533557
  566914
  554862
]
4.91 ms
(1.63%)
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
  118086
  385021
  385225
  386522
  397251
  401003
  408911
  414132
  414601
  420254
  423953
  428171
  428220
  428255
  441057
  441063
  441093
  441111
  441207
  441269
  441925
  442978
  443309
  446492
  447100
  449075
  454926
  456050
  457698
  458086
  459659
  464042
  476728
  477532
  479530
  481441
  487970
  489946
  491583
  493735
  494495
  495067
  500724
  509063
  511255
  512922
  514946
  517634
  517717
  519722
  521835
  522705
  528346
  529331
  530956
  531561
  533557
  533724
  535277
  535308
  535458
  536421
  536440
  537264
  537452
  539559
  541540
  541797
  544200
  551892
  552131
  552603
  554862
  555282
  557268
  558098
  560939
  565909
  566914
  567947
  568770
  569072
  569247
  571126
  571846
  574089
  575665
  575928
  579471
  581050
  582088
  584402
  590271
  592009
  592245
  594300
  594775
  596350
  601367
  604322
  604815
  606651
  609244
  613494
  618844
  619108
  631145
  634602
  636428
  636592
  636956
  642700
  650726
  671205
  676642
  680440
  686576
  688980
  689415
  727560
]
1.96 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в жопу рукой"
]
1.61 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал рук"
]
1.60 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.52%)
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.