Query Metrics
7
Database Queries
7
Different statements
159.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.99 ms (84.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 154133 188560 386156 386522 387394 397197 407423 412814 414271 415863 416230 416677 416699 418111 418780 424613 428728 432289 438543 438880 443256 444283 444896 452978 454590 455365 458552 459198 467114 467584 467633 467634 467882 471131 475497 475504 476053 479148 480450 481351 483684 486775 493823 504144 509168 509436 509991 515992 516640 518884 523884 525431 527920 529617 530402 530953 532634 535290 537250 537766 540680 545439 548941 551598 554100 560026 564271 564518 567561 572774 574391 576888 580069 582636 583420 584425 586113 590788 594143 598141 598882 600144 600958 608550 612091 620891 622971 625780 654978 657567 659209 668292 669062 670360 684487 697108 738476 739131 739791 744047 749090 751609 761430 778760 780339 782047 791026 792148 793151 795404 795420 796333 796650 796753 800289 803632 803931 808612 810852 824256 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (9.84%) |
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 444896 625780 800289 387394 493823 154133 540680 516640 483684 567561 824256 424613 598882 397197 412814 416230 416699 537766 530953 467633 545439 551598 620891 608550 598141 810852 739131 480450 509168 518884 475497 738476 458552 535290 583420 560026 576888 684487 654978 657567 554100 778760 780339 792148 739791 761430 782047 796753 697108 791026 803632 803931 808612 438880 444283 467634 386156 459198 414271 432289 486775 509991 407423 467882 525431 386522 481351 418111 527920 590788 443256 452978 416677 504144 537250 572774 622971 188560 454590 467584 532634 529617 530402 475504 476053 584425 564271 564518 574391 669062 668292 670360 580069 586113 594143 600144 795404 796650 793151 795420 796333 749090 751609 515992 428728 415863 467114 471131 438543 479148 509436 523884 418780 455365 612091 582636 659209 548941 600958 744047 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.55%) |
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 154133 188560 386156 386522 387394 397197 407423 412814 414271 415863 416230 416677 416699 418111 418780 424613 428728 432289 438543 438880 443256 444283 444896 452978 454590 455365 458552 459198 467114 467584 467633 467634 467882 471131 475497 475504 476053 479148 480450 481351 483684 486775 493823 504144 509168 509436 509991 515992 516640 518884 523884 525431 527920 529617 530402 530953 532634 535290 537250 537766 540680 545439 548941 551598 554100 560026 564271 564518 567561 572774 574391 576888 580069 582636 583420 584425 586113 590788 594143 598141 598882 600144 600958 608550 612091 620891 622971 625780 654978 657567 659209 668292 669062 670360 684487 697108 738476 739131 739791 744047 749090 751609 761430 778760 780339 782047 791026 792148 793151 795404 795420 796333 796650 796753 800289 803632 803931 808612 810852 824256 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls dildo webcam"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк дилд вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.