Query Metrics
7
Database Queries
7
Different statements
158.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.58 ms (85.05%) |
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 6999 24944 25080 327121 358603 379559 381789 382588 391662 396154 397478 401076 403181 415977 416111 425541 432708 441092 447553 452873 454537 467120 467992 468430 473190 473261 478482 491583 493735 493778 500593 514946 516730 523289 531303 531370 533594 534578 541328 550560 554752 555220 562587 563401 563618 566684 569072 595367 604615 604815 609244 609909 610657 618344 621682 629458 629604 641097 642158 643225 650139 665051 671429 690510 691381 695725 697806 702631 704255 704261 716088 717366 718669 720410 722642 736271 739480 740284 741427 742318 742348 743903 747958 749237 752759 754887 756431 758188 758993 759756 760713 761624 762379 764821 766945 767078 767416 772901 775720 788544 793182 794781 795136 795686 799352 799947 800587 802459 804524 806321 807948 810331 812936 813198 815536 816671 817889 818283 822216 827676 ] |
||||||||||||||||||||||||||||||
|
13.04 ms (8.24%) |
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 441092 382588 500593 665051 717366 550560 795686 742348 741427 704261 793182 810331 416111 691381 720410 555220 610657 759756 749237 629458 24944 794781 491583 468430 742318 454537 762379 756431 799947 473261 6999 815536 822216 563618 743903 758993 739480 747958 767416 760713 761624 800587 531303 569072 358603 758188 722642 566684 641097 788544 807948 379559 425541 467992 478482 604815 403181 695725 799352 795136 754887 401076 621682 827676 467120 531370 642158 766945 767078 817889 563401 802459 764821 415977 493735 452873 533594 534578 514946 541328 650139 554752 595367 736271 752759 697806 804524 447553 493778 381789 391662 25080 396154 816671 562587 604615 775720 812936 813198 740284 432708 516730 609244 818283 629604 806321 397478 690510 618344 716088 609909 772901 702631 327121 473190 671429 643225 704255 523289 718669 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.99%) |
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 6999 24944 25080 327121 358603 379559 381789 382588 391662 396154 397478 401076 403181 415977 416111 425541 432708 441092 447553 452873 454537 467120 467992 468430 473190 473261 478482 491583 493735 493778 500593 514946 516730 523289 531303 531370 533594 534578 541328 550560 554752 555220 562587 563401 563618 566684 569072 595367 604615 604815 609244 609909 610657 618344 621682 629458 629604 641097 642158 643225 650139 665051 671429 690510 691381 695725 697806 702631 704255 704261 716088 717366 718669 720410 722642 736271 739480 740284 741427 742318 742348 743903 747958 749237 752759 754887 756431 758188 758993 759756 760713 761624 762379 764821 766945 767078 767416 772901 775720 788544 793182 794781 795136 795686 799352 799947 800587 802459 804524 806321 807948 810331 812936 813198 815536 816671 817889 818283 822216 827676 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal shower fuck"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал shower секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал shower секс"
]
|
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.