Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.81 ms
(87.35%)
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
  414967
  436066
  457216
  466686
  469988
  489254
  494732
  508884
  512860
  513119
  514752
  516604
  517746
  522139
  529708
  533238
  533818
  534800
  541899
  543209
  544229
  544414
  546827
  549505
  549565
  550068
  551828
  553006
  555889
  557917
  558794
  565598
  567192
  570732
  574824
  585301
  590624
  590638
  595048
  595712
  595747
  596621
  596665
  596819
  599981
  606756
  610938
  612302
  621099
  622061
  625314
  630077
  630984
  635144
  643095
  644175
  647140
  653678
  656629
  662206
  666556
  667809
  673217
  675303
  675841
  676644
  678811
  679228
  682822
  684359
  689133
  689136
  692653
  695828
  712527
  712552
  716607
  716834
  728134
  731110
  732915
  734180
  734234
  737932
  740481
  743067
  746335
  747646
  749282
  749618
  750115
  756165
  756955
  760782
  760895
  763350
  767952
  768797
  770370
  771724
  775892
  779489
  779632
  780030
  787802
  790475
  791106
  791706
  793364
  793593
  793629
  796581
  797435
  799523
  800747
  805635
  809146
  809657
  810388
  811745
]
16.86 ms
(8.23%)
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
  643095
  793629
  517746
  534800
  712552
  775892
  457216
  533818
  466686
  692653
  675841
  662206
  676644
  644175
  625314
  630077
  779632
  749282
  767952
  793593
  514752
  543209
  653678
  551828
  558794
  596621
  731110
  805635
  436066
  469988
  494732
  516604
  546827
  550068
  565598
  541899
  544414
  557917
  678811
  679228
  673217
  595712
  596665
  599981
  595747
  791706
  732915
  743067
  797435
  809146
  811745
  734234
  734180
  749618
  760895
  737932
  747646
  612302
  791106
  522139
  508884
  513119
  544229
  553006
  574824
  549565
  682822
  666556
  689136
  695828
  712527
  555889
  570732
  610938
  622061
  596819
  630984
  780030
  799523
  800747
  810388
  728134
  768797
  760782
  763350
  635144
  716607
  787802
  796581
  414967
  489254
  512860
  533238
  529708
  549505
  567192
  684359
  656629
  667809
  675303
  647140
  689133
  716834
  585301
  590624
  590638
  621099
  595048
  606756
  779489
  790475
  793364
  770370
  809657
  746335
  756955
  740481
  750115
  756165
  771724
]
2.75 ms
(1.34%)
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
  414967
  436066
  457216
  466686
  469988
  489254
  494732
  508884
  512860
  513119
  514752
  516604
  517746
  522139
  529708
  533238
  533818
  534800
  541899
  543209
  544229
  544414
  546827
  549505
  549565
  550068
  551828
  553006
  555889
  557917
  558794
  565598
  567192
  570732
  574824
  585301
  590624
  590638
  595048
  595712
  595747
  596621
  596665
  596819
  599981
  606756
  610938
  612302
  621099
  622061
  625314
  630077
  630984
  635144
  643095
  644175
  647140
  653678
  656629
  662206
  666556
  667809
  673217
  675303
  675841
  676644
  678811
  679228
  682822
  684359
  689133
  689136
  692653
  695828
  712527
  712552
  716607
  716834
  728134
  731110
  732915
  734180
  734234
  737932
  740481
  743067
  746335
  747646
  749282
  749618
  750115
  756165
  756955
  760782
  760895
  763350
  767952
  768797
  770370
  771724
  775892
  779489
  779632
  780030
  787802
  790475
  791106
  791706
  793364
  793593
  793629
  796581
  797435
  799523
  800747
  805635
  809146
  809657
  810388
  811745
]
1.71 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "горлом ебет"
]
1.61 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "горл секс"
]
1.30 ms
(0.63%)
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.