Query Metrics
7
Database Queries
7
Different statements
154.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.77 ms (83.43%) |
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 420303 428064 443188 449283 458116 474507 493052 514606 517661 533395 540590 566270 567456 568944 574020 581739 587268 590328 593613 596372 597903 606248 609081 610001 610434 613440 615137 619350 622869 625937 625957 625992 628594 632295 637998 639111 639243 648693 652169 655452 660008 664698 668034 668100 668102 673908 677981 683698 684477 689040 690052 692829 693420 698915 702639 708578 710092 713181 714799 714808 716153 716992 718562 719280 723010 731123 733151 740763 742069 743630 744218 747429 747982 748076 761820 763993 764060 764623 765091 768060 769556 771430 771937 775002 775647 780323 783250 783887 784886 787252 787437 787732 789797 789818 790944 791481 791538 792683 794706 794827 794909 795371 795950 796294 798816 800975 801141 802334 803714 810174 813833 820167 823713 824546 824913 824997 825055 825829 827480 827539 ] |
||||||||||||||||||||||||||||||
|
14.40 ms (9.33%) |
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 791481 566270 673908 597903 740763 625937 514606 574020 648693 684477 664698 693420 622869 639111 596372 639243 733151 420303 820167 824913 825055 719280 713181 784886 787732 798816 789797 794706 731123 743630 765091 771430 783250 789818 795950 801141 802334 744218 761820 771937 764623 747982 763993 716992 775647 780323 787437 792683 810174 606248 458116 493052 517661 567456 655452 668102 702639 714799 714808 652169 668034 683698 689040 660008 668100 677981 692829 590328 609081 615137 619350 593613 625992 587268 632295 748076 769556 768060 613440 625957 628594 637998 698915 718562 690052 610001 610434 813833 796294 800975 783887 764060 824997 825829 823713 533395 540590 568944 708578 723010 710092 716153 581739 787252 791538 775002 794827 794909 742069 747429 790944 795371 474507 449283 428064 803714 443188 824546 827480 827539 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (2.32%) |
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 420303 428064 443188 449283 458116 474507 493052 514606 517661 533395 540590 566270 567456 568944 574020 581739 587268 590328 593613 596372 597903 606248 609081 610001 610434 613440 615137 619350 622869 625937 625957 625992 628594 632295 637998 639111 639243 648693 652169 655452 660008 664698 668034 668100 668102 673908 677981 683698 684477 689040 690052 692829 693420 698915 702639 708578 710092 713181 714799 714808 716153 716992 718562 719280 723010 731123 733151 740763 742069 743630 744218 747429 747982 748076 761820 763993 764060 764623 765091 768060 769556 771430 771937 775002 775647 780323 783250 783887 784886 787252 787437 787732 789797 789818 790944 791481 791538 792683 794706 794827 794909 795371 795950 796294 798816 800975 801141 802334 803714 810174 813833 820167 823713 824546 824913 824997 825055 825829 827480 827539 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real home made"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real домашн любительск"
]
|
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.