Query Metrics
7
Database Queries
7
Different statements
170.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.14 ms (84.47%) |
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 389150 390684 391492 395784 396378 410062 425574 436020 436644 438493 438694 438729 448903 453646 453661 454732 457193 458210 459205 462522 462575 462731 463181 463254 466304 474050 474216 477933 482601 485392 490293 490306 496162 498890 498900 499494 501450 504167 505226 510995 514299 515845 515990 520637 521962 521991 525687 525867 529159 532339 533649 535205 535664 544971 547653 551723 552248 556562 557254 566892 567922 568276 569476 572714 583392 588529 589102 589996 593690 594282 594365 594448 594602 598623 605451 605875 608512 613732 620218 636232 641693 647253 650825 662022 674948 694715 718810 719811 721939 729217 732793 733437 734259 735753 737196 737206 738036 738626 741710 743349 743353 750070 750894 754260 761513 762739 763527 768144 769004 775384 776389 779427 781591 782582 786718 787090 804120 806754 826238 827370 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (9.66%) |
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 738626 768144 737206 750894 761513 620218 641693 719811 804120 438694 453661 474216 466304 498900 499494 544971 390684 463181 438493 515990 662022 588529 589102 781591 782582 786718 737196 762739 787090 735753 738036 763527 806754 462575 462731 389150 410062 490293 718810 510995 391492 482601 535205 569476 425574 436020 438729 826238 827370 453646 454732 485392 459205 533649 532339 566892 605875 636232 605451 775384 776389 741710 743349 729217 732793 734259 733437 750070 754260 743353 721939 448903 458210 436644 463254 395784 462522 474050 477933 520637 567922 613732 457193 521991 498890 583392 547653 674948 647253 551723 568276 594365 594602 594448 608512 589996 594282 593690 515845 557254 552248 598623 769004 504167 396378 694715 779427 490306 535664 496162 501450 505226 521962 525867 514299 525687 529159 572714 556562 650825 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.56%) |
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 389150 390684 391492 395784 396378 410062 425574 436020 436644 438493 438694 438729 448903 453646 453661 454732 457193 458210 459205 462522 462575 462731 463181 463254 466304 474050 474216 477933 482601 485392 490293 490306 496162 498890 498900 499494 501450 504167 505226 510995 514299 515845 515990 520637 521962 521991 525687 525867 529159 532339 533649 535205 535664 544971 547653 551723 552248 556562 557254 566892 567922 568276 569476 572714 583392 588529 589102 589996 593690 594282 594365 594448 594602 598623 605451 605875 608512 613732 620218 636232 641693 647253 650825 662022 674948 694715 718810 719811 721939 729217 732793 733437 734259 735753 737196 737206 738036 738626 741710 743349 743353 750070 750894 754260 761513 762739 763527 768144 769004 775384 776389 779427 781591 782582 786718 787090 804120 806754 826238 827370 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"couple homemade"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"couple домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"couple домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.