Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.00 ms
(87.07%)
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
  466728
  466758
  467323
  468047
  487843
  489161
  508103
  510925
  514310
  523583
  524472
  524656
  526567
  529066
  532041
  533706
  533750
  537678
  537756
  540642
  569871
  570641
  574984
  584981
  588843
  592584
  592695
  594499
  596252
  597174
  605166
  606079
  606176
  608912
  611443
  616727
  617174
  621026
  622033
  623846
  630925
  636483
  665253
  697927
  703279
  707490
  709835
  720029
  726059
  726398
  727523
  730031
  731659
  733651
  736128
  738533
  738759
  739995
  740058
  744777
  745073
  745459
  747711
  749934
  750877
  756724
  757688
  757737
  757996
  758228
  758277
  758402
  759301
  760382
  760517
  760520
  760523
  760721
  760756
  761634
  761796
  761883
  763343
  766460
  768465
  768472
  770049
  775577
  776601
  777472
  781270
  782307
  782555
  782597
  783970
  784169
  786339
  790133
  790760
  791726
  791918
  792308
  795329
  796511
  797884
  797955
  797957
  798016
  798035
  799039
  800812
  802551
  802821
  802831
  804251
  809561
  809566
  810535
  811150
  811231
]
13.64 ms
(7.29%)
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
  569871
  570641
  574984
  608912
  622033
  636483
  605166
  606176
  594499
  596252
  597174
  616727
  630925
  588843
  592584
  592695
  606079
  611443
  621026
  623846
  776601
  781270
  783970
  790133
  796511
  809566
  811231
  777472
  782307
  784169
  786339
  791918
  797884
  797955
  797957
  798016
  798035
  799039
  800812
  802821
  811150
  736128
  739995
  740058
  744777
  758402
  760517
  760520
  760721
  760756
  761634
  761796
  768465
  770049
  782597
  790760
  802831
  804251
  809561
  810535
  730031
  738533
  750877
  757996
  758228
  759301
  766460
  726398
  727523
  768472
  726059
  745073
  745459
  747711
  756724
  757688
  760382
  763343
  731659
  733651
  738759
  749934
  757737
  758277
  760523
  761883
  617174
  697927
  703279
  707490
  709835
  720029
  775577
  782555
  791726
  792308
  795329
  802551
  466758
  487843
  584981
  665253
  466728
  467323
  468047
  489161
  510925
  524472
  524656
  526567
  532041
  533706
  537678
  540642
  514310
  523583
  529066
  533750
  537756
  508103
]
3.40 ms
(1.81%)
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
  466728
  466758
  467323
  468047
  487843
  489161
  508103
  510925
  514310
  523583
  524472
  524656
  526567
  529066
  532041
  533706
  533750
  537678
  537756
  540642
  569871
  570641
  574984
  584981
  588843
  592584
  592695
  594499
  596252
  597174
  605166
  606079
  606176
  608912
  611443
  616727
  617174
  621026
  622033
  623846
  630925
  636483
  665253
  697927
  703279
  707490
  709835
  720029
  726059
  726398
  727523
  730031
  731659
  733651
  736128
  738533
  738759
  739995
  740058
  744777
  745073
  745459
  747711
  749934
  750877
  756724
  757688
  757737
  757996
  758228
  758277
  758402
  759301
  760382
  760517
  760520
  760523
  760721
  760756
  761634
  761796
  761883
  763343
  766460
  768465
  768472
  770049
  775577
  776601
  777472
  781270
  782307
  782555
  782597
  783970
  784169
  786339
  790133
  790760
  791726
  791918
  792308
  795329
  796511
  797884
  797955
  797957
  798016
  798035
  799039
  800812
  802551
  802821
  802831
  804251
  809561
  809566
  810535
  811150
  811231
]
2.21 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с разговорам"
]
1.75 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "разговор"
]
1.48 ms
(0.79%)
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.