Query Metrics
7
Database Queries
7
Different statements
174.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.59 ms (86.33%) |
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 229389 280631 383947 384491 385379 385385 387667 389819 390258 395677 397963 398543 407423 413808 422153 422180 426561 428473 433746 439285 440637 444254 444923 449104 450279 452362 454018 454383 456127 458814 459182 459403 463896 466842 469955 470225 475312 482309 486175 486803 490381 503395 508423 508807 527823 527828 527847 545001 545905 554488 554793 558172 559543 574076 575973 578169 609045 612937 613912 621724 629522 630112 643380 672812 707545 710142 713162 725441 725460 725500 725517 727037 729212 731036 731262 734253 735850 735868 735875 735880 741737 744197 744391 744462 746144 752131 752825 753720 756363 758807 760176 760345 762185 764414 766304 774060 781917 789748 795983 796836 796933 800727 800753 800807 801507 802266 803427 803534 804266 804434 804435 804729 810099 812363 812377 812378 819421 819649 824528 827723 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (7.83%) |
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 796933 800807 801507 802266 804729 812363 812377 725517 731036 741737 744391 756363 760176 760345 812378 735875 735880 758807 752131 752825 764414 766304 744462 753720 774060 729212 735868 630112 713162 789748 796836 804266 385379 385385 390258 426561 459403 490381 574076 575973 710142 609045 629522 800727 800753 725441 735850 744197 810099 439285 469955 486803 554793 449104 558172 527847 508807 621724 731262 803427 384491 395677 280631 440637 422153 433746 422180 413808 428473 450279 454383 475312 456127 458814 459182 466842 470225 508423 463896 482309 554488 559543 545905 578169 672812 545001 613912 643380 612937 781917 795983 803534 725460 734253 727037 762185 725500 746144 707545 804434 804435 454018 452362 444254 444923 527828 486175 503395 527823 229389 407423 383947 389819 387667 397963 398543 819421 819649 824528 827723 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.88%) |
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 229389 280631 383947 384491 385379 385385 387667 389819 390258 395677 397963 398543 407423 413808 422153 422180 426561 428473 433746 439285 440637 444254 444923 449104 450279 452362 454018 454383 456127 458814 459182 459403 463896 466842 469955 470225 475312 482309 486175 486803 490381 503395 508423 508807 527823 527828 527847 545001 545905 554488 554793 558172 559543 574076 575973 578169 609045 612937 613912 621724 629522 630112 643380 672812 707545 710142 713162 725441 725460 725500 725517 727037 729212 731036 731262 734253 735850 735868 735875 735880 741737 744197 744391 744462 746144 752131 752825 753720 756363 758807 760176 760345 762185 764414 766304 774060 781917 789748 795983 796836 796933 800727 800753 800807 801507 802266 803427 803534 804266 804434 804435 804729 810099 812363 812377 812378 819421 819649 824528 827723 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац вебкамер chubby"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation webcam chubby"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац вебкамер chubby"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.