Query Metrics
7
Database Queries
7
Different statements
159.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.70 ms (85.70%) |
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 384898 388374 417934 417940 417951 419931 419932 419950 421411 421657 422304 422444 422967 422997 423271 423709 423760 423762 432890 435813 436093 438290 439593 439769 439800 439823 439837 442384 443271 443514 444080 444798 444869 446840 448210 451018 451144 453669 453688 453730 454928 455360 455485 455772 456571 456790 457574 457687 459093 459749 459759 463495 464706 467683 470719 471959 475365 475960 477449 477456 488155 489073 494172 494513 495063 495937 496667 501433 503400 506100 506475 508195 508200 508539 509201 511245 513725 513773 515678 516998 517451 518501 520596 529527 535933 540721 542520 545268 546226 552069 560837 568035 576270 577651 578301 580293 588237 589356 595516 602031 602104 613993 623832 641857 642665 713192 727959 729920 730299 750827 756952 771924 787765 791164 801292 806423 807177 809647 809894 810229 ] |
||||||||||||||||||||||||||||||
|
13.80 ms (8.65%) |
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 588237 641857 791164 806423 750827 801292 807177 810229 730299 727959 756952 771924 602031 602104 613993 809647 809894 384898 417940 443271 470719 417934 419931 422967 423271 439593 439837 442384 459093 422304 423709 444080 459749 388374 417951 422444 438290 457574 421657 444798 455360 477449 513725 509201 517451 494172 506100 508200 511245 515678 540721 488155 489073 496667 520596 423760 422997 421411 423762 432890 419932 419950 448210 451144 467683 459759 446840 453730 454928 455772 456790 495063 513773 518501 494513 508539 535933 495937 516998 529527 463495 542520 580293 560837 545268 552069 568035 576270 578301 713192 546226 577651 589356 595516 623832 642665 729920 787765 443514 444869 453669 453688 455485 464706 475365 435813 471959 475960 436093 456571 439769 439800 439823 457687 451018 477456 501433 503400 506475 508195 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.94%) |
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 384898 388374 417934 417940 417951 419931 419932 419950 421411 421657 422304 422444 422967 422997 423271 423709 423760 423762 432890 435813 436093 438290 439593 439769 439800 439823 439837 442384 443271 443514 444080 444798 444869 446840 448210 451018 451144 453669 453688 453730 454928 455360 455485 455772 456571 456790 457574 457687 459093 459749 459759 463495 464706 467683 470719 471959 475365 475960 477449 477456 488155 489073 494172 494513 495063 495937 496667 501433 503400 506100 506475 508195 508200 508539 509201 511245 513725 513773 515678 516998 517451 518501 520596 529527 535933 540721 542520 545268 546226 552069 560837 568035 576270 577651 578301 580293 588237 589356 595516 602031 602104 613993 623832 641857 642665 713192 727959 729920 730299 750827 756952 771924 787765 791164 801292 806423 807177 809647 809894 810229 ] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"throat throat"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"throat throat"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"throat throat"
]
|
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.