Query Metrics
7
Database Queries
7
Different statements
145.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.08 ms (79.99%) |
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 45853 66792 187443 383429 400835 401003 407863 409251 412101 421855 426697 428153 432497 433078 433363 433618 444071 457759 460431 462712 463710 469498 476633 477676 478424 489381 492012 492926 500314 509878 512198 515651 516055 525965 526569 527580 528843 529017 530674 534006 538318 540234 548010 552317 554423 554434 559865 559889 571378 581292 585525 586211 587781 589928 591159 601429 608696 617834 621761 622927 623784 675081 682857 688195 688958 692971 714434 715073 716156 716795 718756 723828 726560 732538 735845 736561 739350 740861 742323 744227 744374 747935 750666 757568 757763 758893 760679 760760 762118 767675 770591 777765 778017 778103 778755 778945 780831 781352 782262 784295 785883 788773 790178 790191 795030 796818 804319 804339 805202 808050 809186 809771 811510 813200 813949 814168 817744 824303 825909 ] |
||||||||||||||||||||||||||||||
|
18.22 ms (12.56%) |
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 538318 554423 688958 692971 682857 688195 716795 559889 586211 598922 601429 608696 621761 623784 585525 589928 778945 780831 804339 808050 778017 782262 809186 723828 758893 767675 790178 796818 811510 750666 757763 762118 747935 732538 735845 739350 726560 740861 744227 744374 757568 760679 760760 770591 617834 714434 718756 778103 778755 781352 788773 790191 805202 813200 469498 477676 795030 736561 433363 401003 409251 187443 509878 460431 412101 500314 528843 534006 478424 492012 559865 622927 742323 421855 426697 516055 512198 675081 444071 554434 515651 489381 525965 457759 66792 571378 526569 581292 492926 463710 587781 591159 777765 785883 804319 432497 400835 433618 45853 715073 716156 784295 809771 433078 383429 407863 428153 813949 825909 814168 817744 824303 462712 540234 529017 530674 527580 476633 552317 548010 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"через колготки и трус%…"
]
|
||||||||||||||||||||||||||||||
|
2.42 ms (1.67%) |
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 45853 66792 187443 383429 400835 401003 407863 409251 412101 421855 426697 428153 432497 433078 433363 433618 444071 457759 460431 462712 463710 469498 476633 477676 478424 489381 492012 492926 500314 509878 512198 515651 516055 525965 526569 527580 528843 529017 530674 534006 538318 540234 548010 552317 554423 554434 559865 559889 571378 581292 585525 586211 587781 589928 591159 601429 608696 617834 621761 622927 623784 675081 682857 688195 688958 692971 714434 715073 716156 716795 718756 723828 726560 732538 735845 736561 739350 740861 742323 744227 744374 747935 750666 757568 757763 758893 760679 760760 762118 767675 770591 777765 778017 778103 778755 778945 780831 781352 782262 784295 785883 788773 790178 790191 795030 796818 804319 804339 805202 808050 809186 809771 811510 813200 813949 814168 817744 824303 825909 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"колготк трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.22%) |
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.