Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.76 ms
(49.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mofos sex"
]
188.62 ms
(44.85%)
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
  820405
  820504
  820525
  820533
  820534
  820541
  820558
  820570
  820582
  820598
  820615
  820642
  820660
  820677
  820792
  820855
  820856
  820896
  820920
  820930
  820966
  820968
  821015
  821030
  821037
  821061
  821121
  821124
  821143
  821168
  821192
  821198
  821251
  821294
  821304
  821308
  821326
  821414
  821430
  821448
  821453
  821493
  821565
  821566
  821582
  821600
  821601
  821619
  821663
  821679
  821684
  821704
  821711
  821724
  821736
  821752
  821977
  822005
  822215
  822217
  822239
  822262
  822269
  822285
  822292
  822310
  822492
  822499
  822545
  822582
  822621
  822675
  822704
  822714
  822791
  822812
  822814
  822867
  822881
  822883
  822896
  822919
  822965
  823010
  823013
  823016
  823031
  823036
  823038
  823039
  823047
  823082
  823106
  823109
  823111
  823114
  823119
  823123
  823128
  823129
  823130
  823133
  823137
  823140
  823143
  823146
  823208
  823286
  823289
  823302
  823379
  823399
  823432
  823507
]
14.90 ms
(3.54%)
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
  823123
  823133
  823379
  820920
  820598
  820968
  823016
  823038
  823109
  823129
  823137
  821192
  822269
  822812
  821724
  822881
  823039
  820570
  821453
  823010
  820504
  821037
  823289
  821015
  821448
  821326
  821663
  821736
  822005
  822215
  822217
  822239
  822545
  822814
  822867
  822896
  823114
  823334
  820405
  820533
  820541
  821143
  821168
  821294
  822704
  823013
  820677
  820896
  821198
  821566
  821679
  821752
  822292
  822310
  822883
  822919
  822935
  822998
  823031
  823047
  823106
  823117
  823130
  823140
  823146
  823302
  823399
  823432
  821308
  821430
  821493
  821582
  821619
  822262
  822582
  823111
  823128
  823286
  822714
  820792
  821565
  822751
  822791
  820966
  822675
  821414
  823143
  820642
  821030
  821251
  822621
  821124
  821304
  821704
  820855
  820856
  821121
  821684
  822499
  820525
  820558
  820930
  821061
  821601
  822492
  820582
  820660
  821600
  821711
  821977
  822285
  822965
  823036
  823082
  823119
  823208
  823291
  823507
  820534
  820615
]
2.70 ms
(0.64%)
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
  820405
  820504
  820525
  820533
  820534
  820541
  820558
  820570
  820582
  820598
  820615
  820642
  820660
  820677
  820792
  820855
  820856
  820896
  820920
  820930
  820966
  820968
  821015
  821030
  821037
  821061
  821121
  821124
  821143
  821168
  821192
  821198
  821251
  821294
  821304
  821308
  821326
  821414
  821430
  821448
  821453
  821493
  821565
  821566
  821582
  821600
  821601
  821619
  821663
  821679
  821684
  821704
  821711
  821724
  821736
  821752
  821977
  822005
  822215
  822217
  822239
  822262
  822269
  822285
  822292
  822310
  822492
  822499
  822545
  822582
  822621
  822675
  822704
  822714
  822791
  822812
  822814
  822867
  822881
  822883
  822896
  822919
  822965
  823010
  823013
  823016
  823031
  823036
  823038
  823039
  823047
  823082
  823106
  823109
  823111
  823114
  823119
  823123
  823128
  823129
  823130
  823133
  823137
  823140
  823143
  823146
  823208
  823286
  823289
  823302
  823379
  823399
  823432
  823507
]
1.94 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mofos секс"
]
1.72 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mofos секс"
]

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.