Query Metrics
7
Database Queries
7
Different statements
465.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
434.73 ms (93.46%) |
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 187349 390653 395889 400474 409995 410267 411603 413134 415112 416408 420087 420438 421780 424481 425990 428368 428826 440620 443202 443797 448154 450814 451498 462572 469576 472244 472471 474148 475951 477441 482368 482379 485619 489489 491500 491670 491702 492163 500669 512332 512701 513609 519141 519492 519907 520898 521995 522056 523454 523950 524564 525432 525675 526188 527495 532753 532831 534786 536766 536885 538216 540932 546747 557177 558840 562626 568659 573926 574538 574897 574916 575069 575088 575123 575139 575472 575734 575768 575791 575802 576051 576056 576080 576082 576112 576399 576412 581401 586650 596323 599246 601234 610011 612222 614017 615726 620201 623485 623622 623813 623818 633732 637094 650955 669215 669218 679389 726718 727465 727812 732559 733886 744704 748236 776521 799262 799360 810902 818472 ] |
||||||||||||||||||||||||||||||
|
20.30 ms (4.36%) |
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 558840 575088 575791 576056 650955 679389 574538 575734 744704 443202 472471 519492 525675 491670 521995 523454 540932 527495 538216 536766 522056 525432 440620 513609 526188 523324 546747 575069 575802 576051 576082 562626 568659 574897 575139 575768 575123 575472 596323 612222 614017 733886 477441 491702 532831 395889 390653 411603 421780 818472 534786 599246 586650 623485 776521 727465 799262 620201 420087 424481 428368 485619 519141 469576 523950 532753 576412 576399 573926 574916 576112 637094 415112 491500 413134 482379 472244 536885 512332 520898 669218 610011 726718 748236 799360 187349 451498 462572 400474 428826 450814 576080 519907 581401 623813 623622 727812 633732 524564 492163 420438 448154 474148 512701 482368 557177 669215 601234 615726 810902 732559 409995 416408 443797 489489 500669 475951 623818 410267 425990 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.53%) |
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 187349 390653 395889 400474 409995 410267 411603 413134 415112 416408 420087 420438 421780 424481 425990 428368 428826 440620 443202 443797 448154 450814 451498 462572 469576 472244 472471 474148 475951 477441 482368 482379 485619 489489 491500 491670 491702 492163 500669 512332 512701 513609 519141 519492 519907 520898 521995 522056 523454 523950 524564 525432 525675 526188 527495 532753 532831 534786 536766 536885 538216 540932 546747 557177 558840 562626 568659 573926 574538 574897 574916 575069 575088 575123 575139 575472 575734 575768 575791 575802 576051 576056 576080 576082 576112 576399 576412 581401 586650 596323 599246 601234 610011 612222 614017 615726 620201 623485 623622 623813 623818 633732 637094 650955 669215 669218 679389 726718 727465 727812 732559 733886 744704 748236 776521 799262 799360 810902 818472 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young porn"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young porn"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young porn"
]
|
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.