Query Metrics
7
Database Queries
7
Different statements
491.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
254.64 ms (51.78%) |
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 89346 384491 410295 416174 434102 447238 452205 452250 454517 458507 461088 464533 464790 464930 466469 467096 468228 469892 470439 472416 473496 473723 475655 475678 475680 475690 476664 480541 493789 496514 500905 501903 504463 504471 510906 511474 513136 515025 515550 516561 517524 523371 523382 523603 526532 530430 531559 531724 531791 532381 533554 534578 534946 535031 535356 536320 537977 538905 543945 545001 545304 545345 545971 545987 546105 547009 547945 548534 549235 549797 551896 551928 553134 554026 554488 555131 556585 556788 558115 558178 561459 567077 571708 574217 575392 576120 578693 581975 584086 587781 589701 590274 591974 596292 597097 598146 598416 606503 607638 607669 612996 619593 623821 629742 649517 649949 651632 659934 662836 664236 668699 671525 681232 684066 686738 687419 692288 695835 710865 714378 ] |
||||||||||||||||||||||||||||||
|
208.83 ms (42.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo short hair"
]
|
||||||||||||||||||||||||||||||
|
17.26 ms (3.51%) |
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 475655 475690 598416 598146 612996 475678 475680 434102 461088 384491 89346 410295 416174 452205 464533 464930 468228 476664 452250 469892 472416 480541 447238 454517 458507 466469 467096 470439 473496 523371 523603 531559 534946 535031 510906 511474 513136 515025 516561 531791 532381 537977 538905 501903 504463 504471 515550 517524 523382 530430 534578 535356 496514 500905 526532 531724 533554 536320 464790 473723 493789 546105 549797 554488 556585 556788 571708 578693 581975 584086 543945 545987 547945 548534 551928 574217 576120 545345 545971 547009 549235 551896 555131 558115 561459 567077 664236 671525 684066 686738 692288 695835 710865 649517 668699 649949 651632 659934 662836 681232 687419 714378 545001 545304 553134 554026 558178 575392 587781 596292 606503 607638 589701 590274 591974 597097 607669 619593 623821 629742 ] |
||||||||||||||||||||||||||||||
|
5.45 ms (1.11%) |
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 89346 384491 410295 416174 434102 447238 452205 452250 454517 458507 461088 464533 464790 464930 466469 467096 468228 469892 470439 472416 473496 473723 475655 475678 475680 475690 476664 480541 493789 496514 500905 501903 504463 504471 510906 511474 513136 515025 515550 516561 517524 523371 523382 523603 526532 530430 531559 531724 531791 532381 533554 534578 534946 535031 535356 536320 537977 538905 543945 545001 545304 545345 545971 545987 546105 547009 547945 548534 549235 549797 551896 551928 553134 554026 554488 555131 556585 556788 558115 558178 561459 567077 571708 574217 575392 576120 578693 581975 584086 587781 589701 590274 591974 596292 597097 598146 598416 606503 607638 607669 612996 619593 623821 629742 649517 649949 651632 659934 662836 664236 668699 671525 681232 684066 686738 687419 692288 695835 710865 714378 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло short hair"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло short hair"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.37%) |
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.