Query Metrics
7
Database Queries
7
Different statements
125.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.55 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.09 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porno 1998"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.82 ms |
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 524250 491144 425925 427262 492554 500207 523122 525439 513751 523796 530420 527865 580615 572201 551170 594788 594929 634607 805023 784528 445591 450484 472266 481285 427898 428930 438333 453279 509715 487802 516687 541332 429089 445615 460860 469711 486592 455176 470550 535046 534779 493231 543618 657780 552777 428965 476269 458888 472958 424473 455503 474495 429137 454736 498225 504209 558012 576651 546954 670959 604689 453623 458893 360439 420206 458890 489373 498237 498257 522876 462606 569830 476261 472910 476254 455465 462171 518945 522212 492340 482492 446109 666819 557676 730798 410254 519576 469601 ] |
||||||||||||||||||||||||||||||
| 4 | 2.72 ms |
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 360439 410254 420206 424473 425925 427262 427898 428930 428965 429089 429137 438333 445591 445615 446109 450484 453279 453623 454736 455176 455465 455503 458888 458890 458893 460860 462171 462606 469601 469711 470550 472266 472910 472958 474495 476254 476261 476269 481285 482492 486592 487802 489373 491144 492340 492554 493231 498225 498237 498257 500207 504209 509715 513751 516687 518945 519576 522212 522876 523122 523796 524250 525439 527865 530420 534779 535046 541332 543618 546954 551170 552777 557676 558012 569830 572201 576651 580615 594788 594929 604689 634607 657780 666819 670959 730798 784528 805023 ] |
||||||||||||||||||||||||||||||
| 5 | 100.99 ms |
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 360439 410254 420206 424473 425925 427262 427898 428930 428965 429089 429137 438333 445591 445615 446109 450484 453279 453623 454736 455176 455465 455503 458888 458890 458893 460860 462171 462606 469601 469711 470550 472266 472910 472958 474495 476254 476261 476269 481285 482492 486592 487802 489373 491144 492340 492554 493231 498225 498237 498257 500207 504209 509715 513751 516687 518945 519576 522212 522876 523122 523796 524250 525439 527865 530420 534779 535046 541332 543618 546954 551170 552777 557676 558012 569830 572201 576651 580615 594788 594929 604689 634607 657780 666819 670959 730798 784528 805023 ] |
||||||||||||||||||||||||||||||
| 6 | 2.04 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porno"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.56 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porno"
]
|
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.