Query Metrics
7
Database Queries
7
Different statements
254.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
233.38 ms (91.58%) |
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 70123 333653 382108 385508 392172 393047 402980 405815 416853 419890 423585 424521 435753 442472 445027 448684 452903 452915 454780 456166 457546 458642 468722 470979 473040 476620 476942 479873 485605 491337 494553 498340 498557 502762 504950 524395 527179 527616 529884 530498 531053 541670 544941 550334 552295 554128 556261 558539 560260 575840 575859 575910 576495 579451 580218 582552 582678 585554 585781 589907 589922 589931 589945 590067 590089 590100 598508 600104 602626 608121 612703 619714 620901 629645 645644 646016 650786 660079 662512 666439 686203 690961 693564 709037 711710 715899 720186 724978 725980 727844 728630 734002 737025 738835 748716 753672 754170 756640 761645 762123 763087 764817 772204 772360 778212 782150 782535 783176 783858 785752 790634 791298 792441 796712 798725 802369 804121 805160 808725 827825 ] |
||||||||||||||||||||||||||||||
|
12.53 ms (4.92%) |
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 772360 756640 470979 423585 445027 476620 473040 502762 527179 524395 527616 333653 70123 402980 416853 827825 457546 476942 479873 494553 529884 530498 531053 575840 575859 580218 582678 541670 650786 690961 660079 709037 666439 715899 585781 589945 608121 602626 585554 589931 590089 598508 590100 600104 791298 798725 785752 790634 724978 725980 727844 737025 792441 764817 753672 754170 772204 761645 802369 808725 468722 424521 498557 485605 393047 442472 456166 448684 556261 645644 711710 686203 646016 662512 589922 590067 778212 783858 782150 783176 804121 805160 762123 728630 734002 738835 748716 763087 782535 796712 382108 454780 385508 392172 405815 435753 419890 452915 458642 491337 452903 504950 498340 550334 560260 579451 582552 554128 575910 544941 576495 693564 720186 552295 558539 589907 612703 619714 620901 629645 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.03%) |
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 70123 333653 382108 385508 392172 393047 402980 405815 416853 419890 423585 424521 435753 442472 445027 448684 452903 452915 454780 456166 457546 458642 468722 470979 473040 476620 476942 479873 485605 491337 494553 498340 498557 502762 504950 524395 527179 527616 529884 530498 531053 541670 544941 550334 552295 554128 556261 558539 560260 575840 575859 575910 576495 579451 580218 582552 582678 585554 585781 589907 589922 589931 589945 590067 590089 590100 598508 600104 602626 608121 612703 619714 620901 629645 645644 646016 650786 660079 662512 666439 686203 690961 693564 709037 711710 715899 720186 724978 725980 727844 728630 734002 737025 738835 748716 753672 754170 756640 761645 762123 763087 764817 772204 772360 778212 782150 782535 783176 783858 785752 790634 791298 792441 796712 798725 802369 804121 805160 808725 827825 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"perfect вагин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"perfect vagina"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"perfect вагин"
]
|
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.