Query Metrics
7
Database Queries
7
Different statements
174.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.15 ms (83.60%) |
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 150470 263759 321277 382207 386896 391327 414269 419167 420140 420383 420394 421133 427364 427722 432673 432680 438880 439427 443233 446778 448351 449586 449930 454800 457650 465680 467563 467568 467579 467585 467616 467633 467986 471127 473873 475426 476847 482190 499856 503861 511953 514886 515364 515559 516640 518185 518550 518884 521435 521682 525431 525468 526179 526943 527508 528104 531804 532856 534257 540531 554551 566784 571975 580504 592593 592681 595683 596288 598310 601071 619322 623300 626044 631203 639791 640859 641972 660757 667276 678707 679270 728567 738446 738471 738496 739145 740492 742323 742359 743455 749248 753124 756752 757427 760862 766415 772617 782281 784398 790154 796509 796640 796696 796715 796801 797003 800031 807590 808168 808235 808265 808998 811125 812779 813801 814024 816235 816547 817875 826278 ] |
||||||||||||||||||||||||||||||
|
18.95 ms (10.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 580504 595683 808235 473873 420394 641972 796696 465680 826278 321277 263759 420383 813801 814024 816235 467579 532856 526943 540531 534257 678707 596288 639791 592593 598310 601071 796715 790154 796509 797003 753124 772617 784398 812779 728567 738446 743455 760862 742359 640859 782281 528104 554551 811125 467585 518550 391327 516640 471127 626044 438880 432680 525468 467616 467633 808998 382207 526179 619322 150470 432673 448351 796640 518884 482190 475426 446778 427364 679270 419167 457650 592681 807590 808265 766415 739145 738496 443233 521435 420140 660757 623300 454800 439427 467568 531804 386896 421133 467563 476847 449930 511953 527508 514886 521682 427722 816547 571975 518185 631203 525431 414269 817875 449586 467986 515364 499856 503861 515559 667276 566784 796801 800031 808168 738471 740492 742323 756752 757427 749248 ] |
||||||||||||||||||||||||||||||
|
2.83 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 150470 263759 321277 382207 386896 391327 414269 419167 420140 420383 420394 421133 427364 427722 432673 432680 438880 439427 443233 446778 448351 449586 449930 454800 457650 465680 467563 467568 467579 467585 467616 467633 467986 471127 473873 475426 476847 482190 499856 503861 511953 514886 515364 515559 516640 518185 518550 518884 521435 521682 525431 525468 526179 526943 527508 528104 531804 532856 534257 540531 554551 566784 571975 580504 592593 592681 595683 596288 598310 601071 619322 623300 626044 631203 639791 640859 641972 660757 667276 678707 679270 728567 738446 738471 738496 739145 740492 742323 742359 743455 749248 753124 756752 757427 760862 766415 772617 782281 784398 790154 796509 796640 796696 796715 796801 797003 800031 807590 808168 808235 808265 808998 811125 812779 813801 814024 816235 816547 817875 826278 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные дилд жоп"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд жоп"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo ass"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.90%) |
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.