Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.75 ms
(51.81%)
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
  233647
  323352
  386716
  387379
  392721
  398125
  398237
  401754
  401809
  404090
  406010
  412137
  413098
  418131
  418351
  418365
  418750
  420824
  420858
  421390
  421617
  423714
  424134
  425183
  425480
  426451
  429098
  432949
  436080
  437233
  438671
  441301
  441611
  442709
  444930
  445099
  448585
  449297
  450364
  452736
  454098
  456147
  457074
  457254
  459578
  461444
  461619
  462336
  466703
  466882
  467988
  468432
  468853
  469501
  469741
  470703
  473193
  473454
  476728
  477393
  478922
  479065
  479550
  480957
  481156
  481524
  482568
  483240
  483735
  487556
  490951
  492022
  495751
  498541
  499922
  501707
  503054
  506306
  509035
  509812
  509898
  512496
  514430
  520602
  522328
  524594
  526013
  526948
  527917
  531838
  534135
  536635
  536641
  541845
  541858
  548175
  555886
  557106
  559515
  564652
  568262
  568300
  568301
  572782
  579190
  587292
  598318
  598746
  605285
  607870
  620330
  621183
  635207
  678974
  681731
  683297
  717644
  731691
  736796
  782302
]
171.24 ms
(42.09%)
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
  233647
  323352
  386716
  387379
  392721
  398125
  398237
  401754
  401809
  404090
  406010
  412137
  413098
  418131
  418351
  418365
  418750
  420824
  420858
  421390
  421617
  423714
  424134
  425183
  425480
  426451
  429098
  432949
  436080
  437233
  438671
  441301
  441611
  442709
  444930
  445099
  448585
  449297
  450364
  452736
  454098
  456147
  457074
  457254
  459578
  461444
  461619
  462336
  466703
  466882
  467988
  468432
  468853
  469501
  469741
  470703
  473193
  473454
  476728
  477393
  478922
  479065
  479550
  480957
  481156
  481524
  482568
  483240
  483735
  487556
  490951
  492022
  495751
  498541
  499922
  501707
  503054
  506306
  509035
  509812
  509898
  512496
  514430
  520602
  522328
  524594
  526013
  526948
  527917
  531838
  534135
  536635
  536641
  541845
  541858
  548175
  555886
  557106
  559515
  564652
  568262
  568300
  568301
  572782
  579190
  587292
  598318
  598746
  605285
  607870
  620330
  621183
  635207
  678974
  681731
  683297
  717644
  731691
  736796
  782302
]
17.71 ms
(4.35%)
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
  398237
  731691
  233647
  392721
  478922
  526013
  442709
  579190
  681731
  678974
  598746
  481524
  469501
  509812
  432949
  420824
  467988
  406010
  503054
  412137
  501707
  568301
  473193
  444930
  483735
  526948
  683297
  457254
  441301
  506306
  564652
  621183
  421390
  418351
  423714
  482568
  782302
  454098
  536641
  587292
  426451
  418750
  462336
  476728
  495751
  477393
  436080
  509898
  520602
  480957
  717644
  438671
  386716
  429098
  425183
  531838
  479065
  559515
  441611
  499922
  541845
  568262
  437233
  445099
  468432
  481156
  498541
  490951
  387379
  522328
  404090
  452736
  466703
  468853
  449297
  473454
  466882
  534135
  548175
  568300
  598318
  736796
  413098
  448585
  401754
  424134
  456147
  512496
  483240
  401809
  461619
  527917
  555886
  541858
  572782
  635207
  605285
  607870
  620330
  323352
  398125
  421617
  450364
  487556
  492022
  509035
  536635
  425480
  418131
  469741
  457074
  470703
  514430
  524594
  557106
  459578
  479550
  461444
  418365
  420858
]
1.95 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur webcam sex"
]
1.77 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск вебкамер секс"
]
1.71 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск вебкамер секс"
]
1.67 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.