Query Metrics
7
Database Queries
7
Different statements
167.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.65 ms (85.37%) |
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 119927 172420 193462 358466 378046 382434 384279 391588 393856 397214 397889 398484 400818 400845 400855 401146 401843 401916 403021 403321 406688 409939 411356 411975 416117 419529 419539 421860 421867 421902 424436 425490 439621 439673 439763 439776 439785 440222 440771 443765 444870 444890 444913 448882 451221 452318 455117 459837 466877 467103 467914 468121 470191 470201 472691 476352 478384 479102 482192 483629 483643 485690 486578 493175 496063 512947 514436 515693 516477 521133 521160 528474 531892 533659 536431 561386 566787 566875 580585 585975 596228 599710 622693 624472 663772 670902 696513 713193 717911 718538 725185 726995 735031 735936 741764 750169 759766 767257 768730 770102 770127 770129 770135 770256 794854 794859 794886 796679 797521 798773 800567 802157 803537 807994 810769 811013 814129 823857 824259 824584 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (8.69%) |
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 596228 467914 824259 531892 800567 470201 421867 440222 483629 515693 566875 624472 803537 794859 391588 440771 358466 439776 483643 521133 485690 536431 401843 802157 400855 797521 796679 798773 403321 486578 382434 466877 533659 750169 717911 811013 741764 172420 393856 401146 794886 378046 419539 452318 421860 425490 400818 512947 444913 421902 451221 439763 528474 400845 439621 409939 824584 467103 468121 521160 663772 599710 397214 444870 444890 566787 406688 770135 794854 193462 670902 585975 767257 768730 718538 439673 561386 479102 470191 119927 398484 493175 411975 416117 482192 696513 403021 496063 622693 476352 419529 384279 759766 713193 580585 726995 735031 770102 735936 770129 770256 807994 810769 443765 448882 401916 424436 455117 516477 814129 823857 459837 439785 514436 770127 472691 478384 725185 397889 411356 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.70%) |
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 119927 172420 193462 358466 378046 382434 384279 391588 393856 397214 397889 398484 400818 400845 400855 401146 401843 401916 403021 403321 406688 409939 411356 411975 416117 419529 419539 421860 421867 421902 424436 425490 439621 439673 439763 439776 439785 440222 440771 443765 444870 444890 444913 448882 451221 452318 455117 459837 466877 467103 467914 468121 470191 470201 472691 476352 478384 479102 482192 483629 483643 485690 486578 493175 496063 512947 514436 515693 516477 521133 521160 528474 531892 533659 536431 561386 566787 566875 580585 585975 596228 599710 622693 624472 663772 670902 696513 713193 717911 718538 725185 726995 735031 735936 741764 750169 759766 767257 768730 770102 770127 770129 770135 770256 794854 794859 794886 796679 797521 798773 800567 802157 803537 807994 810769 811013 814129 823857 824259 824584 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал с зрелой пышкой"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал зрелая женщин полная"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.