Query Metrics
7
Database Queries
7
Different statements
164.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.46 ms (80.49%) |
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 188066 382519 385491 390794 391027 417854 422403 424468 425749 427536 428265 429439 430430 434040 435020 436693 442021 442952 443818 446729 447628 448985 451815 452628 452782 454053 454398 455776 457311 457660 459685 460722 462475 463225 463726 464443 464556 465030 470299 475948 476332 477968 479473 480576 482680 484485 488549 489301 490394 499749 502048 503089 505968 505987 506012 507176 508819 510467 513334 516207 517369 518062 518388 518865 519935 519969 522230 522830 525144 528099 528235 529446 531067 534190 540647 540657 543907 545319 545916 551162 552326 557922 561281 562938 563196 563906 564855 566001 573757 574655 576348 576644 577177 579867 580651 581748 599727 600737 601355 611264 614443 618813 623392 637399 668949 676209 681443 682259 682296 682300 683008 690693 722705 726523 726561 726598 761118 780805 791425 803719 ] |
||||||||||||||||||||||||||||||
|
21.78 ms (13.24%) |
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 417854 434040 457311 505968 576348 618813 611264 545319 505987 681443 429439 690693 722705 780805 457660 564855 382519 424468 455776 506012 551162 528099 447628 463726 682300 522830 499749 573757 576644 761118 460722 459685 430430 442952 525144 531067 623392 803719 726598 462475 448985 464556 581748 574655 422403 518865 516207 599727 540657 436693 510467 534190 545916 543907 446729 577177 637399 188066 425749 475948 482680 502048 507176 580651 508819 682259 683008 454398 443818 518062 566001 452782 600737 470299 503089 428265 454053 517369 557922 682296 791425 465030 477968 563196 442021 668949 601355 480576 390794 435020 518388 513334 464443 540647 561281 726523 726561 552326 563906 579867 385491 614443 484485 451815 529446 676209 562938 519935 490394 528235 488549 519969 479473 427536 452628 489301 463225 476332 522230 391027 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"спящую в рот ебут"
]
|
||||||||||||||||||||||||||||||
|
2.57 ms (1.56%) |
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 188066 382519 385491 390794 391027 417854 422403 424468 425749 427536 428265 429439 430430 434040 435020 436693 442021 442952 443818 446729 447628 448985 451815 452628 452782 454053 454398 455776 457311 457660 459685 460722 462475 463225 463726 464443 464556 465030 470299 475948 476332 477968 479473 480576 482680 484485 488549 489301 490394 499749 502048 503089 505968 505987 506012 507176 508819 510467 513334 516207 517369 518062 518388 518865 519935 519969 522230 522830 525144 528099 528235 529446 531067 534190 540647 540657 543907 545319 545916 551162 552326 557922 561281 562938 563196 563906 564855 566001 573757 574655 576348 576644 577177 579867 580651 581748 599727 600737 601355 611264 614443 618813 623392 637399 668949 676209 681443 682259 682296 682300 683008 690693 722705 726523 726561 726598 761118 780805 791425 803719 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ в рот секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
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.