Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.51 ms
(86.03%)
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
  4274
  10035
  14599
  16679
  31627
  53698
  129791
  239542
  241603
  251476
  263299
  309991
  318315
  318318
  381828
  385024
  385742
  386835
  387085
  387207
  389757
  390378
  396168
  396261
  396662
  396677
  397329
  401124
  401966
  403418
  403539
  417362
  420460
  421249
  421696
  427221
  428543
  428631
  431410
  432081
  432595
  446375
  447846
  453790
  456398
  456597
  456676
  457528
  457776
  463114
  474442
  482566
  490837
  493488
  497524
  497806
  509151
  509161
  510586
  519447
  519683
  520727
  522515
  523634
  525749
  526083
  533997
  536894
  540461
  547954
  558659
  559598
  563399
  568327
  571441
  576074
  583976
  591736
  597831
  599271
  599586
  603460
  605500
  627103
  629381
  642260
  657246
  663912
  665122
  677352
  680102
  693898
  695338
  705741
  720515
  724536
  725826
  726157
  726788
  728114
  731053
  737445
  745683
  750271
  758430
  762226
  775355
  780876
  782252
  788772
  788912
  789544
  795529
  797736
  804114
  804249
  805309
  807725
  809328
  810031
]
14.68 ms
(8.45%)
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
  726788
  725826
  750271
  788772
  804249
  805309
  810031
  239542
  386835
  4274
  403418
  788912
  387085
  568327
  599586
  597831
  605500
  396168
  309991
  381828
  16679
  396261
  417362
  428543
  482566
  463114
  453790
  456597
  457776
  519683
  533997
  510586
  526083
  540461
  490837
  680102
  663912
  677352
  559598
  603460
  591736
  627103
  807725
  737445
  387207
  432595
  31627
  397329
  318315
  509161
  522515
  509151
  497524
  519447
  241603
  263299
  389757
  390378
  421249
  421696
  427221
  493488
  456398
  456676
  447846
  536894
  571441
  629381
  797736
  396662
  385742
  523634
  385024
  251476
  129791
  318318
  53698
  14599
  396677
  403539
  420460
  474442
  446375
  558659
  547954
  665122
  657246
  693898
  705741
  695338
  720515
  642260
  599271
  775355
  789544
  795529
  809328
  780876
  758430
  724536
  745683
  728114
  731053
  762226
  726157
  782252
  804114
  401124
  401966
  457528
  10035
  525749
  497806
  428631
  431410
  520727
  583976
  563399
  576074
  432081
]
2.45 ms
(1.41%)
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
  4274
  10035
  14599
  16679
  31627
  53698
  129791
  239542
  241603
  251476
  263299
  309991
  318315
  318318
  381828
  385024
  385742
  386835
  387085
  387207
  389757
  390378
  396168
  396261
  396662
  396677
  397329
  401124
  401966
  403418
  403539
  417362
  420460
  421249
  421696
  427221
  428543
  428631
  431410
  432081
  432595
  446375
  447846
  453790
  456398
  456597
  456676
  457528
  457776
  463114
  474442
  482566
  490837
  493488
  497524
  497806
  509151
  509161
  510586
  519447
  519683
  520727
  522515
  523634
  525749
  526083
  533997
  536894
  540461
  547954
  558659
  559598
  563399
  568327
  571441
  576074
  583976
  591736
  597831
  599271
  599586
  603460
  605500
  627103
  629381
  642260
  657246
  663912
  665122
  677352
  680102
  693898
  695338
  705741
  720515
  724536
  725826
  726157
  726788
  728114
  731053
  737445
  745683
  750271
  758430
  762226
  775355
  780876
  782252
  788772
  788912
  789544
  795529
  797736
  804114
  804249
  805309
  807725
  809328
  810031
]
1.86 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мужчин жоп"
]
1.82 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "man ass"
]
1.74 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин жоп"
]
1.73 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.