Query Metrics
7
Database Queries
7
Different statements
400.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.43 ms (52.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"while parents"
]
|
||||||||||||||||||||||||||||||
|
163.12 ms (40.68%) |
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 417414 422371 426334 431500 434612 437918 438127 438454 438978 439362 444180 444267 445998 451669 452650 453315 453985 456678 458344 460447 460885 461864 464022 468409 469793 471335 472036 477202 478791 481545 485558 491048 494806 496829 498530 507432 508227 508247 510428 512482 514416 520495 521603 521664 522986 524179 525296 525460 533892 537042 545667 547747 554097 556113 556493 560364 562085 562716 565887 567187 567188 567194 568696 571500 577634 577898 578787 579773 584460 586385 586490 587968 588897 593774 596590 600932 614533 614587 626122 635723 637201 647815 659061 660581 663802 680677 688398 694715 706471 710467 717490 724074 727095 729198 730750 736690 736745 749113 751034 752934 764589 765343 767611 770595 775541 777278 777686 778106 778669 781519 783521 783877 784593 788002 788878 795123 798788 806650 810533 826259 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (4.42%) |
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 437918 680677 578787 600932 783521 788002 806650 729198 749113 727095 736745 730750 477202 514416 533892 556493 562085 706471 556113 798788 788878 724074 765343 777278 507432 545667 471335 481545 710467 659061 717490 614587 775541 770595 781519 434612 464022 485558 524179 525296 494806 508227 521603 560364 562716 577634 647815 694715 586490 593774 626122 777686 810533 764589 614533 795123 426334 422371 439362 438978 460447 472036 508247 498530 460885 478791 452650 456678 520495 568696 547747 579773 565887 635723 751034 784593 438454 458344 438127 444180 512482 451669 496829 525460 567188 567194 571500 554097 577898 637201 596590 417414 445998 431500 453985 510428 491048 469793 567187 660581 586385 444267 584460 521664 522986 588897 826259 663802 778669 783877 778106 461864 688398 752934 453315 736690 587968 767611 468409 537042 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (0.78%) |
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 417414 422371 426334 431500 434612 437918 438127 438454 438978 439362 444180 444267 445998 451669 452650 453315 453985 456678 458344 460447 460885 461864 464022 468409 469793 471335 472036 477202 478791 481545 485558 491048 494806 496829 498530 507432 508227 508247 510428 512482 514416 520495 521603 521664 522986 524179 525296 525460 533892 537042 545667 547747 554097 556113 556493 560364 562085 562716 565887 567187 567188 567194 568696 571500 577634 577898 578787 579773 584460 586385 586490 587968 588897 593774 596590 600932 614533 614587 626122 635723 637201 647815 659061 660581 663802 680677 688398 694715 706471 710467 717490 724074 727095 729198 730750 736690 736745 749113 751034 752934 764589 765343 767611 770595 775541 777278 777686 778106 778669 781519 783521 783877 784593 788002 788878 795123 798788 806650 810533 826259 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"while parents"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"while parents"
]
|
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.