Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
273.00 ms
(43.30%)
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
  605443
  606199
  609905
  612255
  623874
  637689
  643194
  595945
  639379
  805601
  790888
  811669
  723927
  729818
  725112
  741294
  734840
  741539
  733138
  740596
  728385
  742422
  751457
  760610
  808756
  809894
  390470
  395931
  423401
  424219
  432334
  463159
  469156
  470769
  475556
  383262
  410093
  446162
  460716
  461210
  470891
  397109
  399520
  423570
  423620
  432597
  432685
  445187
  445550
  462286
  385653
  415942
  418527
  422543
  443210
  458530
  459999
  468714
  473168
  474756
  416032
  445975
  460697
  460804
  466912
  472111
  481298
  503491
  505885
  506149
  509448
  515363
  526896
  496780
  497692
  513056
  515554
  517745
  525717
  535540
  483326
  486596
  494820
  498657
  508572
  514090
  526050
  483372
  483754
  492168
  493304
  495878
  510581
  514268
  518480
  523970
  527664
  528293
  529043
  80332
  383160
  393391
  397940
  419300
  421220
  443593
  414105
  418704
  434654
  422686
  423503
  424908
  425572
  442356
  422591
  422908
  437084
  439492
  815959
  448808
]
210.75 ms
(33.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
137.44 ms
(21.80%)
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
  80332
  383160
  383262
  385653
  390470
  393391
  395931
  397109
  397940
  399520
  410093
  414105
  415942
  416032
  418527
  418704
  419300
  421220
  422543
  422591
  422686
  422908
  423401
  423503
  423570
  423620
  424219
  424908
  425572
  432334
  432597
  432685
  434654
  437084
  439492
  442356
  443210
  443593
  445187
  445550
  445975
  446162
  448808
  458530
  459999
  460697
  460716
  460804
  461210
  462286
  463159
  466912
  468714
  469156
  470769
  470891
  472111
  473168
  474756
  475556
  481298
  483326
  483372
  483754
  486596
  492168
  493304
  494820
  495878
  496780
  497692
  498657
  503491
  505885
  506149
  508572
  509448
  510581
  513056
  514090
  514268
  515363
  515554
  517745
  518480
  523970
  525717
  526050
  526896
  527664
  528293
  529043
  535540
  595945
  605443
  606199
  609905
  612255
  623874
  637689
  639379
  643194
  723927
  725112
  728385
  729818
  733138
  734840
  740596
  741294
  741539
  742422
  751457
  760610
  790888
  805601
  808756
  809894
  811669
  815959
]
2.81 ms
(0.45%)
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
  80332
  383160
  383262
  385653
  390470
  393391
  395931
  397109
  397940
  399520
  410093
  414105
  415942
  416032
  418527
  418704
  419300
  421220
  422543
  422591
  422686
  422908
  423401
  423503
  423570
  423620
  424219
  424908
  425572
  432334
  432597
  432685
  434654
  437084
  439492
  442356
  443210
  443593
  445187
  445550
  445975
  446162
  448808
  458530
  459999
  460697
  460716
  460804
  461210
  462286
  463159
  466912
  468714
  469156
  470769
  470891
  472111
  473168
  474756
  475556
  481298
  483326
  483372
  483754
  486596
  492168
  493304
  494820
  495878
  496780
  497692
  498657
  503491
  505885
  506149
  508572
  509448
  510581
  513056
  514090
  514268
  515363
  515554
  517745
  518480
  523970
  525717
  526050
  526896
  527664
  528293
  529043
  535540
  595945
  605443
  606199
  609905
  612255
  623874
  637689
  639379
  643194
  723927
  725112
  728385
  729818
  733138
  734840
  740596
  741294
  741539
  742422
  751457
  760610
  790888
  805601
  808756
  809894
  811669
  815959
]
2.37 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "toys man"
]
2.37 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "toys мужчин"
]
1.76 ms
(0.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "toys мужчин"
]

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.