Query Metrics
7
Database Queries
7
Different statements
159.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.14 ms (83.39%) |
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 486201 525778 532086 543203 544307 544749 546822 547656 549267 556796 557326 580241 581661 589821 600042 609647 615612 617183 617433 619463 620791 630852 641006 645845 649084 654729 655977 657643 663395 663919 664296 666458 667231 667312 667472 668189 674705 681809 682918 683917 686054 689685 690126 691250 692641 693039 693528 696974 697289 699772 700662 702137 702633 702895 704727 706311 707276 708457 708804 712911 712971 715209 716069 717892 720009 720824 721552 722443 724867 730853 731174 732426 735594 735844 736707 740494 740821 741445 741889 743039 743089 743118 743147 744314 746406 747476 747609 747858 748561 749896 751656 754356 757200 758033 759595 759596 760971 762999 766042 766043 769766 771163 771203 771321 771344 773973 774090 776016 784600 786036 789233 789270 789885 790995 791000 798971 807729 810684 827846 827978 ] |
||||||||||||||||||||||||||||||
|
15.20 ms (9.52%) |
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 827978 827846 486201 525778 532086 546822 549267 580241 543203 544307 547656 649084 654729 674705 682918 686054 691250 693039 699772 702633 707276 708457 645845 657643 663395 663919 667472 689685 697289 700662 712911 715209 716069 717892 721552 655977 664296 666458 667231 667312 668189 681809 683917 690126 692641 693528 702137 702895 706311 708804 712971 720009 720824 722443 544749 556796 557326 581661 619463 589821 600042 617433 609647 620791 630852 615612 617183 776016 786036 798971 810684 789233 789885 790995 791000 807729 743089 743147 744314 746406 747609 747858 748561 757200 773973 774090 784600 789270 730853 735844 736707 741445 751656 754356 759595 766042 771203 740494 741889 758033 759596 762999 769766 732426 735594 743039 743118 766043 771321 724867 731174 740821 747476 749896 760971 771163 771344 641006 696974 704727 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (2.29%) |
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 486201 525778 532086 543203 544307 544749 546822 547656 549267 556796 557326 580241 581661 589821 600042 609647 615612 617183 617433 619463 620791 630852 641006 645845 649084 654729 655977 657643 663395 663919 664296 666458 667231 667312 667472 668189 674705 681809 682918 683917 686054 689685 690126 691250 692641 693039 693528 696974 697289 699772 700662 702137 702633 702895 704727 706311 707276 708457 708804 712911 712971 715209 716069 717892 720009 720824 721552 722443 724867 730853 731174 732426 735594 735844 736707 740494 740821 741445 741889 743039 743089 743118 743147 744314 746406 747476 747609 747858 748561 749896 751656 754356 757200 758033 759595 759596 760971 762999 766042 766043 769766 771163 771203 771321 771344 773973 774090 776016 784600 786036 789233 789270 789885 790995 791000 798971 807729 810684 827846 827978 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"a young girl"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк"
]
|
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.