Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.25 ms
(85.64%)
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
  358453
  394136
  395778
  400923
  404051
  423764
  443634
  454797
  456280
  457748
  477970
  490525
  492568
  494553
  494662
  498867
  500494
  506321
  507853
  511821
  512087
  513101
  514847
  515553
  517236
  518907
  522432
  526981
  529638
  533527
  534742
  535286
  535313
  537630
  539030
  539283
  539328
  539429
  541050
  541198
  541544
  542080
  542720
  544515
  546659
  547274
  547606
  547990
  548888
  549435
  550771
  551878
  552756
  553263
  553674
  553932
  553949
  554841
  557251
  559450
  559875
  560413
  560723
  561244
  562595
  564702
  568966
  570858
  570875
  571304
  571753
  578002
  578778
  579886
  581149
  589141
  593913
  602505
  603779
  605013
  606947
  622090
  622505
  624017
  632401
  648648
  668741
  668887
  679564
  695551
  718874
  723575
  733211
  735790
  738032
  761603
  764190
  773174
  782179
  796958
  803658
  811721
  812265
  814150
  814303
  818753
  819302
  820666
  823252
  823272
  823676
  824157
  825021
  825557
  826469
  826624
  827912
  827952
  827963
  828853
]
16.62 ms
(8.31%)
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
  494662
  539429
  578778
  589141
  738032
  606947
  423764
  456280
  568966
  782179
  761603
  514847
  553949
  400923
  544515
  818753
  492568
  526981
  559875
  562595
  695551
  718874
  679564
  564702
  593913
  622505
  773174
  733211
  550771
  668887
  605013
  735790
  811721
  553674
  648648
  513101
  443634
  506321
  547606
  542080
  546659
  547274
  560413
  624017
  764190
  812265
  494553
  511821
  518907
  533527
  571753
  579886
  668741
  602505
  622090
  632401
  603779
  796958
  803658
  512087
  394136
  395778
  358453
  404051
  814150
  820666
  823676
  825021
  723575
  826469
  814303
  819302
  823252
  823272
  825557
  827912
  828853
  827952
  827963
  824157
  826624
  454797
  457748
  490525
  507853
  529638
  498867
  522432
  535286
  537630
  539328
  515553
  517236
  534742
  535313
  539030
  500494
  539283
  477970
  541050
  542720
  547990
  549435
  551878
  552756
  553263
  557251
  560723
  561244
  570858
  570875
  571304
  578002
  581149
  541198
  541544
  548888
  553932
  554841
  559450
]
4.17 ms
(2.08%)
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
  358453
  394136
  395778
  400923
  404051
  423764
  443634
  454797
  456280
  457748
  477970
  490525
  492568
  494553
  494662
  498867
  500494
  506321
  507853
  511821
  512087
  513101
  514847
  515553
  517236
  518907
  522432
  526981
  529638
  533527
  534742
  535286
  535313
  537630
  539030
  539283
  539328
  539429
  541050
  541198
  541544
  542080
  542720
  544515
  546659
  547274
  547606
  547990
  548888
  549435
  550771
  551878
  552756
  553263
  553674
  553932
  553949
  554841
  557251
  559450
  559875
  560413
  560723
  561244
  562595
  564702
  568966
  570858
  570875
  571304
  571753
  578002
  578778
  579886
  581149
  589141
  593913
  602505
  603779
  605013
  606947
  622090
  622505
  624017
  632401
  648648
  668741
  668887
  679564
  695551
  718874
  723575
  733211
  735790
  738032
  761603
  764190
  773174
  782179
  796958
  803658
  811721
  812265
  814150
  814303
  818753
  819302
  820666
  823252
  823272
  823676
  824157
  825021
  825557
  826469
  826624
  827912
  827952
  827963
  828853
]
2.24 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые жен"
]
2.16 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny wife"
]
1.81 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.86%)
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.