Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
232.10 ms
(91.25%)
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
  109176
  210576
  397424
  398436
  408532
  452067
  461360
  463239
  469101
  469503
  476971
  486044
  487872
  494281
  494870
  499285
  505591
  508648
  515774
  525771
  530638
  534862
  545768
  547070
  547763
  549951
  552861
  554837
  563408
  564860
  566912
  569530
  574656
  575257
  579523
  581028
  584014
  588302
  588549
  589374
  589580
  589799
  599768
  605290
  609653
  609918
  616276
  623710
  625597
  626824
  628772
  633563
  641479
  644854
  644974
  651075
  652451
  660279
  660441
  661356
  666476
  692437
  694704
  695652
  695980
  695997
  696009
  696061
  696103
  696776
  697917
  702506
  706642
  708297
  709517
  709855
  711320
  716339
  722020
  723383
  728188
  729567
  736924
  741582
  747634
  750686
  755737
  757569
  759313
  770164
  778925
  780649
  780742
  780884
  781930
  783535
  783750
  789033
  792990
  797854
  798918
  799010
  800663
  802023
  802816
  804271
  804881
  810644
  810757
  812669
  813612
  813802
  820475
  828036
  828046
  828047
  828050
  828098
  828376
]
12.28 ms
(4.83%)
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
  633563
  706642
  709855
  780884
  799010
  800663
  398436
  716339
  692437
  554837
  651075
  723383
  605290
  759313
  505591
  534862
  564860
  487872
  828046
  828098
  828376
  828047
  549951
  626824
  588302
  802023
  210576
  494281
  581028
  652451
  696776
  722020
  616276
  588549
  589799
  628772
  589580
  798918
  729567
  750686
  757569
  770164
  609918
  711320
  781930
  783535
  797854
  804271
  810644
  566912
  452067
  515774
  525771
  508648
  494870
  476971
  569530
  545768
  660441
  660279
  661356
  584014
  609653
  599768
  810757
  702506
  109176
  469101
  575257
  828050
  828036
  827995
  397424
  408532
  644854
  644974
  813612
  813802
  820475
  469503
  486044
  461360
  463239
  499285
  530638
  552861
  579523
  547763
  547070
  574656
  695652
  695980
  695997
  696009
  696061
  696103
  709517
  666476
  694704
  697917
  708297
  563408
  623710
  641479
  625597
  589374
  778925
  789033
  792990
  802816
  804881
  812669
  780649
  780742
  736924
  755737
  783750
  728188
  741582
  747634
]
2.74 ms
(1.08%)
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
  109176
  210576
  397424
  398436
  408532
  452067
  461360
  463239
  469101
  469503
  476971
  486044
  487872
  494281
  494870
  499285
  505591
  508648
  515774
  525771
  530638
  534862
  545768
  547070
  547763
  549951
  552861
  554837
  563408
  564860
  566912
  569530
  574656
  575257
  579523
  581028
  584014
  588302
  588549
  589374
  589580
  589799
  599768
  605290
  609653
  609918
  616276
  623710
  625597
  626824
  628772
  633563
  641479
  644854
  644974
  651075
  652451
  660279
  660441
  661356
  666476
  692437
  694704
  695652
  695980
  695997
  696009
  696061
  696103
  696776
  697917
  702506
  706642
  708297
  709517
  709855
  711320
  716339
  722020
  723383
  728188
  729567
  736924
  741582
  747634
  750686
  755737
  757569
  759313
  770164
  778925
  780649
  780742
  780884
  781930
  783535
  783750
  789033
  792990
  797854
  798918
  799010
  800663
  802023
  802816
  804271
  804881
  810644
  810757
  812669
  813612
  813802
  820475
  828036
  828046
  828047
  828050
  828098
  828376
]
2.20 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx на улиц"
]
2.05 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx public"
]
1.52 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx на улиц"
]

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.