Query Metrics
7
Database Queries
7
Different statements
159.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.50 ms (85.19%) |
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 394240 410967 423584 426818 427550 435263 437727 460491 461364 462101 466540 469827 474754 476397 477784 487712 487833 498198 500120 505937 506135 509278 511681 519458 521770 528811 530237 549516 549695 551553 561324 562780 562988 563033 567565 569867 571819 574030 576841 577039 577471 582558 584456 592752 598268 598315 605961 606396 610241 610261 613849 616002 616851 619011 623834 630080 637399 643587 644091 644526 644540 653356 653618 676421 678910 680580 682304 682741 686514 693302 705226 710807 716033 724553 726829 729134 731014 734952 736260 738022 738962 741796 743933 743957 745682 746141 748753 758314 758594 760602 763953 766115 767017 767864 768944 773131 777782 779738 779817 780565 781574 782729 783966 784613 784970 785364 787136 787435 793162 793959 798968 801526 806632 809891 811237 811390 812680 819834 827919 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (8.91%) |
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 741796 738962 768944 793162 806632 427550 466540 519458 461364 474754 606396 758314 779817 410967 562780 619011 729134 785364 745682 758594 766115 783966 787136 605961 577039 827919 576841 549516 678910 682741 686514 716033 592752 616851 643587 779738 630080 511681 528811 798968 811390 763953 767017 710807 598315 680580 784970 811237 738022 760602 773131 787435 731014 736260 743933 724553 743957 777782 780565 781574 551553 571819 644526 569867 394240 487712 567565 682304 693302 610241 637399 610261 500120 423584 469827 549695 767864 748753 793959 435263 437727 476397 505937 530237 734952 623834 462101 460491 477784 574030 653356 561324 801526 746141 784613 809891 487833 594372 506135 498198 521770 563033 584456 705226 653618 676421 562988 613849 616002 644091 644540 426818 819834 509278 577471 598268 782729 812680 726829 582558 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.95%) |
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 394240 410967 423584 426818 427550 435263 437727 460491 461364 462101 466540 469827 474754 476397 477784 487712 487833 498198 500120 505937 506135 509278 511681 519458 521770 528811 530237 549516 549695 551553 561324 562780 562988 563033 567565 569867 571819 574030 576841 577039 577471 582558 584456 592752 598268 598315 605961 606396 610241 610261 613849 616002 616851 619011 623834 630080 637399 643587 644091 644526 644540 653356 653618 676421 678910 680580 682304 682741 686514 693302 705226 710807 716033 724553 726829 729134 731014 734952 736260 738022 738962 741796 743933 743957 745682 746141 748753 758314 758594 760602 763953 766115 767017 767864 768944 773131 777782 779738 779817 780565 781574 782729 783966 784613 784970 785364 787136 787435 793162 793959 798968 801526 806632 809891 811237 811390 812680 819834 827919 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage homemade"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.84%) |
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.