Query Metrics
7
Database Queries
7
Different statements
388.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
363.54 ms (93.62%) |
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 382270 430546 476314 513327 513335 517822 526204 526214 526264 533529 534686 541901 543385 543446 543747 544978 567946 580914 583224 584026 589718 590856 591289 595532 595894 602652 602998 603407 603539 604577 611315 612675 614194 618674 620341 620491 625171 626066 628693 631683 635888 637490 638631 645581 649249 650705 663362 663911 663971 665421 665592 665894 667195 669749 669755 688938 692085 709215 710678 711297 714199 716221 726872 731034 742636 753023 758138 760169 765463 765516 766709 769502 770149 771480 781773 781841 781845 782002 782020 782395 787797 792550 797478 802748 802903 803784 807589 807914 807944 807973 811124 811884 812080 813825 816730 819336 819631 824293 824495 824509 824622 824834 824871 824962 825070 826597 826759 826886 827013 828034 828490 828491 828493 828592 828596 828604 828709 828710 828713 828714 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (4.00%) |
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 711297 782395 533529 513327 649249 667195 716221 645581 714199 602652 620491 637490 595894 612675 638631 803784 807589 802903 807944 811124 753023 765463 787797 792550 797478 765516 770149 766709 769502 604577 635888 709215 782020 828491 828034 513335 628693 626066 589718 631683 782002 731034 760169 476314 517822 580914 541901 614194 620341 807914 726872 611315 625171 828493 382270 828490 828596 430546 526264 526214 595532 603539 618674 742636 828713 828709 828592 827013 828710 526204 590856 591289 603407 819631 826759 824622 824962 534686 567946 650705 710678 812080 758138 824495 824871 826886 816730 824293 824509 825070 828714 584026 663911 663971 692085 663362 771480 819336 824834 826597 813825 828604 543385 543446 543747 544978 583224 669749 665894 665421 665592 669755 688938 602998 781841 781845 802748 807973 811884 781773 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (0.66%) |
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 382270 430546 476314 513327 513335 517822 526204 526214 526264 533529 534686 541901 543385 543446 543747 544978 567946 580914 583224 584026 589718 590856 591289 595532 595894 602652 602998 603407 603539 604577 611315 612675 614194 618674 620341 620491 625171 626066 628693 631683 635888 637490 638631 645581 649249 650705 663362 663911 663971 665421 665592 665894 667195 669749 669755 688938 692085 709215 710678 711297 714199 716221 726872 731034 742636 753023 758138 760169 765463 765516 766709 769502 770149 771480 781773 781841 781845 782002 782020 782395 787797 792550 797478 802748 802903 803784 807589 807914 807944 807973 811124 811884 812080 813825 816730 819336 819631 824293 824495 824509 824622 824834 824871 824962 825070 826597 826759 826886 827013 828034 828490 828491 828493 828592 828596 828604 828709 828710 828713 828714 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw hair"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw hair"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw hair"
]
|
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.