Query Metrics
7
Database Queries
7
Different statements
152.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.20 ms (84.49%) |
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 420268 425876 427207 430581 432909 432954 435177 435669 436796 443464 444608 445642 445941 446942 448375 448677 452635 453018 453165 453618 454149 459061 459508 460323 466417 466474 469213 473778 478110 487154 490854 492273 492565 497636 498363 500766 503032 504080 508224 508938 510190 512431 521887 521889 527529 528034 529092 531143 532550 534193 536571 546665 551183 554485 555834 560416 560625 561851 564603 567947 569542 575104 576387 580623 597167 598854 602627 607315 609130 612363 615226 615730 617959 630830 630982 633015 639040 643404 647315 652895 656233 662134 668141 670534 677352 679355 685065 687964 690859 690919 692815 694010 694028 695262 695929 696353 697263 697806 698557 699682 706359 707843 708350 717314 723914 733106 747398 750213 752450 763398 763536 768961 770387 770390 770397 770410 783069 790496 803796 810303 ] |
||||||||||||||||||||||||||||||
|
14.09 ms (9.21%) |
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 536571 512431 528034 527529 534193 560625 564603 567947 692815 708350 668141 677352 685065 694010 695929 698557 652895 656233 662134 670534 697263 707843 615730 602627 630830 597167 639040 790496 723914 750213 752450 783069 770390 633015 697806 427207 432954 453618 435177 454149 459508 521889 420268 444608 445642 448677 452635 453018 459061 460323 487154 497636 508224 503032 500766 532550 469213 554485 555834 576387 560416 696353 679355 695262 706359 690919 551183 561851 617959 598854 643404 810303 768961 733106 747398 763536 770387 770410 615226 630982 717314 425876 473778 466417 510190 521887 504080 498363 492273 492565 430581 436796 443464 435669 478110 446942 508938 529092 531143 490854 569542 580623 575104 687964 694028 647315 690859 546665 609130 607315 612363 770397 763398 699682 803796 432909 445941 448375 453165 466474 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.84%) |
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 420268 425876 427207 430581 432909 432954 435177 435669 436796 443464 444608 445642 445941 446942 448375 448677 452635 453018 453165 453618 454149 459061 459508 460323 466417 466474 469213 473778 478110 487154 490854 492273 492565 497636 498363 500766 503032 504080 508224 508938 510190 512431 521887 521889 527529 528034 529092 531143 532550 534193 536571 546665 551183 554485 555834 560416 560625 561851 564603 567947 569542 575104 576387 580623 597167 598854 602627 607315 609130 612363 615226 615730 617959 630830 630982 633015 639040 643404 647315 652895 656233 662134 668141 670534 677352 679355 685065 687964 690859 690919 692815 694010 694028 695262 695929 696353 697263 697806 698557 699682 706359 707843 708350 717314 723914 733106 747398 750213 752450 763398 763536 768961 770387 770390 770397 770410 783069 790496 803796 810303 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen video"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen video"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen video"
]
|
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.