Query Metrics
7
Database Queries
7
Different statements
198.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.27 ms (84.30%) |
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 111260 151018 162000 187843 188338 188455 188669 358592 379600 389500 389785 394420 397214 398484 398552 398969 400489 401006 409934 411704 411868 411893 414782 421945 424248 424436 428142 428817 433353 439746 439758 439791 439821 439824 440222 441000 441774 441910 442814 443768 444145 444917 454232 457450 457468 459837 461322 464975 465545 465958 466015 466228 466877 467103 468121 468348 470215 472688 474104 474109 475883 476349 478420 478582 479102 479769 483646 483655 484564 486340 487315 496873 498491 506836 514761 516469 516480 521160 523845 525479 531900 532271 536431 549836 554463 560400 565275 584059 599710 609071 619614 642290 663772 670902 718524 718538 726847 731100 733265 740647 749234 758444 758792 759717 761046 761056 767257 768730 770149 776995 782407 788546 792670 794863 796566 796808 799351 824442 825143 826531 ] |
||||||||||||||||||||||||||||||
|
20.19 ms (10.17%) |
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 439791 439821 440222 442814 151018 111260 162000 188455 826531 467103 468121 521160 479769 554463 663772 599710 465545 188338 394420 358592 478582 397214 411893 506836 474109 466015 470215 487315 584059 389500 441910 514761 464975 465958 411868 400489 433353 536431 516480 441774 670902 767257 768730 731100 718538 794863 409934 496873 472688 479102 443768 398969 474104 379600 398484 411704 444145 428817 483655 523845 484564 483646 398552 825143 824442 733265 759717 718524 782407 796808 459837 758444 414782 776995 389785 478420 441000 525479 516469 476349 560400 619614 424436 439758 466228 475883 428142 466877 188669 401006 421945 439746 439824 457450 454232 486340 498491 444917 187843 424248 461322 468348 531900 532271 549836 565275 609071 642290 799351 740647 788546 796566 726847 758792 761046 749234 770149 761056 792670 457468 ] |
||||||||||||||||||||||||||||||
|
3.76 ms (1.89%) |
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 111260 151018 162000 187843 188338 188455 188669 358592 379600 389500 389785 394420 397214 398484 398552 398969 400489 401006 409934 411704 411868 411893 414782 421945 424248 424436 428142 428817 433353 439746 439758 439791 439821 439824 440222 441000 441774 441910 442814 443768 444145 444917 454232 457450 457468 459837 461322 464975 465545 465958 466015 466228 466877 467103 468121 468348 470215 472688 474104 474109 475883 476349 478420 478582 479102 479769 483646 483655 484564 486340 487315 496873 498491 506836 514761 516469 516480 521160 523845 525479 531900 532271 536431 549836 554463 560400 565275 584059 599710 609071 619614 642290 663772 670902 718524 718538 726847 731100 733265 740647 749234 758444 758792 759717 761046 761056 767257 768730 770149 776995 782407 788546 792670 794863 796566 796808 799351 824442 825143 826531 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby mature анал"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby mature anal"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby mature анал"
]
|
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.