Query Metrics
7
Database Queries
7
Different statements
636.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.64 ms (33.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац cam"
]
|
||||||||||||||||||||||||||||||
|
205.65 ms (32.31%) |
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 266977 382326 384917 388363 388545 389202 389495 391473 401184 401215 401684 414277 415863 416620 420434 420534 423913 428932 429108 438770 443502 443519 444005 444647 446008 448579 448582 451598 452903 452920 452948 453223 453820 454368 454744 456870 457992 466306 468003 469086 469139 471121 477222 477507 480203 480541 483494 484259 485905 488789 490146 492834 494488 494806 495487 495489 495490 496812 502789 509884 510906 512810 514921 517795 519646 519764 527782 527829 528669 535916 536375 536659 541478 544887 545491 546841 546972 547881 548465 556788 568214 568262 578640 582743 598469 598809 599829 600125 600144 602993 603491 603542 614805 615730 619085 635207 650280 654048 669274 692421 700257 709006 713122 714609 734857 742348 744774 751354 751422 755952 756745 757219 758648 772605 781807 785665 793115 797324 803047 803635 ] |
||||||||||||||||||||||||||||||
|
198.88 ms (31.24%) |
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 266977 382326 384917 388363 388545 389202 389495 391473 401184 401215 401684 414277 415863 416620 420434 420534 423913 428932 429108 438770 443502 443519 444005 444647 446008 448579 448582 451598 452903 452920 452948 453223 453820 454368 454744 456870 457992 466306 468003 469086 469139 471121 477222 477507 480203 480541 483494 484259 485905 488789 490146 492834 494488 494806 495487 495489 495490 496812 502789 509884 510906 512810 514921 517795 519646 519764 527782 527829 528669 535916 536375 536659 541478 544887 545491 546841 546972 547881 548465 556788 568214 568262 578640 582743 598469 598809 599829 600125 600144 602993 603491 603542 614805 615730 619085 635207 650280 654048 669274 692421 700257 709006 713122 714609 734857 742348 744774 751354 751422 755952 756745 757219 758648 772605 781807 785665 793115 797324 803047 803635 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (2.23%) |
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 793115 772605 785665 391473 468003 443502 510906 495489 546841 751354 527829 484259 490146 514921 578640 544887 603542 599829 781807 756745 734857 751422 797324 582743 384917 388545 401684 446008 452920 471121 488789 457992 494806 541478 598809 600125 598469 619085 758648 744774 448579 401184 416620 466306 389202 496812 382326 477222 494488 495487 528669 519764 527782 469086 568262 545491 709006 669274 713122 714609 635207 755952 803635 757219 428932 469139 454368 519646 420534 451598 266977 388363 401215 453223 452903 452948 453820 480541 477507 502789 536375 495490 535916 547881 556788 546972 568214 654048 700257 650280 692421 548465 615730 600144 602993 614805 803047 742348 603491 414277 423913 438770 443519 389495 444647 456870 444005 454744 480203 429108 448582 536659 483494 492834 512810 485905 509884 517795 415863 420434 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation cam"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац cam"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.24%) |
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.