Query Metrics
7
Database Queries
7
Different statements
368.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
344.63 ms (93.45%) |
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 4463 6602 124361 146112 188009 188373 194216 232973 233667 236765 250695 358365 382021 382569 386044 388739 388968 389582 391652 392673 393433 394190 394195 394433 397885 398557 398935 404441 409938 411249 411347 443690 467445 480731 483135 484462 486821 506045 506830 511523 516461 517002 530326 543694 551157 551507 557145 561585 561586 593542 609592 613988 620708 621536 663395 663504 664809 665254 665516 667319 667850 667886 668881 669735 688078 702955 703448 714152 714165 716470 721472 722127 722676 725372 726786 726962 737083 737169 739955 740185 740792 741080 741896 743800 743811 746460 746619 748252 752523 759596 759807 766574 770913 774200 776865 780634 780645 781970 782154 782199 782264 788696 789537 794679 794689 796211 804211 804221 807380 810286 818731 818811 820249 823692 823910 824604 824807 824908 825037 825915 ] |
||||||||||||||||||||||||||||||
|
14.09 ms (3.82%) |
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 480731 467445 484462 486821 506045 506830 511523 517002 483135 194216 393433 394433 820249 824807 818731 823692 824908 818811 530326 543694 551157 551507 561585 561586 665254 669735 667886 702955 716470 663504 665516 667319 667850 557145 613988 620708 782199 776865 804221 807380 725372 766574 788696 746460 746619 609592 780645 782264 804211 382021 6602 394195 146112 382569 250695 824604 825915 516461 722127 668881 714152 664809 703448 593542 621536 781970 789537 782154 794689 726786 740185 741080 770913 737169 759807 721472 794679 796211 232973 411249 188373 386044 392673 358365 394190 443690 233667 397885 404441 236765 124361 188009 388739 398557 409938 780634 740792 741896 739955 743811 774200 4463 388968 389582 398935 391652 411347 752523 810286 748252 825037 823910 688078 663395 714165 722676 737083 726962 759596 743800 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.67%) |
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 4463 6602 124361 146112 188009 188373 194216 232973 233667 236765 250695 358365 382021 382569 386044 388739 388968 389582 391652 392673 393433 394190 394195 394433 397885 398557 398935 404441 409938 411249 411347 443690 467445 480731 483135 484462 486821 506045 506830 511523 516461 517002 530326 543694 551157 551507 557145 561585 561586 593542 609592 613988 620708 621536 663395 663504 664809 665254 665516 667319 667850 667886 668881 669735 688078 702955 703448 714152 714165 716470 721472 722127 722676 725372 726786 726962 737083 737169 739955 740185 740792 741080 741896 743800 743811 746460 746619 748252 752523 759596 759807 766574 770913 774200 776865 780634 780645 781970 782154 782199 782264 788696 789537 794679 794689 796211 804211 804221 807380 810286 818731 818811 820249 823692 823910 824604 824807 824908 825037 825915 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young and mature"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young mature"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young mature"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.44%) |
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.