Query Metrics
7
Database Queries
7
Different statements
182.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.87 ms (84.81%) |
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 33113 185855 407418 411734 415893 420238 424507 427025 428639 429473 429478 429485 437133 440643 443465 446272 454722 461437 462505 463950 467328 467387 468094 468577 470045 476837 477198 479836 480805 485284 486732 486940 489151 490195 491355 492836 493840 495920 498349 498435 498582 499593 503250 505035 506551 510241 512824 514924 515179 515595 519555 521073 525121 525372 526293 528009 529192 531091 536606 536699 550400 550681 553410 557197 557199 558077 558549 565722 566273 569886 570312 570516 570620 570626 571054 572203 574825 575446 576397 578106 580576 580792 583770 586603 588626 592681 593793 596541 597717 598994 601113 605459 607050 611950 612393 613843 622057 623967 625826 633085 637689 646824 651192 654463 659775 665454 671785 676799 679206 692902 711565 722460 722691 741584 748960 767220 773565 788848 809225 810685 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (9.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 558077 570312 572203 580792 553410 557199 574825 578106 583770 550400 550681 570626 571054 580576 671785 676799 646824 651192 711565 722460 575446 597717 592681 607050 593793 622057 809225 767220 741584 612393 788848 33113 467328 468094 420238 428639 429485 443465 463950 476837 411734 427025 429473 429478 440643 468577 477198 515595 521073 492836 498582 499593 486940 491355 498349 519555 529192 485284 486732 489151 490195 512824 528009 185855 462505 493840 510241 536699 525121 531091 506551 525372 536606 558549 569886 576397 557197 565722 570620 654463 679206 692902 722691 659775 665454 566273 570516 601113 596541 613843 598994 605459 637689 586603 588626 623967 633085 810685 773565 748960 611950 625826 407418 454722 424507 461437 470045 480805 479836 495920 503250 505035 515179 498435 514924 415893 437133 446272 467387 526293 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.59%) |
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 33113 185855 407418 411734 415893 420238 424507 427025 428639 429473 429478 429485 437133 440643 443465 446272 454722 461437 462505 463950 467328 467387 468094 468577 470045 476837 477198 479836 480805 485284 486732 486940 489151 490195 491355 492836 493840 495920 498349 498435 498582 499593 503250 505035 506551 510241 512824 514924 515179 515595 519555 521073 525121 525372 526293 528009 529192 531091 536606 536699 550400 550681 553410 557197 557199 558077 558549 565722 566273 569886 570312 570516 570620 570626 571054 572203 574825 575446 576397 578106 580576 580792 583770 586603 588626 592681 593793 596541 597717 598994 601113 605459 607050 611950 612393 613843 622057 623967 625826 633085 637689 646824 651192 654463 659775 665454 671785 676799 679206 692902 711565 722460 722691 741584 748960 767220 773565 788848 809225 810685 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hottie"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hottie"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hottie"
]
|
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.