Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.22 ms
(85.67%)
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
  559753
  560132
  566911
  575675
  578926
  584199
  584741
  585275
  585569
  585755
  587711
  587729
  587943
  588095
  588557
  588609
  588767
  588861
  589203
  590173
  590206
  590472
  590492
  590916
  590917
  591160
  591189
  591329
  591539
  591641
  591907
  592093
  592591
  592788
  592793
  592900
  593068
  593191
  593793
  593910
  593977
  594024
  594030
  594095
  594166
  595046
  595634
  595715
  595883
  596530
  596945
  596999
  597031
  597145
  597581
  597672
  597713
  597807
  598230
  598462
  598914
  598965
  599783
  600476
  600487
  600488
  600737
  600768
  601067
  601498
  601543
  602450
  602509
  602652
  602701
  603019
  603181
  603261
  603363
  603398
  604434
  604490
  604720
  604754
  604802
  605118
  605619
  605887
  606008
  607359
  607830
  609436
  610074
  611351
  613810
  615284
  615488
  615924
  616012
  616822
  616824
  617122
  617441
  619059
  620531
  622103
  622317
  623288
  624768
  625089
  626287
  626858
  627706
  629855
  632734
  634276
  634468
  635697
  636819
  644359
]
13.60 ms
(8.02%)
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
  559753
  560132
  566911
  575675
  578926
  584199
  584741
  585275
  585569
  588095
  591641
  592591
  595046
  595634
  597581
  598965
  600737
  602652
  605619
  606008
  607830
  610074
  615284
  616822
  617122
  622103
  624768
  634468
  636819
  585755
  587943
  588767
  588861
  590472
  590916
  591189
  591539
  591907
  592793
  593068
  593191
  593977
  597713
  597807
  598462
  600768
  601498
  602450
  602509
  602701
  604434
  604490
  604720
  611351
  615924
  616012
  619059
  632734
  634276
  644359
  589203
  590173
  590492
  590917
  591160
  591329
  593910
  594030
  594166
  595715
  597145
  598230
  598914
  600476
  600487
  601067
  603019
  603261
  603363
  603398
  604754
  604802
  605118
  607359
  616824
  620531
  623288
  625089
  626287
  626858
  627706
  629855
  635697
  587711
  587729
  588557
  588609
  590206
  592093
  592788
  592900
  593793
  594024
  594095
  595883
  596530
  596945
  596999
  597031
  597672
  599783
  600488
  601543
  603181
  605887
  609436
  613810
  615488
  617441
  622317
]
2.63 ms
(1.55%)
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
  559753
  560132
  566911
  575675
  578926
  584199
  584741
  585275
  585569
  585755
  587711
  587729
  587943
  588095
  588557
  588609
  588767
  588861
  589203
  590173
  590206
  590472
  590492
  590916
  590917
  591160
  591189
  591329
  591539
  591641
  591907
  592093
  592591
  592788
  592793
  592900
  593068
  593191
  593793
  593910
  593977
  594024
  594030
  594095
  594166
  595046
  595634
  595715
  595883
  596530
  596945
  596999
  597031
  597145
  597581
  597672
  597713
  597807
  598230
  598462
  598914
  598965
  599783
  600476
  600487
  600488
  600737
  600768
  601067
  601498
  601543
  602450
  602509
  602652
  602701
  603019
  603181
  603261
  603363
  603398
  604434
  604490
  604720
  604754
  604802
  605118
  605619
  605887
  606008
  607359
  607830
  609436
  610074
  611351
  613810
  615284
  615488
  615924
  616012
  616822
  616824
  617122
  617441
  619059
  620531
  622103
  622317
  623288
  624768
  625089
  626287
  626858
  627706
  629855
  632734
  634276
  634468
  635697
  636819
  644359
]
2.14 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сосет и дрочит"
]
2.11 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сосет дрочк"
]
2.05 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.04%)
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.