Query Metrics
7
Database Queries
7
Different statements
433.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.00 ms (49.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск riding волосатая"
]
|
||||||||||||||||||||||||||||||
|
195.62 ms (45.08%) |
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 385064 447250 453677 453989 453993 455997 456005 460598 469959 477374 483522 488191 488982 490633 490648 504005 507832 508566 508705 513382 521599 525988 527459 531597 537237 538093 539860 547088 550357 551047 555312 556677 557363 563731 563751 566877 572025 576537 576774 585416 585553 586973 589323 589977 599239 602529 602920 610161 615265 616359 617368 617380 620864 621450 625343 630016 635688 635878 637363 640254 647481 649372 655011 658499 666716 673496 680519 680806 685526 688167 699082 705200 708702 709459 710050 710331 714587 718150 722116 723642 723877 729157 734362 734370 734590 735783 738405 739298 740105 740738 745257 748650 752680 756252 758068 758583 760491 767516 768890 772141 784284 788633 788753 788848 794390 794392 795812 797049 798704 798769 800657 801004 801844 803805 812558 814272 820085 823713 826725 827397 ] |
||||||||||||||||||||||||||||||
|
15.13 ms (3.49%) |
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 585416 635878 640254 585553 616359 740738 814272 488982 745257 795812 508705 617380 525988 556677 576537 718150 722116 734370 735783 734362 739298 729157 738405 748650 768890 740105 798769 820085 563751 801844 758583 734590 788633 666716 488191 507832 447250 547088 709459 688167 602529 617368 637363 589323 630016 699082 710050 710331 538093 823713 673496 826725 550357 599239 513382 723642 827397 455997 563731 551047 655011 621450 788753 723877 752680 772141 760491 714587 784284 477374 685526 794390 756252 788848 483522 504005 460598 490648 453677 537237 555312 589977 801004 797049 798704 800657 812558 767516 758068 803805 658499 469959 508566 557363 539860 576774 647481 705200 680519 615265 602920 625343 620864 610161 635688 531597 708702 453989 453993 456005 521599 586973 794392 385064 490633 527459 566877 572025 649372 680806 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (0.79%) |
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 385064 447250 453677 453989 453993 455997 456005 460598 469959 477374 483522 488191 488982 490633 490648 504005 507832 508566 508705 513382 521599 525988 527459 531597 537237 538093 539860 547088 550357 551047 555312 556677 557363 563731 563751 566877 572025 576537 576774 585416 585553 586973 589323 589977 599239 602529 602920 610161 615265 616359 617368 617380 620864 621450 625343 630016 635688 635878 637363 640254 647481 649372 655011 658499 666716 673496 680519 680806 685526 688167 699082 705200 708702 709459 710050 710331 714587 718150 722116 723642 723877 729157 734362 734370 734590 735783 738405 739298 740105 740738 745257 748650 752680 756252 758068 758583 760491 767516 768890 772141 784284 788633 788753 788848 794390 794392 795812 797049 798704 798769 800657 801004 801844 803805 812558 814272 820085 823713 826725 827397 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade riding hairy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск riding волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.