Query Metrics
7
Database Queries
7
Different statements
420.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.73 ms (49.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"close up young"
]
|
||||||||||||||||||||||||||||||
|
192.14 ms (45.66%) |
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 392461 396251 410150 411125 414944 415092 418648 418653 420374 420600 422925 426007 427221 429147 435468 464648 484822 491067 497337 504669 511691 529566 540736 543734 544873 548300 549582 550691 561007 566511 567240 569962 574964 590346 597820 598725 599791 600287 600455 614201 617128 617835 622880 623519 624592 631280 640320 640427 642908 649191 651977 663434 666654 671229 677258 677337 679579 680633 682691 683011 683247 687929 690000 691326 693028 693873 695840 696126 697976 698091 705320 708432 711639 712955 713701 715144 718614 724186 724519 725532 727631 730204 731404 732086 735709 737408 740618 740738 741268 742434 747966 749028 750127 757105 757182 758615 759317 760335 760547 761161 766670 771903 778303 781099 783530 785291 789526 794978 796532 798533 806680 808116 811533 817746 819444 823049 825140 827474 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (2.98%) |
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 698091 708432 712955 718614 677337 682691 695840 640320 598725 614201 617128 622880 590346 597820 811533 796532 798533 806680 741268 749028 760335 772553 783530 750127 759317 766670 740618 757182 760547 725532 735709 761161 773406 724519 731404 740738 771903 631280 711639 392461 411125 414944 410150 426007 429147 427221 418653 504669 529566 549582 561007 569962 649191 680633 713701 687929 705320 683247 548300 566511 599791 794978 730204 737408 757105 785291 789526 808116 724186 732086 727631 747966 742434 758615 623519 640427 396251 418648 422925 420374 435468 420600 484822 491067 511691 696126 497337 415092 817746 819444 823049 825140 827474 464648 540736 544873 550691 543734 574964 651977 679579 683011 691326 693873 666654 671229 715144 663434 677258 690000 693028 697976 567240 600455 642908 600287 617835 624592 781099 778303 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (0.72%) |
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 392461 396251 410150 411125 414944 415092 418648 418653 420374 420600 422925 426007 427221 429147 435468 464648 484822 491067 497337 504669 511691 529566 540736 543734 544873 548300 549582 550691 561007 566511 567240 569962 574964 590346 597820 598725 599791 600287 600455 614201 617128 617835 622880 623519 624592 631280 640320 640427 642908 649191 651977 663434 666654 671229 677258 677337 679579 680633 682691 683011 683247 687929 690000 691326 693028 693873 695840 696126 697976 698091 705320 708432 711639 712955 713701 715144 718614 724186 724519 725532 727631 730204 731404 732086 735709 737408 740618 740738 741268 742434 747966 749028 750127 757105 757182 758615 759317 760335 760547 761161 766670 771903 778303 781099 783530 785291 789526 794978 796532 798533 806680 808116 811533 817746 819444 823049 825140 827474 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"close up young"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"close up young"
]
|
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.