Query Metrics
7
Database Queries
7
Different statements
169.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.61 ms (83.55%) |
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 8867 81734 96495 188600 212873 382915 385348 386083 387448 388028 392605 402378 402950 404777 406324 407501 409237 411927 413086 414313 416697 417756 419613 421829 421877 421917 428179 428830 428841 432249 432731 433475 433664 433718 434244 439522 439532 439667 441789 443134 443422 443720 446404 451624 454661 462113 464008 465336 465961 466271 467112 471431 472270 474702 475273 478672 480298 480687 482305 482553 482678 482712 484241 484619 484656 484776 486535 486665 487550 488746 490400 493163 493198 496072 496616 499382 499882 502199 504664 505725 506094 511114 512940 514070 518587 520979 521222 521843 524606 524779 527658 528712 531282 539416 546058 546884 546935 555393 557235 559392 562361 563472 564203 565679 571137 597157 597162 599506 613396 620257 626944 637404 665182 665297 667875 735881 748375 749025 806327 827593 ] |
||||||||||||||||||||||||||||||
|
17.51 ms (10.33%) |
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 484619 486535 496072 504664 505725 506094 520979 527658 484776 493198 524779 382915 188600 212873 8867 387448 409237 411927 827593 735881 749025 521222 81734 402378 428830 439532 462113 531282 439667 414313 466271 474702 484656 499882 562361 571137 564203 557235 613396 465336 493163 514070 406324 487550 546058 565679 563472 637404 599506 620257 433475 626944 478672 480298 521843 559392 528712 486665 96495 402950 404777 432249 407501 416697 428179 434244 417756 419613 433718 439522 555393 482712 446404 467112 471431 472270 454661 482553 488746 499382 518587 524606 496616 511114 539416 512940 464008 465961 482678 546884 546935 665182 665297 667875 597157 597162 806327 748375 388028 392605 421829 428841 432731 385348 386083 421877 433664 443720 441789 413086 421917 443134 443422 475273 480687 482305 451624 502199 484241 490400 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.49%) |
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 8867 81734 96495 188600 212873 382915 385348 386083 387448 388028 392605 402378 402950 404777 406324 407501 409237 411927 413086 414313 416697 417756 419613 421829 421877 421917 428179 428830 428841 432249 432731 433475 433664 433718 434244 439522 439532 439667 441789 443134 443422 443720 446404 451624 454661 462113 464008 465336 465961 466271 467112 471431 472270 474702 475273 478672 480298 480687 482305 482553 482678 482712 484241 484619 484656 484776 486535 486665 487550 488746 490400 493163 493198 496072 496616 499382 499882 502199 504664 505725 506094 511114 512940 514070 518587 520979 521222 521843 524606 524779 527658 528712 531282 539416 546058 546884 546935 555393 557235 559392 562361 563472 564203 565679 571137 597157 597162 599506 613396 620257 626944 637404 665182 665297 667875 735881 748375 749025 806327 827593 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature bitch"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature женскийрод"
]
|
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.