Query Metrics
8
Database Queries
8
Different statements
167.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.06 ms (84.11%) |
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 34645 185753 381758 383592 385389 389026 395625 404644 405194 406578 411012 413104 413979 421105 421119 421235 433748 438533 450254 453513 453555 459760 462484 462970 463882 469825 469827 471609 472212 473079 473836 474823 476309 477810 478887 479800 485450 487712 488467 492266 501568 501718 501760 510362 511294 523214 525208 526826 527063 528811 538333 543418 545814 551293 551319 559958 565940 568363 574890 575801 584389 584726 598301 598774 600581 600602 602725 610191 613850 614049 618319 622986 628989 634756 636804 637037 643895 648876 669110 672485 672551 672564 682268 689299 701469 702546 708471 710423 712726 727717 732922 736852 737535 744452 756460 758938 758980 761422 762567 773174 774090 776724 786356 789745 793001 795548 800066 801366 812522 815326 815751 817468 818254 818394 818780 818783 821429 822818 828420 ] |
||||||||||||||||||||||||||||||
|
15.11 ms (9.01%) |
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 689299 600602 634756 622986 602725 786356 776724 789745 800066 761422 773174 774090 801366 737535 756460 758980 381758 185753 421105 488467 528811 818780 818783 821429 818254 818394 828420 702546 712726 669110 614049 637037 762567 736852 744452 463882 523214 526826 545814 584726 672551 568363 598301 600581 727717 406578 501718 511294 648876 643895 815326 477810 565940 628989 636804 538333 822818 817468 708471 710423 610191 618319 812522 795548 793001 732922 758938 771167 395625 413979 438533 450254 462484 473836 478887 501568 574890 543418 551293 575801 559958 598774 613850 404644 453513 476309 433748 473079 421119 462970 471609 479800 389026 527063 485450 487712 525208 501760 510362 469827 492266 405194 385389 383592 34645 421235 411012 413104 815751 453555 474823 459760 469825 472212 584389 672485 672564 701469 682268 551319 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.57%) |
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 34645 185753 381758 383592 385389 389026 395625 404644 405194 406578 411012 413104 413979 421105 421119 421235 433748 438533 450254 453513 453555 459760 462484 462970 463882 469825 469827 471609 472212 473079 473836 474823 476309 477810 478887 479800 485450 487712 488467 492266 501568 501718 501760 510362 511294 523214 525208 526826 527063 528811 538333 543418 545814 551293 551319 559958 565940 568363 574890 575801 584389 584726 598301 598774 600581 600602 602725 610191 613850 614049 618319 622986 628989 634756 636804 637037 643895 648876 669110 672485 672551 672564 682268 689299 701469 702546 708471 710423 712726 727717 732922 736852 737535 744452 756460 758938 758980 761422 762567 773174 774090 776724 786356 789745 793001 795548 800066 801366 812522 815326 815751 817468 818254 818394 818780 818783 821429 822818 828420 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil massage"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл массаж"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.06%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01’ì,“zsl…\x1C¬Ü{v\x02c"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.85%) |
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.