Query Metrics
7
Database Queries
7
Different statements
196.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.61 ms (84.90%) |
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 41776 345851 384275 395703 397509 401177 414090 414094 414256 419694 421462 427341 435700 443168 446534 448588 452816 458115 462900 466563 471951 475752 477111 477169 477245 478215 480393 480454 483189 485031 492112 495140 495562 499934 504102 513183 519437 522785 536224 547453 547501 554949 556442 559294 578493 586760 596035 598584 605874 609888 628641 630796 633887 641097 642403 646014 646433 648395 648852 652831 653561 656886 671578 676531 692711 694441 698423 699531 700259 713896 713911 717836 718631 718785 719026 720701 723549 727807 733645 738912 739141 739390 740919 741252 752837 753654 758648 760667 763445 763739 766335 766381 766707 770377 770387 770391 770413 774691 775240 776527 777847 784221 787857 790875 791489 796930 797443 797842 805120 805230 806541 806687 806794 810830 811325 814648 814754 817217 820594 822930 ] |
||||||||||||||||||||||||||||||
|
18.64 ms (9.50%) |
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 791489 478215 504102 483189 495562 446534 692711 763739 513183 522785 495140 646433 480393 435700 471951 480454 519437 723549 817217 822930 556442 648395 648852 699531 653561 694441 700259 775240 739390 806687 739141 753654 766381 770377 763445 752837 419694 814754 458115 475752 717836 718785 628641 642403 805120 766335 784221 443168 814648 820594 536224 547501 559294 547453 656886 671578 713911 719026 646014 652831 676531 713896 698423 718631 641097 605874 586760 630796 598584 609888 774691 777847 796930 806794 811325 776527 787857 790875 797443 810830 727807 733645 797842 805230 806541 766707 770391 738912 741252 740919 770413 720701 345851 395703 466563 477245 384275 41776 578493 596035 633887 770387 427341 477111 492112 760667 499934 477169 758648 448588 414256 414090 421462 414094 462900 452816 485031 554949 397509 401177 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.59%) |
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 41776 345851 384275 395703 397509 401177 414090 414094 414256 419694 421462 427341 435700 443168 446534 448588 452816 458115 462900 466563 471951 475752 477111 477169 477245 478215 480393 480454 483189 485031 492112 495140 495562 499934 504102 513183 519437 522785 536224 547453 547501 554949 556442 559294 578493 586760 596035 598584 605874 609888 628641 630796 633887 641097 642403 646014 646433 648395 648852 652831 653561 656886 671578 676531 692711 694441 698423 699531 700259 713896 713911 717836 718631 718785 719026 720701 723549 727807 733645 738912 739141 739390 740919 741252 752837 753654 758648 760667 763445 763739 766335 766381 766707 770377 770387 770391 770413 774691 775240 776527 777847 784221 787857 790875 791489 796930 797443 797842 805120 805230 806541 806687 806794 810830 811325 814648 814754 817217 820594 822930 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty anal masturbation"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty анал мастурбац"
]
|
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.