Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.88 ms
(86.50%)
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
  58516
  91578
  169962
  220769
  263788
  330764
  365381
  381822
  388124
  398515
  405551
  409134
  415107
  425638
  428382
  428784
  443655
  444412
  448314
  451602
  453916
  457150
  457169
  461221
  465745
  466664
  467133
  469159
  471593
  473168
  476387
  476744
  477574
  477582
  480066
  486485
  487144
  488212
  488286
  488565
  489003
  490462
  491641
  491719
  494734
  496800
  497661
  499968
  501306
  505236
  505986
  508836
  510617
  512665
  512688
  513281
  513290
  513541
  518263
  518397
  521928
  522535
  522833
  523510
  524007
  524178
  525640
  525925
  527511
  527517
  527549
  527620
  533157
  540482
  544683
  546015
  551196
  551640
  565361
  565372
  565414
  565551
  565561
  566810
  570030
  570233
  570299
  570620
  570639
  570644
  570661
  571546
  571884
  572499
  572520
  572522
  575117
  575499
  575512
  578059
  578068
  605318
  611820
  611900
  638647
  669609
  669643
  671409
  672402
  685926
  690480
  691607
  723878
  725563
  729441
  741175
  748200
  753907
  769139
  820677
]
15.42 ms
(8.09%)
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
  525640
  501306
  513281
  523510
  611820
  443655
  444412
  486485
  476744
  499968
  513541
  466664
  469159
  565361
  570030
  575499
  575512
  578068
  565551
  571884
  551640
  570620
  578059
  565372
  565414
  565561
  570644
  575117
  451602
  457169
  480066
  428784
  457150
  471593
  476387
  425638
  473168
  428382
  512665
  513290
  524007
  527620
  488286
  491641
  491719
  505986
  518397
  521928
  489003
  518263
  524178
  540482
  488212
  505236
  508836
  510617
  527549
  611900
  570661
  546015
  572520
  453916
  465745
  490462
  487144
  605318
  58516
  533157
  729441
  522535
  91578
  398515
  409134
  820677
  488565
  669609
  723878
  725563
  753907
  769139
  741175
  748200
  381822
  263788
  527511
  544683
  467133
  497661
  477582
  570639
  671409
  672402
  691607
  638647
  388124
  365381
  572499
  570233
  669643
  496800
  448314
  461221
  566810
  220769
  330764
  405551
  512688
  527517
  551196
  570299
  571546
  690480
  685926
  572522
  477574
  415107
  525925
  522833
  169962
  494734
]
2.90 ms
(1.52%)
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
  58516
  91578
  169962
  220769
  263788
  330764
  365381
  381822
  388124
  398515
  405551
  409134
  415107
  425638
  428382
  428784
  443655
  444412
  448314
  451602
  453916
  457150
  457169
  461221
  465745
  466664
  467133
  469159
  471593
  473168
  476387
  476744
  477574
  477582
  480066
  486485
  487144
  488212
  488286
  488565
  489003
  490462
  491641
  491719
  494734
  496800
  497661
  499968
  501306
  505236
  505986
  508836
  510617
  512665
  512688
  513281
  513290
  513541
  518263
  518397
  521928
  522535
  522833
  523510
  524007
  524178
  525640
  525925
  527511
  527517
  527549
  527620
  533157
  540482
  544683
  546015
  551196
  551640
  565361
  565372
  565414
  565551
  565561
  566810
  570030
  570233
  570299
  570620
  570639
  570644
  570661
  571546
  571884
  572499
  572520
  572522
  575117
  575499
  575512
  578059
  578068
  605318
  611820
  611900
  638647
  669609
  669643
  671409
  672402
  685926
  690480
  691607
  723878
  725563
  729441
  741175
  748200
  753907
  769139
  820677
]
2.04 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в пикап"
]
2.03 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в пикапе"
]
1.58 ms
(0.83%)
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.