Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.17 ms
(84.73%)
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
  388712
  395711
  397361
  400857
  409097
  419113
  420398
  425028
  425588
  425945
  425967
  429985
  431133
  432236
  432869
  434624
  438851
  443600
  443652
  445742
  445879
  453511
  463059
  463094
  464129
  470344
  472693
  474167
  478453
  483081
  484161
  484977
  485773
  487920
  489674
  494036
  494260
  494717
  494731
  494752
  494980
  495740
  499878
  502092
  502436
  502743
  507528
  512203
  515137
  516775
  517750
  521772
  534293
  534664
  535269
  536726
  538973
  540952
  543107
  546106
  550325
  550689
  551111
  552043
  554539
  557161
  558522
  559692
  560169
  562337
  562882
  565542
  566028
  567149
  568835
  572811
  575176
  576343
  581665
  582617
  584382
  587757
  591109
  591190
  592320
  595011
  595944
  603643
  610290
  614430
  615015
  619423
  641901
  653377
  663370
  665121
  669695
  669738
  676117
  677974
  684910
  719343
  724425
  725607
  732061
  739557
  748255
  749981
  750445
  770824
  784315
  804771
  807407
  807687
  808467
  811090
  811845
  814808
  814923
  823198
]
17.86 ms
(9.69%)
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
  535269
  494752
  550689
  562337
  566028
  572811
  591109
  610290
  804771
  725607
  495740
  502092
  395711
  397361
  425967
  484161
  485773
  494717
  512203
  487920
  575176
  663370
  676117
  560169
  595944
  770824
  739557
  641901
  453511
  478453
  463094
  507528
  515137
  814923
  445742
  502743
  536726
  546106
  551111
  592320
  614430
  807407
  807687
  724425
  732061
  749981
  474167
  431133
  483081
  814808
  823198
  516775
  557161
  567149
  584382
  576343
  603643
  750445
  811090
  748255
  420398
  521772
  502436
  534293
  665121
  808467
  409097
  568835
  552043
  615015
  425588
  388712
  565542
  494036
  499878
  438851
  494980
  538973
  811845
  429985
  443600
  472693
  562882
  653377
  669695
  595011
  784315
  425028
  443652
  543107
  554539
  669738
  582617
  419113
  432236
  470344
  494731
  425945
  445879
  494260
  534664
  581665
  591190
  587757
  619423
  400857
  432869
  463059
  489674
  484977
  434624
  464129
  517750
  558522
  559692
  540952
  550325
  677974
  684910
  719343
]
4.01 ms
(2.18%)
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
  388712
  395711
  397361
  400857
  409097
  419113
  420398
  425028
  425588
  425945
  425967
  429985
  431133
  432236
  432869
  434624
  438851
  443600
  443652
  445742
  445879
  453511
  463059
  463094
  464129
  470344
  472693
  474167
  478453
  483081
  484161
  484977
  485773
  487920
  489674
  494036
  494260
  494717
  494731
  494752
  494980
  495740
  499878
  502092
  502436
  502743
  507528
  512203
  515137
  516775
  517750
  521772
  534293
  534664
  535269
  536726
  538973
  540952
  543107
  546106
  550325
  550689
  551111
  552043
  554539
  557161
  558522
  559692
  560169
  562337
  562882
  565542
  566028
  567149
  568835
  572811
  575176
  576343
  581665
  582617
  584382
  587757
  591109
  591190
  592320
  595011
  595944
  603643
  610290
  614430
  615015
  619423
  641901
  653377
  663370
  665121
  669695
  669738
  676117
  677974
  684910
  719343
  724425
  725607
  732061
  739557
  748255
  749981
  750445
  770824
  784315
  804771
  807407
  807687
  808467
  811090
  811845
  814808
  814923
  823198
]
1.82 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс в очках"
]
1.72 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс очкастые"
]
1.25 ms
(0.68%)
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.