Query Metrics
7
Database Queries
7
Different statements
175.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.46 ms (85.53%) |
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 355652 357977 381975 385578 386583 387058 398196 438848 466000 473692 478735 492996 498158 499681 528405 542112 547761 550158 552437 552766 554845 558082 558169 558673 563310 568133 570410 580226 585882 595548 596253 599091 608574 630436 632934 642124 648722 650113 651596 653977 653978 660035 669860 669868 669896 670006 671531 673213 674872 678661 678683 680676 684883 692691 696763 700056 700924 702319 705798 707968 708697 710068 713061 713977 715170 715171 719394 722237 731656 735037 736063 736080 736804 737804 739811 743272 743294 746822 746984 749383 749513 749518 750402 750535 751289 751294 753773 755892 756141 756144 756702 758740 762007 763410 766154 776788 777984 780263 781804 782744 782949 783651 788321 790430 791437 791552 796917 796966 796982 805864 806644 806694 809943 810463 811069 811778 812402 814164 814337 824196 ] |
||||||||||||||||||||||||||||||
|
14.69 ms (8.35%) |
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 810463 398196 528405 355652 381975 814337 824196 473692 478735 499681 550158 552766 558169 563310 558082 547761 552437 568133 651596 669860 684883 692691 702319 707968 715171 653977 669868 700056 713061 722237 669896 708697 710068 715170 558673 642124 608574 585882 595548 596253 599091 632934 630436 776788 777984 788321 791552 806644 809943 811778 812402 780263 783651 790430 796917 796982 806694 736063 736080 739811 743294 758740 781804 782744 782949 791437 811069 731656 737804 749513 749518 751289 756141 756144 762007 766154 735037 753773 755892 736804 746822 746984 756702 763410 743272 749383 750402 750535 751294 705798 796966 805864 385578 357977 386583 466000 498158 570410 387058 438848 814164 492996 542112 554845 580226 648722 653978 660035 673213 674872 678661 678683 696763 719394 650113 670006 671531 680676 700924 713977 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.72%) |
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 355652 357977 381975 385578 386583 387058 398196 438848 466000 473692 478735 492996 498158 499681 528405 542112 547761 550158 552437 552766 554845 558082 558169 558673 563310 568133 570410 580226 585882 595548 596253 599091 608574 630436 632934 642124 648722 650113 651596 653977 653978 660035 669860 669868 669896 670006 671531 673213 674872 678661 678683 680676 684883 692691 696763 700056 700924 702319 705798 707968 708697 710068 713061 713977 715170 715171 719394 722237 731656 735037 736063 736080 736804 737804 739811 743272 743294 746822 746984 749383 749513 749518 750402 750535 751289 751294 753773 755892 756141 756144 756702 758740 762007 763410 766154 776788 777984 780263 781804 782744 782949 783651 788321 790430 791437 791552 796917 796966 796982 805864 806644 806694 809943 810463 811069 811778 812402 814164 814337 824196 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo sweet"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло милая"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.84%) |
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.