Query Metrics
7
Database Queries
7
Different statements
184.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.04 ms (88.78%) |
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 39054 384906 387656 391781 392403 396177 397114 402020 404263 404434 411930 412419 431673 438769 446267 461090 468756 471564 472599 478548 482073 488957 489522 489544 489691 490093 492459 495606 501892 504836 510510 513724 519980 523660 525395 528271 528808 528809 533273 534178 538090 539571 540601 540908 542635 544589 544679 545809 548155 548752 565272 566644 575831 578158 584576 598007 599113 601089 608544 614426 626783 629129 633798 636816 650464 654650 655113 656384 659667 659713 672677 689325 693291 696075 706351 707719 711668 718084 720009 720359 720506 720883 724193 725345 725597 732000 734103 735405 738976 742580 742932 743018 747092 748584 757328 761873 764405 787866 810716 814139 815292 820983 821566 823058 825963 826333 826411 826413 826422 826423 828058 828115 828280 828352 ] |
||||||||||||||||||||||||||||||
|
11.29 ms (6.11%) |
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 431673 468756 478548 412419 438769 482073 501892 528809 495606 513724 525395 534178 489544 523660 528808 391781 542635 544679 734103 584576 601089 828115 725345 738976 823105 828058 510510 575831 397114 659713 814139 578158 548752 566644 672677 696075 598007 636816 540601 461090 492459 519980 599113 720883 411930 404263 490093 504836 488957 489522 489691 748584 826333 820983 538090 711668 626783 629129 655113 654650 656384 614426 384906 39054 396177 823058 824398 825963 826411 826413 826423 821566 822574 822998 826422 815292 828280 828352 828573 471564 472599 544589 659667 742580 725597 633798 528271 540908 565272 689325 706351 720506 720009 608544 735405 743018 747092 764405 724193 732000 742932 757328 761873 718084 387656 720359 533273 810716 693291 545809 402020 404434 539571 650464 707719 787866 392403 825960 446267 548155 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.65%) |
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 39054 384906 387656 391781 392403 396177 397114 402020 404263 404434 411930 412419 431673 438769 446267 461090 468756 471564 472599 478548 482073 488957 489522 489544 489691 490093 492459 495606 501892 504836 510510 513724 519980 523660 525395 528271 528808 528809 533273 534178 538090 539571 540601 540908 542635 544589 544679 545809 548155 548752 565272 566644 575831 578158 584576 598007 599113 601089 608544 614426 626783 629129 633798 636816 650464 654650 655113 656384 659667 659713 672677 689325 693291 696075 706351 707719 711668 718084 720009 720359 720506 720883 724193 725345 725597 732000 734103 735405 738976 742580 742932 743018 747092 748584 757328 761873 764405 787866 810716 814139 815292 820983 821566 823058 825963 826333 826411 826413 826422 826423 828058 828115 828280 828352 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny big dick"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.72%) |
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.