Query Metrics
7
Database Queries
7
Different statements
196.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.02 ms (87.00%) |
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 422380 423602 423912 438916 443514 454035 458220 470804 472156 477597 477625 478395 488529 490665 492972 493402 494039 495478 496066 498459 501670 502484 502856 503097 504492 512163 513158 515557 515893 515897 516298 518220 518961 521319 523422 524875 525332 531244 561860 571130 572881 585308 586981 587883 588258 591783 591795 598107 609197 609837 612254 613146 615604 616862 624652 632703 634118 639610 639802 645273 647949 647994 651977 656158 666534 666539 666540 666541 666684 666883 689040 692962 697561 697578 700689 706400 706895 708050 712477 714194 718826 720964 725654 730332 733489 734268 734620 734661 735900 738332 745962 748063 748531 750499 750701 753216 757751 761904 772010 773615 779976 783581 791818 793521 794511 794715 796213 802386 804297 812699 813534 814069 817996 820762 820775 823706 823732 824285 824691 826850 ] |
||||||||||||||||||||||||||||||
|
15.67 ms (7.97%) |
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 706400 588258 616862 745962 612254 423912 454035 470804 478395 521319 488529 524875 495478 490665 571130 587883 515557 820775 814069 472156 477597 523422 666541 645273 656158 666534 585308 609837 591795 750499 438916 515897 518961 502856 496066 501670 512163 824691 586981 609197 502484 515893 531244 503097 513158 647949 632703 443514 477625 422380 492972 504492 494039 516298 458220 493402 823706 725654 498459 666539 666540 639802 591783 750701 748531 525332 647994 613146 598107 730332 718826 720964 666883 634118 518220 823732 826850 692962 773615 796213 772010 572881 712477 697578 714194 779976 812699 753216 748063 738332 735900 802386 804297 615604 820762 733489 423602 817996 824285 651977 689040 666684 561860 794511 794715 734661 734268 761904 700689 791818 793521 757751 783581 708050 813534 697561 706895 639610 734620 624652 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.71%) |
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 422380 423602 423912 438916 443514 454035 458220 470804 472156 477597 477625 478395 488529 490665 492972 493402 494039 495478 496066 498459 501670 502484 502856 503097 504492 512163 513158 515557 515893 515897 516298 518220 518961 521319 523422 524875 525332 531244 561860 571130 572881 585308 586981 587883 588258 591783 591795 598107 609197 609837 612254 613146 615604 616862 624652 632703 634118 639610 639802 645273 647949 647994 651977 656158 666534 666539 666540 666541 666684 666883 689040 692962 697561 697578 700689 706400 706895 708050 712477 714194 718826 720964 725654 730332 733489 734268 734620 734661 735900 738332 745962 748063 748531 750499 750701 753216 757751 761904 772010 773615 779976 783581 791818 793521 794511 794715 796213 802386 804297 812699 813534 814069 817996 820762 820775 823706 823732 824285 824691 826850 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy creampie"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy creampie"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.19 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy creampie"
]
|
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.