Query Metrics
7
Database Queries
7
Different statements
186.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.04 ms (88.62%) |
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 396911 402092 412419 417390 420762 422735 423350 425316 425353 430493 443637 446856 446872 447102 452602 461048 463840 464195 465608 465710 469586 475724 477464 478640 490132 491275 491461 494289 498594 512029 512974 522846 525526 525547 527659 529954 530536 531244 531319 532763 536200 537671 537676 539570 540433 540513 540575 540579 542278 542813 543878 543888 550063 551082 555164 566300 566758 569457 571230 573304 576980 586398 590850 594584 604174 604569 606727 612804 614426 619199 621426 630592 630916 633825 647361 650459 650509 653876 656559 669216 675002 681301 681313 684106 708125 719896 720237 720249 720257 727282 728277 731663 732565 733208 735860 737709 741064 745452 747012 750060 758023 770002 780601 793757 796997 804026 805811 810296 813770 816838 817851 818143 819757 820149 822578 825213 826061 828115 828868 828871 ] |
||||||||||||||||||||||||||||||
|
11.86 ms (6.37%) |
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 805811 731663 747012 750060 612804 402092 465710 412419 512974 525547 491461 491275 498594 522846 825213 828868 539570 728277 804026 822578 820149 828115 828871 531319 542813 604174 770002 633825 396911 816838 819757 566300 656559 650509 614426 745452 737709 733208 758023 540513 604569 813770 817851 542278 669216 684106 708125 741064 727282 719896 780601 818143 826061 536200 532763 530536 555164 810296 735860 732565 422735 423350 443637 463840 490132 446856 461048 464195 477464 478640 446872 447102 469586 512029 531244 537671 537676 540433 540575 494289 529954 475724 571230 550063 566758 543878 543888 573304 576980 650459 653876 681301 720237 720257 681313 720249 647361 675002 551082 569457 606727 619199 630592 590850 586398 594584 621426 793757 630916 796997 420762 425353 425316 465608 417390 430493 452602 527659 525526 540579 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (1.90%) |
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 396911 402092 412419 417390 420762 422735 423350 425316 425353 430493 443637 446856 446872 447102 452602 461048 463840 464195 465608 465710 469586 475724 477464 478640 490132 491275 491461 494289 498594 512029 512974 522846 525526 525547 527659 529954 530536 531244 531319 532763 536200 537671 537676 539570 540433 540513 540575 540579 542278 542813 543878 543888 550063 551082 555164 566300 566758 569457 571230 573304 576980 586398 590850 594584 604174 604569 606727 612804 614426 619199 621426 630592 630916 633825 647361 650459 650509 653876 656559 669216 675002 681301 681313 684106 708125 719896 720237 720249 720257 727282 728277 731663 732565 733208 735860 737709 741064 745452 747012 750060 758023 770002 780601 793757 796997 804026 805811 810296 813770 816838 817851 818143 819757 820149 822578 825213 826061 828115 828868 828871 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc milf"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc milf"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc milf"
]
|
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.