Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.59 ms
(86.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
  26468
  29280
  30310
  131462
  383547
  389661
  391301
  396139
  396881
  398247
  401334
  402252
  404120
  407279
  414201
  418741
  419464
  420549
  421914
  424186
  425857
  427912
  432696
  439049
  442518
  443968
  444326
  446346
  446777
  446900
  446986
  461428
  462763
  464913
  464927
  472614
  472940
  478656
  483466
  488080
  488902
  489230
  495602
  496293
  496829
  497270
  499027
  499047
  500271
  502299
  508825
  509860
  511259
  511357
  511794
  514111
  514931
  515672
  517676
  519446
  519479
  521094
  521402
  522989
  523362
  523513
  532334
  534402
  534463
  535309
  535539
  537391
  540475
  542099
  545221
  549090
  549787
  551723
  552844
  566369
  567057
  569193
  571948
  573428
  574630
  579011
  580928
  583513
  585175
  588224
  589793
  590041
  591565
  592371
  592840
  596996
  601643
  603997
  605211
  609747
  618619
  619541
  620701
  625326
  633569
  636323
  643624
  647951
  652577
  656470
  663695
  677147
  685613
  687466
  691209
  710912
  712667
  750843
  750860
  812638
]
13.05 ms
(7.74%)
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
  489230
  515672
  535539
  30310
  750860
  396881
  414201
  418741
  432696
  427912
  444326
  542099
  532334
  535309
  508825
  511259
  534463
  500271
  517676
  519479
  522989
  537391
  499027
  511794
  540475
  464913
  549090
  573428
  583513
  545221
  569193
  647951
  652577
  677147
  685613
  691209
  549787
  574630
  579011
  603997
  589793
  618619
  620701
  636323
  591565
  592840
  601643
  421914
  424186
  442518
  420549
  446986
  26468
  131462
  566369
  663695
  619541
  750843
  633569
  710912
  712667
  812638
  29280
  389661
  383547
  398247
  402252
  407279
  425857
  419464
  478656
  472614
  464927
  521094
  523362
  534402
  495602
  488080
  488902
  571948
  580928
  552844
  687466
  656470
  551723
  567057
  585175
  605211
  625326
  643624
  590041
  596996
  609747
  592371
  588224
  391301
  396139
  404120
  446777
  446346
  461428
  462763
  401334
  439049
  443968
  472940
  502299
  509860
  499047
  511357
  521402
  523513
  496293
  483466
  514111
  519446
  446900
  496829
  514931
  497270
]
2.83 ms
(1.68%)
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
  26468
  29280
  30310
  131462
  383547
  389661
  391301
  396139
  396881
  398247
  401334
  402252
  404120
  407279
  414201
  418741
  419464
  420549
  421914
  424186
  425857
  427912
  432696
  439049
  442518
  443968
  444326
  446346
  446777
  446900
  446986
  461428
  462763
  464913
  464927
  472614
  472940
  478656
  483466
  488080
  488902
  489230
  495602
  496293
  496829
  497270
  499027
  499047
  500271
  502299
  508825
  509860
  511259
  511357
  511794
  514111
  514931
  515672
  517676
  519446
  519479
  521094
  521402
  522989
  523362
  523513
  532334
  534402
  534463
  535309
  535539
  537391
  540475
  542099
  545221
  549090
  549787
  551723
  552844
  566369
  567057
  569193
  571948
  573428
  574630
  579011
  580928
  583513
  585175
  588224
  589793
  590041
  591565
  592371
  592840
  596996
  601643
  603997
  605211
  609747
  618619
  619541
  620701
  625326
  633569
  636323
  643624
  647951
  652577
  656470
  663695
  677147
  685613
  687466
  691209
  710912
  712667
  750843
  750860
  812638
]
1.89 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волос рак"
]
1.85 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "волосы раком"
]
1.69 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.95%)
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.