Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.22 ms
(82.40%)
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
  384998
  394548
  397335
  401842
  404459
  404471
  407587
  408293
  408774
  410712
  414126
  415004
  415387
  417388
  419120
  420178
  420398
  421043
  421691
  423320
  423332
  426043
  426571
  427289
  429709
  432799
  433069
  433199
  435211
  437344
  443558
  447121
  448300
  449369
  449888
  451950
  451951
  455180
  460969
  465256
  467047
  469560
  471438
  471945
  472506
  472544
  472935
  473491
  474553
  474593
  481664
  481719
  481812
  484494
  487517
  488805
  494979
  497892
  502530
  502998
  512984
  517391
  517528
  518140
  520730
  522168
  523586
  524200
  524846
  525556
  526042
  527088
  527932
  531415
  531996
  534293
  543920
  553037
  553072
  558235
  560155
  565568
  565650
  567041
  568149
  568172
  568641
  573933
  574298
  581908
  583807
  595158
  595808
  602259
  603422
  603949
  607717
  611244
  615542
  620160
  621298
  621375
  622335
  623364
  624288
  633133
  633204
  647637
  675936
  682489
  683870
  720245
  735132
  744362
  792624
  807557
  815204
  815881
  817136
  823410
]
16.44 ms
(11.00%)
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
  553037
  573933
  553072
  568149
  675936
  682489
  683870
  565650
  567041
  583807
  595158
  607717
  620160
  621298
  633204
  603422
  615542
  611244
  807557
  735132
  621375
  623364
  481719
  426571
  448300
  449369
  420178
  429709
  502998
  524200
  524846
  497892
  484494
  522168
  523586
  527932
  474593
  481812
  817136
  823410
  568172
  744362
  451951
  384998
  394548
  404471
  404459
  423320
  423332
  432799
  433199
  410712
  443558
  408774
  427289
  435211
  437344
  815881
  815204
  474553
  467047
  471438
  473491
  487517
  525556
  526042
  531996
  527088
  531415
  512984
  517528
  518140
  534293
  494979
  517391
  520730
  469560
  472506
  472544
  472935
  568641
  581908
  543920
  560155
  720245
  647637
  558235
  565568
  574298
  633133
  603949
  595808
  602259
  622335
  624288
  792624
  397335
  407587
  408293
  426043
  481664
  417388
  401842
  414126
  415004
  415387
  419120
  447121
  465256
  433069
  449888
  451950
  455180
  471945
  420398
  421043
  421691
  460969
  502530
  488805
]
2.87 ms
(1.92%)
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
  384998
  394548
  397335
  401842
  404459
  404471
  407587
  408293
  408774
  410712
  414126
  415004
  415387
  417388
  419120
  420178
  420398
  421043
  421691
  423320
  423332
  426043
  426571
  427289
  429709
  432799
  433069
  433199
  435211
  437344
  443558
  447121
  448300
  449369
  449888
  451950
  451951
  455180
  460969
  465256
  467047
  469560
  471438
  471945
  472506
  472544
  472935
  473491
  474553
  474593
  481664
  481719
  481812
  484494
  487517
  488805
  494979
  497892
  502530
  502998
  512984
  517391
  517528
  518140
  520730
  522168
  523586
  524200
  524846
  525556
  526042
  527088
  527932
  531415
  531996
  534293
  543920
  553037
  553072
  558235
  560155
  565568
  565650
  567041
  568149
  568172
  568641
  573933
  574298
  581908
  583807
  595158
  595808
  602259
  603422
  603949
  607717
  611244
  615542
  620160
  621298
  621375
  622335
  623364
  624288
  633133
  633204
  647637
  675936
  682489
  683870
  720245
  735132
  744362
  792624
  807557
  815204
  815881
  817136
  823410
]
1.98 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina hairy"
]
1.67 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская волосатая"
]
1.48 ms
(0.99%)
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.