Query Metrics
7
Database Queries
7
Different statements
153.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.95 ms (85.19%) |
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 14225 33431 336072 383089 442632 457828 461103 469406 472614 477461 482822 493806 496372 496721 497681 497687 500621 505630 512122 519810 529385 530666 532487 534831 535071 535817 535841 538031 538790 540068 540412 541259 544779 545835 547078 547101 564251 575335 575349 584970 585270 588115 591936 592256 595279 602070 603546 603600 604464 604466 604474 604531 606538 606858 606947 607018 608083 622716 629891 630955 633027 634215 636666 640120 644789 646436 648793 651512 651578 652784 653392 653728 653791 653801 656808 658146 677189 693155 697608 697912 697935 700824 704187 708279 708923 710667 715600 719811 719847 730406 732380 732412 732625 733560 733570 735805 737159 737177 737662 738056 738475 738490 738854 739668 749032 750093 750914 752713 752939 763934 764340 767864 771073 776861 781815 785663 785676 802181 807142 818530 ] |
||||||||||||||||||||||||||||||
|
13.61 ms (8.85%) |
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 604474 710667 529385 629891 530666 547101 763934 540412 541259 651512 732380 477461 535071 505630 575349 588115 739668 735805 737662 738475 732625 715600 538790 512122 584970 658146 697608 652784 640120 633027 644789 608083 719811 648793 592256 606947 534831 697935 785663 764340 771073 719847 14225 469406 493806 535817 547078 700824 604464 634215 781815 785676 733570 749032 730406 752713 732412 738490 336072 500621 575335 651578 656808 653392 677189 653791 653801 603600 738056 646436 697912 496372 802181 767864 776861 457828 693155 595279 33431 442632 818530 482822 653728 807142 750914 738854 750093 497687 497681 519810 532487 535841 704187 708923 708279 585270 604466 604531 622716 591936 602070 752939 737177 603546 606858 496721 540068 538031 544779 606538 737159 630955 383089 461103 472614 545835 564251 607018 636666 733560 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.39%) |
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 14225 33431 336072 383089 442632 457828 461103 469406 472614 477461 482822 493806 496372 496721 497681 497687 500621 505630 512122 519810 529385 530666 532487 534831 535071 535817 535841 538031 538790 540068 540412 541259 544779 545835 547078 547101 564251 575335 575349 584970 585270 588115 591936 592256 595279 602070 603546 603600 604464 604466 604474 604531 606538 606858 606947 607018 608083 622716 629891 630955 633027 634215 636666 640120 644789 646436 648793 651512 651578 652784 653392 653728 653791 653801 656808 658146 677189 693155 697608 697912 697935 700824 704187 708279 708923 710667 715600 719811 719847 730406 732380 732412 732625 733560 733570 735805 737159 737177 737662 738056 738475 738490 738854 739668 749032 750093 750914 752713 752939 763934 764340 767864 771073 776861 781815 785663 785676 802181 807142 818530 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc in homemade"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc домашн любительск"
]
|
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.