Query Metrics
7
Database Queries
7
Different statements
188.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.55 ms (82.10%) |
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 187349 391477 395661 409371 415577 427010 429552 433672 443308 443363 443802 448930 454260 458311 463266 466893 477955 543509 544254 544300 544352 546017 546713 546715 547920 547930 549300 550449 550507 550648 551250 552126 555912 556645 557510 558021 558689 559064 560619 562314 563001 563070 564213 564417 565188 565650 565778 565982 566002 566075 566297 566327 566516 566928 567474 569155 569866 571269 572166 573105 573741 573744 573918 574417 574794 576352 578162 579958 581704 592310 599543 604083 605335 605851 620019 621316 622371 622382 624864 637679 640698 640812 662390 665454 670507 681319 681899 682489 684213 684996 685004 687370 693077 710485 714748 714938 714973 716027 716787 720800 722738 722809 724522 726488 726712 726713 726718 726839 726981 727449 741294 748224 759691 760963 775985 790015 807514 810665 810773 ] |
||||||||||||||||||||||||||||||
|
23.51 ms (12.49%) |
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 546017 546713 550648 551250 552126 557510 558021 563001 565982 566002 566075 566297 566516 569155 569866 581704 544254 544300 544352 546715 550449 556645 559064 562314 564213 565188 567474 572166 573741 574417 578162 543509 547930 549300 550507 563070 571269 573105 573744 573918 662221 662390 681319 684213 684996 687370 670507 681899 714748 716787 720800 722738 722809 665454 682489 685004 693077 710485 714938 716027 547920 555912 558689 560619 564417 565650 565778 566327 566928 574794 576352 579958 599543 592310 621316 622371 622382 640812 604083 620019 624864 637679 605335 605851 775985 810665 807514 724522 726718 727449 741294 748224 759691 726488 726713 760963 726712 726839 726981 640698 714973 790015 810773 187349 391477 395661 409371 415577 429552 466893 477955 427010 433672 443308 443363 443802 448930 454260 458311 463266 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.49%) |
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 187349 391477 395661 409371 415577 427010 429552 433672 443308 443363 443802 448930 454260 458311 463266 466893 477955 543509 544254 544300 544352 546017 546713 546715 547920 547930 549300 550449 550507 550648 551250 552126 555912 556645 557510 558021 558689 559064 560619 562314 563001 563070 564213 564417 565188 565650 565778 565982 566002 566075 566297 566327 566516 566928 567474 569155 569866 571269 572166 573105 573741 573744 573918 574417 574794 576352 578162 579958 581704 592310 599543 604083 605335 605851 620019 621316 622371 622382 624864 637679 640698 640812 662390 665454 670507 681319 681899 682489 684213 684996 685004 687370 693077 710485 714748 714938 714973 716027 716787 720800 722738 722809 724522 726488 726712 726713 726718 726839 726981 727449 741294 748224 759691 760963 775985 790015 807514 810665 810773 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old kissing"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old kissing"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old kissing"
]
|
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.