Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.61 ms
(84.90%)
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
  41776
  345851
  384275
  395703
  397509
  401177
  414090
  414094
  414256
  419694
  421462
  427341
  435700
  443168
  446534
  448588
  452816
  458115
  462900
  466563
  471951
  475752
  477111
  477169
  477245
  478215
  480393
  480454
  483189
  485031
  492112
  495140
  495562
  499934
  504102
  513183
  519437
  522785
  536224
  547453
  547501
  554949
  556442
  559294
  578493
  586760
  596035
  598584
  605874
  609888
  628641
  630796
  633887
  641097
  642403
  646014
  646433
  648395
  648852
  652831
  653561
  656886
  671578
  676531
  692711
  694441
  698423
  699531
  700259
  713896
  713911
  717836
  718631
  718785
  719026
  720701
  723549
  727807
  733645
  738912
  739141
  739390
  740919
  741252
  752837
  753654
  758648
  760667
  763445
  763739
  766335
  766381
  766707
  770377
  770387
  770391
  770413
  774691
  775240
  776527
  777847
  784221
  787857
  790875
  791489
  796930
  797443
  797842
  805120
  805230
  806541
  806687
  806794
  810830
  811325
  814648
  814754
  817217
  820594
  822930
]
18.64 ms
(9.50%)
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
  791489
  478215
  504102
  483189
  495562
  446534
  692711
  763739
  513183
  522785
  495140
  646433
  480393
  435700
  471951
  480454
  519437
  723549
  817217
  822930
  556442
  648395
  648852
  699531
  653561
  694441
  700259
  775240
  739390
  806687
  739141
  753654
  766381
  770377
  763445
  752837
  419694
  814754
  458115
  475752
  717836
  718785
  628641
  642403
  805120
  766335
  784221
  443168
  814648
  820594
  536224
  547501
  559294
  547453
  656886
  671578
  713911
  719026
  646014
  652831
  676531
  713896
  698423
  718631
  641097
  605874
  586760
  630796
  598584
  609888
  774691
  777847
  796930
  806794
  811325
  776527
  787857
  790875
  797443
  810830
  727807
  733645
  797842
  805230
  806541
  766707
  770391
  738912
  741252
  740919
  770413
  720701
  345851
  395703
  466563
  477245
  384275
  41776
  578493
  596035
  633887
  770387
  427341
  477111
  492112
  760667
  499934
  477169
  758648
  448588
  414256
  414090
  421462
  414094
  462900
  452816
  485031
  554949
  397509
  401177
]
3.12 ms
(1.59%)
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
  41776
  345851
  384275
  395703
  397509
  401177
  414090
  414094
  414256
  419694
  421462
  427341
  435700
  443168
  446534
  448588
  452816
  458115
  462900
  466563
  471951
  475752
  477111
  477169
  477245
  478215
  480393
  480454
  483189
  485031
  492112
  495140
  495562
  499934
  504102
  513183
  519437
  522785
  536224
  547453
  547501
  554949
  556442
  559294
  578493
  586760
  596035
  598584
  605874
  609888
  628641
  630796
  633887
  641097
  642403
  646014
  646433
  648395
  648852
  652831
  653561
  656886
  671578
  676531
  692711
  694441
  698423
  699531
  700259
  713896
  713911
  717836
  718631
  718785
  719026
  720701
  723549
  727807
  733645
  738912
  739141
  739390
  740919
  741252
  752837
  753654
  758648
  760667
  763445
  763739
  766335
  766381
  766707
  770377
  770387
  770391
  770413
  774691
  775240
  776527
  777847
  784221
  787857
  790875
  791489
  796930
  797443
  797842
  805120
  805230
  806541
  806687
  806794
  810830
  811325
  814648
  814754
  817217
  820594
  822930
]
2.33 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty anal masturbation"
]
2.01 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty анал мастурбац"
]
1.66 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty анал мастурбац"
]

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.