Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.50 ms
(87.66%)
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
  34382
  410203
  414643
  419293
  419631
  420353
  420367
  420369
  420381
  421732
  421982
  431893
  431904
  432928
  437193
  437368
  444074
  444424
  447005
  448103
  448503
  448867
  452890
  452892
  453030
  453032
  453226
  453228
  457174
  457179
  457183
  457653
  457958
  457971
  460863
  461234
  464343
  464982
  465611
  468726
  469997
  470418
  470555
  470858
  476274
  478582
  480135
  481126
  482314
  482698
  484271
  486383
  487368
  487543
  502756
  502762
  509078
  510953
  515023
  515364
  515725
  515805
  516514
  521559
  524614
  530109
  530452
  531700
  536390
  541103
  544305
  545455
  545624
  545854
  550314
  550530
  556072
  561313
  565252
  565280
  566656
  569020
  577990
  579790
  580166
  580182
  581500
  582301
  582321
  582849
  583035
  612070
  630380
  702627
  705737
  709198
  711685
  718928
  722812
  722864
  726635
  751094
  751128
  751150
  751159
  757431
  761129
  761992
  774214
  780567
  784153
  786471
  797328
  798351
  802594
  810991
  813273
  816565
  818206
]
13.27 ms
(7.07%)
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
  813273
  751159
  774214
  726635
  761992
  751128
  751150
  757431
  751094
  761129
  612070
  630380
  702627
  705737
  722812
  722864
  780567
  784153
  786471
  797328
  798351
  802594
  810991
  453226
  457958
  470555
  444424
  452890
  452892
  468726
  478582
  480135
  410203
  419293
  420369
  457653
  457971
  469997
  414643
  420367
  437193
  444074
  448503
  509078
  516514
  487368
  502756
  515725
  502762
  524614
  510953
  536390
  556072
  453030
  579790
  709198
  437368
  464982
  460863
  34382
  420381
  421732
  431893
  431904
  432928
  419631
  420353
  421982
  816565
  818206
  482698
  447005
  448103
  448867
  453032
  470418
  470858
  481126
  484271
  453228
  457174
  457179
  461234
  464343
  486383
  457183
  482314
  487543
  515023
  515364
  515805
  530452
  521559
  530109
  531700
  465611
  476274
  541103
  544305
  545455
  565252
  566656
  569020
  580166
  580182
  582849
  545624
  561313
  581500
  582321
  545854
  550314
  550530
  552409
  565280
  577990
  582301
  583035
  711685
  718928
]
3.30 ms
(1.76%)
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
  34382
  410203
  414643
  419293
  419631
  420353
  420367
  420369
  420381
  421732
  421982
  431893
  431904
  432928
  437193
  437368
  444074
  444424
  447005
  448103
  448503
  448867
  452890
  452892
  453030
  453032
  453226
  453228
  457174
  457179
  457183
  457653
  457958
  457971
  460863
  461234
  464343
  464982
  465611
  468726
  469997
  470418
  470555
  470858
  476274
  478582
  480135
  481126
  482314
  482698
  484271
  486383
  487368
  487543
  502756
  502762
  509078
  510953
  515023
  515364
  515725
  515805
  516514
  521559
  524614
  530109
  530452
  531700
  536390
  541103
  544305
  545455
  545624
  545854
  550314
  550530
  556072
  561313
  565252
  565280
  566656
  569020
  577990
  579790
  580166
  580182
  581500
  582301
  582321
  582849
  583035
  612070
  630380
  702627
  705737
  709198
  711685
  718928
  722812
  722864
  726635
  751094
  751128
  751150
  751159
  757431
  761129
  761992
  774214
  780567
  784153
  786471
  797328
  798351
  802594
  810991
  813273
  816565
  818206
]
1.93 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно мультики смотреть"
]
1.64 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн мультфильм смотрет"
]
1.41 ms
(0.75%)
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.