Query Metrics
7
Database Queries
7
Different statements
163.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.25 ms (86.27%) |
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 421610 423552 423781 433352 436526 439340 443129 444193 459028 461993 481655 483043 493770 500616 502347 507497 509756 509761 523980 534488 536392 537456 543671 545677 547721 547799 554936 561166 562238 568826 568932 569325 571096 573572 573827 573861 578331 578972 595465 596648 598482 598525 601747 601955 608726 609569 613255 616936 617961 619906 619949 622780 639195 651727 651800 659007 659397 672511 673214 673448 673852 680026 682961 694650 695341 695477 696379 696576 699910 700006 701267 720822 721124 727376 730843 731516 736106 738835 741233 751291 752783 757196 757290 758963 758984 759537 761913 762183 764201 765066 765255 767078 768414 773187 776622 778724 779579 780459 781011 781211 789129 789130 789175 796992 797366 797668 797817 799095 804935 805647 809779 811668 812038 813260 813319 813587 814214 814350 ] |
||||||||||||||||||||||||||||||
|
11.57 ms (7.07%) |
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 765066 421610 443129 433352 444193 814214 493770 562238 554936 673214 682961 659007 659397 619949 622780 609569 639195 796992 805647 727376 734988 773187 789130 731516 738835 741233 764201 757290 767078 601955 776622 813319 459028 596648 523980 509761 439340 813587 814350 537456 509756 536392 651727 720822 651800 672511 694650 695341 561166 598482 598922 778724 779579 781011 759537 752783 758963 762183 768414 751291 780459 789129 797366 507497 568932 500616 578972 461993 502347 483043 423781 436526 543671 680026 696379 701267 673852 695477 569325 573572 573827 608726 616936 613255 601747 781211 736106 758984 730843 761913 765255 812038 423552 481655 534488 545677 578331 547799 571096 573861 699910 721124 696576 673448 700006 547721 568826 598525 617961 595465 619906 797668 799095 809779 789175 757196 797817 804935 811668 813260 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.03%) |
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 421610 423552 423781 433352 436526 439340 443129 444193 459028 461993 481655 483043 493770 500616 502347 507497 509756 509761 523980 534488 536392 537456 543671 545677 547721 547799 554936 561166 562238 568826 568932 569325 571096 573572 573827 573861 578331 578972 595465 596648 598482 598525 601747 601955 608726 609569 613255 616936 617961 619906 619949 622780 639195 651727 651800 659007 659397 672511 673214 673448 673852 680026 682961 694650 695341 695477 696379 696576 699910 700006 701267 720822 721124 727376 730843 731516 736106 738835 741233 751291 752783 757196 757290 758963 758984 759537 761913 762183 764201 765066 765255 767078 768414 773187 776622 778724 779579 780459 781011 781211 789129 789130 789175 796992 797366 797668 797817 799095 804935 805647 809779 811668 812038 813260 813319 813587 814214 814350 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"узкая русское"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"узкая русск"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.00%) |
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.