Query Metrics
7
Database Queries
7
Different statements
130.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.09 ms (86.52%) |
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 101789 396098 407130 417554 417783 417821 434766 441479 464953 506283 512196 530987 534094 535311 535794 542460 562419 564521 567967 568002 575341 583082 590847 594615 604262 617645 618005 618843 620805 621081 624170 625577 626507 626509 630369 633870 636960 639552 640390 640466 643590 649916 650230 651770 657143 657193 660338 660461 662148 670832 671952 672780 680230 683092 684404 686729 687740 687771 690218 690239 690508 691217 694492 695993 707088 709798 712583 713909 716461 717728 718605 720362 720397 725549 729133 729937 730230 731314 732015 734932 742139 744907 747100 747158 752595 753209 755025 757111 757932 758528 758571 758971 759044 760285 761080 762972 765293 767043 767947 768361 770279 770295 774650 777056 778850 781101 791769 793527 796918 799914 804814 805310 805668 805961 820655 822593 828560 828723 ] |
||||||||||||||||||||||||||||||
|
8.83 ms (6.76%) |
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 742139 768361 747100 758971 757111 630369 464953 417821 441479 583082 650230 657143 670832 671952 707088 712583 720362 720397 662148 672780 694492 660338 680230 683092 691217 695993 640466 620805 633870 621081 624170 639552 805961 774650 777056 752595 758528 805668 729937 744907 762972 767043 725549 770295 640390 396098 101789 821958 828723 828560 506283 512196 530987 534094 535311 535794 542460 562419 564521 568002 575341 649916 657193 690508 709798 660461 686729 687771 690218 690239 717728 687740 716461 718605 567967 617645 618843 626507 625577 636960 590847 626509 643590 778850 781101 793527 799914 804814 730230 731314 753209 758571 759044 761080 791769 796918 767947 769790 732015 734932 747158 765293 760285 713909 417783 651770 604262 407130 618005 434766 684404 594615 805310 757932 729133 755025 770279 417554 820655 822593 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen close-up"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.53%) |
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 101789 396098 407130 417554 417783 417821 434766 441479 464953 506283 512196 530987 534094 535311 535794 542460 562419 564521 567967 568002 575341 583082 590847 594615 604262 617645 618005 618843 620805 621081 624170 625577 626507 626509 630369 633870 636960 639552 640390 640466 643590 649916 650230 651770 657143 657193 660338 660461 662148 670832 671952 672780 680230 683092 684404 686729 687740 687771 690218 690239 690508 691217 694492 695993 707088 709798 712583 713909 716461 717728 718605 720362 720397 725549 729133 729937 730230 731314 732015 734932 742139 744907 747100 747158 752595 753209 755025 757111 757932 758528 758571 758971 759044 760285 761080 762972 765293 767043 767947 768361 770279 770295 774650 777056 778850 781101 791769 793527 796918 799914 804814 805310 805668 805961 820655 822593 828560 828723 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen close up"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen close up"
]
|
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.