Query Metrics
8
Database Queries
8
Different statements
202.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.43 ms (87.49%) |
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 6739 387874 400493 402876 443913 447829 448954 452594 453710 454313 458014 471395 471678 473783 483628 483637 484721 484901 489381 489648 490419 493220 493581 497517 497700 499825 499826 502843 511828 514007 516712 517012 519573 523839 525878 527750 529999 531070 531464 537760 548443 549799 550900 550904 555912 563870 564103 564252 592462 595309 603890 615571 617807 619070 622056 660467 662898 667986 690144 710814 716787 718041 727049 727343 728718 730104 732579 733148 736741 736780 740241 740819 758502 759982 760859 760983 761461 761492 761510 761514 761598 761698 762994 764242 767058 782410 785847 788545 790846 791590 791783 793142 794781 796904 797728 800569 800683 801090 801260 801303 803463 805735 810337 810470 811480 811510 814813 815311 815849 815978 817237 817456 817963 819431 823176 824028 824936 824938 825255 ] |
||||||||||||||||||||||||||||||
|
14.36 ms (7.08%) |
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 736780 728718 767058 791783 810470 6739 493581 473783 548443 550904 550900 690144 619070 791590 796904 793142 797728 800569 811510 727049 764242 617807 718041 790846 387874 549799 453710 531464 452594 402876 667986 447829 490419 499825 489648 716787 555912 595309 622056 788545 760859 603890 471395 511828 516712 483637 519573 525878 502843 489381 801303 761510 760983 736741 758502 761698 499826 564252 523839 448954 517012 527750 531070 458014 484901 493220 529999 592462 730104 761598 803463 810337 761514 733148 443913 454313 400493 497517 497700 514007 824938 824028 537760 563870 660467 615571 785847 800683 805735 727343 762994 782410 794781 801090 801260 764183 740819 761492 732579 740241 759982 761461 710814 811480 471678 483628 484721 815311 817456 817963 824936 817237 825255 814813 823176 815849 815978 819431 564103 662898 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.23%) |
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 6739 387874 400493 402876 443913 447829 448954 452594 453710 454313 458014 471395 471678 473783 483628 483637 484721 484901 489381 489648 490419 493220 493581 497517 497700 499825 499826 502843 511828 514007 516712 517012 519573 523839 525878 527750 529999 531070 531464 537760 548443 549799 550900 550904 555912 563870 564103 564252 592462 595309 603890 615571 617807 619070 622056 660467 662898 667986 690144 710814 716787 718041 727049 727343 728718 730104 732579 733148 736741 736780 740241 740819 758502 759982 760859 760983 761461 761492 761510 761514 761598 761698 762994 764242 767058 782410 785847 788545 790846 791590 791783 793142 794781 796904 797728 800569 800683 801090 801260 801303 803463 805735 810337 810470 811480 811510 814813 815311 815849 815978 817237 817456 817963 819431 823176 824028 824936 824938 825255 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal fucked"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал fucked"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01–\x1AGEÂq_’C2ß©ëæ“"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал fucked"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.71%) |
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.