Query Metrics
7
Database Queries
7
Different statements
161.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.71 ms (83.48%) |
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 384306 399170 400442 402088 410304 418632 418649 420301 421652 426697 429181 429215 429223 429232 429234 432306 442148 445761 447441 447524 447611 456065 456911 456917 457874 458039 458144 468840 479756 479846 483288 484876 485877 486607 487049 489250 492495 493306 493470 495600 497186 501760 504050 505263 505807 506194 508141 509877 511428 511670 520114 520251 521501 522226 524168 524823 525476 526965 529087 529471 538428 540722 541057 551293 552392 555718 556690 557405 557907 558736 560444 562193 563573 565543 566123 571784 574267 577705 577724 577783 577796 577816 577837 577897 577899 578333 583671 592293 593900 594031 594644 597602 597811 598078 598710 602435 605857 612265 622474 624664 626553 636338 655462 657865 663172 664468 672338 675866 685929 705669 719837 721073 722918 728774 747136 748705 760068 763540 781511 788595 ] |
||||||||||||||||||||||||||||||
|
16.76 ms (10.39%) |
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 558736 551293 552392 565543 577724 675866 657865 557405 577796 583671 598710 597811 747136 456911 458144 442148 456065 456917 421652 410304 426697 447611 457874 468840 506194 522226 540722 485877 489250 495600 497186 508141 483288 501760 511428 524168 505263 509877 529471 541057 420301 487049 526965 524823 493470 563573 577899 578333 705669 664468 719837 612265 605857 597602 592293 593900 760068 748705 728774 479756 447441 525476 529087 429234 511670 492495 574267 560444 566123 602435 781511 479846 520114 486607 504050 484876 521501 493306 505807 788595 400442 624664 722918 447524 418649 429232 626553 763540 432306 384306 402088 458039 399170 520251 418632 429181 429215 538428 577816 557907 577783 577897 562193 577705 577837 655462 663172 685929 672338 555718 556690 571784 598078 594644 594031 636338 622474 721073 445761 429223 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.80%) |
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 384306 399170 400442 402088 410304 418632 418649 420301 421652 426697 429181 429215 429223 429232 429234 432306 442148 445761 447441 447524 447611 456065 456911 456917 457874 458039 458144 468840 479756 479846 483288 484876 485877 486607 487049 489250 492495 493306 493470 495600 497186 501760 504050 505263 505807 506194 508141 509877 511428 511670 520114 520251 521501 522226 524168 524823 525476 526965 529087 529471 538428 540722 541057 551293 552392 555718 556690 557405 557907 558736 560444 562193 563573 565543 566123 571784 574267 577705 577724 577783 577796 577816 577837 577897 577899 578333 583671 592293 593900 594031 594644 597602 597811 598078 598710 602435 605857 612265 622474 624664 626553 636338 655462 657865 663172 664468 672338 675866 685929 705669 719837 721073 722918 728774 747136 748705 760068 763540 781511 788595 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 year"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 year"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 year"
]
|
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.