Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.19 ms
(86.64%)
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
  132836
  229361
  386548
  397876
  400311
  402141
  413140
  413507
  415860
  415875
  418512
  422017
  429353
  446405
  449112
  460056
  462170
  463661
  473928
  476452
  478787
  485818
  489156
  491658
  492384
  492661
  493080
  493934
  496419
  499050
  500745
  501227
  513054
  513613
  515296
  520492
  522461
  527507
  527526
  529820
  531588
  533464
  533708
  537791
  544880
  549415
  552212
  553775
  553776
  558655
  574144
  577900
  579204
  587091
  589181
  589218
  590334
  590830
  593999
  594108
  594339
  595077
  603145
  603542
  603925
  608091
  609649
  618432
  619774
  620967
  622068
  622540
  623932
  623960
  624078
  639960
  644404
  648360
  650731
  650765
  671077
  676491
  676495
  676517
  676521
  677041
  685892
  703708
  706465
  709179
  723368
  727335
  732167
  736967
  744840
  746935
  747481
  748634
  756074
  757098
  765448
  767308
  770984
  778514
  778595
  778833
  782737
  784994
  785288
  786344
  786458
  789166
  789876
  792441
  795120
  806031
  806672
  807967
  810271
  814019
]
17.29 ms
(8.60%)
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
  492661
  493080
  496419
  513054
  513613
  515296
  537791
  473928
  478787
  499050
  501227
  463661
  462170
  491658
  520492
  492384
  402141
  397876
  619774
  603145
  732167
  770984
  644404
  400311
  415860
  413507
  476452
  709179
  603542
  778595
  418512
  413140
  522461
  609649
  622068
  623932
  806031
  807967
  789876
  765448
  748634
  229361
  814019
  446405
  531588
  558655
  671077
  608091
  590830
  622540
  623960
  786458
  757098
  795120
  746935
  723368
  429353
  386548
  132836
  422017
  415875
  460056
  485818
  449112
  489156
  533708
  500745
  527507
  527526
  533464
  529820
  493934
  579204
  553776
  577900
  552212
  650731
  676491
  676517
  677041
  706465
  648360
  650765
  676521
  685892
  703708
  676495
  544880
  549415
  553775
  574144
  593999
  594108
  594339
  624078
  587091
  590334
  639960
  603925
  620967
  589181
  589218
  595077
  618432
  778514
  782737
  810271
  778833
  784994
  786344
  727335
  736967
  744840
  767308
  785288
  789166
  792441
  806672
  747481
  756074
]
2.93 ms
(1.46%)
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
  132836
  229361
  386548
  397876
  400311
  402141
  413140
  413507
  415860
  415875
  418512
  422017
  429353
  446405
  449112
  460056
  462170
  463661
  473928
  476452
  478787
  485818
  489156
  491658
  492384
  492661
  493080
  493934
  496419
  499050
  500745
  501227
  513054
  513613
  515296
  520492
  522461
  527507
  527526
  529820
  531588
  533464
  533708
  537791
  544880
  549415
  552212
  553775
  553776
  558655
  574144
  577900
  579204
  587091
  589181
  589218
  590334
  590830
  593999
  594108
  594339
  595077
  603145
  603542
  603925
  608091
  609649
  618432
  619774
  620967
  622068
  622540
  623932
  623960
  624078
  639960
  644404
  648360
  650731
  650765
  671077
  676491
  676495
  676517
  676521
  677041
  685892
  703708
  706465
  709179
  723368
  727335
  732167
  736967
  744840
  746935
  747481
  748634
  756074
  757098
  765448
  767308
  770984
  778514
  778595
  778833
  782737
  784994
  785288
  786344
  786458
  789166
  789876
  792441
  795120
  806031
  806672
  807967
  810271
  814019
]
2.10 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18летней ира ростов"
]
1.77 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 ир 19 рост лет"
]
1.21 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 ир 19 рост лет"
]

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.