Query Metrics
7
Database Queries
7
Different statements
199.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.60 ms (86.02%) |
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 295700 393734 393735 395942 399554 416303 418407 434804 470707 470844 474208 525486 556796 563416 568576 569662 569679 570077 589821 597585 597848 607437 618870 624851 626742 645845 655366 663903 663919 664296 666103 667231 667312 668648 678726 684197 688307 688336 689299 692641 696974 697289 700662 701488 704727 706601 710957 712335 712804 712817 715501 717699 717700 718532 720009 728351 729743 730853 731174 731339 731379 740494 740522 741248 741639 742186 743039 743089 743124 743147 743196 744314 744508 746060 747476 751656 753727 753815 754784 757200 758033 759439 759595 759657 767961 769766 771163 774155 774162 779523 786036 788739 789202 789228 789233 789401 789424 789829 789879 790158 790977 790995 799172 800114 803179 803326 807729 810684 811492 812097 812148 812150 814084 817022 817310 817683 817816 818232 818421 825037 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (9.22%) |
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 399554 470844 474208 418407 470707 525486 434804 568576 569662 569679 570077 416303 393735 395942 814084 817683 817816 817022 818232 825037 817310 818421 563416 655366 678726 701488 712804 717700 645845 663903 663919 666103 688307 697289 700662 710957 712335 664296 667231 667312 668648 684197 688336 689299 692641 712817 717699 720009 556796 589821 607437 618870 624851 597585 597848 626742 786036 789228 803326 810684 811492 789233 790977 790995 807729 812097 731339 743089 743124 743147 743196 744314 757200 759439 759657 788739 789202 789401 789424 789879 790158 812148 812150 730853 751656 759595 767961 774162 728351 731379 740494 741639 742186 744508 746060 753815 758033 769766 729743 741248 743039 753727 754784 731174 740522 747476 771163 774155 696974 704727 706601 715501 718532 779523 789829 799172 800114 803179 393734 295700 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.15%) |
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 295700 393734 393735 395942 399554 416303 418407 434804 470707 470844 474208 525486 556796 563416 568576 569662 569679 570077 589821 597585 597848 607437 618870 624851 626742 645845 655366 663903 663919 664296 666103 667231 667312 668648 678726 684197 688307 688336 689299 692641 696974 697289 700662 701488 704727 706601 710957 712335 712804 712817 715501 717699 717700 718532 720009 728351 729743 730853 731174 731339 731379 740494 740522 741248 741639 742186 743039 743089 743124 743147 743196 744314 744508 746060 747476 751656 753727 753815 754784 757200 758033 759439 759595 759657 767961 769766 771163 774155 774162 779523 786036 788739 789202 789228 789233 789401 789424 789829 789879 790158 790977 790995 799172 800114 803179 803326 807729 810684 811492 812097 812148 812150 814084 817022 817310 817683 817816 818232 818421 825037 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy young"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy young"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy 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.