Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.50 ms
(80.04%)
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
  381921
  393724
  400490
  404931
  412474
  412838
  413791
  415874
  418049
  419137
  424056
  425834
  426284
  429523
  435391
  443092
  443510
  443883
  444438
  445947
  447499
  447750
  447888
  447948
  448884
  450281
  451108
  452259
  453409
  454051
  454081
  454585
  455683
  458031
  458039
  461394
  461416
  462504
  468593
  472448
  473526
  474914
  481214
  482416
  486301
  490453
  490718
  491589
  492389
  492530
  492595
  492649
  498264
  500896
  505130
  506946
  507291
  508116
  510209
  510758
  512471
  514774
  514984
  518807
  521370
  522734
  523197
  525540
  527038
  527157
  530041
  535882
  543503
  546042
  546053
  546665
  552535
  553958
  569409
  571227
  572195
  574629
  579422
  580238
  581096
  581696
  583724
  587178
  591349
  592651
  595252
  597923
  599538
  606017
  606029
  613502
  625127
  625140
  625780
  632969
  633804
  644674
  650083
  663524
  670250
  677142
  678916
  680177
  680206
  687006
  714511
  722916
  724176
  741539
  755082
  757896
  758216
  760739
  787311
  814266
]
20.26 ms
(12.92%)
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
  381921
  418049
  452259
  472448
  451108
  454051
  510209
  498264
  522734
  527157
  514774
  514984
  552535
  574629
  581696
  663524
  670250
  678916
  680177
  546053
  546665
  571227
  572195
  606029
  587178
  613502
  599538
  625127
  633804
  758216
  760739
  741539
  755082
  632969
  722916
  787311
  412838
  443092
  448884
  419137
  445947
  455683
  458039
  461394
  412474
  400490
  426284
  481214
  508116
  518807
  521370
  525540
  491589
  492595
  506946
  393724
  443510
  443883
  424056
  429523
  482416
  447948
  492649
  523197
  530041
  535882
  461416
  492389
  543503
  579422
  583724
  553958
  687006
  569409
  580238
  606017
  592651
  591349
  595252
  625780
  757896
  724176
  644674
  454585
  473526
  435391
  474914
  404931
  447750
  450281
  447499
  500896
  510758
  492530
  505130
  486301
  490718
  425834
  413791
  814266
  454081
  458031
  462504
  546042
  680206
  597923
  625140
  447888
  415874
  468593
  527038
  507291
  444438
  677142
  714511
  650083
  453409
  490453
  512471
  581096
]
3.31 ms
(2.11%)
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
  381921
  393724
  400490
  404931
  412474
  412838
  413791
  415874
  418049
  419137
  424056
  425834
  426284
  429523
  435391
  443092
  443510
  443883
  444438
  445947
  447499
  447750
  447888
  447948
  448884
  450281
  451108
  452259
  453409
  454051
  454081
  454585
  455683
  458031
  458039
  461394
  461416
  462504
  468593
  472448
  473526
  474914
  481214
  482416
  486301
  490453
  490718
  491589
  492389
  492530
  492595
  492649
  498264
  500896
  505130
  506946
  507291
  508116
  510209
  510758
  512471
  514774
  514984
  518807
  521370
  522734
  523197
  525540
  527038
  527157
  530041
  535882
  543503
  546042
  546053
  546665
  552535
  553958
  569409
  571227
  572195
  574629
  579422
  580238
  581096
  581696
  583724
  587178
  591349
  592651
  595252
  597923
  599538
  606017
  606029
  613502
  625127
  625140
  625780
  632969
  633804
  644674
  650083
  663524
  670250
  677142
  678916
  680177
  680206
  687006
  714511
  722916
  724176
  741539
  755082
  757896
  758216
  760739
  787311
  814266
]
2.35 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fat teens"
]
2.03 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fat teens"
]
1.58 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fat teens"
]

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.