Query Metrics
7
Database Queries
7
Different statements
149.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.62 ms (81.56%) |
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 142493 154157 187717 191254 306089 310679 358264 389726 389966 398553 399738 402131 404028 411362 411547 424013 429895 432582 439528 439542 440440 444684 448404 460069 460226 465385 466049 466206 466209 466256 470191 470949 485275 487880 488402 490414 491636 493535 503845 515977 517711 518594 521130 521210 530011 531699 534959 547764 547862 558441 561386 567338 573801 579876 581251 584353 586931 591042 592462 593342 596872 598169 599153 604823 606202 609229 619544 620157 623978 643542 668597 670947 671749 678767 703540 716903 717007 720719 721700 725180 729700 736776 737726 739668 748478 752134 756685 758304 758701 760998 761469 761784 766693 766872 777031 787637 790229 790840 791626 794941 796062 796092 799077 800616 800800 806078 811681 813005 815184 815320 816067 817556 817613 819411 823151 824182 826157 826166 828535 828873 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (10.96%) |
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 439528 389726 717007 736776 756685 191254 440440 596872 399738 599153 488402 817556 824182 826166 819411 826157 828873 521210 531699 668597 547862 593342 777031 800800 790840 800616 758701 758304 725180 402131 398553 515977 558441 154157 310679 790229 739668 796062 760998 752134 465385 517711 503845 485275 389966 187717 591042 460226 606202 620157 547764 567338 670947 598169 623978 787637 806078 811681 737726 466256 466209 466049 521130 444684 609229 142493 404028 448404 432582 823151 487880 604823 643542 748478 766872 766693 791626 799077 813005 761784 796092 761469 470949 518594 429895 721700 358264 817613 828535 581251 794941 729700 411547 579876 460069 424013 561386 678767 470191 466206 573801 439542 411362 490414 491636 530011 619544 493535 306089 816067 815320 815184 534959 584353 671749 716903 720719 703540 586931 592462 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.16%) |
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 142493 154157 187717 191254 306089 310679 358264 389726 389966 398553 399738 402131 404028 411362 411547 424013 429895 432582 439528 439542 440440 444684 448404 460069 460226 465385 466049 466206 466209 466256 470191 470949 485275 487880 488402 490414 491636 493535 503845 515977 517711 518594 521130 521210 530011 531699 534959 547764 547862 558441 561386 567338 573801 579876 581251 584353 586931 591042 592462 593342 596872 598169 599153 604823 606202 609229 619544 620157 623978 643542 668597 670947 671749 678767 703540 716903 717007 720719 721700 725180 729700 736776 737726 739668 748478 752134 756685 758304 758701 760998 761469 761784 766693 766872 777031 787637 790229 790840 791626 794941 796062 796092 799077 800616 800800 806078 811681 813005 815184 815320 816067 817556 817613 819411 823151 824182 826157 826166 828535 828873 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в анал в чулках мамки"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал чулк нижн бел мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.17%) |
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.