Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.32 ms
(83.79%)
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
  97047
  386986
  389504
  402978
  407283
  411090
  416234
  417794
  419013
  420147
  422319
  422774
  422776
  424279
  429219
  429360
  433617
  434195
  440703
  441229
  441268
  442353
  442486
  443853
  444759
  445007
  446608
  448106
  449598
  453375
  454929
  456402
  458473
  458488
  458868
  459025
  459308
  459813
  462524
  463182
  464314
  465095
  467962
  469874
  472085
  472477
  472982
  473974
  474325
  474720
  475731
  476508
  476813
  478402
  484146
  484740
  487855
  489405
  489654
  489991
  490089
  490655
  491805
  494143
  494696
  495680
  496809
  499438
  505716
  506357
  506728
  507031
  507077
  510500
  510619
  511296
  511720
  512681
  514388
  517938
  518351
  520443
  521546
  523089
  524577
  524717
  524947
  529075
  548246
  555736
  555838
  556336
  556714
  557074
  560652
  563361
  564402
  565189
  565479
  566754
  567334
  567663
  568360
  569792
  573768
  573925
  576024
  577728
  587065
  587956
  590406
  591070
  592027
  614436
  617656
  621443
  670197
  673424
  702635
  801341
]
16.11 ms
(9.76%)
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
  97047
  422776
  462524
  511720
  556714
  565479
  573925
  587956
  590406
  702635
  458488
  402978
  467962
  472477
  505716
  510500
  489654
  490655
  499438
  389504
  411090
  507031
  386986
  565189
  475731
  555838
  459813
  484740
  429219
  459308
  478402
  490089
  556336
  673424
  587065
  416234
  422774
  521546
  524717
  489405
  420147
  617656
  463182
  453375
  569792
  567334
  566754
  591070
  422319
  524577
  524947
  510619
  514388
  518351
  491805
  458868
  472982
  474720
  454929
  456402
  464314
  670197
  568360
  473974
  529075
  489991
  511296
  517938
  474325
  506728
  417794
  567663
  614436
  476813
  446608
  433617
  440703
  448106
  507077
  520443
  442486
  465095
  476508
  495680
  548246
  621443
  407283
  449598
  459025
  443853
  429360
  434195
  441229
  484146
  506357
  512681
  442353
  496809
  557074
  555736
  564402
  573768
  560652
  576024
  494143
  494696
  563361
  487855
  441268
  445007
  444759
  577728
  592027
  801341
  424279
  419013
  458473
  472085
  523089
  469874
]
3.31 ms
(2.01%)
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
  97047
  386986
  389504
  402978
  407283
  411090
  416234
  417794
  419013
  420147
  422319
  422774
  422776
  424279
  429219
  429360
  433617
  434195
  440703
  441229
  441268
  442353
  442486
  443853
  444759
  445007
  446608
  448106
  449598
  453375
  454929
  456402
  458473
  458488
  458868
  459025
  459308
  459813
  462524
  463182
  464314
  465095
  467962
  469874
  472085
  472477
  472982
  473974
  474325
  474720
  475731
  476508
  476813
  478402
  484146
  484740
  487855
  489405
  489654
  489991
  490089
  490655
  491805
  494143
  494696
  495680
  496809
  499438
  505716
  506357
  506728
  507031
  507077
  510500
  510619
  511296
  511720
  512681
  514388
  517938
  518351
  520443
  521546
  523089
  524577
  524717
  524947
  529075
  548246
  555736
  555838
  556336
  556714
  557074
  560652
  563361
  564402
  565189
  565479
  566754
  567334
  567663
  568360
  569792
  573768
  573925
  576024
  577728
  587065
  587956
  590406
  591070
  592027
  614436
  617656
  621443
  670197
  673424
  702635
  801341
]
2.13 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl tits"
]
1.92 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк сиськ"
]
1.66 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.99%)
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.