Query Metrics
7
Database Queries
7
Different statements
176.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.47 ms (83.20%) |
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 383063 390566 394420 395591 396772 396925 397883 400550 403356 403378 404495 407754 407761 418953 422345 425462 428463 434168 453471 456618 456731 460915 464388 467083 471629 482239 482339 489082 492048 496346 499814 501338 515931 516102 517369 518349 522207 534733 537600 544295 546017 547930 550630 556320 558021 560113 563196 563875 564813 581260 589139 603242 605841 606223 626024 632060 642832 647595 647617 649836 663380 665226 671381 674740 683870 683906 685669 685836 686047 687269 687270 687271 687503 687542 687588 687604 687980 688024 688351 698289 699333 699611 701206 702077 702835 704560 706269 706290 713270 713630 714938 720607 725382 726640 728018 732029 732079 745785 748552 756083 758432 760837 776892 789733 797756 800937 801866 805331 807716 810760 811051 813573 815594 815982 816541 818929 820588 820902 822693 823298 ] |
||||||||||||||||||||||||||||||
|
19.26 ms (10.94%) |
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 688351 603242 606223 632060 776892 789733 800937 725382 726640 728018 748552 720607 404495 428463 394420 396925 456731 395591 496346 556320 663380 560113 499814 516102 522207 501338 383063 396772 407761 815982 816541 820902 482239 537600 534733 467083 482339 564813 685669 687270 687503 702077 647617 665226 687269 687604 702835 683906 687271 687588 699333 713270 713630 550630 589139 605841 642832 805331 807716 758432 801866 811051 732029 756083 760837 745785 732079 797756 810760 397883 400550 403356 422345 390566 425462 460915 492048 418953 518349 563875 517369 456618 471629 489082 626024 403378 407754 434168 820588 822693 813573 815594 823298 818929 453471 464388 515931 546017 558021 581260 563196 544295 547930 649836 685836 704560 706269 706290 671381 674740 686047 687542 698289 699611 647595 683870 687980 688024 701206 714938 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.81%) |
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 383063 390566 394420 395591 396772 396925 397883 400550 403356 403378 404495 407754 407761 418953 422345 425462 428463 434168 453471 456618 456731 460915 464388 467083 471629 482239 482339 489082 492048 496346 499814 501338 515931 516102 517369 518349 522207 534733 537600 544295 546017 547930 550630 556320 558021 560113 563196 563875 564813 581260 589139 603242 605841 606223 626024 632060 642832 647595 647617 649836 663380 665226 671381 674740 683870 683906 685669 685836 686047 687269 687270 687271 687503 687542 687588 687604 687980 688024 688351 698289 699333 699611 701206 702077 702835 704560 706269 706290 713270 713630 714938 720607 725382 726640 728018 732029 732079 745785 748552 756083 758432 760837 776892 789733 797756 800937 801866 805331 807716 810760 811051 813573 815594 815982 816541 818929 820588 820902 822693 823298 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин mom"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин mom"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man mom"
]
|
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.