Query Metrics
7
Database Queries
7
Different statements
149.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.93 ms (82.15%) |
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 88220 400134 407052 409596 413457 415814 416094 428816 430732 434189 434257 438429 439763 448928 450800 454498 457207 459131 461055 462649 466714 467347 468770 474141 481947 486946 492309 493218 502505 506760 512100 516002 518347 518781 519350 519826 521358 522424 523345 524211 527687 540549 543184 548844 549827 556638 558709 559493 563235 563503 565144 565784 570860 571820 575050 580424 582416 584694 594880 600826 605369 611245 612051 615587 615772 618351 626890 631696 636371 643352 648776 685578 685625 688083 689373 690105 704925 716116 716760 727087 744618 749398 751968 756601 757329 760608 765848 772219 775476 776731 777750 779346 779996 781173 782593 782777 786470 787313 787548 788880 789692 790469 792532 792634 792660 793617 797801 798015 799019 799081 800510 800864 803461 804619 813765 814152 814790 814861 815877 818198 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (10.69%) |
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 815877 818198 704925 559493 643352 777750 540549 565144 582416 543184 584694 787548 798015 799081 727087 757329 749398 716116 800510 400134 459131 466714 88220 428816 563503 565784 648776 779346 751968 467347 481947 813765 462649 454498 689373 688083 690105 605369 600826 792532 800864 756601 760608 779996 793617 799019 457207 516002 486946 786470 563235 782777 744618 716760 474141 558709 685625 556638 575050 685578 626890 781173 787313 797801 413457 434257 549827 570860 782593 772219 430732 527687 434189 519826 518347 548844 571820 618351 765848 788880 789692 790469 416094 519350 524211 438429 631696 594880 792634 468770 415814 776731 792660 615772 502505 814861 775476 407052 580424 615587 439763 518781 611245 450800 814790 521358 492309 409596 512100 448928 522424 461055 803461 804619 493218 506760 814152 523345 636371 612051 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (2.02%) |
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 88220 400134 407052 409596 413457 415814 416094 428816 430732 434189 434257 438429 439763 448928 450800 454498 457207 459131 461055 462649 466714 467347 468770 474141 481947 486946 492309 493218 502505 506760 512100 516002 518347 518781 519350 519826 521358 522424 523345 524211 527687 540549 543184 548844 549827 556638 558709 559493 563235 563503 565144 565784 570860 571820 575050 580424 582416 584694 594880 600826 605369 611245 612051 615587 615772 618351 626890 631696 636371 643352 648776 685578 685625 688083 689373 690105 704925 716116 716760 727087 744618 749398 751968 756601 757329 760608 765848 772219 775476 776731 777750 779346 779996 781173 782593 782777 786470 787313 787548 788880 789692 790469 792532 792634 792660 793617 797801 798015 799019 799081 800510 800864 803461 804619 813765 814152 814790 814861 815877 818198 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom wants sex"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom wants секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom wants секс"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.19%) |
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.