Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.56 ms
(84.25%)
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
  318892
  385141
  400992
  415563
  419545
  420155
  422774
  429214
  429665
  432422
  432910
  437161
  437476
  438369
  439608
  443165
  445620
  445919
  446006
  446632
  447529
  450754
  450825
  451030
  451033
  451438
  453599
  455213
  455777
  456264
  457110
  457202
  457609
  459699
  461005
  461388
  461556
  461793
  462865
  463800
  467773
  468638
  469497
  469695
  470771
  471995
  472466
  473971
  474964
  475866
  475876
  476521
  476974
  478507
  480263
  481288
  481527
  481536
  481554
  483130
  483610
  484134
  484429
  484591
  484638
  484931
  485074
  485332
  485353
  486562
  487334
  488090
  488201
  488566
  488700
  488858
  490823
  491320
  492717
  493911
  500146
  500665
  501393
  501394
  501716
  504797
  505930
  506250
  507004
  508078
  508630
  509378
  509636
  510208
  510406
  510676
  511233
  512069
  512782
  513529
  513552
  513612
  514058
  514076
  514792
  516140
  516916
  517149
  517581
  517912
  518218
  521546
  522962
  523934
  525290
  525807
  526655
  527322
  536278
  539058
]
20.26 ms
(10.19%)
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
  429214
  432422
  432910
  439608
  446632
  447529
  450825
  451438
  455777
  457202
  457609
  462865
  463800
  469497
  469695
  473971
  480263
  481288
  318892
  385141
  400992
  415563
  419545
  420155
  422774
  437161
  438369
  455213
  456264
  461005
  461388
  461556
  461793
  471995
  472466
  474964
  475866
  476974
  478507
  481536
  481554
  429665
  437476
  443165
  445620
  445919
  446006
  450754
  451030
  451033
  453599
  457110
  459699
  467773
  468638
  470771
  475876
  476521
  481527
  500146
  500665
  501393
  501394
  501716
  504797
  508630
  509378
  510208
  510406
  510676
  511233
  512069
  513552
  514058
  514076
  517149
  517581
  517912
  521546
  525290
  525807
  526655
  539058
  484429
  484591
  484638
  485074
  486562
  487334
  490823
  491320
  493911
  505930
  506250
  507004
  508078
  509636
  512782
  513529
  513612
  514792
  516140
  516916
  518218
  522962
  523934
  527322
  536278
  483130
  483610
  484134
  484931
  485332
  485353
  488090
  488201
  488566
  488700
  488858
  492717
]
3.40 ms
(1.71%)
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
  318892
  385141
  400992
  415563
  419545
  420155
  422774
  429214
  429665
  432422
  432910
  437161
  437476
  438369
  439608
  443165
  445620
  445919
  446006
  446632
  447529
  450754
  450825
  451030
  451033
  451438
  453599
  455213
  455777
  456264
  457110
  457202
  457609
  459699
  461005
  461388
  461556
  461793
  462865
  463800
  467773
  468638
  469497
  469695
  470771
  471995
  472466
  473971
  474964
  475866
  475876
  476521
  476974
  478507
  480263
  481288
  481527
  481536
  481554
  483130
  483610
  484134
  484429
  484591
  484638
  484931
  485074
  485332
  485353
  486562
  487334
  488090
  488201
  488566
  488700
  488858
  490823
  491320
  492717
  493911
  500146
  500665
  501393
  501394
  501716
  504797
  505930
  506250
  507004
  508078
  508630
  509378
  509636
  510208
  510406
  510676
  511233
  512069
  512782
  513529
  513552
  513612
  514058
  514076
  514792
  516140
  516916
  517149
  517581
  517912
  518218
  521546
  522962
  523934
  525290
  525807
  526655
  527322
  536278
  539058
]
2.32 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "щеку"
]
1.94 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "щек"
]
1.82 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.80%)
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.