Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.93 ms
(85.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
  82710
  98040
  384047
  402948
  443436
  461239
  470694
  495308
  507098
  525368
  530563
  531662
  533914
  534697
  542302
  547689
  553587
  555247
  590114
  591000
  591030
  591489
  591542
  593821
  595898
  596953
  600940
  602316
  602432
  609347
  609768
  610743
  613137
  613294
  614732
  614886
  615411
  616039
  617327
  617841
  619299
  621393
  621827
  626362
  630941
  631222
  640478
  641367
  642274
  642291
  642317
  643522
  644049
  647915
  652997
  656566
  660979
  666933
  670588
  676853
  677919
  680358
  685528
  689228
  689402
  689545
  689784
  692833
  693392
  694931
  697387
  697757
  700689
  701457
  702128
  702258
  702373
  702641
  703480
  703941
  704113
  705306
  705408
  705861
  707595
  708164
  709374
  710498
  710563
  710864
  712467
  713459
  713997
  714423
  716963
  725273
  725275
  734334
  738376
  739459
  747532
  766344
  778233
  782122
  782169
  789075
  789649
  791234
  795357
  796764
  807248
  816127
  818173
  819754
  820084
  824311
  824626
  827084
  828499
  828588
]
12.17 ms
(8.42%)
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
  689228
  694931
  697757
  703480
  666933
  676853
  689784
  692833
  701457
  703941
  705306
  709374
  710563
  712467
  713997
  652997
  656566
  660979
  670588
  677919
  685528
  689402
  689545
  702128
  702641
  705861
  708164
  710864
  593821
  609768
  616039
  617327
  621393
  626362
  590114
  595898
  615411
  617841
  621827
  642274
  642291
  644049
  591030
  610743
  614886
  619299
  631222
  640478
  643522
  591000
  591489
  591542
  596953
  600940
  613294
  614732
  641367
  642317
  782169
  734334
  739459
  602316
  609347
  613137
  630941
  697387
  700689
  702258
  702373
  704113
  705408
  707595
  713459
  714423
  470694
  525368
  82710
  602432
  530563
  818173
  533914
  531662
  534697
  461239
  542302
  555247
  680358
  693392
  647915
  553587
  778233
  791234
  725273
  782122
  789075
  789649
  725275
  747532
  710498
  402948
  443436
  495308
  507098
  384047
  828588
  828499
  547689
  796764
  795357
  716963
  807248
  738376
  766344
  98040
  819754
  820084
  824311
  824626
  827084
  816127
]
3.00 ms
(2.08%)
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
  82710
  98040
  384047
  402948
  443436
  461239
  470694
  495308
  507098
  525368
  530563
  531662
  533914
  534697
  542302
  547689
  553587
  555247
  590114
  591000
  591030
  591489
  591542
  593821
  595898
  596953
  600940
  602316
  602432
  609347
  609768
  610743
  613137
  613294
  614732
  614886
  615411
  616039
  617327
  617841
  619299
  621393
  621827
  626362
  630941
  631222
  640478
  641367
  642274
  642291
  642317
  643522
  644049
  647915
  652997
  656566
  660979
  666933
  670588
  676853
  677919
  680358
  685528
  689228
  689402
  689545
  689784
  692833
  693392
  694931
  697387
  697757
  700689
  701457
  702128
  702258
  702373
  702641
  703480
  703941
  704113
  705306
  705408
  705861
  707595
  708164
  709374
  710498
  710563
  710864
  712467
  713459
  713997
  714423
  716963
  725273
  725275
  734334
  738376
  739459
  747532
  766344
  778233
  782122
  782169
  789075
  789649
  791234
  795357
  796764
  807248
  816127
  818173
  819754
  820084
  824311
  824626
  827084
  828499
  828588
]
1.76 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домохозяйки частное видео"
]
1.60 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домохозяйк любительск виде"
]
1.48 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домохозяйк любительск виде"
]
1.47 ms
(1.02%)
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.