Query Metrics

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

Queries

Group similar statements

# Time Info
1 210.84 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.89 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny teen dp"
]
3 26.82 ms
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
  497613
  500312
  566991
  537210
  558601
  634818
  634208
  406308
  418399
  434000
  443103
  483544
  461056
  447926
  535505
  537903
  537919
  534995
  540518
  464168
  550099
  561980
  566502
  583936
  541856
  581349
  543471
  674927
  676087
  679016
  649556
  678127
  649578
  666883
  586693
  631965
  590460
  597252
  600026
  590542
  628406
  599912
  622402
  623198
  634778
  701010
  428301
  421271
  461569
  516350
  505048
  487713
  427447
  820759
  481142
  484457
  446505
  531255
  534842
  536638
  527198
  537660
  539232
  565267
  678143
  687158
  647993
  666878
  672710
  592034
  593868
  597204
  634482
  599969
  615718
  601624
  601595
  633775
  432787
  501382
  465606
  534021
  558130
  543858
  544840
  570704
  647932
  646427
  677307
  675009
  617411
  632978
  403909
  434712
  537236
  518473
  530382
  531123
  558134
  565276
  650155
  634198
  588265
  594231
  540330
  530369
  598105
  553280
  541866
]
4 2.76 ms
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
  403909
  406308
  418399
  421271
  427447
  428301
  432787
  434000
  434712
  443103
  446505
  447926
  461056
  461569
  464168
  465606
  481142
  483544
  484457
  487713
  497613
  500312
  501382
  505048
  516350
  518473
  527198
  530369
  530382
  531123
  531255
  534021
  534842
  534995
  535505
  536638
  537210
  537236
  537660
  537903
  537919
  539232
  540330
  540518
  541856
  541866
  543471
  543858
  544840
  550099
  553280
  558130
  558134
  558601
  561980
  565267
  565276
  566502
  566991
  570704
  581349
  583936
  586693
  588265
  590460
  590542
  592034
  593868
  594231
  597204
  597252
  598105
  599912
  599969
  600026
  601595
  601624
  615718
  617411
  622402
  623198
  628406
  631965
  632978
  633775
  634198
  634208
  634482
  634778
  634818
  646427
  647932
  647993
  649556
  649578
  650155
  666878
  666883
  672710
  674927
  675009
  676087
  677307
  678127
  678143
  679016
  687158
  701010
  820759
]
5 399.73 ms
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
  403909
  406308
  418399
  421271
  427447
  428301
  432787
  434000
  434712
  443103
  446505
  447926
  461056
  461569
  464168
  465606
  481142
  483544
  484457
  487713
  497613
  500312
  501382
  505048
  516350
  518473
  527198
  530369
  530382
  531123
  531255
  534021
  534842
  534995
  535505
  536638
  537210
  537236
  537660
  537903
  537919
  539232
  540330
  540518
  541856
  541866
  543471
  543858
  544840
  550099
  553280
  558130
  558134
  558601
  561980
  565267
  565276
  566502
  566991
  570704
  581349
  583936
  586693
  588265
  590460
  590542
  592034
  593868
  594231
  597204
  597252
  598105
  599912
  599969
  600026
  601595
  601624
  615718
  617411
  622402
  623198
  628406
  631965
  632978
  633775
  634198
  634208
  634482
  634778
  634818
  646427
  647932
  647993
  649556
  649578
  650155
  666878
  666883
  672710
  674927
  675009
  676087
  677307
  678127
  678143
  679016
  687158
  701010
  820759
]
6 1.62 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые teen dp"
]
7 1.30 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые teen dp"
]

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.