Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.15 ms
(85.51%)
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
  394747
  395492
  395682
  395867
  397072
  399754
  400157
  401945
  410413
  414976
  416841
  418213
  421346
  421394
  422754
  425773
  426094
  426301
  428966
  428987
  429471
  429906
  430742
  445731
  447142
  449112
  449579
  456894
  459226
  467908
  471899
  473023
  476120
  476360
  483978
  484117
  485303
  489161
  500699
  504720
  506469
  511279
  515734
  519277
  522148
  524110
  526132
  537518
  538870
  540168
  544479
  544591
  545312
  545330
  546690
  549426
  550101
  550208
  550214
  552005
  552912
  552913
  553452
  556408
  559118
  559867
  559868
  561124
  563876
  564247
  566761
  567020
  568738
  571092
  571124
  571447
  572621
  572902
  577767
  578531
  579922
  580287
  580301
  585198
  591556
  591829
  592396
  593117
  596415
  598670
  598783
  601038
  605332
  606699
  606749
  608426
  610365
  618734
  621029
  622607
  622991
  623544
  623569
  636707
  647605
  662071
  665936
  680212
  696443
  715319
  735128
  797726
  800396
  802295
  806422
  812052
  818825
  819537
  823181
  827888
]
12.90 ms
(8.47%)
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
  823181
  827888
  459226
  445731
  456894
  545312
  556408
  563876
  564247
  696443
  561124
  571092
  593117
  622607
  802295
  735128
  618734
  421346
  426094
  471899
  511279
  504720
  580301
  549426
  665936
  598670
  605332
  621029
  797726
  428966
  401945
  410413
  414976
  394747
  467908
  568738
  484117
  421394
  428987
  566761
  476120
  397072
  422754
  449112
  485303
  522148
  519277
  545330
  580287
  550101
  577767
  622991
  591556
  800396
  806422
  500699
  418213
  399754
  819537
  540168
  550208
  552912
  559118
  559868
  544479
  546690
  553452
  544591
  647605
  550214
  572621
  608426
  592396
  596415
  606749
  606699
  812052
  473023
  430742
  524110
  515734
  483978
  476360
  395867
  449579
  426301
  425773
  572902
  578531
  662071
  506469
  395682
  416841
  680212
  447142
  559867
  571124
  591829
  395492
  429906
  552005
  571447
  552913
  598783
  623569
  400157
  429471
  818825
  489161
  537518
  526132
  538870
  579922
  567020
  636707
  585198
  601038
  610365
  623544
  715319
]
2.73 ms
(1.80%)
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
  394747
  395492
  395682
  395867
  397072
  399754
  400157
  401945
  410413
  414976
  416841
  418213
  421346
  421394
  422754
  425773
  426094
  426301
  428966
  428987
  429471
  429906
  430742
  445731
  447142
  449112
  449579
  456894
  459226
  467908
  471899
  473023
  476120
  476360
  483978
  484117
  485303
  489161
  500699
  504720
  506469
  511279
  515734
  519277
  522148
  524110
  526132
  537518
  538870
  540168
  544479
  544591
  545312
  545330
  546690
  549426
  550101
  550208
  550214
  552005
  552912
  552913
  553452
  556408
  559118
  559867
  559868
  561124
  563876
  564247
  566761
  567020
  568738
  571092
  571124
  571447
  572621
  572902
  577767
  578531
  579922
  580287
  580301
  585198
  591556
  591829
  592396
  593117
  596415
  598670
  598783
  601038
  605332
  606699
  606749
  608426
  610365
  618734
  621029
  622607
  622991
  623544
  623569
  636707
  647605
  662071
  665936
  680212
  696443
  715319
  735128
  797726
  800396
  802295
  806422
  812052
  818825
  819537
  823181
  827888
]
1.73 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny hairy sex"
]
1.69 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые волосатая секс"
]
1.54 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые волосатая секс"
]
1.45 ms
(0.95%)
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.