Query Metrics
7
Database Queries
7
Different statements
188.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.24 ms (84.45%) |
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 390794 397961 400195 403003 413110 415567 415598 417258 418024 428892 433808 433860 438208 438429 438629 443300 446587 447574 447979 448578 450399 450855 453436 456061 457654 457932 459225 459783 460191 464200 464805 466865 467662 467663 472295 473375 479021 479298 481599 482249 482251 483496 485187 489110 492115 492366 496537 507889 512886 517712 518046 518050 518081 519831 521997 523476 524144 525273 527687 528817 532028 536901 536913 540073 546425 548489 553672 557518 559679 561441 562987 565094 568098 571392 572943 577899 581092 581716 584765 586178 587915 590735 591442 591940 600395 605809 606621 606827 607697 609432 609759 609827 610235 611977 613855 613864 619582 620302 630630 640941 687503 700540 716954 717966 719912 724646 726410 726882 736627 737098 737922 756803 772466 782626 790022 805504 806058 809271 ] |
||||||||||||||||||||||||||||||
|
18.57 ms (9.85%) |
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 581716 687503 620302 737098 736627 700540 415598 447979 467662 546425 806058 726882 611977 413110 403003 433808 536901 519831 518081 517712 562987 559679 571392 587915 619582 590735 609432 772466 717966 459225 457654 527687 485187 489110 523476 464805 482249 518050 464200 473375 581092 716954 548489 586178 640941 724646 719912 438629 459783 479298 418024 443300 447574 457932 448578 483496 472295 525273 540073 467663 481599 492366 553672 584765 557518 565094 568098 606827 605809 607697 613855 591442 805504 756803 737922 433860 460191 390794 438208 450399 492115 518046 496537 524144 528817 532028 400195 613864 438429 456061 527201 536913 466865 572943 577899 561441 676582 591940 609759 630630 600395 609827 610235 782626 726410 482251 453436 450855 521997 512886 809271 428892 397961 417258 446587 479021 606621 790022 507889 415567 ] |
||||||||||||||||||||||||||||||
|
3.06 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 390794 397961 400195 403003 413110 415567 415598 417258 418024 428892 433808 433860 438208 438429 438629 443300 446587 447574 447979 448578 450399 450855 453436 456061 457654 457932 459225 459783 460191 464200 464805 466865 467662 467663 472295 473375 479021 479298 481599 482249 482251 483496 485187 489110 492115 492366 496537 507889 512886 517712 518046 518050 518081 519831 521997 523476 524144 525273 527687 528817 532028 536901 536913 540073 546425 548489 553672 557518 559679 561441 562987 565094 568098 571392 572943 577899 581092 581716 584765 586178 587915 590735 591442 591940 600395 605809 606621 606827 607697 609432 609759 609827 610235 611977 613855 613864 619582 620302 630630 640941 687503 700540 716954 717966 719912 724646 726410 726882 736627 737098 737922 756803 772466 782626 790022 805504 806058 809271 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step fuck"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step секс"
]
|
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.