Query Metrics
7
Database Queries
7
Different statements
165.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.39 ms (85.63%) |
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 394012 453583 458567 529089 531667 533591 537156 539555 540866 545466 553322 558144 562522 568191 568959 569876 570229 570693 571236 575980 576588 578459 579616 583585 587044 587282 588022 588456 588574 589309 590175 595252 598725 602769 602876 605938 615532 616574 616653 616963 618489 625517 626509 628027 628065 628436 628447 629740 630135 630999 640295 640463 640663 644161 644745 648059 648201 649916 655950 656432 659158 666608 666913 668827 668965 669433 670496 674503 682944 688470 690588 693087 693308 694495 701418 705481 705502 713951 715576 717368 718139 721083 722097 723794 723949 723973 726456 731082 733509 734291 734580 734596 734647 736279 736613 738612 740194 741340 743482 743516 744788 747625 747684 747977 748842 750862 752404 755199 783139 783140 783147 784160 806195 812699 812944 817184 824560 825890 827914 828848 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (7.74%) |
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 630999 741340 747625 726456 562522 579616 529089 588022 824560 828848 537156 553322 558144 568191 583585 570693 648059 648201 649916 659158 668827 715576 722097 666608 690588 713951 666913 688470 693308 545466 587282 616653 625517 628027 640463 644745 605938 629740 602876 616963 618489 626509 723794 723949 734647 752404 783140 783147 784160 733509 734596 743516 747684 723973 736613 738612 750862 755199 743482 747977 748842 740194 640663 701418 394012 694495 587044 812944 458567 571236 578459 628065 628447 595252 630135 453583 827914 539555 531667 575980 817184 540866 825890 533591 570229 576588 568959 569876 655950 656432 717368 718139 668965 682944 693087 721083 669433 670496 674503 705481 705502 602769 616574 640295 588456 588574 589309 598725 644161 590175 615532 628436 806195 812699 731082 734580 744788 783139 734291 736279 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.99%) |
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 394012 453583 458567 529089 531667 533591 537156 539555 540866 545466 553322 558144 562522 568191 568959 569876 570229 570693 571236 575980 576588 578459 579616 583585 587044 587282 588022 588456 588574 589309 590175 595252 598725 602769 602876 605938 615532 616574 616653 616963 618489 625517 626509 628027 628065 628436 628447 629740 630135 630999 640295 640463 640663 644161 644745 648059 648201 649916 655950 656432 659158 666608 666913 668827 668965 669433 670496 674503 682944 688470 690588 693087 693308 694495 701418 705481 705502 713951 715576 717368 718139 721083 722097 723794 723949 723973 726456 731082 733509 734291 734580 734596 734647 736279 736613 738612 740194 741340 743482 743516 744788 747625 747684 747977 748842 750862 752404 755199 783139 783140 783147 784160 806195 812699 812944 817184 824560 825890 827914 828848 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding big cock"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding большие 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.