Query Metrics
7
Database Queries
7
Different statements
165.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.96 ms (83.17%) |
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 20617 408546 415309 416837 424780 430444 433239 434553 443046 444773 453929 454953 477498 478032 478427 492416 498481 512176 512182 512198 512212 512217 515606 515734 537289 541930 542181 545628 550742 550770 554016 554769 554790 554866 557207 557209 557503 559889 559921 565983 565984 565985 565987 565989 565994 566016 567321 575303 577230 579721 583468 583501 585364 586542 588242 592708 593002 593590 597917 600526 606554 606674 614529 619199 623396 630521 632171 636127 641663 643383 643587 645530 650933 670210 672258 681448 697284 699408 709880 712884 714848 718995 722187 726647 733588 733598 737900 741631 748436 748669 750423 752878 759881 760674 764715 767057 770304 771792 771876 775584 776184 776189 782413 789999 793669 793934 802671 804465 805789 807915 809462 810813 812883 812975 815219 815454 815893 817920 818371 822721 ] |
||||||||||||||||||||||||||||||
|
17.54 ms (10.58%) |
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 793669 805789 759881 752878 733588 770304 699408 776184 20617 434553 433239 512198 512212 512217 478032 550742 550770 554769 557209 557503 567321 606674 619199 416837 815893 818371 822721 454953 478427 492416 512182 554866 541930 542181 577230 718995 645530 712884 714848 722187 559889 565985 585364 586542 636127 592708 614529 630521 643383 588242 789999 775584 776189 812975 737900 748669 726647 748436 760674 771876 782413 793934 807915 477498 498481 583468 583501 597917 593002 554016 554790 424780 430444 512176 408546 443046 444773 815454 817920 815219 515606 537289 565994 566016 545628 565989 650933 681448 672258 670210 697284 575303 579721 593590 606554 600526 643587 810813 812883 767057 741631 733598 764715 771792 750423 623396 632171 641663 709880 802671 804465 809462 415309 515734 453929 559921 565983 557207 565984 565987 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.86%) |
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 20617 408546 415309 416837 424780 430444 433239 434553 443046 444773 453929 454953 477498 478032 478427 492416 498481 512176 512182 512198 512212 512217 515606 515734 537289 541930 542181 545628 550742 550770 554016 554769 554790 554866 557207 557209 557503 559889 559921 565983 565984 565985 565987 565989 565994 566016 567321 575303 577230 579721 583468 583501 585364 586542 588242 592708 593002 593590 597917 600526 606554 606674 614529 619199 623396 630521 632171 636127 641663 643383 643587 645530 650933 670210 672258 681448 697284 699408 709880 712884 714848 718995 722187 726647 733588 733598 737900 741631 748436 748669 750423 752878 759881 760674 764715 767057 770304 771792 771876 775584 776184 776189 782413 789999 793669 793934 802671 804465 805789 807915 809462 810813 812883 812975 815219 815454 815893 817920 818371 822721 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf asian"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf азиатк"
]
|
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.