Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.17 ms
(85.06%)
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
  96665
  385752
  388903
  390623
  390713
  395182
  397780
  400942
  402649
  406128
  407313
  414135
  416294
  417836
  419523
  419694
  421043
  424613
  427245
  432766
  435695
  446079
  446110
  448806
  450455
  452832
  454188
  457701
  460208
  460305
  461315
  462305
  462317
  464326
  464959
  467872
  467893
  468072
  468073
  468096
  468099
  468154
  468835
  469616
  472659
  473223
  476180
  482527
  482552
  484283
  484645
  485130
  489868
  490517
  491259
  493127
  493202
  493835
  496835
  497827
  502775
  508807
  509800
  511027
  513195
  518238
  519309
  520684
  522592
  538870
  543855
  550925
  554866
  574298
  576636
  576695
  580265
  584004
  586673
  590418
  594340
  596844
  602259
  609887
  614833
  615748
  622335
  631930
  642022
  643767
  648204
  656200
  658773
  670286
  680215
  692732
  694222
  696120
  710460
  715368
  720714
  722212
  724268
  727560
  733416
  744463
  758256
  775869
  788187
  796297
  798705
  800429
  808472
  815119
  815943
  817119
  817632
  823746
  824456
  825044
]
18.94 ms
(9.94%)
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
  427245
  519309
  508807
  468835
  462305
  462317
  493127
  454188
  468072
  509800
  419523
  388903
  390713
  414135
  468099
  395182
  824456
  580265
  432766
  419694
  464959
  468154
  576695
  518238
  485130
  715368
  522592
  658773
  594340
  482527
  424613
  490517
  450455
  502775
  513195
  469616
  543855
  400942
  406128
  468073
  473223
  497827
  710460
  609887
  643767
  744463
  720714
  417836
  446079
  511027
  815119
  472659
  648204
  670286
  574298
  631930
  642022
  590418
  602259
  622335
  724268
  808472
  448806
  467872
  467893
  496835
  484283
  464326
  385752
  390623
  817632
  823746
  815943
  817119
  538870
  554866
  694222
  722212
  656200
  680215
  696120
  596844
  798705
  733416
  758256
  452832
  727560
  407313
  416294
  457701
  493202
  614833
  397780
  520684
  460305
  476180
  550925
  692732
  775869
  788187
  800429
  796297
  461315
  96665
  584004
  435695
  491259
  493835
  576636
  615748
  402649
  421043
  446110
  460208
  482552
  489868
  468096
  484645
  825044
  586673
]
2.39 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.05%)
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
  96665
  385752
  388903
  390623
  390713
  395182
  397780
  400942
  402649
  406128
  407313
  414135
  416294
  417836
  419523
  419694
  421043
  424613
  427245
  432766
  435695
  446079
  446110
  448806
  450455
  452832
  454188
  457701
  460208
  460305
  461315
  462305
  462317
  464326
  464959
  467872
  467893
  468072
  468073
  468096
  468099
  468154
  468835
  469616
  472659
  473223
  476180
  482527
  482552
  484283
  484645
  485130
  489868
  490517
  491259
  493127
  493202
  493835
  496835
  497827
  502775
  508807
  509800
  511027
  513195
  518238
  519309
  520684
  522592
  538870
  543855
  550925
  554866
  574298
  576636
  576695
  580265
  584004
  586673
  590418
  594340
  596844
  602259
  609887
  614833
  615748
  622335
  631930
  642022
  643767
  648204
  656200
  658773
  670286
  680215
  692732
  694222
  696120
  710460
  715368
  720714
  722212
  724268
  727560
  733416
  744463
  758256
  775869
  788187
  796297
  798705
  800429
  808472
  815119
  815943
  817119
  817632
  823746
  824456
  825044
]
2.00 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "волосатую зрелку в попу"
]
1.63 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая зрелая женщин анал"
]
1.52 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.