Query Metrics
7
Database Queries
7
Different statements
200.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.90 ms (84.83%) |
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 229460 381771 382246 382747 385356 386813 388102 391895 392874 396064 400156 406917 406973 412535 418017 435768 443264 448200 449566 450735 451676 457259 459873 460957 462204 464165 464370 465976 468974 469913 470631 472327 472787 474581 475073 478484 478883 481813 486277 497406 502575 515805 518746 524910 527653 534131 536332 536614 543401 548522 550416 558020 560112 560210 565061 567957 584008 587797 590855 612336 617216 618882 620377 624223 637072 637566 646219 647311 648859 663482 663493 665208 667290 671585 671759 677957 684541 686658 687269 687270 687271 693075 696353 698456 699333 702835 705739 705988 707370 709624 712441 712820 712822 713270 713630 717867 720364 721864 722805 732070 733889 736627 736663 752935 766274 770124 771836 775836 786064 789959 790034 790990 800240 803454 808134 811870 814069 815194 819565 820967 ] |
||||||||||||||||||||||||||||||
|
18.43 ms (9.20%) |
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 617216 815194 712441 667290 712822 550416 560112 590855 814069 543401 693075 722805 475073 684541 435768 567957 587797 448200 663493 386813 709624 717867 811870 406917 819565 637072 382747 385356 518746 687269 713270 713630 400156 418017 702835 699333 671585 451676 464165 469913 465976 497406 459873 470631 460957 449566 481813 396064 468974 803454 406973 771836 637566 527653 229460 388102 472787 536332 560210 671759 677957 721864 618882 486277 450735 584008 696353 647311 663482 686658 698456 736663 382246 478883 391895 381771 820967 474581 534131 515805 558020 687271 752935 790990 808134 770124 732070 789959 464370 472327 502575 457259 536614 524910 478484 705988 786064 800240 733889 766274 412535 687270 775836 736627 790034 612336 646219 443264 707370 705739 712820 392874 462204 565061 720364 620377 624223 665208 648859 548522 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (1.87%) |
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 229460 381771 382246 382747 385356 386813 388102 391895 392874 396064 400156 406917 406973 412535 418017 435768 443264 448200 449566 450735 451676 457259 459873 460957 462204 464165 464370 465976 468974 469913 470631 472327 472787 474581 475073 478484 478883 481813 486277 497406 502575 515805 518746 524910 527653 534131 536332 536614 543401 548522 550416 558020 560112 560210 565061 567957 584008 587797 590855 612336 617216 618882 620377 624223 637072 637566 646219 647311 648859 663482 663493 665208 667290 671585 671759 677957 684541 686658 687269 687270 687271 693075 696353 698456 699333 702835 705739 705988 707370 709624 712441 712820 712822 713270 713630 717867 720364 721864 722805 732070 733889 736627 736663 752935 766274 770124 771836 775836 786064 789959 790034 790990 800240 803454 808134 811870 814069 815194 819565 820967 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits sex"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.72%) |
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.