Query Metrics
7
Database Queries
7
Different statements
351.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.04 ms (59.98%) |
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 391499 400896 410073 418221 420730 422302 426111 426671 432554 432694 433033 437155 438671 440884 442518 442664 445376 446055 448296 451276 454500 456460 456542 458420 467027 473669 478222 478295 483908 484210 485551 486137 502211 503482 512950 517491 518318 519160 521232 521594 524623 524911 525896 527619 527644 529167 531140 539243 551645 556674 563734 569071 574408 577723 579556 580624 583176 583471 592293 594167 595026 595499 596948 608357 610154 612971 615660 619521 621067 626327 627743 632102 656628 662427 680561 682250 693632 707059 708643 710744 718394 718566 721749 722687 724604 727087 729239 735752 736151 736979 739699 739997 741156 749909 753023 756570 757455 758124 760653 761167 780215 781573 784261 784989 785299 785634 787066 788342 791457 792310 793844 796364 796723 799704 800186 801487 802503 802815 812593 813718 ] |
||||||||||||||||||||||||||||||
|
119.18 ms (33.87%) |
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 391499 400896 410073 418221 420730 422302 426111 426671 432554 432694 433033 437155 438671 440884 442518 442664 445376 446055 448296 451276 454500 456460 456542 458420 467027 473669 478222 478295 483908 484210 485551 486137 502211 503482 512950 517491 518318 519160 521232 521594 524623 524911 525896 527619 527644 529167 531140 539243 551645 556674 563734 569071 574408 577723 579556 580624 583176 583471 592293 594167 595026 595499 596948 608357 610154 612971 615660 619521 621067 626327 627743 632102 656628 662427 680561 682250 693632 707059 708643 710744 718394 718566 721749 722687 724604 727087 729239 735752 736151 736979 739699 739997 741156 749909 753023 756570 757455 758124 760653 761167 780215 781573 784261 784989 785299 785634 787066 788342 791457 792310 793844 796364 796723 799704 800186 801487 802503 802815 812593 813718 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (4.18%) |
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 442664 437155 445376 446055 456460 458420 512950 521232 524911 656628 569071 592293 753023 632102 780215 442518 440884 467027 448296 485551 391499 422302 432694 410073 432554 813718 478295 484210 456542 451276 483908 517491 518318 502211 521594 531140 539243 519160 527619 527644 529167 503482 524623 525896 486137 556674 574408 580624 583176 583471 680561 693632 718394 718566 721749 662427 682250 707059 710744 722687 551645 563734 577723 579556 608357 612971 595026 626327 596948 615660 619521 594167 595499 610154 627743 781573 785299 788342 793844 799704 800186 802815 812593 784261 784989 796364 802503 727087 739997 741156 757455 758124 761167 785634 791457 792310 796723 724604 735752 756570 729239 736151 736979 739699 749909 760653 621067 708643 787066 801487 420730 454500 438671 473669 478222 418221 400896 426111 426671 433033 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot big ass"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot большая большие жоп"
]
|
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.