Query Metrics
7
Database Queries
7
Different statements
163.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.04 ms (85.61%) |
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 181009 246506 391669 400492 400509 400515 423988 424254 436868 443669 443997 448508 451470 453505 454544 455406 462193 462952 466405 468088 468862 469161 469173 472392 475097 475819 477137 477619 477794 483055 484947 485367 488887 492640 493042 493909 502852 504175 506757 509614 509650 510828 511835 518600 518822 522270 522956 528028 538603 542938 544953 546934 547274 547577 552334 552338 553684 556471 558610 561377 563135 570954 572765 579213 579542 584479 588735 588862 590538 600838 619903 625233 655515 657804 659360 671896 672821 672843 688967 697513 705471 714320 714443 714459 714487 718876 725476 731005 736382 741044 741201 741700 741750 741854 745834 746028 749929 751613 758158 761247 763729 763744 764215 765868 777172 781656 781713 782190 786384 790180 790648 792932 795702 798743 799859 805129 808562 810458 825560 825771 ] |
||||||||||||||||||||||||||||||
|
14.16 ms (8.66%) |
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 475097 400492 455406 792932 558610 714443 547577 798743 714459 777172 469173 655515 400515 436868 492640 483055 423988 477137 584479 451470 475819 504175 510828 528028 825560 825771 553684 542938 671896 705471 795702 810458 741044 741854 745834 782190 790180 746028 741201 472392 511835 488887 546934 552338 579213 552334 588735 477794 468862 462952 443669 454544 443997 509614 518600 502852 484947 485367 522270 522956 506757 544953 672843 714320 659360 563135 588862 590538 781713 808562 741750 749929 751613 790648 799859 736382 741700 731005 763729 765868 697513 400509 462193 570954 714487 453505 477619 466405 572765 556471 469161 391669 518822 181009 538603 468088 561377 547274 672821 657804 688967 579542 600838 625233 781656 805129 758158 763744 725476 761247 764215 619903 718876 786384 448508 246506 509650 493042 493909 424254 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.97%) |
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 181009 246506 391669 400492 400509 400515 423988 424254 436868 443669 443997 448508 451470 453505 454544 455406 462193 462952 466405 468088 468862 469161 469173 472392 475097 475819 477137 477619 477794 483055 484947 485367 488887 492640 493042 493909 502852 504175 506757 509614 509650 510828 511835 518600 518822 522270 522956 528028 538603 542938 544953 546934 547274 547577 552334 552338 553684 556471 558610 561377 563135 570954 572765 579213 579542 584479 588735 588862 590538 600838 619903 625233 655515 657804 659360 671896 672821 672843 688967 697513 705471 714320 714443 714459 714487 718876 725476 731005 736382 741044 741201 741700 741750 741854 745834 746028 749929 751613 758158 761247 763729 763744 764215 765868 777172 781656 781713 782190 786384 790180 790648 792932 795702 798743 799859 805129 808562 810458 825560 825771 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy russian milf"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy русск milf"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy русск milf"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.82%) |
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.