Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.34 ms
(85.36%)
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
  6640
  24993
  25650
  34593
  124308
  187643
  187986
  188129
  188610
  213598
  289778
  359102
  381958
  382398
  386037
  387490
  389829
  389840
  392013
  392181
  392672
  393621
  398559
  398932
  400493
  407782
  409939
  411765
  418059
  421891
  422345
  424248
  428142
  433388
  439778
  440222
  441782
  441788
  443626
  450243
  454184
  454440
  462183
  464019
  465133
  465518
  472679
  474123
  475883
  476494
  478377
  478411
  480497
  484654
  486578
  490707
  492972
  495157
  506866
  507281
  516028
  516469
  517696
  524134
  527919
  536431
  549836
  554466
  566777
  582001
  584395
  590464
  599502
  603023
  604332
  610005
  646929
  664956
  665195
  665873
  698154
  705705
  714936
  725204
  726788
  728643
  729923
  731030
  731751
  734605
  735880
  735905
  735954
  735984
  739923
  740891
  742633
  746604
  749891
  750159
  754704
  758298
  770152
  794830
  795101
  796899
  800932
  803896
  805634
  810134
  823739
  824584
  824763
  825164
  825400
  826691
  827408
  827619
  828219
  828485
]
13.67 ms
(8.75%)
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
  382398
  381958
  424248
  462183
  584395
  549836
  554466
  422345
  480497
  389840
  400493
  478377
  507281
  536431
  486578
  124308
  289778
  825400
  827619
  828219
  828485
  582001
  603023
  803896
  734605
  725204
  731030
  735984
  735905
  749891
  754704
  728643
  735954
  800932
  389829
  492972
  516469
  475883
  428142
  398559
  439778
  440222
  454440
  472679
  433388
  506866
  187643
  566777
  664956
  665195
  714936
  646929
  665873
  610005
  729923
  758298
  735880
  731751
  746604
  740891
  795101
  796899
  490707
  805634
  465133
  24993
  517696
  527919
  392181
  34593
  6640
  441782
  441788
  465518
  478411
  464019
  590464
  742633
  810134
  726788
  705705
  476494
  393621
  392013
  409939
  418059
  824584
  484654
  454184
  474123
  794830
  750159
  770152
  188129
  407782
  411765
  392672
  188610
  359102
  386037
  187986
  443626
  450243
  524134
  495157
  604332
  599502
  739923
  698154
  387490
  398932
  421891
  516028
  213598
  25650
  823739
  826691
  827408
  824763
  825164
]
2.60 ms
(1.66%)
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
  6640
  24993
  25650
  34593
  124308
  187643
  187986
  188129
  188610
  213598
  289778
  359102
  381958
  382398
  386037
  387490
  389829
  389840
  392013
  392181
  392672
  393621
  398559
  398932
  400493
  407782
  409939
  411765
  418059
  421891
  422345
  424248
  428142
  433388
  439778
  440222
  441782
  441788
  443626
  450243
  454184
  454440
  462183
  464019
  465133
  465518
  472679
  474123
  475883
  476494
  478377
  478411
  480497
  484654
  486578
  490707
  492972
  495157
  506866
  507281
  516028
  516469
  517696
  524134
  527919
  536431
  549836
  554466
  566777
  582001
  584395
  590464
  599502
  603023
  604332
  610005
  646929
  664956
  665195
  665873
  698154
  705705
  714936
  725204
  726788
  728643
  729923
  731030
  731751
  734605
  735880
  735905
  735954
  735984
  739923
  740891
  742633
  746604
  749891
  750159
  754704
  758298
  770152
  794830
  795101
  796899
  800932
  803896
  805634
  810134
  823739
  824584
  824763
  825164
  825400
  826691
  827408
  827619
  828219
  828485
]
1.81 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature chubby doggy"
]
1.76 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature chubby рак"
]
1.55 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature chubby рак"
]
1.49 ms
(0.95%)
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.