Query Metrics
7
Database Queries
7
Different statements
185.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.76 ms (85.39%) |
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 7322 326081 382285 386062 387174 395669 395693 395703 396684 396726 402541 415520 420877 425679 426179 431948 439034 445730 448245 458156 461443 475472 494072 502230 511246 514756 527386 529034 529854 530750 532799 532945 533012 535280 536636 537810 545475 571126 574089 577130 582805 583210 584222 604346 605323 606595 610504 613017 614967 615287 616795 619375 620711 623165 628089 632674 633722 635306 637106 640739 655924 657547 659396 659404 661555 665051 668083 680151 680198 684465 685588 686406 687249 687431 696081 696156 700451 702624 702628 705829 716118 717954 718683 718688 720819 722590 725141 725390 733246 736440 739978 741279 741537 743068 747815 749919 757549 758189 759326 761572 761578 765706 771015 775931 777081 778666 780713 790541 791844 792059 795600 798670 805438 806192 817244 817272 820594 820977 822271 827971 ] |
||||||||||||||||||||||||||||||
|
18.16 ms (9.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 705829 717954 775931 7322 806192 640739 820977 817244 445730 387174 458156 326081 461443 396726 396684 402541 425679 420877 820594 475472 527386 502230 535280 530750 583210 582805 584222 655924 661555 668083 696081 716118 718683 659404 665051 685588 657547 659396 687431 696156 702628 720819 722590 545475 615287 635306 613017 623165 610504 614967 632674 606595 637106 778666 780713 792059 795600 798670 805438 725141 761572 791844 725390 733246 747815 759326 743068 741537 739978 758189 765706 604346 619375 700451 702624 777081 382285 395693 395703 395669 426179 494072 532799 532945 533012 536636 605323 628089 415520 680151 680198 529034 684465 439034 529854 386062 431948 817272 827971 514756 616795 736440 761578 757549 771015 620711 633722 822271 511246 687249 686406 718688 741279 749919 448245 537810 571126 574089 577130 790541 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.32%) |
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 7322 326081 382285 386062 387174 395669 395693 395703 396684 396726 402541 415520 420877 425679 426179 431948 439034 445730 448245 458156 461443 475472 494072 502230 511246 514756 527386 529034 529854 530750 532799 532945 533012 535280 536636 537810 545475 571126 574089 577130 582805 583210 584222 604346 605323 606595 610504 613017 614967 615287 616795 619375 620711 623165 628089 632674 633722 635306 637106 640739 655924 657547 659396 659404 661555 665051 668083 680151 680198 684465 685588 686406 687249 687431 696081 696156 700451 702624 702628 705829 716118 717954 718683 718688 720819 722590 725141 725390 733246 736440 739978 741279 741537 743068 747815 749919 757549 758189 759326 761572 761578 765706 771015 775931 777081 778666 780713 790541 791844 792059 795600 798670 805438 806192 817244 817272 820594 820977 822271 827971 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen first anal"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen first анал"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen first анал"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.