Query Metrics
7
Database Queries
7
Different statements
185.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.19 ms (84.84%) |
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 386320 389116 391034 395606 395684 395856 395970 396253 399401 404201 411637 413050 414974 418649 419867 419880 423893 424498 425523 427819 431965 434596 438844 441398 443001 443069 443524 444346 445652 446735 446894 447732 448560 449666 451788 459805 461704 463802 464794 465946 468396 477544 478220 480050 480331 483582 483594 484223 490863 491606 492029 492528 495890 496757 508180 512049 513126 513732 515339 515645 515709 516650 516659 518920 519261 519560 520690 521251 522679 523937 524096 524097 526397 526415 526608 528519 528938 536004 543536 546668 561814 561818 562872 564491 567000 574224 575832 576920 578527 578587 578596 579140 591612 599197 602506 613485 620298 621439 622704 624224 630806 675405 679656 690153 693945 693954 693965 698878 700540 700631 723927 732070 732159 766884 788899 790739 791855 800442 806903 810408 ] |
||||||||||||||||||||||||||||||
|
19.19 ms (10.36%) |
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 806903 810408 766884 732070 700540 700631 791855 404201 480050 434596 480331 411637 478220 520690 490863 521251 523937 526415 492029 528519 591612 425523 399401 418649 443069 690153 451788 463802 448560 524097 512049 516650 526397 515339 579140 561818 562872 576920 675405 693945 679656 693954 546668 564491 613485 630806 621439 788899 723927 790739 800442 732159 698878 395684 414974 427819 461704 468396 386320 389116 477544 446894 391034 413050 443001 443524 449666 459805 464794 536004 524096 495890 574224 567000 578527 578596 575832 693965 620298 624224 599197 622704 395606 447732 438844 492528 528938 483582 484223 513732 515709 395970 396253 431965 518920 519261 522679 395856 424498 445652 516659 483594 496757 491606 441398 446735 526608 515645 543536 561814 578587 602506 423893 465946 519560 513126 508180 419867 419880 444346 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.36%) |
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 386320 389116 391034 395606 395684 395856 395970 396253 399401 404201 411637 413050 414974 418649 419867 419880 423893 424498 425523 427819 431965 434596 438844 441398 443001 443069 443524 444346 445652 446735 446894 447732 448560 449666 451788 459805 461704 463802 464794 465946 468396 477544 478220 480050 480331 483582 483594 484223 490863 491606 492029 492528 495890 496757 508180 512049 513126 513732 515339 515645 515709 516650 516659 518920 519261 519560 520690 521251 522679 523937 524096 524097 526397 526415 526608 528519 528938 536004 543536 546668 561814 561818 562872 564491 567000 574224 575832 576920 578527 578587 578596 579140 591612 599197 602506 613485 620298 621439 622704 624224 630806 675405 679656 690153 693945 693954 693965 698878 700540 700631 723927 732070 732159 766884 788899 790739 791855 800442 806903 810408 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen with friend"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen friend"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen friend"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.70%) |
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.