Query Metrics
7
Database Queries
7
Different statements
419.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.73 ms (51.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"facial сперм"
]
|
||||||||||||||||||||||||||||||
|
181.37 ms (43.28%) |
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 388569 388968 411033 412520 416310 423378 435047 436001 440929 443497 445089 449744 456976 457653 458056 458367 459942 460010 461251 469474 474382 474742 476968 488088 488354 496153 497946 499295 502023 505631 506664 510484 511384 524080 524668 525775 526741 528786 534923 539365 545008 546140 549499 552104 552246 553084 554357 555066 559027 559293 559644 561707 565240 565421 565759 566690 570144 573922 577976 579941 585838 589175 591426 593051 604732 607621 613937 620645 624888 626434 636674 638133 646270 649587 653216 654402 671470 679685 679847 693567 694044 695836 708303 709181 712722 713091 714498 716660 716856 722687 723131 724245 725339 747090 751715 757455 758124 763279 763309 764298 764484 775127 775196 775268 782427 783080 784989 785238 785718 788533 792396 793435 796206 797570 799435 806293 806841 807358 807919 810572 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (3.82%) |
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 555066 570144 549499 559027 552246 561707 577976 579941 646270 653216 712722 679685 694044 695836 713091 671470 693567 714498 722687 573922 585838 626434 620645 591426 613937 624888 636674 589175 607621 638133 792396 797570 775196 775268 784989 793435 799435 806841 807358 810572 757455 758124 783080 785238 796206 806293 807919 724245 725339 747090 751715 764484 763279 763309 764298 709181 775127 782427 785718 788533 388569 458056 469474 388968 411033 440929 461251 474742 435047 456976 457653 459942 436001 449744 496153 510484 528786 502023 525775 604732 524080 443497 445089 416310 423378 412520 488088 458367 460010 511384 499295 524668 526741 534923 497946 505631 506664 539365 474382 476968 488354 552104 565759 545008 546140 553084 559293 559644 654402 679847 716856 723131 649587 716660 708303 554357 565240 565421 566690 593051 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (0.79%) |
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 388569 388968 411033 412520 416310 423378 435047 436001 440929 443497 445089 449744 456976 457653 458056 458367 459942 460010 461251 469474 474382 474742 476968 488088 488354 496153 497946 499295 502023 505631 506664 510484 511384 524080 524668 525775 526741 528786 534923 539365 545008 546140 549499 552104 552246 553084 554357 555066 559027 559293 559644 561707 565240 565421 565759 566690 570144 573922 577976 579941 585838 589175 591426 593051 604732 607621 613937 620645 624888 626434 636674 638133 646270 649587 653216 654402 671470 679685 679847 693567 694044 695836 708303 709181 712722 713091 714498 716660 716856 722687 723131 724245 725339 747090 751715 757455 758124 763279 763309 764298 764484 775127 775196 775268 782427 783080 784989 785238 785718 788533 792396 793435 796206 797570 799435 806293 806841 807358 807919 810572 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facial sperm"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"facial сперм"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.33%) |
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.