Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.60 ms
(87.48%)
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
  384046
  419220
  443127
  443915
  445099
  446772
  448077
  464790
  465323
  468254
  468353
  468453
  471461
  474261
  482772
  487028
  488160
  495581
  497918
  510507
  522462
  523581
  531561
  534426
  534633
  537780
  548876
  550538
  552513
  555014
  559733
  570167
  581579
  588056
  595619
  595881
  597663
  601211
  613002
  615494
  620775
  623830
  646270
  650305
  656603
  663185
  663425
  663938
  669370
  671437
  673838
  675547
  675705
  679381
  679445
  681059
  681212
  700930
  708573
  710770
  711220
  712108
  712157
  712800
  717134
  717814
  720384
  721609
  722899
  726123
  726214
  728620
  730806
  735924
  740059
  740493
  740502
  741966
  745293
  745478
  745682
  747091
  750248
  751023
  752229
  752627
  756436
  756504
  756704
  760598
  762917
  763740
  767142
  767148
  769892
  770607
  770671
  773045
  775240
  782407
  785324
  788140
  793023
  793899
  794736
  796488
  797000
  800242
  800344
  800497
  801083
  801557
  801921
  804335
  804356
  805996
  815799
  823857
  825907
  827654
]
15.09 ms
(7.56%)
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
  770607
  804356
  752229
  534426
  597663
  613002
  623830
  773045
  769892
  751023
  726123
  595619
  671437
  712157
  801921
  495581
  656603
  712800
  588056
  804335
  760598
  801557
  767148
  740502
  793023
  730806
  745682
  550538
  722899
  794736
  443127
  679381
  681059
  720384
  741966
  827654
  785324
  762917
  770671
  646270
  650305
  721609
  775240
  788140
  805996
  740059
  615494
  497918
  384046
  464790
  756504
  756704
  465323
  675547
  679445
  708573
  800242
  740493
  735924
  488160
  570167
  793899
  487028
  548876
  745478
  531561
  750248
  474261
  523581
  815799
  446772
  710770
  712108
  796488
  726214
  763740
  752627
  797000
  700930
  801083
  468353
  825907
  534633
  552513
  669370
  663185
  717134
  745293
  747091
  782407
  445099
  522462
  675705
  663938
  448077
  823857
  471461
  581579
  595881
  800344
  756436
  728620
  443915
  800497
  559733
  620775
  601211
  673838
  711220
  468254
  681212
  482772
  537780
  555014
  767142
  419220
  468453
  510507
  663425
  717814
]
2.67 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
  384046
  419220
  443127
  443915
  445099
  446772
  448077
  464790
  465323
  468254
  468353
  468453
  471461
  474261
  482772
  487028
  488160
  495581
  497918
  510507
  522462
  523581
  531561
  534426
  534633
  537780
  548876
  550538
  552513
  555014
  559733
  570167
  581579
  588056
  595619
  595881
  597663
  601211
  613002
  615494
  620775
  623830
  646270
  650305
  656603
  663185
  663425
  663938
  669370
  671437
  673838
  675547
  675705
  679381
  679445
  681059
  681212
  700930
  708573
  710770
  711220
  712108
  712157
  712800
  717134
  717814
  720384
  721609
  722899
  726123
  726214
  728620
  730806
  735924
  740059
  740493
  740502
  741966
  745293
  745478
  745682
  747091
  750248
  751023
  752229
  752627
  756436
  756504
  756704
  760598
  762917
  763740
  767142
  767148
  769892
  770607
  770671
  773045
  775240
  782407
  785324
  788140
  793023
  793899
  794736
  796488
  797000
  800242
  800344
  800497
  801083
  801557
  801921
  804335
  804356
  805996
  815799
  823857
  825907
  827654
]
2.03 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy and ass"
]
1.70 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy жоп"
]
1.47 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy жоп"
]

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.