Query Metrics
7
Database Queries
7
Different statements
148.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.79 ms (84.74%) |
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 155232 263548 396339 400802 411454 414277 423812 425948 429892 433939 434645 435563 435798 437190 439103 439230 439345 440641 446251 448854 448915 449930 450707 452914 454800 457486 467588 469437 469741 473873 475426 490232 509921 513223 513522 518372 522579 523058 534953 535319 536914 547470 554989 569345 584039 584046 584362 585788 586876 589390 589701 592662 595138 595318 598272 598814 602416 606254 607706 608516 617045 623821 626082 638671 638941 651690 654048 667045 670782 672317 678707 691989 705825 705999 706446 706717 707408 708062 709754 714203 719461 736024 738446 739089 746201 757232 757883 758780 767827 772210 772254 774876 776035 777094 779868 782096 782372 783671 785880 785883 786005 788423 788524 791445 796372 796715 796950 798243 798291 801615 801639 803832 807902 808559 808984 810501 811284 811690 811696 812779 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (9.50%) |
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 798243 811690 626082 798291 446251 467588 429892 513522 400802 435563 450707 475426 449930 522579 536914 513223 523058 569345 584046 547470 584362 667045 586876 638671 585788 592662 617045 595318 425948 439230 434645 437190 454800 509921 448854 607706 651690 782372 783671 263548 396339 433939 439103 411454 452914 457486 469741 490232 469437 518372 534953 535319 670782 708062 709754 654048 678707 691989 706446 706717 672317 714203 719461 554989 584039 606254 589701 623821 589390 595138 598814 598272 608516 774876 782096 785883 796372 796715 801639 803832 810501 811284 811696 779868 785880 788524 796950 808559 808984 758780 772210 772254 788423 791445 807902 812779 757883 767827 738446 746201 736024 739089 757232 602416 638941 705825 705999 707408 776035 777094 786005 801615 155232 414277 439345 440641 448915 423812 435798 473873 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.54%) |
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 155232 263548 396339 400802 411454 414277 423812 425948 429892 433939 434645 435563 435798 437190 439103 439230 439345 440641 446251 448854 448915 449930 450707 452914 454800 457486 467588 469437 469741 473873 475426 490232 509921 513223 513522 518372 522579 523058 534953 535319 536914 547470 554989 569345 584039 584046 584362 585788 586876 589390 589701 592662 595138 595318 598272 598814 602416 606254 607706 608516 617045 623821 626082 638671 638941 651690 654048 667045 670782 672317 678707 691989 705825 705999 706446 706717 707408 708062 709754 714203 719461 736024 738446 739089 746201 757232 757883 758780 767827 772210 772254 774876 776035 777094 779868 782096 782372 783671 785880 785883 786005 788423 788524 791445 796372 796715 796950 798243 798291 801615 801639 803832 807902 808559 808984 810501 811284 811690 811696 812779 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo pussy solo"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд pussy соло"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд pussy соло"
]
|
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.