Query Metrics
7
Database Queries
7
Different statements
194.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.99 ms (87.98%) |
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 13011 70852 78620 78942 161436 338098 389978 395450 398828 399156 401813 412858 444064 467028 487795 505101 506791 529571 529903 533498 534696 534860 536578 536877 536977 537609 537941 538749 541668 541832 546284 548116 550309 558777 562588 578778 579650 579696 581275 581960 584754 593132 596484 597723 597855 604705 605704 606240 606878 606900 606968 609361 616080 622679 629510 630465 633609 633917 642572 645525 647697 650265 652691 653747 658124 664151 665334 685280 691337 691739 696983 697603 697969 715068 716657 716896 717080 717219 719996 720010 720013 720015 720025 723993 724517 730517 731300 732623 732758 732792 737305 737378 737644 737670 737674 737686 738414 739772 740779 742551 750275 750873 751466 751829 756780 775348 784394 788992 790768 795901 796426 801062 803509 803926 810426 811703 826501 827830 827850 ] |
||||||||||||||||||||||||||||||
|
13.09 ms (6.73%) |
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 533498 529903 538749 529571 536578 548116 581275 541668 716657 720015 691337 715068 717219 801062 796426 803926 731300 739772 737686 730517 738414 724517 732758 811703 399156 70852 389978 506791 534860 790768 78942 412858 536977 505101 691739 642572 633609 541832 401813 531288 537609 581960 630465 609361 697969 398828 578778 562588 597855 750873 338098 803509 606968 78620 720025 716896 732792 737378 732623 795901 395450 826501 467028 487795 537941 546284 550309 579696 653747 717080 647697 719996 720013 775348 784394 810426 788992 737644 740779 723993 751829 737305 737674 742551 751466 756780 750275 622679 720010 444064 685280 658124 584754 697603 633917 605704 606900 827850 827830 536877 534696 579650 652691 696983 664151 645525 650265 665334 606878 629510 593132 596484 597723 604705 606240 737670 616080 13011 161436 558777 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.45%) |
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 13011 70852 78620 78942 161436 338098 389978 395450 398828 399156 401813 412858 444064 467028 487795 505101 506791 529571 529903 533498 534696 534860 536578 536877 536977 537609 537941 538749 541668 541832 546284 548116 550309 558777 562588 578778 579650 579696 581275 581960 584754 593132 596484 597723 597855 604705 605704 606240 606878 606900 606968 609361 616080 622679 629510 630465 633609 633917 642572 645525 647697 650265 652691 653747 658124 664151 665334 685280 691337 691739 696983 697603 697969 715068 716657 716896 717080 717219 719996 720010 720013 720015 720025 723993 724517 730517 731300 732623 732758 732792 737305 737378 737644 737670 737674 737686 738414 739772 740779 742551 750275 750873 751466 751829 756780 775348 784394 788992 790768 795901 796426 801062 803509 803926 810426 811703 826501 827830 827850 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc amateur wife"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc любительск жен"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc любительск жен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.81%) |
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.