Query Metrics
7
Database Queries
7
Different statements
160.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.47 ms (87.32%) |
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 443830 469092 477081 486810 505387 506765 507643 511314 513623 517535 517538 523881 527923 528512 530092 530412 530568 530651 531058 531789 531892 531986 532134 533700 534586 535381 535407 535409 535601 536082 536756 540563 542728 546422 547411 547415 547492 547809 553221 554490 554543 554992 555046 555205 555210 555319 555752 555760 555761 556769 558173 559355 563970 566568 570883 575297 576574 577185 582321 584620 588401 590134 592922 593065 597730 603377 606051 607703 612276 614360 615950 617115 617805 618682 629205 632094 637462 639647 643447 660397 667397 681227 700900 701235 704911 708530 710732 715111 715133 716490 724649 732855 752078 758079 761946 762186 765497 765634 770194 780668 802919 803503 803510 803542 803544 803883 804423 804430 804431 804486 808125 808164 810097 812534 812535 812541 812555 819861 826603 827399 ] |
||||||||||||||||||||||||||||||
|
10.54 ms (6.55%) |
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 547415 555205 555210 555761 575297 667397 555319 590134 614360 810097 804423 812534 812535 812555 724649 770194 765497 761946 765634 629205 803510 513623 511314 592922 597730 617805 612276 527923 507643 563970 553221 802919 517538 532134 531986 554543 577185 584620 708530 710732 681227 704911 700900 715111 603377 615950 643447 606051 593065 607703 637462 639647 632094 701235 617115 826603 819861 827399 530412 535409 536082 530651 531058 531892 533700 535601 530092 535407 536756 535381 555760 556769 570883 566568 716490 576574 588401 804430 808164 804431 803883 808125 762186 752078 618682 715133 780668 803503 803542 803544 804486 758079 530568 540563 547411 660397 812541 732855 443830 528512 506765 477081 469092 486810 523881 534586 505387 517535 531789 542728 547809 555046 546422 554490 582321 547492 554992 555752 558173 559355 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur solo mature"
]
|
||||||||||||||||||||||||||||||
|
2.25 ms (1.40%) |
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 443830 469092 477081 486810 505387 506765 507643 511314 513623 517535 517538 523881 527923 528512 530092 530412 530568 530651 531058 531789 531892 531986 532134 533700 534586 535381 535407 535409 535601 536082 536756 540563 542728 546422 547411 547415 547492 547809 553221 554490 554543 554992 555046 555205 555210 555319 555752 555760 555761 556769 558173 559355 563970 566568 570883 575297 576574 577185 582321 584620 588401 590134 592922 593065 597730 603377 606051 607703 612276 614360 615950 617115 617805 618682 629205 632094 637462 639647 643447 660397 667397 681227 700900 701235 704911 708530 710732 715111 715133 716490 724649 732855 752078 758079 761946 762186 765497 765634 770194 780668 802919 803503 803510 803542 803544 803883 804423 804430 804431 804486 808125 808164 810097 812534 812535 812541 812555 819861 826603 827399 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск соло mature"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск соло 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.