Query Metrics
7
Database Queries
7
Different statements
149.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.37 ms (85.99%) |
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 446345 484304 487896 489728 490157 499083 526464 526954 536578 536947 538163 545861 546273 547917 553671 556300 565291 566051 567456 568944 574020 585595 588278 590071 590328 593613 599318 603027 606557 609081 614001 615137 615509 619350 620707 621364 623745 624389 625492 625957 625992 626678 634862 635578 636623 637998 647604 647607 648693 661991 662076 663839 664698 667752 668100 668102 668131 673187 677981 678216 678876 682976 683698 687140 687835 689040 689994 691149 693420 693630 693679 696374 698915 702623 707214 709427 710066 711802 714808 715435 716303 719457 723010 723826 724516 724781 727407 728463 731580 732140 733356 734124 734185 734277 736933 737334 737425 739324 739682 740181 741983 743005 747533 747563 756277 757925 758420 759608 761733 761765 762771 764443 765394 782297 793755 794827 805533 816052 821468 ] |
||||||||||||||||||||||||||||||
|
11.26 ms (7.54%) |
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 821468 536578 547917 567456 565291 568944 574020 648693 668102 678876 687140 687835 689994 691149 693630 696374 707214 711802 714808 719457 723010 647604 663839 664698 668131 683698 689040 693420 702623 662076 668100 677981 678216 715435 546273 553671 590328 609081 615137 619350 625492 636623 593613 614001 615509 620707 625992 588278 626678 590071 623745 793755 794827 723826 733356 734124 734185 736933 740181 761733 782297 731580 739324 759608 728463 762771 766177 734277 741983 743005 756277 758420 761765 625957 637998 698915 499083 566051 661991 635578 747563 489728 487896 538163 526464 526954 536947 545861 647607 673187 585595 599318 805533 737334 764443 727407 737425 710066 446345 556300 682976 667752 693679 709427 603027 606557 621364 624389 634862 724516 724781 739682 757925 732140 747533 765394 716303 484304 490157 816052 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.86%) |
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 446345 484304 487896 489728 490157 499083 526464 526954 536578 536947 538163 545861 546273 547917 553671 556300 565291 566051 567456 568944 574020 585595 588278 590071 590328 593613 599318 603027 606557 609081 614001 615137 615509 619350 620707 621364 623745 624389 625492 625957 625992 626678 634862 635578 636623 637998 647604 647607 648693 661991 662076 663839 664698 667752 668100 668102 668131 673187 677981 678216 678876 682976 683698 687140 687835 689040 689994 691149 693420 693630 693679 696374 698915 702623 707214 709427 710066 711802 714808 715435 716303 719457 723010 723826 724516 724781 727407 728463 731580 732140 733356 734124 734185 734277 736933 737334 737425 739324 739682 740181 741983 743005 747533 747563 756277 757925 758420 759608 761733 761765 762771 764443 765394 782297 793755 794827 805533 816052 821468 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real big cock"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real большие cock"
]
|
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.