Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.53 ms
(83.33%)
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
  188062
  212750
  229555
  396337
  398534
  406062
  411918
  411924
  412992
  419560
  449084
  450133
  453471
  454196
  460186
  460332
  460919
  462075
  462076
  462083
  462084
  462098
  463172
  464941
  466731
  468232
  469292
  470388
  471067
  472413
  474395
  474820
  474859
  476239
  476347
  476350
  479765
  485374
  485768
  485989
  488032
  488370
  489172
  499548
  499914
  502806
  502921
  506819
  510872
  514331
  518823
  518834
  518871
  518873
  519152
  519153
  519154
  521463
  522478
  525510
  548067
  548393
  554446
  554498
  554512
  554843
  559279
  559292
  559344
  559579
  566814
  574448
  577192
  577267
  589579
  628637
  629813
  630049
  665141
  665423
  681290
  701182
  705796
  709544
  709668
  713188
  720571
  724252
  732385
  741787
  744234
  744369
  744996
  745447
  746049
  770091
  770176
  770248
  771339
  772882
  773901
  773902
  776145
  776148
  780554
  781760
  781968
  781976
  785136
  794734
  795093
  795221
  800714
  801117
  805960
  807996
  808001
  808271
  809753
  810348
]
18.09 ms
(11.21%)
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
  411918
  460919
  471067
  525510
  499914
  559292
  554843
  771339
  720571
  466731
  212750
  521463
  681290
  705796
  781968
  800714
  772882
  773902
  419560
  559279
  770091
  485768
  518871
  485989
  468232
  519153
  485374
  449084
  450133
  589579
  709544
  770248
  808271
  785136
  522478
  229555
  518823
  713188
  709668
  665141
  665423
  795093
  805960
  807996
  745447
  801117
  810348
  732385
  746049
  630049
  776145
  780554
  808001
  406062
  453471
  462083
  454196
  474395
  474859
  510872
  499548
  469292
  724252
  463172
  472413
  462084
  464941
  470388
  479765
  488032
  518873
  519154
  559579
  476347
  488370
  460186
  559344
  577192
  776148
  462075
  548393
  744996
  489172
  412992
  506819
  519152
  574448
  554512
  701182
  577267
  628637
  629813
  773901
  781976
  794734
  795221
  744369
  741787
  781760
  809753
  398534
  411924
  548067
  396337
  462098
  554446
  566814
  554498
  188062
  460332
  474820
  476239
  514331
  476350
  462076
  502806
  502921
  518834
  770176
  744234
]
2.42 ms
(1.50%)
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
  188062
  212750
  229555
  396337
  398534
  406062
  411918
  411924
  412992
  419560
  449084
  450133
  453471
  454196
  460186
  460332
  460919
  462075
  462076
  462083
  462084
  462098
  463172
  464941
  466731
  468232
  469292
  470388
  471067
  472413
  474395
  474820
  474859
  476239
  476347
  476350
  479765
  485374
  485768
  485989
  488032
  488370
  489172
  499548
  499914
  502806
  502921
  506819
  510872
  514331
  518823
  518834
  518871
  518873
  519152
  519153
  519154
  521463
  522478
  525510
  548067
  548393
  554446
  554498
  554512
  554843
  559279
  559292
  559344
  559579
  566814
  574448
  577192
  577267
  589579
  628637
  629813
  630049
  665141
  665423
  681290
  701182
  705796
  709544
  709668
  713188
  720571
  724252
  732385
  741787
  744234
  744369
  744996
  745447
  746049
  770091
  770176
  770248
  771339
  772882
  773901
  773902
  776145
  776148
  780554
  781760
  781968
  781976
  785136
  794734
  795093
  795221
  800714
  801117
  805960
  807996
  808001
  808271
  809753
  810348
]
1.84 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "бабки с большой жопой%…"
]
1.42 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бабушк большая большие жоп"
]
1.32 ms
(0.82%)
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.