Query Metrics
7
Database Queries
7
Different statements
168.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.67 ms (80.35%) |
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 218026 323088 392540 395639 395706 396249 397373 402425 405093 414232 414710 422409 427832 428029 428494 428587 429931 430267 432823 441185 443516 447679 448377 453213 454107 459497 464185 469553 478049 478248 481847 481904 490786 491326 495212 498560 509685 510965 511455 512331 518216 519227 521893 521905 521916 522903 523027 523416 523990 531061 531090 532974 536310 536584 536616 543872 545537 559715 560648 565413 566758 567775 569003 569070 569097 573156 577370 578376 580750 586400 587863 590079 597203 600354 602829 604580 612442 614441 622335 624178 625342 631937 632256 633079 637025 637139 637416 638326 638991 644270 650188 651190 653467 653504 663348 668518 680130 699586 707368 708469 714522 716870 721551 722805 755082 774273 786468 788576 789382 803659 804619 805541 805554 806323 807907 809478 811628 815202 815598 826142 ] |
||||||||||||||||||||||||||||||
|
22.62 ms (13.40%) |
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 402425 453213 521905 545537 323088 786468 392540 469553 721551 653467 577370 624178 638326 622335 604580 632256 809478 397373 396249 428587 218026 414710 422409 428029 464185 498560 522903 490786 491326 510965 519227 521893 638991 478049 454107 625342 481904 536310 650188 427832 826142 708469 789382 447679 509685 536616 569003 543872 614441 602829 443516 815598 815202 532974 523990 559715 578376 699586 707368 714522 716870 651190 680130 560648 637139 644270 805554 774273 788576 807907 755082 633079 722805 804619 805541 806323 395639 395706 459497 495212 521916 597203 566758 569070 663348 668518 565413 567775 580750 590079 631937 587863 612442 637025 429931 432823 441185 405093 511455 512331 518216 536584 531061 531090 569097 637416 586400 600354 811628 803659 448377 478248 414232 481847 428494 430267 523416 573156 523027 653504 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.87%) |
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 218026 323088 392540 395639 395706 396249 397373 402425 405093 414232 414710 422409 427832 428029 428494 428587 429931 430267 432823 441185 443516 447679 448377 453213 454107 459497 464185 469553 478049 478248 481847 481904 490786 491326 495212 498560 509685 510965 511455 512331 518216 519227 521893 521905 521916 522903 523027 523416 523990 531061 531090 532974 536310 536584 536616 543872 545537 559715 560648 565413 566758 567775 569003 569070 569097 573156 577370 578376 580750 586400 587863 590079 597203 600354 602829 604580 612442 614441 622335 624178 625342 631937 632256 633079 637025 637139 637416 638326 638991 644270 650188 651190 653467 653504 663348 668518 680130 699586 707368 708469 714522 716870 721551 722805 755082 774273 786468 788576 789382 803659 804619 805541 805554 806323 807907 809478 811628 815202 815598 826142 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot beauty anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot beauty анал"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot beauty анал"
]
|
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.