Query Metrics
7
Database Queries
7
Different statements
152.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.85 ms (81.94%) |
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 387160 388856 404478 404698 404740 407532 408928 409630 411899 415177 415591 415615 418955 420219 424933 425164 425330 430002 431716 433058 433501 433592 440644 441985 444978 446011 446022 446135 447959 448427 449020 449022 450184 450241 450371 452052 453378 454714 454909 456938 457279 457434 460191 464018 465079 465500 465630 465912 466462 467627 468538 469389 469519 472484 472543 478039 479860 480397 480510 481971 483725 494771 499921 502809 503792 509476 509720 510049 513852 514935 517535 517933 523394 526824 532817 533937 536282 536728 537261 549723 562398 565275 570936 585663 591115 592922 599004 601113 601115 601670 602229 604909 623263 625452 669213 676890 702268 720357 737554 745979 749522 764414 770007 773420 776638 782003 783452 791148 797580 801121 802302 803784 804585 807906 808265 809076 812547 812732 814754 818456 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (11.14%) |
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 807906 812547 737554 749522 745979 764414 773420 770007 602229 702268 720357 782003 791148 802302 804585 812732 387160 431716 409630 456938 466462 483725 447959 446135 676890 585663 599004 801121 440644 415591 433592 441985 433058 433501 814754 818456 478039 454714 472543 452052 454909 533937 514935 526824 472484 549723 562398 601113 388856 446022 469389 480510 446011 457279 465912 479860 411899 415177 418955 425330 444978 465079 408928 465500 468538 480397 430002 453378 494771 509720 536728 502809 404740 415615 425164 481971 537261 404698 457434 404478 407532 420219 424933 448427 450184 450241 450371 465630 469519 449020 449022 503792 510049 532817 536282 499921 517933 513852 509476 517535 523394 467627 669213 565275 570936 592922 601670 604909 623263 601115 591115 803784 809076 783452 797580 808265 625452 776638 460191 464018 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.82%) |
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 387160 388856 404478 404698 404740 407532 408928 409630 411899 415177 415591 415615 418955 420219 424933 425164 425330 430002 431716 433058 433501 433592 440644 441985 444978 446011 446022 446135 447959 448427 449020 449022 450184 450241 450371 452052 453378 454714 454909 456938 457279 457434 460191 464018 465079 465500 465630 465912 466462 467627 468538 469389 469519 472484 472543 478039 479860 480397 480510 481971 483725 494771 499921 502809 503792 509476 509720 510049 513852 514935 517535 517933 523394 526824 532817 533937 536282 536728 537261 549723 562398 565275 570936 585663 591115 592922 599004 601113 601115 601670 602229 604909 623263 625452 669213 676890 702268 720357 737554 745979 749522 764414 770007 773420 776638 782003 783452 791148 797580 801121 802302 803784 804585 807906 808265 809076 812547 812732 814754 818456 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf boobs oil"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf boobs масл"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf boobs масл"
]
|
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.