Query Metrics
7
Database Queries
7
Different statements
163.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.34 ms (82.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 382094 385171 385946 390041 390601 395648 395699 395998 396258 397456 399631 402137 407786 411941 426558 427523 454879 454897 465507 465840 474465 480780 482364 484475 496269 502583 505722 512471 515138 519542 520002 520735 529602 548712 550643 552179 552183 552738 554897 559059 559098 559184 560202 564197 566595 567423 573407 580747 591317 591595 596648 597859 599327 601381 602947 608049 610299 611241 621971 622331 622826 624290 629357 631970 636466 654300 663385 663884 664861 665311 665349 665465 666780 666849 667536 669756 669768 673056 674388 675524 679826 680702 694715 701051 701397 712668 717630 718309 718556 720614 724226 725359 725570 735624 745394 747258 747597 748337 754227 758433 770992 772318 779904 781676 781689 788452 788601 789998 792147 798877 800864 804109 807332 807522 813916 814212 816776 817010 823804 ] |
||||||||||||||||||||||||||||||
|
17.36 ms (10.64%) |
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 559184 560202 580747 679826 573407 629357 601381 611241 624290 591595 622331 395648 465840 515138 519542 484475 496269 520002 512471 385946 385171 395699 395998 382094 390041 390601 396258 397456 399631 402137 426558 407786 411941 427523 680702 813916 814212 816776 817010 823804 465507 474465 480780 482364 454879 454897 520735 529602 502583 505722 548712 552179 554897 559059 559098 550643 552183 552738 669768 674388 675524 712668 718309 654300 663385 663884 665465 666849 669756 694715 717630 718556 664861 665311 665349 666780 667536 673056 720614 564197 566595 567423 599327 622826 591317 596648 621971 631970 636466 610299 597859 602947 779904 781689 789998 800864 804109 807332 807522 725359 754227 758433 769103 772318 788601 792147 798877 745394 748337 747258 770992 735624 747597 724226 725570 608049 701051 701397 781676 788452 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (2.14%) |
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 382094 385171 385946 390041 390601 395648 395699 395998 396258 397456 399631 402137 407786 411941 426558 427523 454879 454897 465507 465840 474465 480780 482364 484475 496269 502583 505722 512471 515138 519542 520002 520735 529602 548712 550643 552179 552183 552738 554897 559059 559098 559184 560202 564197 566595 567423 573407 580747 591317 591595 596648 597859 599327 601381 602947 608049 610299 611241 621971 622331 622826 624290 629357 631970 636466 654300 663385 663884 664861 665311 665349 665465 666780 666849 667536 669756 669768 673056 674388 675524 679826 680702 694715 701051 701397 712668 717630 718309 718556 720614 724226 725359 725570 735624 745394 747258 747597 748337 754227 758433 770992 772318 779904 781676 781689 788452 788601 789998 792147 798877 800864 804109 807332 807522 813916 814212 816776 817010 823804 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young hot"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young hot"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young hot"
]
|
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.