Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.72 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.18 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "loves"
]
3 10.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
  10778
  385751
  385111
  53601
  396645
  396717
  402024
  444325
  416238
  813832
  814490
  814652
  819960
  826502
  825619
  815898
  816767
  821180
  821956
  823424
  825577
  814623
  815332
  816154
  820045
  820975
  822125
  825648
  819858
  824781
  825510
  828569
  828736
  533924
  477810
  459314
  489321
  514671
  516367
  538919
  499330
  542292
  545065
  563961
  581318
  554941
  541668
  542577
  547876
  550438
  686255
  687835
  690535
  706784
  706809
  709557
  710511
  710576
  714799
  721390
  645050
  646330
  650304
  656494
  657254
  660407
  661588
  670863
  673094
  678651
  684400
  694541
  696825
  696827
  709707
  720793
  652009
  655225
  660345
  666560
  667179
  667542
  694540
  695324
  719570
  720328
  550750
  584196
  593072
  594572
  601855
  602129
  607172
  636438
  625943
  627461
  637173
  639371
  640363
  586657
  602995
  609625
  609824
  620907
  625535
  636873
  639134
  588519
  590195
  612000
  618974
  622915
  777654
  778155
  778283
  780269
  781289
  786012
  786041
  787755
]
4 2.91 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
  10778
  53601
  385111
  385751
  396645
  396717
  402024
  416238
  444325
  459314
  477810
  489321
  499330
  514671
  516367
  533924
  538919
  541668
  542292
  542577
  545065
  547876
  550438
  550750
  554941
  563961
  581318
  584196
  586657
  588519
  590195
  593072
  594572
  601855
  602129
  602995
  607172
  609625
  609824
  612000
  618974
  620907
  622915
  625535
  625943
  627461
  636438
  636873
  637173
  639134
  639371
  640363
  645050
  646330
  650304
  652009
  655225
  656494
  657254
  660345
  660407
  661588
  666560
  667179
  667542
  670863
  673094
  678651
  684400
  686255
  687835
  690535
  694540
  694541
  695324
  696825
  696827
  706784
  706809
  709557
  709707
  710511
  710576
  714799
  719570
  720328
  720793
  721390
  777654
  778155
  778283
  780269
  781289
  786012
  786041
  787755
  813832
  814490
  814623
  814652
  815332
  815898
  816154
  816767
  819858
  819960
  820045
  820975
  821180
  821956
  822125
  823424
  824781
  825510
  825577
  825619
  825648
  826502
  828569
]
5 146.02 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
  10778
  53601
  385111
  385751
  396645
  396717
  402024
  416238
  444325
  459314
  477810
  489321
  499330
  514671
  516367
  533924
  538919
  541668
  542292
  542577
  545065
  547876
  550438
  550750
  554941
  563961
  581318
  584196
  586657
  588519
  590195
  593072
  594572
  601855
  602129
  602995
  607172
  609625
  609824
  612000
  618974
  620907
  622915
  625535
  625943
  627461
  636438
  636873
  637173
  639134
  639371
  640363
  645050
  646330
  650304
  652009
  655225
  656494
  657254
  660345
  660407
  661588
  666560
  667179
  667542
  670863
  673094
  678651
  684400
  686255
  687835
  690535
  694540
  694541
  695324
  696825
  696827
  706784
  706809
  709557
  709707
  710511
  710576
  714799
  719570
  720328
  720793
  721390
  777654
  778155
  778283
  780269
  781289
  786012
  786041
  787755
  813832
  814490
  814623
  814652
  815332
  815898
  816154
  816767
  819858
  819960
  820045
  820975
  821180
  821956
  822125
  823424
  824781
  825510
  825577
  825619
  825648
  826502
  828569
]
6 1.85 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "loves"
]
7 1.44 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "loves"
]

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.