Query Metrics
7
Database Queries
7
Different statements
393.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.95 ms (54.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс пляж природ"
]
|
||||||||||||||||||||||||||||||
|
159.74 ms (40.59%) |
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 400428 440747 444313 448393 456894 457715 457721 457722 463705 472930 491624 499735 507327 514300 520173 523940 526185 527501 528681 531154 532361 533797 534363 534366 534370 537010 537617 538316 539248 543575 543757 544590 544604 545210 545229 548076 548510 551038 551191 552280 552282 555763 558113 561306 562372 565220 567467 578103 580710 581007 582872 585896 592981 599400 603697 613599 614840 624460 625294 628301 631185 633708 634432 635684 635740 635751 639218 644198 644847 650258 651325 651917 652469 658841 659326 661004 672181 680937 680944 688999 690882 693567 695398 695417 714002 714032 714034 716516 718520 720481 724126 728068 736463 737144 738909 740798 740832 745606 747535 756878 757026 768003 771498 774339 778765 779688 780175 780797 783535 785376 789045 792997 793024 798709 798712 800461 800505 801637 801782 803693 ] |
||||||||||||||||||||||||||||||
|
11.92 ms (3.03%) |
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 463705 714032 747535 652469 801782 803693 800505 800461 714034 780797 756878 798712 740798 716516 736463 695417 793024 457722 780175 539248 658841 695398 639218 544604 798709 624460 534366 444313 745606 778765 789045 545210 771498 737144 661004 634432 635751 537617 533797 544590 728068 448393 740832 757026 543757 585896 801637 792997 532361 688999 456894 651917 528681 457715 552282 718520 548510 633708 545229 548076 738909 538316 650258 651325 614840 400428 558113 785376 520173 514300 714002 551191 578103 783535 774339 581007 644847 555763 625294 582872 659326 565220 635684 672181 720481 527501 693567 635740 724126 628301 499735 768003 534370 680937 644198 567467 457721 779688 580710 531154 440747 523940 472930 631185 562372 599400 613599 491624 551038 552280 603697 526185 534363 537010 543575 690882 680944 592981 507327 561306 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.77%) |
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 400428 440747 444313 448393 456894 457715 457721 457722 463705 472930 491624 499735 507327 514300 520173 523940 526185 527501 528681 531154 532361 533797 534363 534366 534370 537010 537617 538316 539248 543575 543757 544590 544604 545210 545229 548076 548510 551038 551191 552280 552282 555763 558113 561306 562372 565220 567467 578103 580710 581007 582872 585896 592981 599400 603697 613599 614840 624460 625294 628301 631185 633708 634432 635684 635740 635751 639218 644198 644847 650258 651325 651917 652469 658841 659326 661004 672181 680937 680944 688999 690882 693567 695398 695417 714002 714032 714034 716516 718520 720481 724126 728068 736463 737144 738909 740798 740832 745606 747535 756878 757026 768003 771498 774339 778765 779688 780175 780797 783535 785376 789045 792997 793024 798709 798712 800461 800505 801637 801782 803693 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck on beach"
]
|
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.