Query Metrics
7
Database Queries
7
Different statements
162.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.36 ms (84.97%) |
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 2332 5565 51659 79479 79742 147313 209941 307458 310945 330409 339392 382362 384904 385319 385454 385600 387117 389887 391759 393049 393310 396107 396933 398588 398790 402682 403589 407504 408751 412875 414785 417267 417950 418693 420608 429742 443699 452399 477739 490848 501603 540973 548910 549288 563316 575303 590266 595695 597990 607109 615460 620211 620969 627986 628792 637459 638083 647130 651901 664614 666452 667410 679687 683252 688756 693006 704015 713164 715666 716601 716648 716736 723482 723485 728869 734424 736259 739548 742191 742944 758894 762635 763263 763329 769621 769859 774717 775580 777477 778959 779436 780008 780523 780853 780925 786421 789823 791173 792582 793746 795604 797908 798907 799419 799904 802972 805053 805056 808768 810607 814311 815036 818650 819728 819914 824842 824943 825121 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (8.87%) |
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 774717 777477 778959 779436 786421 791173 792582 798907 805053 805056 810607 2332 79479 420608 79742 385319 398790 418693 429742 51659 339392 396933 501603 477739 443699 414785 563316 797908 789823 716648 407504 408751 742191 417950 412875 452399 307458 827931 402682 384904 723485 607109 728869 715666 310945 382362 389887 490848 540973 666452 693006 704015 713164 575303 590266 637459 597990 799419 808768 734424 762635 739548 775580 780925 387117 396107 5565 393310 716601 595695 780853 793746 403589 549288 815036 679687 620211 769859 417267 209941 147313 385454 391759 330409 398588 818650 819728 819914 824943 825121 814311 824842 548910 647130 664614 683252 716736 651901 667410 688756 615460 620969 628792 638083 795604 780008 799904 736259 802972 769621 742944 763329 758894 763263 764819 627986 723482 780523 385600 393049 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.92%) |
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 2332 5565 51659 79479 79742 147313 209941 307458 310945 330409 339392 382362 384904 385319 385454 385600 387117 389887 391759 393049 393310 396107 396933 398588 398790 402682 403589 407504 408751 412875 414785 417267 417950 418693 420608 429742 443699 452399 477739 490848 501603 540973 548910 549288 563316 575303 590266 595695 597990 607109 615460 620211 620969 627986 628792 637459 638083 647130 651901 664614 666452 667410 679687 683252 688756 693006 704015 713164 715666 716601 716648 716736 723482 723485 728869 734424 736259 739548 742191 742944 758894 762635 763263 763329 769621 769859 774717 775580 777477 778959 779436 780008 780523 780853 780925 786421 789823 791173 792582 793746 795604 797908 798907 799419 799904 802972 805053 805056 808768 810607 814311 815036 818650 819728 819914 824842 824943 825121 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скачать минет"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скача минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скача минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.94%) |
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.