Query Metrics
7
Database Queries
7
Different statements
192.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.74 ms (80.54%) |
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 72822 143195 174164 187289 365875 383449 386813 388365 388436 388537 390169 391564 392880 395577 400243 401957 404078 407558 407628 408263 408765 409081 409168 409356 409390 411689 411820 411863 415602 415849 418377 425603 427981 429416 432864 438001 439484 439679 440390 440934 445709 449950 451443 451479 451713 453348 456831 457463 461605 465201 465635 467536 469410 469487 471452 474447 475889 477980 480045 482230 483360 484655 484659 485679 485945 486915 489495 491463 492689 493162 493733 494317 497363 501362 504028 506051 514740 518148 519726 521243 523831 525457 526086 536655 546977 554375 562599 563548 595425 600314 610142 622387 624789 635946 649249 663214 663935 664823 665210 667526 667555 667903 705451 726517 732236 740129 742753 761036 795300 796084 796091 803001 807329 807340 809357 815865 818503 824345 824900 825812 ] |
||||||||||||||||||||||||||||||
|
17.39 ms (9.05%) |
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 439679 506051 492689 483360 484655 486915 491463 514740 484659 383449 143195 404078 407558 818503 456831 663935 409356 485945 504028 388436 439484 440390 445709 465201 451713 480045 546977 663214 796091 477980 72822 429416 482230 825812 187289 388365 408263 409081 411820 815865 457463 497363 649249 667555 664823 665210 622387 624789 635946 610142 807329 726517 732236 365875 409390 451443 467536 471452 388537 469410 485679 391564 440934 824900 526086 525457 493733 667903 795300 742753 392880 518148 563548 807340 523831 427981 438001 465635 489495 475889 536655 562599 411863 461605 521243 400243 415602 425603 408765 432864 411689 449950 494317 796084 809357 401957 453348 469487 407628 451479 474447 519726 493162 174164 395577 409168 415849 824345 501362 554375 705451 667526 595425 600314 803001 740129 761036 418377 386813 390169 ] |
||||||||||||||||||||||||||||||
|
9.92 ms (5.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.48 ms (1.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature fucking boy"
]
|
||||||||||||||||||||||||||||||
|
3.34 ms (1.74%) |
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 72822 143195 174164 187289 365875 383449 386813 388365 388436 388537 390169 391564 392880 395577 400243 401957 404078 407558 407628 408263 408765 409081 409168 409356 409390 411689 411820 411863 415602 415849 418377 425603 427981 429416 432864 438001 439484 439679 440390 440934 445709 449950 451443 451479 451713 453348 456831 457463 461605 465201 465635 467536 469410 469487 471452 474447 475889 477980 480045 482230 483360 484655 484659 485679 485945 486915 489495 491463 492689 493162 493733 494317 497363 501362 504028 506051 514740 518148 519726 521243 523831 525457 526086 536655 546977 554375 562599 563548 595425 600314 610142 622387 624789 635946 649249 663214 663935 664823 665210 667526 667555 667903 705451 726517 732236 740129 742753 761036 795300 796084 796091 803001 807329 807340 809357 815865 818503 824345 824900 825812 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature fucking парен"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature fucking парен"
]
|
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.