Query Metrics
7
Database Queries
7
Different statements
208.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.28 ms (82.64%) |
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 454635 468603 525089 528459 530028 530486 530487 530757 530941 531089 531124 531126 531144 531163 531165 531186 531215 531419 532735 532753 532754 532772 532984 533053 533374 533375 533463 533738 534028 535038 535056 535505 535584 536233 536687 536766 537654 537670 537672 537919 540338 540405 540518 540577 541197 541201 541206 542580 542583 544823 544827 545430 547467 550124 550128 550194 550196 553273 556014 565243 582323 596437 599957 599994 600002 600185 600200 600215 600332 600334 600340 601517 601576 628401 630540 631195 631249 633743 634787 637043 637063 637078 638985 639731 640762 640767 640784 640800 641986 642775 645858 646239 646771 646786 646838 646896 646904 647340 647954 648220 648815 648816 648841 648870 650330 653447 666872 666874 666899 666903 679799 679810 683261 685714 687257 696204 703831 704529 716878 719333 ] |
||||||||||||||||||||||||||||||
|
26.98 ms (12.94%) |
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 532984 535038 544823 547467 550124 553273 542583 544827 565243 541201 646896 647954 666872 666874 666899 653447 679799 646904 648815 648870 666903 550196 596437 600332 601576 631195 631249 637063 641986 599957 600200 600340 634787 637043 600215 628401 637078 640800 599994 600002 600334 601517 638985 640767 640784 633743 639731 640762 642775 704529 468603 525089 528459 533463 454635 530486 531163 531215 532753 532754 533738 535505 537672 530757 531144 531165 531186 533053 533374 533375 537654 540338 530941 531089 531124 531126 531419 532735 532772 534028 536233 536766 537919 540577 530028 530487 535056 535584 536687 537670 540405 540518 550128 582323 541197 541206 542580 550194 645858 646239 648220 679810 687257 646771 648816 648841 683261 696204 703831 716878 719333 646786 646838 647340 650330 685714 545430 556014 600185 630540 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.26%) |
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 454635 468603 525089 528459 530028 530486 530487 530757 530941 531089 531124 531126 531144 531163 531165 531186 531215 531419 532735 532753 532754 532772 532984 533053 533374 533375 533463 533738 534028 535038 535056 535505 535584 536233 536687 536766 537654 537670 537672 537919 540338 540405 540518 540577 541197 541201 541206 542580 542583 544823 544827 545430 547467 550124 550128 550194 550196 553273 556014 565243 582323 596437 599957 599994 600002 600185 600200 600215 600332 600334 600340 601517 601576 628401 630540 631195 631249 633743 634787 637043 637063 637078 638985 639731 640762 640767 640784 640800 641986 642775 645858 646239 646771 646786 646838 646896 646904 647340 647954 648220 648815 648816 648841 648870 650330 653447 666872 666874 666899 666903 679799 679810 683261 685714 687257 696204 703831 704529 716878 719333 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"balls deep"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"balls deep"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"balls deep"
]
|
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.