Query Metrics
7
Database Queries
7
Different statements
180.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.86 ms (85.90%) |
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 70150 147173 383325 396829 407637 417034 419258 419275 422483 424739 425479 426134 428269 428446 428517 435351 437260 442039 442257 443344 444007 444986 445989 446898 448227 449478 449490 451271 452558 457656 463219 464508 465015 465026 466531 468625 469185 470573 471587 471929 472334 474355 477925 478295 479595 480094 484061 484594 485671 486094 486979 487037 488000 488493 488512 489785 496416 497544 497808 500076 508999 509954 511749 512644 513321 513516 514256 516599 521711 522229 526150 528280 529309 531072 536872 539907 548753 551604 553239 553714 560807 563396 567096 568231 570862 570864 573791 576289 585701 597136 605213 618797 619929 626112 654514 655751 656465 657287 658583 663386 666769 673547 687506 701255 738268 761843 767619 768074 774350 777548 778039 781032 783729 789203 792404 795132 800042 806356 808859 813318 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (7.77%) |
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 435351 428517 446898 451271 488493 469185 485671 663386 806356 383325 424739 500076 522229 487037 147173 417034 444986 449490 465026 465015 529309 489785 687506 701255 795132 792404 800042 808859 466531 496416 513516 516599 477925 666769 789203 425479 444007 442039 422483 464508 478295 470573 457656 497808 539907 570862 551604 573791 553239 597136 605213 774350 445989 472334 479595 396829 448227 419258 426134 443344 468625 508999 488000 488512 484061 509954 521711 428446 463219 513321 560807 576289 626112 761843 767619 70150 480094 471929 437260 528280 656465 442257 618797 428269 486094 585701 511749 531072 419275 514256 781032 778039 768074 449478 512644 548753 536872 497544 407637 484594 673547 486979 563396 657287 526150 568231 655751 654514 658583 619929 813318 783729 738268 777548 452558 570864 553714 567096 471587 474355 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.88%) |
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 70150 147173 383325 396829 407637 417034 419258 419275 422483 424739 425479 426134 428269 428446 428517 435351 437260 442039 442257 443344 444007 444986 445989 446898 448227 449478 449490 451271 452558 457656 463219 464508 465015 465026 466531 468625 469185 470573 471587 471929 472334 474355 477925 478295 479595 480094 484061 484594 485671 486094 486979 487037 488000 488493 488512 489785 496416 497544 497808 500076 508999 509954 511749 512644 513321 513516 514256 516599 521711 522229 526150 528280 529309 531072 536872 539907 548753 551604 553239 553714 560807 563396 567096 568231 570862 570864 573791 576289 585701 597136 605213 618797 619929 626112 654514 655751 656465 657287 658583 663386 666769 673547 687506 701255 738268 761843 767619 768074 774350 777548 778039 781032 783729 789203 792404 795132 800042 806356 808859 813318 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð┤ðÁð▓ÐâÐêð║ð░ ð┤ÐÇð¥Ðçð©Ðé ð┐ð░ÐÇð¢ÐÅð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк дрочк парен"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.89%) |
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.