Query Metrics
7
Database Queries
7
Different statements
168.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.27 ms (85.50%) |
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 7502 8518 43250 97107 341608 373798 386062 393677 395696 397232 398666 399418 403255 408711 421637 467606 471476 473764 506321 509802 532756 545453 549785 550264 550563 551057 609875 610577 620785 621029 629243 632423 633895 637016 640523 642700 644274 644275 649133 652966 653888 654078 665927 666546 670997 672130 672388 673371 674733 681804 683564 683584 685819 686501 688660 690749 693049 694447 695096 695930 696250 697361 697785 697839 697973 697987 698597 699632 699667 699755 700282 703037 703055 703095 705520 705829 709259 715176 715818 717636 717805 719057 720202 721318 722607 722655 723468 728327 733870 737516 738812 739012 741213 742363 750154 752785 759485 766611 767283 769418 772729 775798 775922 775931 782836 784324 784732 787628 791772 793899 795137 802471 802477 802732 803399 809050 810914 814423 817423 827829 ] |
||||||||||||||||||||||||||||||
|
14.19 ms (8.41%) |
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 621029 633895 775798 782836 795137 802732 803399 809050 775922 787628 793899 802471 750154 767283 769418 772729 784324 802477 810914 728327 737516 742363 752785 741213 759485 738812 739012 766611 609875 620785 629243 632423 640523 644274 644275 697987 703037 703095 705829 715176 717805 775931 784732 791772 8518 408711 373798 403255 471476 473764 642700 395696 509802 532756 666546 610577 637016 733870 386062 393677 341608 97107 43250 7502 397232 398666 399418 421637 814423 817423 827829 467606 506321 545453 549785 551057 550563 652966 653888 654078 670997 686501 688660 695930 696250 697785 697839 697973 700282 721318 672130 672388 683564 695096 697361 698597 705520 709259 715818 717636 722607 722655 723468 649133 665927 673371 674733 681804 683584 685819 690749 693049 694447 699632 699667 699755 703055 719057 720202 550264 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.65%) |
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 7502 8518 43250 97107 341608 373798 386062 393677 395696 397232 398666 399418 403255 408711 421637 467606 471476 473764 506321 509802 532756 545453 549785 550264 550563 551057 609875 610577 620785 621029 629243 632423 633895 637016 640523 642700 644274 644275 649133 652966 653888 654078 665927 666546 670997 672130 672388 673371 674733 681804 683564 683584 685819 686501 688660 690749 693049 694447 695096 695930 696250 697361 697785 697839 697973 697987 698597 699632 699667 699755 700282 703037 703055 703095 705520 705829 709259 715176 715818 717636 717805 719057 720202 721318 722607 722655 723468 728327 733870 737516 738812 739012 741213 742363 750154 752785 759485 766611 767283 769418 772729 775798 775922 775931 782836 784324 784732 787628 791772 793899 795137 802471 802477 802732 803399 809050 810914 814423 817423 827829 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double penetration teens"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double penetration teens"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double penetration teens"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.97%) |
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.