Query Metrics
7
Database Queries
7
Different statements
162.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.17 ms (84.27%) |
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 88226 154123 155144 383500 385618 385713 386193 391327 392023 394590 398101 400950 408880 411211 414114 414124 415966 416634 416678 416681 419439 421257 421369 428171 435689 441042 443247 443251 449173 449916 449921 454767 455918 457216 467568 467875 470403 470405 473453 475502 479738 480251 482190 486773 487425 497474 499921 506105 511857 514085 525489 526653 529741 530943 547235 547494 547556 548835 559784 561038 561040 577307 587292 587306 588034 595571 596684 597190 602249 604781 605133 605219 609885 615921 615950 621450 624191 627147 627224 628097 630091 664149 669067 669079 669080 669386 671044 678713 683297 713508 719573 722385 735906 736891 739878 742360 744038 745126 745921 750623 750881 752644 752657 752676 752704 770397 776209 784681 786864 788354 788953 792729 796646 796663 798243 800289 804663 811125 811690 811733 ] |
||||||||||||||||||||||||||||||
|
16.73 ms (10.28%) |
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 487425 713508 588034 628097 796663 742360 750881 719573 470405 530943 385713 400950 386193 457216 416634 411211 486773 482190 548835 671044 664149 669067 669080 561040 605133 605219 609885 615921 788953 798243 811690 770397 752704 796646 441042 467875 88226 154123 155144 529741 615950 443251 479738 804663 736891 547556 587306 630091 506105 511857 750623 398101 449916 514085 385618 414124 449921 383500 587292 577307 621450 788354 792729 752657 739878 745921 627224 811733 744038 525489 394590 683297 597190 416678 467568 470403 449173 497474 559784 392023 435689 419439 416681 473453 547494 561038 678713 669079 669386 624191 627147 604781 414114 421369 480251 722385 595571 800289 786864 391327 455918 499921 547235 596684 776209 752676 784681 811125 745126 735906 752644 421257 408880 454767 475502 428171 526653 415966 443247 602249 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.30%) |
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 88226 154123 155144 383500 385618 385713 386193 391327 392023 394590 398101 400950 408880 411211 414114 414124 415966 416634 416678 416681 419439 421257 421369 428171 435689 441042 443247 443251 449173 449916 449921 454767 455918 457216 467568 467875 470403 470405 473453 475502 479738 480251 482190 486773 487425 497474 499921 506105 511857 514085 525489 526653 529741 530943 547235 547494 547556 548835 559784 561038 561040 577307 587292 587306 588034 595571 596684 597190 602249 604781 605133 605219 609885 615921 615950 621450 624191 627147 627224 628097 630091 664149 669067 669079 669080 669386 671044 678713 683297 713508 719573 722385 735906 736891 739878 742360 744038 745126 745921 750623 750881 752644 752657 752676 752704 770397 776209 784681 786864 788354 788953 792729 796646 796663 798243 800289 804663 811125 811690 811733 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam huge dildo"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер огромные дилд"
]
|
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.