Query Metrics
7
Database Queries
7
Different statements
171.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.28 ms (88.20%) |
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 381819 385645 410655 413641 414070 418219 420277 420823 421369 428289 428924 429144 430366 431154 432927 445810 447318 452875 452923 454711 469221 471117 478030 495747 497690 516597 522288 527524 529004 529606 529628 530652 530970 538599 542453 553583 558407 562573 568211 572184 574969 575616 575655 575935 576564 580779 580781 584848 594171 594208 594306 595442 595464 596649 597505 604134 616837 616850 628850 629226 635823 636343 646439 646789 651840 652212 652221 658777 664266 666857 669267 671097 672715 674885 677470 681196 681787 684850 687375 687718 690173 700244 707264 708544 708562 709089 729674 732093 733798 741660 742305 750574 751385 752654 758728 763407 770880 774462 776092 777665 781017 782858 783607 783708 786792 789371 792897 800507 803119 803134 804806 806605 810491 813734 814441 821785 825808 826353 ] |
||||||||||||||||||||||||||||||
|
11.00 ms (6.41%) |
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 658777 742305 803134 414070 420277 432927 413641 445810 478030 447318 471117 497690 495747 469221 594208 596649 428924 452923 418219 421369 430366 452875 522288 652212 410655 428289 431154 385645 381819 420823 429144 774462 826353 814441 825808 823492 813734 821785 454711 529606 538599 530970 516597 527524 529004 529628 530652 542453 558407 562573 575655 575935 572184 574969 576564 580779 568211 584848 652221 664266 677470 681787 687718 700244 707264 708544 708562 646439 646789 651840 666857 669267 674885 687375 690173 709089 671097 672715 681196 684850 553583 575616 580781 604134 616850 628850 629226 595442 616837 635823 594171 594306 595464 597505 636343 776092 777665 781017 783607 792897 804806 782858 783708 800507 803119 810491 729674 732093 733798 750574 751385 752654 757736 758728 763407 770880 786792 789371 806605 741660 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.72%) |
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 381819 385645 410655 413641 414070 418219 420277 420823 421369 428289 428924 429144 430366 431154 432927 445810 447318 452875 452923 454711 469221 471117 478030 495747 497690 516597 522288 527524 529004 529606 529628 530652 530970 538599 542453 553583 558407 562573 568211 572184 574969 575616 575655 575935 576564 580779 580781 584848 594171 594208 594306 595442 595464 596649 597505 604134 616837 616850 628850 629226 635823 636343 646439 646789 651840 652212 652221 658777 664266 666857 669267 671097 672715 674885 677470 681196 681787 684850 687375 687718 690173 700244 707264 708544 708562 709089 729674 732093 733798 741660 742305 750574 751385 752654 758728 763407 770880 774462 776092 777665 781017 782858 783607 783708 786792 789371 792897 800507 803119 803134 804806 806605 810491 813734 814441 821785 825808 826353 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen solo teen"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen соло teen"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen соло teen"
]
|
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.