Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.50 ms
(81.62%)
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
  407252
  413993
  420352
  425829
  434045
  439701
  440426
  442239
  452080
  452228
  452370
  463762
  463840
  464727
  465336
  465694
  468517
  477025
  477873
  482270
  482337
  488904
  493204
  499867
  504411
  506606
  507124
  507915
  511345
  513148
  514830
  515838
  522210
  522431
  523039
  524323
  525844
  525858
  527199
  527442
  534672
  536903
  539336
  543434
  545944
  549214
  549727
  550615
  553269
  554790
  555269
  555429
  556121
  557776
  560947
  562185
  562959
  563446
  563729
  564203
  564224
  565989
  566843
  567220
  569955
  570878
  571840
  573759
  574450
  575847
  576653
  577435
  578631
  584354
  587152
  592921
  593162
  596330
  597736
  598654
  599353
  601125
  601176
  603709
  605111
  605200
  605953
  606600
  607478
  608930
  609225
  615975
  616864
  618387
  618746
  619407
  622778
  645270
  654274
  663347
  668505
  684305
  691462
  700588
  702299
  715089
  717278
  724098
  756609
  758248
  766342
  768797
  774124
  784042
  784110
  784793
  787802
  805041
  805983
  808077
]
22.99 ms
(12.07%)
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
  691462
  654274
  555269
  560947
  784042
  575847
  482337
  565989
  465694
  607478
  525844
  702299
  440426
  420352
  756609
  717278
  768797
  787802
  715089
  452370
  507915
  571840
  584354
  562185
  562959
  784110
  758248
  766342
  534672
  784793
  413993
  452080
  555429
  477025
  515838
  514830
  464727
  774124
  570878
  463840
  439701
  442239
  434045
  549214
  523039
  549727
  425829
  566843
  525858
  605200
  618387
  576653
  482270
  545944
  522431
  700588
  805041
  724098
  668505
  463762
  618746
  808077
  524323
  596330
  563729
  536903
  577435
  616864
  539336
  606600
  511345
  805983
  615975
  507124
  599353
  592921
  563446
  605111
  499867
  550615
  603709
  557776
  556121
  619407
  573759
  553269
  554790
  609225
  597736
  527442
  477873
  574450
  593162
  663347
  645270
  522210
  578631
  567220
  605953
  684305
  543434
  527199
  622778
  407252
  506606
  598654
  601176
  468517
  513148
  564203
  465336
  564224
  488904
  587152
  452228
  493204
  569955
  608930
  504411
  601125
]
4.98 ms
(2.62%)
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
  407252
  413993
  420352
  425829
  434045
  439701
  440426
  442239
  452080
  452228
  452370
  463762
  463840
  464727
  465336
  465694
  468517
  477025
  477873
  482270
  482337
  488904
  493204
  499867
  504411
  506606
  507124
  507915
  511345
  513148
  514830
  515838
  522210
  522431
  523039
  524323
  525844
  525858
  527199
  527442
  534672
  536903
  539336
  543434
  545944
  549214
  549727
  550615
  553269
  554790
  555269
  555429
  556121
  557776
  560947
  562185
  562959
  563446
  563729
  564203
  564224
  565989
  566843
  567220
  569955
  570878
  571840
  573759
  574450
  575847
  576653
  577435
  578631
  584354
  587152
  592921
  593162
  596330
  597736
  598654
  599353
  601125
  601176
  603709
  605111
  605200
  605953
  606600
  607478
  608930
  609225
  615975
  616864
  618387
  618746
  619407
  622778
  645270
  654274
  663347
  668505
  684305
  691462
  700588
  702299
  715089
  717278
  724098
  756609
  758248
  766342
  768797
  774124
  784042
  784110
  784793
  787802
  805041
  805983
  808077
]
2.03 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мама сильно секс"
]
1.81 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин сильн секс"
]
1.47 ms
(0.77%)
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.