Query Metrics
7
Database Queries
7
Different statements
179.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.34 ms (85.87%) |
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 382285 386062 386271 395669 395693 395703 405708 405939 412442 413707 414783 426346 429457 431948 437256 439034 448245 457499 458612 459965 462806 467813 468085 471990 478492 483814 505881 511246 513690 514756 514794 521763 523761 525855 531093 535465 535962 536674 537810 560611 561851 562326 564351 566657 567390 571126 571218 571229 571265 574089 574870 575096 576114 576119 577130 579210 586664 592544 598069 604346 616795 619375 620711 624184 633722 634169 637010 637123 641682 644972 650192 650200 668527 674945 679798 680164 680204 684465 684902 686406 687249 695316 700451 701682 702624 709589 718647 718688 725141 725390 733246 736440 739978 741279 741537 743068 747815 749456 749919 753279 757549 758189 759326 761572 761578 765706 771015 777081 790541 791844 792059 795600 798670 805438 806192 807525 817272 822271 827971 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (8.67%) |
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 792059 795600 807525 798670 805438 725141 761572 791844 725390 733246 747815 759326 743068 741537 739978 753279 758189 765706 604346 619375 700451 702624 777081 382285 395693 395703 395669 637123 826228 684465 439034 535962 537810 536674 571126 574089 577130 624184 592544 790541 637010 437256 505881 806192 749456 405939 822271 511246 687249 686406 718688 741279 749919 448245 513690 575096 562326 483814 386062 431948 817272 827971 514756 680204 616795 736440 761578 757549 771015 620711 633722 709589 576119 426346 414783 459965 457499 471990 521763 525855 564351 567390 571265 684902 701682 566657 579210 586664 405708 462806 467813 412442 478492 514794 523761 576114 574870 386271 429457 413707 644972 458612 468085 531093 535465 571218 571229 650192 650200 679798 668527 674945 680164 695316 718647 560611 561851 598069 634169 641682 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.80%) |
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 382285 386062 386271 395669 395693 395703 405708 405939 412442 413707 414783 426346 429457 431948 437256 439034 448245 457499 458612 459965 462806 467813 468085 471990 478492 483814 505881 511246 513690 514756 514794 521763 523761 525855 531093 535465 535962 536674 537810 560611 561851 562326 564351 566657 567390 571126 571218 571229 571265 574089 574870 575096 576114 576119 577130 579210 586664 592544 598069 604346 616795 619375 620711 624184 633722 634169 637010 637123 641682 644972 650192 650200 668527 674945 679798 680164 680204 684465 684902 686406 687249 695316 700451 701682 702624 709589 718647 718688 725141 725390 733246 736440 739978 741279 741537 743068 747815 749456 749919 753279 757549 758189 759326 761572 761578 765706 771015 777081 790541 791844 792059 795600 798670 805438 806192 807525 817272 822271 827971 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens first anal"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens first анал"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens first анал"
]
|
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.