Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.99 ms
(87.18%)
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
  6858
  181184
  233443
  365992
  382132
  386662
  389116
  390805
  393550
  396127
  396159
  396211
  397856
  401594
  401975
  402222
  429946
  447101
  453901
  457406
  461424
  476742
  481298
  531285
  533779
  536236
  595423
  595440
  597560
  598013
  598474
  598695
  605730
  624161
  626880
  652927
  653533
  654409
  655069
  657291
  675041
  680391
  683242
  695093
  696297
  705106
  707164
  713300
  715020
  716992
  720641
  721322
  724240
  725167
  725948
  730623
  739913
  740085
  742846
  743025
  743051
  746067
  747164
  747435
  747709
  753472
  754207
  754228
  754584
  754630
  755677
  755739
  760935
  766173
  766479
  766505
  766712
  766785
  766796
  766802
  766806
  766839
  768867
  769052
  769833
  770319
  770435
  771889
  773599
  773644
  777021
  777041
  777551
  778900
  779741
  780061
  781358
  781412
  782674
  783618
  786372
  786765
  787484
  788198
  788351
  789308
  790531
  792953
  799998
  801285
  804320
  805722
  806332
  813093
  820385
  821116
  823740
  826674
  827429
  828626
]
13.44 ms
(7.37%)
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
  771889
  389116
  597560
  396211
  598695
  476742
  453901
  787484
  396127
  654409
  605730
  789308
  801285
  755739
  755677
  766173
  766796
  747164
  753472
  770319
  766479
  769052
  768867
  779741
  806332
  813093
  386662
  531285
  695093
  720641
  397856
  457406
  598013
  826674
  823740
  827429
  683242
  652927
  715020
  790531
  747709
  754584
  766785
  777021
  401594
  396159
  365992
  233443
  429946
  481298
  181184
  536236
  653533
  657291
  675041
  696297
  655069
  624161
  780061
  804320
  754630
  781358
  766505
  766806
  770435
  754228
  725948
  401975
  743051
  743025
  828626
  821116
  680391
  705106
  707164
  626880
  788351
  782674
  754207
  773644
  781412
  786372
  792953
  742846
  766712
  739913
  724240
  773599
  716992
  783618
  6858
  533779
  713300
  598474
  595440
  595423
  725167
  740085
  461424
  820385
  721322
  777041
  730623
  746067
  786765
  805722
  747435
  760935
  766802
  766839
  769833
  777551
  778900
  788198
  799998
  382132
  390805
  447101
  393550
  402222
]
2.94 ms
(1.61%)
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
  6858
  181184
  233443
  365992
  382132
  386662
  389116
  390805
  393550
  396127
  396159
  396211
  397856
  401594
  401975
  402222
  429946
  447101
  453901
  457406
  461424
  476742
  481298
  531285
  533779
  536236
  595423
  595440
  597560
  598013
  598474
  598695
  605730
  624161
  626880
  652927
  653533
  654409
  655069
  657291
  675041
  680391
  683242
  695093
  696297
  705106
  707164
  713300
  715020
  716992
  720641
  721322
  724240
  725167
  725948
  730623
  739913
  740085
  742846
  743025
  743051
  746067
  747164
  747435
  747709
  753472
  754207
  754228
  754584
  754630
  755677
  755739
  760935
  766173
  766479
  766505
  766712
  766785
  766796
  766802
  766806
  766839
  768867
  769052
  769833
  770319
  770435
  771889
  773599
  773644
  777021
  777041
  777551
  778900
  779741
  780061
  781358
  781412
  782674
  783618
  786372
  786765
  787484
  788198
  788351
  789308
  790531
  792953
  799998
  801285
  804320
  805722
  806332
  813093
  820385
  821116
  823740
  826674
  827429
  828626
]
1.99 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русский анальный секс…"
]
1.88 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал"
]
1.42 ms
(0.78%)
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.