Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.71 ms
(82.80%)
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
  101353
  418861
  420428
  422731
  427573
  435239
  436091
  438486
  452306
  456415
  458496
  460785
  466809
  470651
  477702
  479243
  480071
  480284
  481315
  484514
  485356
  486323
  487578
  487798
  491146
  491622
  493573
  494074
  494894
  496464
  496469
  497127
  498149
  498288
  498945
  500225
  502260
  502799
  506473
  506637
  507346
  507383
  507508
  509743
  512850
  516537
  516846
  517110
  519332
  522467
  523347
  524429
  526854
  527440
  529495
  541420
  541545
  546871
  555600
  556291
  558249
  559617
  560695
  564892
  567739
  568823
  571401
  571467
  571741
  572242
  574408
  575979
  579861
  580906
  580982
  584088
  588915
  594495
  597015
  603888
  605668
  608860
  610450
  616517
  619068
  620812
  621113
  624587
  626070
  627144
  629541
  635604
  636893
  641890
  642084
  650682
  673158
  678858
  686397
  692870
  707148
  708057
  709430
  711416
  714352
  714739
  716952
  717972
  719514
  736112
  745229
  762442
  762525
  762667
  765386
  772376
  772389
  780260
  794403
  797929
]
21.86 ms
(12.09%)
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
  487578
  580982
  559617
  436091
  529495
  466809
  708057
  541420
  512850
  522467
  491622
  621113
  608860
  797929
  762525
  772389
  736112
  765386
  780260
  794403
  438486
  560695
  619068
  481315
  555600
  507346
  420428
  500225
  580906
  626070
  485356
  491146
  498288
  524429
  509743
  624587
  597015
  427573
  484514
  497127
  498945
  506473
  470651
  584088
  745229
  629541
  458496
  486323
  519332
  517110
  571467
  709430
  477702
  527440
  493573
  494894
  762667
  101353
  479243
  546871
  707148
  716952
  717972
  650682
  714352
  678858
  714739
  635604
  616517
  588915
  636893
  772376
  762442
  711416
  422731
  516846
  642084
  564892
  579861
  567739
  571741
  594495
  498149
  719514
  686397
  692870
  435239
  452306
  506637
  507383
  502799
  480284
  556291
  574408
  673158
  620812
  480071
  456415
  507508
  502260
  496469
  487798
  523347
  494074
  496464
  516537
  572242
  418861
  526854
  558249
  575979
  460785
  568823
  571401
  541545
  641890
  603888
  610450
  605668
  627144
]
2.59 ms
(1.43%)
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
  101353
  418861
  420428
  422731
  427573
  435239
  436091
  438486
  452306
  456415
  458496
  460785
  466809
  470651
  477702
  479243
  480071
  480284
  481315
  484514
  485356
  486323
  487578
  487798
  491146
  491622
  493573
  494074
  494894
  496464
  496469
  497127
  498149
  498288
  498945
  500225
  502260
  502799
  506473
  506637
  507346
  507383
  507508
  509743
  512850
  516537
  516846
  517110
  519332
  522467
  523347
  524429
  526854
  527440
  529495
  541420
  541545
  546871
  555600
  556291
  558249
  559617
  560695
  564892
  567739
  568823
  571401
  571467
  571741
  572242
  574408
  575979
  579861
  580906
  580982
  584088
  588915
  594495
  597015
  603888
  605668
  608860
  610450
  616517
  619068
  620812
  621113
  624587
  626070
  627144
  629541
  635604
  636893
  641890
  642084
  650682
  673158
  678858
  686397
  692870
  707148
  708057
  709430
  711416
  714352
  714739
  716952
  717972
  719514
  736112
  745229
  762442
  762525
  762667
  765386
  772376
  772389
  780260
  794403
  797929
]
1.82 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хуй в позже крупно"
]
1.78 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член в крупныйпла"
]
1.39 ms
(0.77%)
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.