Query Metrics
7
Database Queries
7
Different statements
193.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.19 ms (83.73%) |
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 387647 396331 398618 399904 403725 424190 428024 435793 440261 448756 450587 455885 456564 463306 464202 464246 464599 466579 470425 475805 483557 489381 502499 503682 512913 525142 526280 532300 538681 541398 543629 544205 547418 547858 555593 559360 564565 576628 581292 589029 592820 600450 617851 619623 620158 635558 642335 643080 643355 643602 644406 650262 657186 657230 674522 675204 679171 680328 680442 684887 688617 692732 702142 710877 712272 715593 715892 721869 726776 738679 738686 739132 742100 750498 758141 759895 759928 760814 761570 761679 766606 766799 767056 767236 770139 770612 773600 776222 777659 778628 780706 781412 782182 787283 788450 789182 789595 791493 792136 792671 794067 794765 797332 800355 801306 803919 809747 812069 812395 812905 813624 814423 817194 817256 817275 817832 821576 822686 824200 ] |
||||||||||||||||||||||||||||||
|
20.32 ms (10.49%) |
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 777659 541398 589029 403725 512913 502499 463306 581292 466579 544205 503682 526280 643080 759928 767236 809747 742100 721869 464599 813624 814423 559360 715593 674522 675204 692732 702142 680328 684887 600450 592820 619623 643355 803919 782182 792136 812395 766606 770139 773600 758141 760814 738679 767056 761570 770612 739132 750498 620158 643602 710877 715892 780706 787283 788450 789182 387647 448756 424190 428024 483557 532300 538681 475805 547418 555593 399904 440261 456564 470425 525142 576628 464202 455885 688617 817194 817256 817275 822686 617851 794309 800355 435793 396331 817832 824200 543629 547858 680442 635558 776222 759895 738686 812069 464246 450587 489381 564565 398618 821576 657186 657230 712272 679171 650262 644406 642335 778628 791493 792671 797332 801306 766799 781412 789595 794067 794765 812905 726776 761679 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.17%) |
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 387647 396331 398618 399904 403725 424190 428024 435793 440261 448756 450587 455885 456564 463306 464202 464246 464599 466579 470425 475805 483557 489381 502499 503682 512913 525142 526280 532300 538681 541398 543629 544205 547418 547858 555593 559360 564565 576628 581292 589029 592820 600450 617851 619623 620158 635558 642335 643080 643355 643602 644406 650262 657186 657230 674522 675204 679171 680328 680442 684887 688617 692732 702142 710877 712272 715593 715892 721869 726776 738679 738686 739132 742100 750498 758141 759895 759928 760814 761570 761679 766606 766799 767056 767236 770139 770612 773600 776222 777659 778628 780706 781412 782182 787283 788450 789182 789595 791493 792136 792671 794067 794765 797332 800355 801306 803919 809747 812069 812395 812905 813624 814423 817194 817256 817275 817832 821576 822686 824200 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties anal"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел анал"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.73%) |
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.