Query Metrics
7
Database Queries
7
Different statements
203.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.36 ms (88.66%) |
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 389756 407658 422369 423764 425566 427302 428364 449644 453514 460552 468420 469900 483233 487464 490509 495106 496859 496926 497932 497986 498354 500250 506495 507415 509451 511821 512120 513255 522524 525215 531454 551099 552580 559035 559698 560763 561859 565433 565638 566710 577189 578572 578585 578598 579796 583143 585318 585552 585591 587609 589310 590898 605454 605692 605697 610107 619125 620425 625467 628798 632965 633895 635830 651940 657852 666030 682209 687362 688579 689061 693898 695348 696231 696325 699428 699647 701397 713990 715410 720163 721397 727314 730458 731315 748051 750581 753782 756755 759760 761203 764947 767080 768026 769641 771039 771069 773545 776307 777903 788894 788935 789103 789274 790578 794088 795151 795332 797306 799619 802471 803164 804194 804862 805189 807566 813072 814256 823361 825102 825949 ] |
||||||||||||||||||||||||||||||
|
13.84 ms (6.80%) |
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 578585 620425 587609 777903 813072 565638 565433 727314 799619 468420 823361 699647 559698 635830 490509 651940 589310 788935 525215 389756 509451 566710 688579 427302 522524 498354 497932 507415 825102 689061 693898 610107 790578 794088 805189 802471 764947 730458 753782 756755 773545 748051 750581 768026 699428 814256 496859 512120 469900 579796 578572 695348 605692 632965 605454 605697 771039 453514 460552 497986 506495 559035 560763 551099 687362 585552 807566 789103 767080 449644 496926 487464 513255 577189 696325 713990 804862 407658 825949 682209 776307 795151 803164 561859 761203 721397 583143 619125 789274 425566 422369 495106 657852 666030 720163 696231 578598 585591 633895 771069 483233 511821 531454 715410 585318 788894 759760 769641 731315 795332 797306 804194 423764 552580 590898 628798 701397 500250 625467 428364 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.48%) |
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 389756 407658 422369 423764 425566 427302 428364 449644 453514 460552 468420 469900 483233 487464 490509 495106 496859 496926 497932 497986 498354 500250 506495 507415 509451 511821 512120 513255 522524 525215 531454 551099 552580 559035 559698 560763 561859 565433 565638 566710 577189 578572 578585 578598 579796 583143 585318 585552 585591 587609 589310 590898 605454 605692 605697 610107 619125 620425 625467 628798 632965 633895 635830 651940 657852 666030 682209 687362 688579 689061 693898 695348 696231 696325 699428 699647 701397 713990 715410 720163 721397 727314 730458 731315 748051 750581 753782 756755 759760 761203 764947 767080 768026 769641 771039 771069 773545 776307 777903 788894 788935 789103 789274 790578 794088 795151 795332 797306 799619 802471 803164 804194 804862 805189 807566 813072 814256 823361 825102 825949 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck friend girl"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс friend девушк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс friend девушк"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.71%) |
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.