Query Metrics
7
Database Queries
7
Different statements
150.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.81 ms (83.55%) |
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 182036 188561 382578 398099 398113 398114 400483 400571 407415 414077 415885 416522 416580 416634 416668 416678 417334 418893 423662 423663 428860 429861 430262 432674 436132 439135 439325 443248 443250 447144 448082 452876 452922 455918 457293 468146 469636 470453 476164 483737 485555 488817 490741 495467 496340 500308 505798 506105 511240 512442 527409 529296 530953 531891 534764 534772 540032 541274 542711 547847 548857 558261 561034 564250 564285 580114 596649 597029 598141 601789 607296 609890 630039 640312 641997 642149 643080 656200 661653 669075 670368 672304 673942 675344 682397 695868 705476 709128 715797 738515 740315 740931 741557 745087 749084 749259 751546 751571 752603 752636 752683 752712 757263 758780 765684 765712 770270 782836 783043 784066 784217 785580 785868 792078 799759 804939 806924 813195 820162 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (10.33%) |
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 607296 782836 752603 752712 749084 751571 765684 715797 398113 547847 580114 601789 540032 709128 469636 542711 643080 785580 792078 758780 785868 443250 428860 452876 418893 470453 495467 455918 400483 448082 417334 485555 505798 423663 416678 423662 476164 558261 439325 490741 430262 534764 488817 414077 439135 675344 672304 398099 407415 820162 529296 512930 531891 564250 564285 673942 656200 682397 705476 548857 640312 642149 597029 784217 799759 806924 740315 804939 741557 738515 740931 745087 783043 784066 182036 400571 188561 496340 443248 500308 447144 596649 436132 457293 527409 512442 530953 534772 541274 561034 695868 669075 670368 598141 641997 752683 749259 751546 770270 752636 765712 382578 416668 452922 661653 757263 630039 432674 415885 483737 511240 609890 429861 468146 506105 813195 398114 416522 416580 416634 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.62%) |
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 182036 188561 382578 398099 398113 398114 400483 400571 407415 414077 415885 416522 416580 416634 416668 416678 417334 418893 423662 423663 428860 429861 430262 432674 436132 439135 439325 443248 443250 447144 448082 452876 452922 455918 457293 468146 469636 470453 476164 483737 485555 488817 490741 495467 496340 500308 505798 506105 511240 512442 527409 529296 530953 531891 534764 534772 540032 541274 542711 547847 548857 558261 561034 564250 564285 580114 596649 597029 598141 601789 607296 609890 630039 640312 641997 642149 643080 656200 661653 669075 670368 672304 673942 675344 682397 695868 705476 709128 715797 738515 740315 740931 741557 745087 749084 749259 751546 751571 752603 752636 752683 752712 757263 758780 765684 765712 770270 782836 783043 784066 784217 785580 785868 792078 799759 804939 806924 813195 820162 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð┤ð©ð╗ð┤ð¥ ð░ð¢ð░ð╗ ð╝ð░ÐüÐéÐâÐÇð▒ð░Ðåð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.01%) |
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.