Query Metrics
7
Database Queries
7
Different statements
183.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.69 ms (87.03%) |
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 106347 150405 165669 184985 185401 383474 384864 385538 387052 387777 389122 389167 390804 406404 407357 408172 413943 417022 431019 447842 448652 460707 461091 463882 467011 486924 489225 499815 500689 501718 504339 504444 506147 510045 511294 523214 530537 538352 545814 549583 551288 551358 551428 551430 560108 563715 564462 569820 574158 577775 578493 584735 592364 592815 593481 600581 600628 607286 610185 610390 610580 610962 618937 618938 620105 623950 623958 624285 630478 630823 634842 636522 643835 644093 651928 652177 653245 653246 653250 653258 653308 661693 661698 662038 662723 664795 672551 676118 677041 679702 689293 694468 702063 705720 708023 708768 720791 724712 726467 728067 728411 729843 735417 735684 738927 745451 746498 748752 768115 770007 792680 792833 793591 797705 800114 803595 813949 816047 825204 825312 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (7.46%) |
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 630478 607286 623950 797705 792833 726467 735417 746498 724712 610580 413943 447842 610390 184985 463882 545814 600581 383474 460707 538352 504444 662723 636522 630823 618938 768115 792680 770007 643835 705720 165669 448652 387052 499815 708768 185401 387777 390804 406404 624285 593481 803595 728067 793591 467011 500689 551288 106347 461091 563715 676118 689293 708023 600628 610185 644093 417022 150405 486924 551430 574158 653246 720791 651928 653245 652177 653258 653308 661693 661698 662038 694468 702063 551358 618937 610962 728411 745451 729843 735684 748752 800114 825204 664795 738927 523214 672551 389167 501718 511294 816047 825312 384864 510045 504339 530537 506147 634842 389122 549583 584735 407357 431019 385538 564462 578493 569820 653250 679702 577775 592815 620105 592364 623958 408172 813949 489225 560108 551428 677041 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.71%) |
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 106347 150405 165669 184985 185401 383474 384864 385538 387052 387777 389122 389167 390804 406404 407357 408172 413943 417022 431019 447842 448652 460707 461091 463882 467011 486924 489225 499815 500689 501718 504339 504444 506147 510045 511294 523214 530537 538352 545814 549583 551288 551358 551428 551430 560108 563715 564462 569820 574158 577775 578493 584735 592364 592815 593481 600581 600628 607286 610185 610390 610580 610962 618937 618938 620105 623950 623958 624285 630478 630823 634842 636522 643835 644093 651928 652177 653245 653246 653250 653258 653308 661693 661698 662038 662723 664795 672551 676118 677041 679702 689293 694468 702063 705720 708023 708768 720791 724712 726467 728067 728411 729843 735417 735684 738927 745451 746498 748752 768115 770007 792680 792833 793591 797705 800114 803595 813949 816047 825204 825312 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage big"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж большие"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.77%) |
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.