Query Metrics
7
Database Queries
7
Different statements
194.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.26 ms (87.09%) |
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 107545 109218 191315 385438 385510 385683 401077 401926 401972 402190 405745 417703 423812 426537 448933 449713 449718 449728 462059 468495 471853 477950 479124 482954 504855 513140 513945 526561 533474 540276 540776 548390 550152 552906 557141 558102 563958 568500 572424 585607 603679 606362 607128 613040 618867 624152 633036 635453 647759 650162 654491 656453 657352 661902 662812 665103 667207 672919 674585 683505 685600 693408 699418 706898 709913 710197 710380 710726 710978 711566 711576 712183 718946 720378 721894 722195 722452 724538 724718 725189 726193 727786 728810 729861 732014 736999 737573 738453 739016 743181 744188 745333 746856 749812 754468 762677 764924 772882 772885 782762 783357 788214 788240 788488 789107 795217 796111 801091 804359 809711 810280 810428 816381 822007 823457 825091 826973 828008 828604 828868 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (7.26%) |
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 809711 385683 402190 449713 401077 448933 462059 479124 385510 417703 423812 468495 477950 401972 405745 426537 449718 449728 526561 504855 624152 385438 107545 109218 191315 401926 540776 822007 826973 816381 823457 825091 828008 828868 828604 471853 482954 533474 513140 513945 540276 550152 557141 563958 568500 558102 647759 654491 662812 706898 711566 711576 718946 657352 661902 665103 710197 710726 710978 712183 721894 650162 656453 667207 672919 674585 683505 685600 693408 699418 709913 710380 722195 722452 548390 552906 572424 635453 613040 633036 585607 603679 606362 607128 618867 782762 789107 795217 788240 725189 727786 737573 739016 754468 772882 783357 804359 810280 810428 726193 732014 744188 746856 724538 724718 738453 764924 729861 743181 745333 762677 772885 728810 736999 749812 720378 788214 788488 796111 801091 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.54%) |
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 107545 109218 191315 385438 385510 385683 401077 401926 401972 402190 405745 417703 423812 426537 448933 449713 449718 449728 462059 468495 471853 477950 479124 482954 504855 513140 513945 526561 533474 540276 540776 548390 550152 552906 557141 558102 563958 568500 572424 585607 603679 606362 607128 613040 618867 624152 633036 635453 647759 650162 654491 656453 657352 661902 662812 665103 667207 672919 674585 683505 685600 693408 699418 706898 709913 710197 710380 710726 710978 711566 711576 712183 718946 720378 721894 722195 722452 724538 724718 725189 726193 727786 728810 729861 732014 736999 737573 738453 739016 743181 744188 745333 746856 749812 754468 762677 764924 772882 772885 782762 783357 788214 788240 788488 789107 795217 796111 801091 804359 809711 810280 810428 816381 822007 823457 825091 826973 828008 828604 828868 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая short"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette short"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая short"
]
|
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.