Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
331.73 ms
(92.64%)
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
  20031
  29367
  38452
  385064
  389864
  390380
  391144
  392704
  393393
  395389
  395628
  395662
  395793
  396784
  397714
  398412
  398713
  398908
  398920
  400956
  401440
  401614
  402091
  402312
  402931
  403628
  404267
  408824
  411133
  415487
  417758
  418083
  419598
  420084
  420091
  420507
  421122
  421182
  423994
  424023
  425299
  426057
  426463
  426669
  428685
  430969
  431205
  431687
  433950
  435799
  437556
  443443
  443463
  444005
  446253
  454674
  454939
  455009
  455509
  456901
  457005
  457046
  459496
  459790
  460801
  461482
  461519
  461528
  461532
  461625
  461873
  465754
  465950
  466197
  467336
  469202
  473549
  475444
  475584
  477876
  481340
  586803
  587247
  587505
  590511
  590955
  593140
  597226
  598235
  598310
  600191
  605397
  605515
  620475
  625915
  633518
  638550
  721854
  732116
  736979
  737397
  749688
  752161
  756800
  758691
  765055
  774794
  779267
  783151
  784237
  784679
  788908
  795554
  805027
  805031
  805684
  806883
  806961
  807345
  813251
]
15.54 ms
(4.34%)
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
  586803
  590511
  593140
  597226
  598310
  600191
  605397
  587247
  587505
  590955
  598235
  605515
  625915
  638550
  779267
  806961
  807345
  784237
  784679
  805031
  806883
  813251
  749688
  805027
  805684
  756800
  758691
  765055
  752161
  732116
  736979
  737397
  620475
  633518
  721854
  774794
  783151
  788908
  795554
  29367
  385064
  401614
  402312
  402931
  403628
  408824
  411133
  415487
  419598
  420507
  423994
  424023
  425299
  426669
  431205
  431687
  433950
  437556
  455509
  457046
  461482
  475444
  477876
  481340
  38452
  389864
  390380
  392704
  393393
  395389
  395628
  395662
  395793
  398412
  398908
  402091
  404267
  418083
  420091
  426057
  428685
  430969
  443443
  454939
  455009
  457005
  459496
  460801
  461528
  461532
  461873
  465754
  465950
  466197
  467336
  469202
  473549
  475584
  20031
  391144
  396784
  397714
  398713
  398920
  400956
  401440
  417758
  420084
  421122
  421182
  426463
  435799
  443463
  444005
  446253
  454674
  456901
  459790
  461519
  461625
]
2.70 ms
(0.75%)
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
  20031
  29367
  38452
  385064
  389864
  390380
  391144
  392704
  393393
  395389
  395628
  395662
  395793
  396784
  397714
  398412
  398713
  398908
  398920
  400956
  401440
  401614
  402091
  402312
  402931
  403628
  404267
  408824
  411133
  415487
  417758
  418083
  419598
  420084
  420091
  420507
  421122
  421182
  423994
  424023
  425299
  426057
  426463
  426669
  428685
  430969
  431205
  431687
  433950
  435799
  437556
  443443
  443463
  444005
  446253
  454674
  454939
  455009
  455509
  456901
  457005
  457046
  459496
  459790
  460801
  461482
  461519
  461528
  461532
  461625
  461873
  465754
  465950
  466197
  467336
  469202
  473549
  475444
  475584
  477876
  481340
  586803
  587247
  587505
  590511
  590955
  593140
  597226
  598235
  598310
  600191
  605397
  605515
  620475
  625915
  633518
  638550
  721854
  732116
  736979
  737397
  749688
  752161
  756800
  758691
  765055
  774794
  779267
  783151
  784237
  784679
  788908
  795554
  805027
  805031
  805684
  806883
  806961
  807345
  813251
]
2.48 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful xxx"
]
1.97 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая xxx"
]
1.95 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая xxx"
]

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.