Query Metrics
7
Database Queries
7
Different statements
169.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.88 ms (84.21%) |
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 31305 31422 43029 388795 401395 441853 457567 461632 462218 463237 465494 465591 475635 475638 475639 488939 498503 500070 505745 514217 518008 525729 529993 530454 540224 542220 542221 542237 542238 542529 544018 544031 544036 544873 544874 544876 546016 546243 546522 546525 546534 546548 550927 550928 553220 553749 553753 553755 553767 553770 554659 554685 554693 554695 554697 559364 560500 561772 561774 561776 561778 561780 561788 561793 561798 571120 572722 572723 572724 572728 573323 574661 576483 576574 576578 577010 583651 592102 599462 605108 608001 617532 617557 631097 642965 650538 660788 679235 679682 679686 696961 709976 711845 711851 711864 727914 734276 734439 735546 740746 742134 743549 744834 748289 750467 753740 759072 762161 768499 768505 768515 768524 774658 795052 801780 801788 806139 812318 812324 812329 ] |
||||||||||||||||||||||||||||||
|
15.20 ms (8.96%) |
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 577010 560500 561798 542220 546525 711851 679686 498503 505745 553767 546548 550928 554685 561772 546534 561780 631097 592102 774658 734276 812318 768515 740746 696961 31422 742134 550927 553755 559364 561788 553753 553770 572723 572728 544031 561776 546243 553220 571120 572722 748289 546016 583651 605108 518008 542529 525729 457567 529993 542237 544036 576483 542238 561793 711845 650538 554697 561774 642965 768499 795052 812329 768505 768524 43029 540224 544018 576578 542221 711864 546522 554659 554695 561778 576574 617532 727914 762161 743549 554693 750467 735546 441853 574661 812324 488939 544873 465591 530454 753740 734439 608001 806139 465494 599462 759072 475635 31305 463237 461632 514217 572724 401395 553749 679682 544874 544876 660788 679235 573323 617557 801788 744834 709976 801780 388795 475639 475638 462218 500070 ] |
||||||||||||||||||||||||||||||
|
4.35 ms (2.57%) |
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 31305 31422 43029 388795 401395 441853 457567 461632 462218 463237 465494 465591 475635 475638 475639 488939 498503 500070 505745 514217 518008 525729 529993 530454 540224 542220 542221 542237 542238 542529 544018 544031 544036 544873 544874 544876 546016 546243 546522 546525 546534 546548 550927 550928 553220 553749 553753 553755 553767 553770 554659 554685 554693 554695 554697 559364 560500 561772 561774 561776 561778 561780 561788 561793 561798 571120 572722 572723 572724 572728 573323 574661 576483 576574 576578 577010 583651 592102 599462 605108 608001 617532 617557 631097 642965 650538 660788 679235 679682 679686 696961 709976 711845 711851 711864 727914 734276 734439 735546 740746 742134 743549 744834 748289 750467 753740 759072 762161 768499 768505 768515 768524 774658 795052 801780 801788 806139 812318 812324 812329 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большие клитор"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие клитор"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие клитор"
]
|
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.