Query Metrics
7
Database Queries
7
Different statements
154.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.85 ms (83.46%) |
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 14602 117388 392540 395919 396725 397192 402244 403229 412442 412508 417735 418494 421993 424136 424932 432580 432777 435412 437720 442631 444372 446259 447750 448349 454343 456048 457223 459648 461680 464874 467834 468398 468603 472337 473745 474968 482075 485175 497690 497732 500620 510402 519312 519925 524320 528315 531209 533062 536682 537754 540422 541706 556911 559021 560636 565251 567763 576560 583541 594213 604669 606595 609889 610728 614142 623003 623200 628111 628422 630020 632082 633764 633887 634497 634505 634527 634563 637010 638191 647836 650160 653487 660310 662537 665742 666850 666871 672248 674936 679194 682507 685203 692038 694953 696225 698407 698728 702048 706058 720076 721118 747439 749694 751307 756210 758498 761013 766835 769837 776310 783657 788580 788852 799975 803394 805212 806514 810710 813899 817608 ] |
||||||||||||||||||||||||||||||
|
15.33 ms (9.93%) |
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 813899 457223 468398 497732 537754 559021 662537 692038 702048 665742 672248 685203 694953 682507 720076 576560 606595 628111 632082 776310 788580 803394 747439 761013 766835 756210 751307 758498 633764 783657 799975 117388 403229 435412 519925 392540 510402 531209 556911 623200 628422 473745 485175 666871 432777 461680 647836 810710 397192 749694 609889 630020 805212 14602 444372 817608 446259 456048 448349 459648 500620 528315 560636 721118 674936 698407 706058 614142 623003 806514 638191 698728 424136 396725 402244 437720 482075 464874 540422 536682 533062 696225 634497 633887 634505 634527 634563 637010 417735 497690 653487 565251 594213 418494 447750 524320 468603 395919 442631 424932 412508 519312 583541 660310 604669 610728 788852 769837 467834 432580 412442 421993 454343 472337 474968 541706 666850 567763 650160 679194 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.73%) |
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 14602 117388 392540 395919 396725 397192 402244 403229 412442 412508 417735 418494 421993 424136 424932 432580 432777 435412 437720 442631 444372 446259 447750 448349 454343 456048 457223 459648 461680 464874 467834 468398 468603 472337 473745 474968 482075 485175 497690 497732 500620 510402 519312 519925 524320 528315 531209 533062 536682 537754 540422 541706 556911 559021 560636 565251 567763 576560 583541 594213 604669 606595 609889 610728 614142 623003 623200 628111 628422 630020 632082 633764 633887 634497 634505 634527 634563 637010 638191 647836 650160 653487 660310 662537 665742 666850 666871 672248 674936 679194 682507 685203 692038 694953 696225 698407 698728 702048 706058 720076 721118 747439 749694 751307 756210 758498 761013 766835 769837 776310 783657 788580 788852 799975 803394 805212 806514 810710 813899 817608 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"deep teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"deep teen анал"
]
|
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.