Query Metrics
7
Database Queries
7
Different statements
206.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.53 ms (85.99%) |
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 6953 117958 330420 396015 416056 418834 420139 420226 421591 421665 422163 422273 423620 424581 428124 428397 432837 433209 433211 433244 435100 441838 442493 443992 444018 444022 452862 455494 461287 467935 468373 472647 479821 486742 488247 488803 493657 498638 503441 510413 513342 523783 524955 528191 531560 534096 537968 538045 542089 542093 542548 542582 542782 543023 543045 543097 543184 543615 545713 546763 546794 546941 547256 547423 549686 550240 553328 553975 555096 555891 555917 555937 556406 557611 559047 559139 560599 565828 566636 566998 568420 570149 570775 573311 574908 575878 576723 576920 578009 578174 578490 579434 580138 580261 580340 581281 581370 583999 584004 591623 591782 592854 593238 598253 604527 605107 619065 621374 622601 635486 665929 667875 706373 715671 725221 726267 731683 735909 800585 801287 ] |
||||||||||||||||||||||||||||||
|
19.19 ms (9.29%) |
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 576920 801287 479821 488803 488247 6953 468373 524955 538045 542782 545713 579434 581370 555891 580261 635486 591782 604527 800585 467935 452862 537968 523783 493657 560599 581281 542548 619065 396015 422163 421665 418834 513342 461287 542582 580138 592854 422273 423620 432837 416056 534096 486742 498638 542089 543615 570775 593238 555937 543097 443992 455494 547256 566998 578009 565828 568420 665929 667875 573311 621374 598253 605107 543023 543045 726267 556406 546794 531560 731683 428397 444018 574908 503441 557611 570149 441838 591623 472647 576723 424581 549686 553328 550240 546763 559047 444022 578490 421591 420226 528191 553975 559139 555917 542093 543184 555096 715671 706373 546941 578174 725221 735909 580340 117958 575878 547423 435100 442493 428124 566636 584004 622601 433209 420139 433244 510413 583999 330420 433211 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.28%) |
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 6953 117958 330420 396015 416056 418834 420139 420226 421591 421665 422163 422273 423620 424581 428124 428397 432837 433209 433211 433244 435100 441838 442493 443992 444018 444022 452862 455494 461287 467935 468373 472647 479821 486742 488247 488803 493657 498638 503441 510413 513342 523783 524955 528191 531560 534096 537968 538045 542089 542093 542548 542582 542782 543023 543045 543097 543184 543615 545713 546763 546794 546941 547256 547423 549686 550240 553328 553975 555096 555891 555917 555937 556406 557611 559047 559139 560599 565828 566636 566998 568420 570149 570775 573311 574908 575878 576723 576920 578009 578174 578490 579434 580138 580261 580340 581281 581370 583999 584004 591623 591782 592854 593238 598253 604527 605107 619065 621374 622601 635486 665929 667875 706373 715671 725221 726267 731683 735909 800585 801287 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большая дырка в члене%…"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк в член"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие дырк в член"
]
|
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.