Query Metrics
7
Database Queries
7
Different statements
346.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.07 ms (60.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск любительск девушк"
]
|
||||||||||||||||||||||||||||||
|
118.44 ms (34.17%) |
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 478112 518353 527118 530615 533770 537965 540251 542940 546367 546871 547195 547218 547922 550147 553533 558382 559462 559538 561048 566440 575624 585588 588854 591183 591424 598692 600595 601458 601639 609708 611431 615861 619698 623784 626613 626685 627111 628021 632197 638060 639661 642130 643211 644024 647119 651768 657864 670392 670396 670701 672878 673852 674899 675495 678195 678261 678458 678465 681703 682984 685239 686727 687846 690027 690032 691157 691180 692036 692851 693214 694172 696257 696521 704996 705139 708647 709492 710554 711064 712111 712393 712692 713420 713941 716372 716964 720191 720222 722052 723779 734801 735599 737117 746344 746363 747597 751395 756396 760630 764795 768576 769478 777543 778121 781008 787290 789034 791929 794003 794056 796528 799676 799792 800975 808266 809808 814081 828278 ] |
||||||||||||||||||||||||||||||
|
12.57 ms (3.63%) |
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 566440 760630 722052 764795 675495 627111 712393 547922 542940 709492 673852 598692 585588 601458 746344 691157 678465 686727 591424 791929 611431 716372 547218 627588 672878 747597 527118 615861 628021 561048 735599 769478 540251 559538 575624 546871 678261 690027 651768 710554 546367 626613 632197 609708 619698 601639 781008 734801 789034 723779 756396 794056 814081 708647 690032 588854 794003 623784 800975 737117 799792 808266 809808 530615 751395 550147 553533 670701 696521 704996 716964 657864 678458 713941 643211 796528 778121 790440 682984 692851 692036 720191 600595 768576 828278 777543 787290 626685 559462 678195 681703 644024 478112 547195 720222 638060 799676 746363 558382 685239 639661 518353 533770 696257 674899 642130 591183 537965 712692 687846 691180 694172 705139 711064 713420 647119 670392 670396 693214 712111 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.78%) |
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 478112 518353 527118 530615 533770 537965 540251 542940 546367 546871 547195 547218 547922 550147 553533 558382 559462 559538 561048 566440 575624 585588 588854 591183 591424 598692 600595 601458 601639 609708 611431 615861 619698 623784 626613 626685 627111 628021 632197 638060 639661 642130 643211 644024 647119 651768 657864 670392 670396 670701 672878 673852 674899 675495 678195 678261 678458 678465 681703 682984 685239 686727 687846 690027 690032 691157 691180 692036 692851 693214 694172 696257 696521 704996 705139 708647 709492 710554 711064 712111 712393 712692 713420 713941 716372 716964 720191 720222 722052 723779 734801 735599 737117 746344 746363 747597 751395 756396 760630 764795 768576 769478 777543 778121 781008 787290 789034 791929 794003 794056 796528 799676 799792 800975 808266 809808 814081 828278 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade amateur girls"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.