Query Metrics
7
Database Queries
7
Different statements
163.43 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.50 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.61 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"came"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.95 ms |
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 470390 470720 445704 449516 467741 479222 489886 490142 451855 460687 510462 511209 517133 525231 533840 540752 503342 517940 522291 525270 506736 512431 517997 522518 524409 528779 540380 501443 504018 507469 517409 532688 540097 481059 484906 546105 551795 560733 561502 566829 567177 574171 577525 563674 573508 577792 549565 574978 675172 693952 694938 694971 711673 718859 648976 662389 675968 679685 691744 703357 706535 707935 714074 657777 670565 675576 676571 687150 699844 702038 551078 557003 559387 560961 560984 561427 562497 564242 578571 589514 625472 585552 599555 618032 628425 599142 630334 605002 610960 624045 625915 641004 787996 791211 793497 795538 806432 779423 793699 800578 801305 802750 788048 789103 802711 725012 725425 738442 766592 728523 753548 774333 768797 731457 732774 732868 732911 746525 748416 614684 ] |
||||||||||||||||||||||||||||||
| 4 | 4.48 ms |
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 445704 449516 451855 460687 467741 470390 470720 479222 481059 484906 489886 490142 501443 503342 504018 506736 507469 510462 511209 512431 517133 517409 517940 517997 522291 522518 524409 525231 525270 528779 532688 533840 540097 540380 540752 546105 549565 551078 551795 557003 559387 560733 560961 560984 561427 561502 562497 563674 564242 566829 567177 573508 574171 574978 577525 577792 578571 585552 589514 599142 599555 605002 610960 614684 618032 624045 625472 625915 628425 630334 641004 648976 657777 662389 670565 675172 675576 675968 676571 679685 687150 691744 693952 694938 694971 699844 702038 703357 706535 707935 711673 714074 718859 725012 725425 728523 731457 732774 732868 732911 738442 746525 748416 753548 766592 768797 774333 779423 787996 788048 789103 791211 793497 793699 795538 800578 801305 802711 802750 806432 ] |
||||||||||||||||||||||||||||||
| 5 | 133.40 ms |
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 445704 449516 451855 460687 467741 470390 470720 479222 481059 484906 489886 490142 501443 503342 504018 506736 507469 510462 511209 512431 517133 517409 517940 517997 522291 522518 524409 525231 525270 528779 532688 533840 540097 540380 540752 546105 549565 551078 551795 557003 559387 560733 560961 560984 561427 561502 562497 563674 564242 566829 567177 573508 574171 574978 577525 577792 578571 585552 589514 599142 599555 605002 610960 614684 618032 624045 625472 625915 628425 630334 641004 648976 657777 662389 670565 675172 675576 675968 676571 679685 687150 691744 693952 694938 694971 699844 702038 703357 706535 707935 711673 714074 718859 725012 725425 728523 731457 732774 732868 732911 738442 746525 748416 753548 766592 768797 774333 779423 787996 788048 789103 791211 793497 793699 795538 800578 801305 802711 802750 806432 ] |
||||||||||||||||||||||||||||||
| 6 | 1.98 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"came"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.50 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"came"
]
|
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.