Query Metrics
7
Database Queries
7
Different statements
158.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.16 ms (83.58%) |
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 213273 382950 383681 385590 396283 397099 398016 419157 420050 421056 422557 422618 422769 422959 423141 423202 423211 423252 423264 424063 429698 429936 430273 444974 452532 454704 457272 457812 462573 472952 473111 473752 473754 473756 484363 506139 510584 512202 515734 525762 528889 538868 539119 540175 540601 541016 545147 545484 546862 547663 550589 550727 551005 552037 552052 552935 554140 554151 557494 557814 558379 559868 560056 562900 565998 566016 567835 569804 585388 586643 590934 591720 595018 600560 600605 601658 605380 614597 622652 623396 623449 623606 630736 636923 638357 642816 670526 672258 680891 686997 687595 688579 688606 692389 713556 714104 722543 739475 744652 747987 750940 757339 760946 768123 771792 771823 771928 775112 776008 785024 785629 789017 790071 792722 809737 810242 812154 815548 818299 818335 ] |
||||||||||||||||||||||||||||||
|
15.61 ms (9.87%) |
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 550727 429698 429936 552935 586643 760946 750940 454704 552037 600560 739475 382950 768123 785629 538868 539119 790071 775112 457272 383681 552052 554140 422618 462573 540175 688579 688606 692389 591720 785024 812154 815548 559868 600605 515734 424063 562900 557494 565998 789017 792722 420050 421056 419157 642816 423202 457812 545147 622652 528889 569804 614597 776008 484363 554151 385590 422557 506139 541016 546862 545484 595018 630736 623449 623606 525762 550589 623396 398016 818299 213273 423211 444974 567835 547663 557814 585388 771823 397099 423252 473752 422769 510584 558379 757339 818335 512202 771928 747987 771792 423264 430273 452532 472952 473754 473756 670526 590934 638357 601658 810242 744652 809737 540601 396283 551005 605380 423141 422959 473111 680891 636923 560056 566016 687595 714104 722543 672258 686997 713556 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.77%) |
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 213273 382950 383681 385590 396283 397099 398016 419157 420050 421056 422557 422618 422769 422959 423141 423202 423211 423252 423264 424063 429698 429936 430273 444974 452532 454704 457272 457812 462573 472952 473111 473752 473754 473756 484363 506139 510584 512202 515734 525762 528889 538868 539119 540175 540601 541016 545147 545484 546862 547663 550589 550727 551005 552037 552052 552935 554140 554151 557494 557814 558379 559868 560056 562900 565998 566016 567835 569804 585388 586643 590934 591720 595018 600560 600605 601658 605380 614597 622652 623396 623449 623606 630736 636923 638357 642816 670526 672258 680891 686997 687595 688579 688606 692389 713556 714104 722543 739475 744652 747987 750940 757339 760946 768123 771792 771823 771928 775112 776008 785024 785629 789017 790071 792722 809737 810242 812154 815548 818299 818335 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob asian"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.