Query Metrics
7
Database Queries
7
Different statements
159.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.26 ms (84.59%) |
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 392937 419435 420021 423935 425312 427372 429692 429859 429869 429875 435485 437970 439688 464550 469104 470064 480501 480671 490400 490731 492758 494667 499525 499681 507643 510763 511388 513010 513490 519362 519366 528793 537237 538603 542215 543993 544527 544788 544874 547741 547768 547787 549655 552382 552805 555020 555048 555062 561377 563688 564755 568673 572190 575897 584830 599879 605734 605737 605739 618316 619903 623983 647111 652878 662526 663286 667011 669856 669858 669860 669890 672829 687312 696776 700462 700830 702864 706889 710862 714316 714350 718771 739556 741368 741716 741770 742331 744209 750739 751531 763738 763744 765830 765854 765870 774575 778130 778563 794030 800727 800753 800754 803142 804422 805129 805136 806973 807009 807594 808468 812180 816168 818173 824000 825432 825795 826706 826832 827539 827722 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (9.09%) |
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 480501 490400 510763 511388 513490 499525 492758 528793 555020 555048 555062 429869 464550 490731 507643 423935 439688 429859 816168 538603 519366 544527 549655 552382 542215 547741 561377 563688 543993 547787 564755 572190 706889 714316 718771 667011 687312 696776 663286 547768 605734 605737 623983 599879 605739 618316 778563 794030 800727 805129 805136 807009 800753 806973 808468 741368 741716 741770 800754 807594 742331 744209 750739 765854 765870 739556 751531 763744 765830 763738 619903 700462 774575 778130 803142 804422 812180 419435 420021 427372 429875 469104 480671 437970 429692 425312 435485 519362 513010 544788 662526 470064 392937 826706 818173 825795 826832 827722 827539 824000 825432 494667 499681 537237 575897 584830 552805 544874 568673 652878 669860 672829 710862 647111 669856 669858 669890 700830 702864 714350 ] |
||||||||||||||||||||||||||||||
|
3.00 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 392937 419435 420021 423935 425312 427372 429692 429859 429869 429875 435485 437970 439688 464550 469104 470064 480501 480671 490400 490731 492758 494667 499525 499681 507643 510763 511388 513010 513490 519362 519366 528793 537237 538603 542215 543993 544527 544788 544874 547741 547768 547787 549655 552382 552805 555020 555048 555062 561377 563688 564755 568673 572190 575897 584830 599879 605734 605737 605739 618316 619903 623983 647111 652878 662526 663286 667011 669856 669858 669860 669890 672829 687312 696776 700462 700830 702864 706889 710862 714316 714350 718771 739556 741368 741716 741770 742331 744209 750739 751531 763738 763744 765830 765854 765870 774575 778130 778563 794030 800727 800753 800754 803142 804422 805129 805136 806973 807009 807594 808468 812180 816168 818173 824000 825432 825795 826706 826832 827539 827722 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло русских женщин"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло русск женщин"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.93%) |
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.