Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.46 ms
(54.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск разговор"
]
156.21 ms
(39.49%)
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
  420486
  432173
  439655
  452978
  456196
  460760
  462032
  467198
  476383
  482843
  483993
  486190
  488703
  500055
  502748
  506223
  506227
  506246
  508744
  510249
  513490
  513501
  513614
  513616
  516492
  518822
  519357
  519738
  521415
  522446
  522447
  523595
  523933
  525233
  527858
  542711
  544459
  544971
  547450
  547796
  551168
  551210
  552359
  554565
  558115
  560018
  562192
  565004
  565007
  565008
  568965
  569588
  569843
  569902
  570290
  571393
  571584
  571929
  572074
  573973
  574035
  575265
  575516
  578026
  578031
  578054
  579879
  582548
  587709
  596169
  596588
  598493
  603603
  605011
  610376
  611932
  613380
  619947
  621386
  652892
  655407
  655704
  657056
  672842
  672897
  674288
  677222
  677407
  680650
  684679
  688967
  690478
  692651
  706851
  713004
  716852
  719461
  722266
  722655
  728453
  733672
  740051
  741011
  742643
  744380
  744860
  764179
  768462
  768739
  769017
  769452
  771289
  779823
  780514
  787973
  797765
  799688
  799725
  803035
  810187
]
14.52 ms
(3.67%)
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
  500055
  508744
  519357
  569843
  562192
  573973
  655704
  657056
  690478
  722266
  680650
  692651
  713004
  551210
  603603
  613380
  619947
  779823
  797765
  799688
  780514
  740051
  810187
  744380
  764179
  768462
  768739
  769017
  771289
  605011
  787973
  799725
  439655
  462032
  488703
  621386
  596588
  420486
  522446
  486190
  506223
  506246
  513501
  516492
  518822
  522447
  452978
  560018
  565004
  569588
  544971
  551168
  570290
  571393
  572074
  672897
  722655
  688967
  610376
  611932
  596169
  803035
  741011
  742643
  769452
  733672
  744860
  728453
  476383
  482843
  552359
  568965
  547796
  574035
  544459
  565007
  578026
  578031
  579879
  587709
  460760
  456196
  523933
  513490
  513614
  483993
  510249
  519738
  525233
  565008
  575265
  432173
  502748
  506227
  513616
  521415
  527858
  467198
  523595
  547450
  554565
  571929
  575516
  578054
  582548
  542711
  558115
  569902
  652892
  674288
  677407
  706851
  677222
  716852
  655407
  672842
  684679
  719461
  571584
  598493
]
3.06 ms
(0.77%)
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
  420486
  432173
  439655
  452978
  456196
  460760
  462032
  467198
  476383
  482843
  483993
  486190
  488703
  500055
  502748
  506223
  506227
  506246
  508744
  510249
  513490
  513501
  513614
  513616
  516492
  518822
  519357
  519738
  521415
  522446
  522447
  523595
  523933
  525233
  527858
  542711
  544459
  544971
  547450
  547796
  551168
  551210
  552359
  554565
  558115
  560018
  562192
  565004
  565007
  565008
  568965
  569588
  569843
  569902
  570290
  571393
  571584
  571929
  572074
  573973
  574035
  575265
  575516
  578026
  578031
  578054
  579879
  582548
  587709
  596169
  596588
  598493
  603603
  605011
  610376
  611932
  613380
  619947
  621386
  652892
  655407
  655704
  657056
  672842
  672897
  674288
  677222
  677407
  680650
  684679
  688967
  690478
  692651
  706851
  713004
  716852
  719461
  722266
  722655
  728453
  733672
  740051
  741011
  742643
  744380
  744860
  764179
  768462
  768739
  769017
  769452
  771289
  779823
  780514
  787973
  797765
  799688
  799725
  803035
  810187
]
2.10 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русских разговоров"
]
1.75 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.38%)
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.