Query Metrics
7
Database Queries
7
Different statements
209.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.34 ms (87.71%) |
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 395146 395533 397000 407610 411742 415907 422277 430430 443046 445041 448707 451719 457859 465276 465539 469486 483055 496199 503877 516642 517064 525549 525998 531317 531914 536439 545684 547833 549718 549851 555598 555610 555900 556582 558409 560504 561761 565333 582619 590337 601925 604691 608356 612204 619540 621405 623650 625216 626284 626994 628160 628655 643362 644854 650996 659360 661988 669206 669217 672833 673624 673981 682261 701580 709920 710482 710572 712108 712951 714860 715424 716033 716279 719929 721580 721598 721608 726815 727771 736319 754158 755141 761042 762402 765317 779934 784085 784769 788884 789440 789585 790011 793915 794183 794788 796150 796155 796488 802204 802217 803434 803706 804829 806132 807416 807734 808228 810878 813004 814727 814797 816917 817957 818045 819342 820333 824022 824221 825843 826498 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (7.38%) |
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 796150 796155 808228 794788 806132 807416 813004 784085 794183 803706 726815 736319 754158 762402 727771 765317 755141 761042 719929 803434 448707 465539 430430 483055 496199 395146 395533 397000 407610 445041 415907 443046 411742 422277 814797 817957 820333 644854 826498 825843 814727 816917 818045 819342 824022 824221 451719 457859 469486 465276 516642 531317 503877 525549 525998 531914 517064 536439 555598 555610 555900 582619 547833 556582 560504 545684 561761 565333 669206 669217 682261 709920 721580 650996 673981 710482 710572 715424 716279 721598 721608 659360 661988 672833 673624 701580 712108 712951 714860 716033 549718 549851 558409 619540 621405 628160 628655 601925 626994 590337 623650 604691 608356 612204 625216 626284 643362 784769 788884 789585 790011 793915 796488 802204 802217 804829 807734 810878 779934 789440 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.31%) |
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 395146 395533 397000 407610 411742 415907 422277 430430 443046 445041 448707 451719 457859 465276 465539 469486 483055 496199 503877 516642 517064 525549 525998 531317 531914 536439 545684 547833 549718 549851 555598 555610 555900 556582 558409 560504 561761 565333 582619 590337 601925 604691 608356 612204 619540 621405 623650 625216 626284 626994 628160 628655 643362 644854 650996 659360 661988 669206 669217 672833 673624 673981 682261 701580 709920 710482 710572 712108 712951 714860 715424 716033 716279 719929 721580 721598 721608 726815 727771 736319 754158 755141 761042 762402 765317 779934 784085 784769 788884 789440 789585 790011 793915 794183 794788 796150 796155 796488 802204 802217 803434 803706 804829 806132 807416 807734 808228 810878 813004 814727 814797 816917 817957 818045 819342 820333 824022 824221 825843 826498 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.74%) |
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.