Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.58 ms
(83.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
  331119
  385965
  387018
  388075
  407156
  410439
  411829
  416297
  420202
  423129
  424740
  431323
  431484
  433229
  455856
  455965
  455990
  458617
  463741
  492412
  496112
  499688
  500570
  504065
  510589
  512680
  513136
  513798
  518972
  525176
  528777
  531554
  533295
  533388
  540190
  541586
  542518
  545042
  550641
  550991
  551012
  551984
  552025
  552041
  552281
  554766
  554776
  557498
  557505
  557509
  557512
  557518
  558368
  559161
  560096
  560215
  564142
  565469
  565976
  565977
  565979
  565980
  566007
  566010
  585416
  586584
  586588
  586627
  590759
  590969
  591718
  595165
  604429
  604688
  612913
  618510
  620490
  621019
  622203
  622629
  622972
  623513
  623554
  629993
  630492
  638148
  638366
  638829
  640306
  641455
  642064
  671694
  673049
  673052
  710892
  720943
  726811
  728266
  738245
  747177
  747220
  754335
  759029
  767029
  774773
  784628
  796971
  797202
  803996
  806285
  810407
  813921
  816297
  816360
  817847
  820685
  821536
  825906
  827068
]
15.83 ms
(10.14%)
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
  638148
  638366
  622629
  774773
  796971
  759029
  797202
  728266
  747177
  754335
  618510
  620490
  623554
  629993
  388075
  821536
  827917
  545042
  640306
  638829
  767029
  387018
  424740
  431323
  816360
  455965
  458617
  455856
  492412
  533388
  513136
  500570
  566007
  541586
  558368
  565976
  565979
  566010
  557509
  565980
  557505
  586627
  738245
  720943
  504065
  550641
  604429
  623513
  604688
  433229
  554776
  813921
  630492
  512680
  559161
  642064
  590759
  595165
  641455
  407156
  816297
  825906
  455990
  531554
  533295
  550991
  564142
  565469
  542518
  557498
  673049
  673052
  560096
  591718
  622203
  622972
  612913
  784628
  806285
  747220
  726811
  810407
  560215
  551012
  510589
  423129
  803996
  411829
  331119
  420202
  410439
  416297
  431484
  518972
  525176
  496112
  551984
  552041
  565977
  552281
  557518
  557512
  586584
  586588
  463741
  513798
  528777
  385965
  827068
  820685
  817847
  540190
  499688
  552025
  671694
  710892
  554766
  585416
  590969
  621019
]
3.31 ms
(2.12%)
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
  331119
  385965
  387018
  388075
  407156
  410439
  411829
  416297
  420202
  423129
  424740
  431323
  431484
  433229
  455856
  455965
  455990
  458617
  463741
  492412
  496112
  499688
  500570
  504065
  510589
  512680
  513136
  513798
  518972
  525176
  528777
  531554
  533295
  533388
  540190
  541586
  542518
  545042
  550641
  550991
  551012
  551984
  552025
  552041
  552281
  554766
  554776
  557498
  557505
  557509
  557512
  557518
  558368
  559161
  560096
  560215
  564142
  565469
  565976
  565977
  565979
  565980
  566007
  566010
  585416
  586584
  586588
  586627
  590759
  590969
  591718
  595165
  604429
  604688
  612913
  618510
  620490
  621019
  622203
  622629
  622972
  623513
  623554
  629993
  630492
  638148
  638366
  638829
  640306
  641455
  642064
  671694
  673049
  673052
  710892
  720943
  726811
  728266
  738245
  747177
  747220
  754335
  759029
  767029
  774773
  784628
  796971
  797202
  803996
  806285
  810407
  813921
  816297
  816360
  817847
  820685
  821536
  825906
  827068
]
2.06 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf asian"
]
1.79 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf азиатк"
]
1.77 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf азиатк"
]

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.