Query Metrics
7
Database Queries
7
Different statements
173.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.68 ms (86.97%) |
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 334847 390892 391579 392602 394258 395891 395933 396966 398955 414788 415594 424422 443677 443701 443705 443709 443719 443728 443818 443997 456731 462110 462117 486896 496346 515073 519997 530537 534260 534851 539497 541374 546937 546938 550377 550379 560395 563195 563213 563421 563426 564818 580297 586256 590417 603242 610315 619650 621067 621403 632060 647984 650494 663929 663936 684304 685686 688083 688351 688546 688572 689328 694387 712338 714171 717631 720607 721812 724476 725558 725570 726640 728018 728234 740792 742656 743811 745015 745422 745728 746615 746685 747258 748243 752876 758436 761590 772109 774172 775014 775545 779175 779346 782194 782220 785426 788288 788452 788507 788601 788875 788879 788959 789658 790983 793703 801210 802832 804219 807392 807401 807517 807539 807546 807553 808447 808496 808537 808647 813351 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (7.50%) |
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 486896 515073 534851 539497 530537 534260 462110 541374 546937 563195 580297 550377 550379 563421 560395 564818 650494 663929 684304 688572 689328 663936 685686 688546 694387 712338 714171 717631 647984 688083 688351 546938 563213 563426 603242 619650 621403 590417 586256 610315 632060 779175 782220 788507 788875 788879 790983 807392 807401 779346 782194 788959 789658 801210 802832 807539 740792 745422 746615 758436 761590 772109 774172 788601 807546 807553 808447 808496 808537 813351 724476 725558 728234 745728 746685 748243 742656 747258 743811 752876 725570 726640 728018 745015 621067 720607 721812 775014 775545 785426 788288 788452 793703 804219 807517 808647 390892 395933 443701 443719 443728 462117 394258 398955 424422 334847 391579 392602 414788 443818 456731 395891 396966 415594 443677 443705 443709 443997 519997 496346 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.43%) |
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 334847 390892 391579 392602 394258 395891 395933 396966 398955 414788 415594 424422 443677 443701 443705 443709 443719 443728 443818 443997 456731 462110 462117 486896 496346 515073 519997 530537 534260 534851 539497 541374 546937 546938 550377 550379 560395 563195 563213 563421 563426 564818 580297 586256 590417 603242 610315 619650 621067 621403 632060 647984 650494 663929 663936 684304 685686 688083 688351 688546 688572 689328 694387 712338 714171 717631 720607 721812 724476 725558 725570 726640 728018 728234 740792 742656 743811 745015 745422 745728 746615 746685 747258 748243 752876 758436 761590 772109 774172 775014 775545 779175 779346 782194 782220 785426 788288 788452 788507 788601 788875 788879 788959 789658 790983 793703 801210 802832 804219 807392 807401 807517 807539 807546 807553 808447 808496 808537 808647 813351 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom old pussy"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom old pussy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom old pussy"
]
|
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.