Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.39 ms
(55.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "babe hot"
]
143.31 ms
(37.87%)
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
  21506
  192643
  205011
  317820
  382633
  383244
  384196
  384917
  386589
  387072
  387874
  390806
  398784
  407298
  416435
  420062
  421801
  426029
  427226
  435520
  441660
  455537
  461009
  466202
  467792
  468209
  491115
  494399
  506290
  507451
  508578
  510017
  521014
  521202
  523010
  539219
  541428
  543127
  543846
  565024
  566728
  567582
  571591
  572092
  578033
  580352
  580629
  587336
  589229
  598985
  600241
  606565
  609900
  610601
  616778
  619075
  622870
  627552
  630277
  672506
  673772
  677524
  686585
  692538
  705741
  708389
  710872
  716771
  717545
  718089
  721207
  729065
  731428
  737349
  739799
  743916
  748588
  753638
  755334
  755580
  755848
  758601
  761141
  766219
  772605
  774291
  775986
  776053
  778498
  779376
  779538
  780268
  784673
  786575
  787215
  788888
  788897
  789080
  790748
  790927
  791394
  795173
  797719
  799522
  800891
  801881
  802671
  803691
  807593
  810455
  811071
  811639
  812738
  813053
  814660
  815100
  815799
  817260
  820417
  821443
]
15.38 ms
(4.06%)
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
  799522
  729065
  755848
  807593
  811639
  813053
  731428
  774291
  755580
  772605
  606565
  630277
  716771
  721207
  775986
  779376
  779538
  790748
  797719
  383244
  466202
  387874
  426029
  435520
  386589
  384196
  205011
  441660
  427226
  815799
  814660
  820417
  506290
  539219
  541428
  566728
  578033
  692538
  672506
  705741
  677524
  686585
  708389
  717545
  718089
  627552
  610601
  589229
  600241
  778498
  788888
  788897
  758601
  795173
  801881
  748588
  766219
  737349
  755334
  739799
  753638
  761141
  776053
  780268
  784673
  790927
  791394
  800891
  802671
  416435
  461009
  398784
  421801
  467792
  521014
  616778
  192643
  387072
  815100
  817260
  821443
  455537
  507451
  510017
  523010
  571591
  543846
  565024
  580629
  543127
  580352
  710872
  673772
  567582
  572092
  609900
  619075
  598985
  622870
  587336
  787215
  786575
  789080
  803691
  811071
  743916
  810455
  812738
  407298
  390806
  420062
  468209
  508578
  521202
  491115
  494399
  384917
  317820
  382633
  21506
]
2.63 ms
(0.69%)
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
  21506
  192643
  205011
  317820
  382633
  383244
  384196
  384917
  386589
  387072
  387874
  390806
  398784
  407298
  416435
  420062
  421801
  426029
  427226
  435520
  441660
  455537
  461009
  466202
  467792
  468209
  491115
  494399
  506290
  507451
  508578
  510017
  521014
  521202
  523010
  539219
  541428
  543127
  543846
  565024
  566728
  567582
  571591
  572092
  578033
  580352
  580629
  587336
  589229
  598985
  600241
  606565
  609900
  610601
  616778
  619075
  622870
  627552
  630277
  672506
  673772
  677524
  686585
  692538
  705741
  708389
  710872
  716771
  717545
  718089
  721207
  729065
  731428
  737349
  739799
  743916
  748588
  753638
  755334
  755580
  755848
  758601
  761141
  766219
  772605
  774291
  775986
  776053
  778498
  779376
  779538
  780268
  784673
  786575
  787215
  788888
  788897
  789080
  790748
  790927
  791394
  795173
  797719
  799522
  800891
  801881
  802671
  803691
  807593
  810455
  811071
  811639
  812738
  813053
  814660
  815100
  815799
  817260
  820417
  821443
]
2.05 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "babe hot"
]
1.87 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "babe hot"
]

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.