Query Metrics
7
Database Queries
7
Different statements
191.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.15 ms (87.16%) |
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 229270 382408 385788 389014 407592 415544 415586 418405 425593 429959 430330 432991 436756 442399 442947 444750 451137 454239 456368 457421 457768 458449 459508 459511 459738 465003 466948 467639 467677 468301 472085 472268 475681 476854 479200 480302 486519 486705 495031 506911 507810 509035 509431 510717 511388 511696 511896 514827 517039 518318 525402 526557 528915 528919 532160 532237 532440 535029 535251 538318 539609 547987 557213 565977 566074 566093 567381 568312 571248 573848 599017 601021 612228 612250 614582 618389 622364 627595 629313 632070 635160 651227 652879 659353 661928 662797 670546 675329 679375 680096 691514 691518 692319 693990 694492 695236 699778 699915 704918 710266 717336 718687 732651 737752 739471 739787 744429 755741 757201 762195 762322 765156 776607 783452 784822 789009 803807 807637 815194 821596 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (7.50%) |
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 526557 532440 755741 776607 803807 573848 670546 679375 691518 692319 680096 694492 757201 762195 718687 517039 535029 783452 744429 415586 459738 710266 784822 382408 429959 229270 532237 466948 465003 436756 442399 815194 507810 475681 567381 622364 425593 442947 518318 525402 807637 635160 444750 457768 430330 468301 675329 459511 514827 509431 532160 695236 704918 651227 739471 732651 737752 415544 476854 652879 454239 506911 565977 547987 566093 618389 389014 821596 472268 467639 480302 472085 566074 458449 457421 528919 535251 486519 479200 571248 693990 632070 765156 717336 432991 418405 456368 459508 511696 568312 699778 627595 614582 612228 762322 739787 699915 385788 451137 528915 510717 511896 557213 509035 486705 495031 511388 407592 467677 538318 539609 659353 661928 662797 691514 629313 599017 601021 612250 789009 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.43%) |
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 229270 382408 385788 389014 407592 415544 415586 418405 425593 429959 430330 432991 436756 442399 442947 444750 451137 454239 456368 457421 457768 458449 459508 459511 459738 465003 466948 467639 467677 468301 472085 472268 475681 476854 479200 480302 486519 486705 495031 506911 507810 509035 509431 510717 511388 511696 511896 514827 517039 518318 525402 526557 528915 528919 532160 532237 532440 535029 535251 538318 539609 547987 557213 565977 566074 566093 567381 568312 571248 573848 599017 601021 612228 612250 614582 618389 622364 627595 629313 632070 635160 651227 652879 659353 661928 662797 670546 675329 679375 680096 691514 691518 692319 693990 694492 695236 699778 699915 704918 710266 717336 718687 732651 737752 739471 739787 744429 755741 757201 762195 762322 765156 776607 783452 784822 789009 803807 807637 815194 821596 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video big tits"
]
|
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.