Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.72 ms
(84.40%)
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
  27593
  260041
  383211
  400728
  401536
  405815
  415099
  418121
  428373
  429937
  432430
  434541
  438057
  439446
  439620
  439674
  440946
  443673
  445103
  445350
  446003
  452283
  455015
  456825
  459650
  460583
  460804
  465235
  466286
  473404
  478828
  479953
  481941
  483971
  486094
  492440
  495248
  504423
  506602
  507674
  511418
  513937
  515263
  515678
  517558
  518186
  520145
  520382
  521356
  522439
  524029
  531265
  542079
  544585
  546894
  549708
  555036
  557958
  567376
  569538
  569771
  571010
  573806
  578218
  580012
  581294
  585663
  593455
  606605
  608071
  612601
  631358
  633092
  645706
  651768
  653127
  700914
  702237
  702239
  709183
  709458
  709508
  716010
  716082
  716178
  725232
  726398
  726735
  728492
  729177
  738287
  738834
  739542
  742567
  743809
  744184
  745648
  746259
  751498
  752532
  753057
  759917
  760679
  764137
  779934
  780125
  780469
  781769
  784240
  785739
  786690
  787506
  793223
  793770
  794388
  796141
  798600
  802211
  811919
]
15.01 ms
(9.33%)
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
  780469
  439620
  524029
  506602
  728492
  573806
  725232
  786690
  511418
  739542
  520145
  518186
  27593
  794388
  785739
  726398
  593455
  738287
  742567
  651768
  726735
  753057
  709183
  796141
  716010
  802211
  438057
  716082
  544585
  653127
  633092
  459650
  793223
  700914
  716178
  781769
  729177
  784240
  581294
  432430
  798600
  446003
  744184
  580012
  759917
  743809
  492440
  434541
  546894
  401536
  764137
  260041
  793770
  752532
  555036
  631358
  443673
  507674
  702239
  702237
  522439
  751498
  738834
  811919
  760679
  439446
  569771
  709508
  709458
  429937
  567376
  415099
  779905
  612601
  456825
  780125
  531265
  400728
  571010
  779934
  445350
  495248
  515263
  513937
  578218
  465235
  483971
  606605
  466286
  549708
  608071
  428373
  473404
  569538
  645706
  481941
  542079
  479953
  520382
  439674
  460583
  440946
  746259
  515678
  405815
  452283
  455015
  478828
  585663
  521356
  418121
  445103
  787506
  383211
  557958
  504423
  517558
  745648
  486094
  460804
]
2.70 ms
(1.68%)
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
  27593
  260041
  383211
  400728
  401536
  405815
  415099
  418121
  428373
  429937
  432430
  434541
  438057
  439446
  439620
  439674
  440946
  443673
  445103
  445350
  446003
  452283
  455015
  456825
  459650
  460583
  460804
  465235
  466286
  473404
  478828
  479953
  481941
  483971
  486094
  492440
  495248
  504423
  506602
  507674
  511418
  513937
  515263
  515678
  517558
  518186
  520145
  520382
  521356
  522439
  524029
  531265
  542079
  544585
  546894
  549708
  555036
  557958
  567376
  569538
  569771
  571010
  573806
  578218
  580012
  581294
  585663
  593455
  606605
  608071
  612601
  631358
  633092
  645706
  651768
  653127
  700914
  702237
  702239
  709183
  709458
  709508
  716010
  716082
  716178
  725232
  726398
  726735
  728492
  729177
  738287
  738834
  739542
  742567
  743809
  744184
  745648
  746259
  751498
  752532
  753057
  759917
  760679
  764137
  779934
  780125
  780469
  781769
  784240
  785739
  786690
  787506
  793223
  793770
  794388
  796141
  798600
  802211
  811919
]
2.07 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм мам женщин"
]
1.86 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сперма маме"
]
1.84 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.00%)
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.