Query Metrics
7
Database Queries
7
Different statements
168.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.91 ms (86.64%) |
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 399386 418894 422069 433939 438430 438520 450845 455642 456317 461601 465918 477255 481351 488517 489198 489269 490211 490356 491648 494068 496800 502721 503448 505191 513460 514257 519767 522304 526852 534389 541995 556162 559664 560501 566747 568646 570410 577920 579340 579381 583574 586298 591551 598550 598792 600684 605275 605691 607780 608091 608603 614683 617073 617650 625110 625839 627774 630702 632843 637692 638490 642263 652380 668509 678696 678732 679648 680466 693675 710647 711956 712122 724329 724532 726162 729339 737278 740313 742054 745622 753623 754883 757921 758635 761632 761806 761858 762682 762776 765887 766143 767611 771525 784038 785358 785548 786344 789480 791500 792749 792878 796871 801227 801329 802827 803431 803446 805187 805737 807259 809661 810015 811771 813808 814459 814467 814492 825419 826182 827909 ] |
||||||||||||||||||||||||||||||
|
12.84 ms (7.62%) |
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 577920 605691 608091 625110 632843 605275 638490 791500 811771 786344 803431 729339 805187 807259 740313 742054 753623 754883 757921 762682 724329 761858 765887 771525 614683 617650 625839 630702 710647 784038 785548 805737 809661 810015 399386 455642 465918 489198 489269 491648 422069 814492 825419 827909 461601 450845 488517 477255 502721 514257 583574 556162 570410 541995 568646 668509 678732 693675 711956 652380 678696 679648 680466 712122 586298 591551 598550 598792 607780 608603 627774 600684 637692 642263 785358 792878 796871 789480 801227 724532 737278 766143 761632 767611 745622 758635 762776 726162 761806 617073 792749 801329 802827 803446 481351 490211 490356 513460 496800 433939 418894 438430 438520 814467 826182 814459 813808 456317 494068 505191 534389 519767 503448 522304 526852 559664 560501 566747 579340 579381 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.60%) |
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 399386 418894 422069 433939 438430 438520 450845 455642 456317 461601 465918 477255 481351 488517 489198 489269 490211 490356 491648 494068 496800 502721 503448 505191 513460 514257 519767 522304 526852 534389 541995 556162 559664 560501 566747 568646 570410 577920 579340 579381 583574 586298 591551 598550 598792 600684 605275 605691 607780 608091 608603 614683 617073 617650 625110 625839 627774 630702 632843 637692 638490 642263 652380 668509 678696 678732 679648 680466 693675 710647 711956 712122 724329 724532 726162 729339 737278 740313 742054 745622 753623 754883 757921 758635 761632 761806 761858 762682 762776 765887 766143 767611 771525 784038 785358 785548 786344 789480 791500 792749 792878 796871 801227 801329 802827 803431 803446 805187 805737 807259 809661 810015 811771 813808 814459 814467 814492 825419 826182 827909 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"alone with"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"alone"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"alone"
]
|
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.