Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.33 ms
(86.07%)
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
  478452
  496805
  507862
  509053
  514161
  517888
  517901
  529633
  530089
  532080
  533617
  533635
  534911
  534933
  534936
  535956
  536745
  537782
  538135
  541906
  542211
  542301
  543485
  543703
  543741
  544372
  544970
  549304
  549454
  552277
  552479
  552510
  553155
  553214
  556076
  556274
  560713
  562458
  567440
  569809
  571423
  576251
  577528
  579217
  579784
  579919
  581046
  648246
  662572
  667811
  667925
  668829
  670939
  671468
  675369
  678419
  684302
  685159
  686155
  688765
  689093
  689279
  691431
  693224
  694138
  694175
  697441
  698132
  701543
  703907
  703953
  704996
  705104
  705223
  705230
  706638
  706965
  713251
  714390
  716309
  717864
  718908
  814055
  814494
  814609
  816146
  816881
  817076
  817477
  817488
  817643
  818184
  818725
  818750
  818813
  818816
  818881
  818922
  819445
  819507
  819869
  820013
  821037
  822339
  824714
  824962
  825100
  825284
  825835
  825925
  826690
  826809
  826932
  827346
  827552
  828020
  828065
  828326
  828498
  828801
]
18.01 ms
(9.38%)
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
  825284
  825835
  825925
  826690
  814494
  817076
  817643
  818184
  818813
  818816
  820013
  825100
  826932
  827346
  827552
  816881
  817477
  817488
  818725
  818922
  819445
  819869
  821037
  822339
  824962
  814055
  814609
  816146
  818750
  818881
  819507
  824714
  828326
  828065
  828020
  828801
  826809
  828498
  478452
  507862
  514161
  517888
  517901
  529633
  533617
  533635
  534933
  530089
  532080
  536745
  538135
  509053
  534936
  537782
  496805
  534911
  535956
  542211
  543485
  543741
  544372
  552479
  560713
  567440
  576251
  579919
  542301
  543703
  549454
  552277
  556274
  562458
  569809
  571423
  577528
  581046
  541906
  544970
  549304
  552510
  553155
  553214
  556076
  579217
  579784
  648246
  667925
  671468
  675369
  678419
  684302
  688765
  689279
  694138
  701543
  703907
  703953
  705223
  706638
  706965
  713251
  714390
  716309
  717864
  718908
  662572
  667811
  668829
  670939
  685159
  686155
  689093
  691431
  693224
  694175
  697441
  698132
  704996
  705104
  705230
]
2.14 ms
(1.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
  478452
  496805
  507862
  509053
  514161
  517888
  517901
  529633
  530089
  532080
  533617
  533635
  534911
  534933
  534936
  535956
  536745
  537782
  538135
  541906
  542211
  542301
  543485
  543703
  543741
  544372
  544970
  549304
  549454
  552277
  552479
  552510
  553155
  553214
  556076
  556274
  560713
  562458
  567440
  569809
  571423
  576251
  577528
  579217
  579784
  579919
  581046
  648246
  662572
  667811
  667925
  668829
  670939
  671468
  675369
  678419
  684302
  685159
  686155
  688765
  689093
  689279
  691431
  693224
  694138
  694175
  697441
  698132
  701543
  703907
  703953
  704996
  705104
  705223
  705230
  706638
  706965
  713251
  714390
  716309
  717864
  718908
  814055
  814494
  814609
  816146
  816881
  817076
  817477
  817488
  817643
  818184
  818725
  818750
  818813
  818816
  818881
  818922
  819445
  819507
  819869
  820013
  821037
  822339
  824714
  824962
  825100
  825284
  825835
  825925
  826690
  826809
  826932
  827346
  827552
  828020
  828065
  828326
  828498
  828801
]
1.89 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скрытой камера"
]
1.72 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт камер"
]
1.61 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.71%)
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.