Query Metrics
7
Database Queries
7
Different statements
184.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.30 ms (87.64%) |
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 58408 148582 219740 280771 313222 384519 388228 389957 393471 401660 402999 406044 407567 410695 417907 417921 419838 428828 428927 429739 434072 448372 457471 457976 458549 463826 464046 464055 464490 465055 466568 479409 480518 482500 486008 488914 500432 515355 515408 517695 521233 529396 529977 530333 530890 532207 532416 532719 533257 533338 533562 533575 534311 534454 535365 536831 537749 539219 539453 541460 550575 562408 564621 566600 569971 574113 579131 595953 603797 606671 606823 609714 629313 630233 630360 631657 632048 634692 635332 637699 639310 639635 654196 660389 669219 673611 673981 674528 687871 690294 698575 715843 728094 752860 753926 754522 757063 759490 760657 765158 769417 769989 770041 771933 772165 772463 775519 781022 782675 783341 788163 789884 796511 798611 803233 803760 806032 806690 816756 827912 ] |
||||||||||||||||||||||||||||||
|
13.21 ms (7.18%) |
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 406044 539453 541460 464055 482500 533257 533338 521233 530333 532207 533562 534454 530890 537749 529977 535365 566600 550575 669219 673611 698575 569971 595953 606671 629313 630233 606823 782675 798611 728094 757063 760657 772463 752860 753926 769417 771933 715843 806032 464490 515408 517695 464046 529396 532416 579131 480518 388228 816756 827912 533575 574113 687871 635332 639635 789884 775519 788163 313222 148582 609714 58408 458549 631657 630360 219740 457976 393471 434072 639310 280771 389957 428927 515355 660389 419838 486008 536831 539219 532719 534311 564621 674528 673981 690294 562408 803233 803760 759490 783341 806690 754522 770041 634692 637699 781022 402999 410695 448372 407567 479409 417921 428828 488914 500432 465055 772165 429739 457471 384519 401660 654196 632048 603797 796511 765158 769989 417907 463826 466568 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.46%) |
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 58408 148582 219740 280771 313222 384519 388228 389957 393471 401660 402999 406044 407567 410695 417907 417921 419838 428828 428927 429739 434072 448372 457471 457976 458549 463826 464046 464055 464490 465055 466568 479409 480518 482500 486008 488914 500432 515355 515408 517695 521233 529396 529977 530333 530890 532207 532416 532719 533257 533338 533562 533575 534311 534454 535365 536831 537749 539219 539453 541460 550575 562408 564621 566600 569971 574113 579131 595953 603797 606671 606823 609714 629313 630233 630360 631657 632048 634692 635332 637699 639310 639635 654196 660389 669219 673611 673981 674528 687871 690294 698575 715843 728094 752860 753926 754522 757063 759490 760657 765158 769417 769989 770041 771933 772165 772463 775519 781022 782675 783341 788163 789884 796511 798611 803233 803760 806032 806690 816756 827912 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty ass"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty жоп"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.68%) |
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.