Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.45 ms
(58.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "19 year"
]
121.95 ms
(34.24%)
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
  282465
  386548
  418513
  429259
  438486
  458628
  474057
  489156
  489157
  493934
  514976
  527165
  529820
  533708
  539707
  540412
  543657
  553776
  554180
  556060
  558655
  563598
  575681
  577900
  579001
  579204
  582214
  597735
  599058
  605900
  608088
  613293
  613350
  615651
  616701
  618782
  622334
  622427
  627111
  628846
  628957
  630823
  635533
  636522
  637485
  642679
  644666
  659459
  661709
  676444
  676927
  678195
  683359
  696194
  700737
  704638
  708612
  711249
  712293
  712931
  713838
  715235
  719817
  721122
  724891
  729738
  735982
  741640
  742195
  743355
  746371
  748091
  748639
  749501
  749659
  749829
  749878
  750084
  755576
  756473
  757003
  758875
  759223
  761359
  761384
  761873
  762472
  763814
  764038
  765084
  766188
  773132
  777327
  778188
  778835
  780485
  781580
  783780
  784759
  785274
  785441
  785492
  789089
  789417
  789754
  792579
  795704
  797041
  798209
  805650
  810184
  810548
  811537
  812958
  813284
  825226
  825602
  825808
  827126
  827834
]
17.29 ms
(4.86%)
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
  789089
  813284
  729738
  742195
  749829
  761384
  741640
  755576
  761359
  735982
  750084
  757003
  759223
  761873
  622427
  700737
  712293
  780485
  805650
  812958
  429259
  418513
  438486
  676444
  489157
  458628
  514976
  527165
  539707
  540412
  474057
  543657
  554180
  582214
  661709
  678195
  712931
  713838
  719817
  721122
  659459
  696194
  704638
  715235
  556060
  563598
  575681
  605900
  613293
  613350
  628957
  636522
  597735
  622334
  630823
  642679
  628846
  608088
  618782
  784759
  785441
  810548
  811537
  789754
  724891
  743355
  756473
  792579
  748639
  749878
  749501
  766188
  773132
  749659
  765084
  615651
  627111
  644666
  711249
  777327
  781580
  785274
  785492
  810184
  282465
  825602
  825808
  827126
  825226
  827834
  708612
  683359
  637485
  616701
  635533
  599058
  778835
  783780
  797041
  763814
  764038
  789417
  795704
  798209
  746371
  758875
  762472
  748091
  778188
  676927
  579001
  386548
  489156
  533708
  529820
  493934
  558655
  579204
  553776
  577900
]
3.36 ms
(0.94%)
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
  282465
  386548
  418513
  429259
  438486
  458628
  474057
  489156
  489157
  493934
  514976
  527165
  529820
  533708
  539707
  540412
  543657
  553776
  554180
  556060
  558655
  563598
  575681
  577900
  579001
  579204
  582214
  597735
  599058
  605900
  608088
  613293
  613350
  615651
  616701
  618782
  622334
  622427
  627111
  628846
  628957
  630823
  635533
  636522
  637485
  642679
  644666
  659459
  661709
  676444
  676927
  678195
  683359
  696194
  700737
  704638
  708612
  711249
  712293
  712931
  713838
  715235
  719817
  721122
  724891
  729738
  735982
  741640
  742195
  743355
  746371
  748091
  748639
  749501
  749659
  749829
  749878
  750084
  755576
  756473
  757003
  758875
  759223
  761359
  761384
  761873
  762472
  763814
  764038
  765084
  766188
  773132
  777327
  778188
  778835
  780485
  781580
  783780
  784759
  785274
  785441
  785492
  789089
  789417
  789754
  792579
  795704
  797041
  798209
  805650
  810184
  810548
  811537
  812958
  813284
  825226
  825602
  825808
  827126
  827834
]
1.96 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "19 year"
]
1.51 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "19 year"
]

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.