Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.02 ms
(84.88%)
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
  384239
  389745
  395676
  401985
  410712
  413722
  428040
  428933
  435443
  443883
  444935
  445530
  446260
  447125
  450165
  451267
  455772
  455859
  456519
  456634
  456736
  457422
  458437
  460807
  460815
  461368
  461673
  462133
  463728
  463867
  467683
  469352
  470359
  470550
  471978
  472506
  473388
  479893
  481313
  481914
  482734
  483436
  484553
  486350
  486474
  488074
  488212
  488736
  489098
  489134
  489323
  489431
  490098
  490196
  492003
  492557
  492805
  495670
  498239
  500202
  500441
  501705
  501708
  501774
  502060
  503299
  503490
  503730
  505236
  507013
  507095
  510114
  513195
  514020
  515919
  516023
  516624
  516709
  517078
  517079
  517579
  518446
  518501
  519622
  520154
  520930
  521862
  521912
  522526
  522528
  523255
  523529
  523960
  524199
  524298
  524592
  524757
  524782
  525020
  525169
  525947
  527070
  527123
  527463
  528178
  528784
  531214
  531656
  532630
  534707
  539945
  543618
  551219
  551245
  551650
  575192
  584771
  651609
  675071
  675657
]
16.76 ms
(9.68%)
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
  520154
  521912
  524298
  524592
  524757
  524782
  528784
  534707
  483436
  488212
  492003
  492557
  495670
  498239
  500441
  501774
  503490
  505236
  510114
  515919
  517078
  517079
  517579
  518446
  521862
  522526
  523529
  523960
  524199
  525020
  525169
  528178
  513195
  384239
  395676
  389745
  401985
  410712
  413722
  444935
  428040
  428933
  443883
  435443
  482734
  456519
  456634
  457422
  458437
  460807
  460815
  467683
  470359
  473388
  479893
  484553
  488736
  490098
  492805
  445530
  446260
  447125
  455859
  461368
  462133
  463728
  463867
  470550
  481914
  486474
  489323
  450165
  451267
  455772
  456736
  461673
  469352
  471978
  481313
  489134
  489431
  490196
  516023
  516709
  525947
  500202
  507013
  516624
  518501
  520930
  522528
  527463
  501705
  501708
  502060
  503299
  503730
  507095
  514020
  531214
  532630
  519622
  523255
  527070
  527123
  531656
  539945
  472506
  486350
  488074
  489098
  551219
  551650
  584771
  543618
  575192
  651609
  675071
  675657
  551245
]
2.74 ms
(1.58%)
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
  384239
  389745
  395676
  401985
  410712
  413722
  428040
  428933
  435443
  443883
  444935
  445530
  446260
  447125
  450165
  451267
  455772
  455859
  456519
  456634
  456736
  457422
  458437
  460807
  460815
  461368
  461673
  462133
  463728
  463867
  467683
  469352
  470359
  470550
  471978
  472506
  473388
  479893
  481313
  481914
  482734
  483436
  484553
  486350
  486474
  488074
  488212
  488736
  489098
  489134
  489323
  489431
  490098
  490196
  492003
  492557
  492805
  495670
  498239
  500202
  500441
  501705
  501708
  501774
  502060
  503299
  503490
  503730
  505236
  507013
  507095
  510114
  513195
  514020
  515919
  516023
  516624
  516709
  517078
  517079
  517579
  518446
  518501
  519622
  520154
  520930
  521862
  521912
  522526
  522528
  523255
  523529
  523960
  524199
  524298
  524592
  524757
  524782
  525020
  525169
  525947
  527070
  527123
  527463
  528178
  528784
  531214
  531656
  532630
  534707
  539945
  543618
  551219
  551245
  551650
  575192
  584771
  651609
  675071
  675657
]
1.91 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy white"
]
1.87 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy white"
]
1.47 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy white"
]

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.