Query Metrics
7
Database Queries
7
Different statements
151.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.42 ms (81.47%) |
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 389397 391225 392266 392909 393562 393862 395233 396051 396594 397335 398643 398647 401655 406116 406800 410597 410776 410930 412474 413195 413719 413898 419702 420023 425160 429065 429186 430949 439840 440624 443256 444842 446025 446460 449008 450353 451981 454566 455683 456956 461733 470313 475920 479523 479593 482824 488097 491893 491894 499529 500110 501208 501658 506556 515499 517340 519859 523301 524531 525090 535219 536779 543217 546434 546872 548903 552613 558949 560654 567185 571465 571466 571945 572054 573121 573668 574102 575451 577544 578392 578410 581067 584482 585366 585994 586502 590413 590601 594893 595732 595816 597063 598672 653228 654427 654437 655980 659587 665404 666614 668674 675050 680177 684326 693186 734239 736286 765960 777198 780979 803445 804706 809174 810119 814136 816214 817623 821468 821556 824921 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (11.60%) |
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 560654 594893 491894 515499 571465 653228 803445 456956 446460 446025 395233 444842 517340 548903 817623 449008 571945 501208 573668 412474 425160 684326 429065 546434 451981 574102 585366 406800 392909 397335 810119 410776 461733 572054 391225 430949 577544 680177 523301 410930 597063 590413 439840 578392 410597 543217 584482 567185 590601 393862 488097 413898 479523 821468 666614 734239 777198 398647 586502 440624 419702 578410 581067 595816 585994 392266 475920 535219 546872 598672 479593 501658 525090 491893 482824 499529 401655 519859 429186 575451 470313 814136 654437 406116 536779 420023 552613 668674 665404 804706 809174 765960 524531 595732 450353 389397 824921 693186 736286 396051 443256 393562 455683 454566 398643 413195 816214 659587 573121 558949 506556 500110 654427 675050 780979 413719 396594 821556 571466 655980 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (2.01%) |
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 389397 391225 392266 392909 393562 393862 395233 396051 396594 397335 398643 398647 401655 406116 406800 410597 410776 410930 412474 413195 413719 413898 419702 420023 425160 429065 429186 430949 439840 440624 443256 444842 446025 446460 449008 450353 451981 454566 455683 456956 461733 470313 475920 479523 479593 482824 488097 491893 491894 499529 500110 501208 501658 506556 515499 517340 519859 523301 524531 525090 535219 536779 543217 546434 546872 548903 552613 558949 560654 567185 571465 571466 571945 572054 573121 573668 574102 575451 577544 578392 578410 581067 584482 585366 585994 586502 590413 590601 594893 595732 595816 597063 598672 653228 654427 654437 655980 659587 665404 666614 668674 675050 680177 684326 693186 734239 736286 765960 777198 780979 803445 804706 809174 810119 814136 816214 817623 821468 821556 824921 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny girls deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худая девушк глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.