Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.30 ms
(52.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скачет"
]
173.80 ms
(42.02%)
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
  467701
  469810
  471477
  476891
  482154
  485191
  490386
  495334
  497682
  502544
  503851
  507401
  510346
  512632
  516816
  520242
  527743
  530315
  534489
  534901
  534983
  535082
  535613
  538671
  538880
  539583
  539858
  540865
  542131
  542296
  543961
  547300
  548274
  548408
  549060
  549381
  549419
  549953
  550537
  553889
  556384
  556761
  556930
  557723
  559709
  560251
  560351
  560369
  561496
  562611
  562630
  564364
  567430
  567940
  568280
  569379
  570772
  572301
  572475
  576542
  576774
  580802
  584003
  584047
  585840
  586216
  587026
  587044
  587060
  589702
  591994
  592271
  594170
  594639
  595110
  595266
  595469
  595705
  596995
  597544
  598017
  599508
  599619
  600119
  600912
  604034
  608344
  608780
  615265
  622354
  635055
  649023
  652722
  654031
  656874
  656879
  657104
  657426
  658669
  659221
  659587
  660022
  660384
  660650
  661258
  663941
  665235
  665290
  665352
  665408
  667312
  667339
  670584
  670645
  679000
  688407
  689325
  813713
  814133
  814955
]
15.04 ms
(3.64%)
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
  540865
  814133
  813713
  814955
  467701
  469810
  471477
  476891
  485191
  497682
  502544
  503851
  539583
  507401
  516816
  520242
  530315
  534983
  535613
  538880
  495334
  527743
  534489
  534901
  538671
  510346
  512632
  535082
  539858
  482154
  490386
  542131
  549060
  553889
  557723
  560351
  562611
  567940
  568280
  576542
  580802
  584047
  542296
  547300
  549381
  550537
  556384
  556930
  559709
  560369
  562630
  572301
  572475
  543961
  548274
  548408
  549953
  560251
  561496
  567430
  569379
  570772
  576774
  654031
  656874
  659587
  660384
  660650
  661258
  665408
  688407
  689325
  649023
  652722
  656879
  657104
  657426
  658669
  663941
  665235
  665352
  670584
  659221
  660022
  665290
  667312
  667339
  670645
  679000
  549419
  556761
  564364
  584003
  586216
  589702
  594639
  598017
  599619
  600912
  608780
  615265
  622354
  635055
  587026
  587044
  591994
  595110
  595469
  595705
  608344
  587060
  592271
  596995
  599508
  600119
  604034
  585840
  594170
  595266
  597544
]
3.04 ms
(0.73%)
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
  467701
  469810
  471477
  476891
  482154
  485191
  490386
  495334
  497682
  502544
  503851
  507401
  510346
  512632
  516816
  520242
  527743
  530315
  534489
  534901
  534983
  535082
  535613
  538671
  538880
  539583
  539858
  540865
  542131
  542296
  543961
  547300
  548274
  548408
  549060
  549381
  549419
  549953
  550537
  553889
  556384
  556761
  556930
  557723
  559709
  560251
  560351
  560369
  561496
  562611
  562630
  564364
  567430
  567940
  568280
  569379
  570772
  572301
  572475
  576542
  576774
  580802
  584003
  584047
  585840
  586216
  587026
  587044
  587060
  589702
  591994
  592271
  594170
  594639
  595110
  595266
  595469
  595705
  596995
  597544
  598017
  599508
  599619
  600119
  600912
  604034
  608344
  608780
  615265
  622354
  635055
  649023
  652722
  654031
  656874
  656879
  657104
  657426
  658669
  659221
  659587
  660022
  660384
  660650
  661258
  663941
  665235
  665290
  665352
  665408
  667312
  667339
  670584
  670645
  679000
  688407
  689325
  813713
  814133
  814955
]
2.12 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хорошо скачет"
]
1.87 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.36%)
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.