Query Metrics
7
Database Queries
7
Different statements
223.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.81 ms (87.75%) |
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 173238 382971 384960 412583 422515 422863 422947 427278 427851 428903 428944 431038 435443 439252 452781 463798 464690 467715 473055 478433 480788 491248 493423 493852 495167 499791 499885 500743 512222 516873 519497 519769 524369 528314 530661 533538 534023 534791 536340 541848 543874 546098 546783 547241 547768 550778 555532 555547 558175 559782 559890 567127 568617 572967 574243 579499 580129 580270 581898 584678 587307 590981 591440 593228 594570 595329 599789 599829 601194 601664 602573 603813 606493 613995 615447 615983 619446 623818 637318 642069 642164 643145 643411 644787 645526 645604 645669 645670 650948 665964 672212 672229 680706 694373 713706 729156 736507 736738 738691 740110 742370 746942 749693 751036 752700 754873 761289 766625 772507 783740 785707 792273 792621 804703 817679 819181 823818 824449 828324 828326 ] |
||||||||||||||||||||||||||||||
|
16.92 ms (7.58%) |
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 431038 602573 452781 412583 547241 672212 546098 422863 519769 550778 828326 427851 428944 435443 463798 491248 478433 567127 558175 680706 643145 749693 766625 555547 534791 543874 713706 672229 533538 536340 574243 619446 752700 581898 528314 817679 819181 824449 579499 642164 804703 729156 783740 754873 746942 645604 382971 603813 613995 623818 828324 823818 493423 665964 645670 593228 637318 785707 740110 751036 173238 580129 422515 422947 512222 427278 530661 643411 642069 519497 584678 645526 650948 792273 742370 500743 736507 772507 428903 590981 601664 473055 559890 694373 595329 644787 591440 736738 541848 467715 572967 599789 599829 384960 493852 499791 524369 499885 555532 547768 594570 606493 738691 761289 480788 580270 439252 464690 534023 495167 559782 645669 587307 615983 601194 792621 615447 546783 568617 516873 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.43%) |
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 173238 382971 384960 412583 422515 422863 422947 427278 427851 428903 428944 431038 435443 439252 452781 463798 464690 467715 473055 478433 480788 491248 493423 493852 495167 499791 499885 500743 512222 516873 519497 519769 524369 528314 530661 533538 534023 534791 536340 541848 543874 546098 546783 547241 547768 550778 555532 555547 558175 559782 559890 567127 568617 572967 574243 579499 580129 580270 581898 584678 587307 590981 591440 593228 594570 595329 599789 599829 601194 601664 602573 603813 606493 613995 615447 615983 619446 623818 637318 642069 642164 643145 643411 644787 645526 645604 645669 645670 650948 665964 672212 672229 680706 694373 713706 729156 736507 736738 738691 740110 742370 746942 749693 751036 752700 754873 761289 766625 772507 783740 785707 792273 792621 804703 817679 819181 823818 824449 828324 828326 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation asian"
]
|
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.