Query Metrics
7
Database Queries
7
Different statements
203.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.29 ms (86.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 181804 282430 381838 382105 389631 395166 395646 395819 410452 412609 420131 427085 427737 430508 435948 443361 444278 444336 446604 447244 448306 452489 452557 452769 453505 454313 454756 455114 455971 457202 459184 459506 460317 461490 462316 463669 463800 463848 464116 464263 465707 465837 465996 466142 466587 466641 466656 466676 467691 467951 468859 469753 469888 470145 470208 470912 471858 472106 472591 473679 474045 474233 474347 474499 475849 477795 478304 478390 480668 481432 487892 492815 493871 494095 494413 499756 501188 503640 503733 504775 505870 506126 506493 509588 509937 512227 515768 517990 518802 519887 520547 521812 522375 523088 523910 524648 526379 526743 526892 528024 528108 529426 533001 533687 534593 536142 536207 536286 542617 543378 551293 579666 647612 675094 715833 721012 757365 758133 768188 770899 ] |
||||||||||||||||||||||||||||||
|
16.96 ms (8.32%) |
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 468859 471858 472591 481432 487892 492815 503733 509937 518802 524648 526743 533001 533687 536207 494095 499756 506493 512227 515768 519887 521812 523910 526892 536286 504775 505870 523088 528024 494413 501188 503640 506126 509588 517990 520547 522375 526379 528108 529426 534593 536142 460317 464116 464263 465707 466656 467691 467951 469888 470912 474499 475849 493871 542617 543378 551293 647612 721012 675094 579666 758133 770899 757365 768188 715833 389631 395819 420131 427085 427737 435948 453505 454313 454756 461490 474233 478304 478390 480668 382105 395646 412609 443361 446604 452489 452557 459506 463848 465837 465996 466142 466587 466641 473679 474045 181804 282430 381838 395166 410452 430508 444278 444336 447244 448306 452769 455114 455971 457202 459184 462316 463669 463800 466676 469753 470145 470208 472106 474347 477795 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.37%) |
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 181804 282430 381838 382105 389631 395166 395646 395819 410452 412609 420131 427085 427737 430508 435948 443361 444278 444336 446604 447244 448306 452489 452557 452769 453505 454313 454756 455114 455971 457202 459184 459506 460317 461490 462316 463669 463800 463848 464116 464263 465707 465837 465996 466142 466587 466641 466656 466676 467691 467951 468859 469753 469888 470145 470208 470912 471858 472106 472591 473679 474045 474233 474347 474499 475849 477795 478304 478390 480668 481432 487892 492815 493871 494095 494413 499756 501188 503640 503733 504775 505870 506126 506493 509588 509937 512227 515768 517990 518802 519887 520547 521812 522375 523088 523910 524648 526379 526743 526892 528024 528108 529426 533001 533687 534593 536142 536207 536286 542617 543378 551293 579666 647612 675094 715833 721012 757365 758133 768188 770899 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy white"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy white"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy white"
]
|
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.