Query Metrics
7
Database Queries
7
Different statements
153.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.16 ms (82.93%) |
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 23104 385370 385448 387268 387315 396451 406578 409958 415298 415623 418646 418648 420613 421360 422513 422529 422557 422589 422618 422641 422709 422711 422901 422949 422958 422993 423006 423019 423022 423023 423211 423258 423261 423264 423280 424946 429535 429543 432136 433610 445472 446266 456400 456633 456847 462253 462304 469576 471355 472962 477409 489806 500077 510578 520629 530348 530358 531554 537568 540175 550712 559869 566009 572727 572744 583677 586624 591720 601658 608009 610201 614731 619417 619432 619452 621025 622622 622625 623512 624831 629111 630015 632682 642816 644697 652548 658224 658225 688606 692389 694129 694609 694610 712722 713526 717845 720299 720306 721368 740536 744704 745764 748643 748681 748684 748685 761580 762718 765710 773024 775979 776008 785021 789947 805168 808732 810242 818936 827862 ] |
||||||||||||||||||||||||||||||
|
16.29 ms (10.62%) |
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 632682 621025 622625 415623 387315 530358 583677 422589 429535 550712 652548 614731 630015 619432 785021 775979 808732 720299 644697 422709 422901 420613 446266 456633 422949 387268 818936 423258 748684 462304 520629 530348 559869 572727 694129 721368 789947 765710 761580 748681 740536 762718 773024 422641 469576 418648 409958 489806 423019 422993 423006 423023 424946 744704 423022 433610 423280 422711 500077 712722 406578 385370 23104 423261 421360 445472 462253 510578 608009 422529 429543 471355 472962 422958 422513 385448 423211 422618 423264 422557 456847 540175 572744 694609 694610 658224 713526 658225 688606 692389 717845 720306 624831 586624 591720 619452 642816 610201 619417 601658 622622 623512 805168 810242 748685 629111 776008 418646 477409 432136 456400 396451 827862 785193 748643 531554 537568 566009 745764 415298 ] |
||||||||||||||||||||||||||||||
|
2.87 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 23104 385370 385448 387268 387315 396451 406578 409958 415298 415623 418646 418648 420613 421360 422513 422529 422557 422589 422618 422641 422709 422711 422901 422949 422958 422993 423006 423019 423022 423023 423211 423258 423261 423264 423280 424946 429535 429543 432136 433610 445472 446266 456400 456633 456847 462253 462304 469576 471355 472962 477409 489806 500077 510578 520629 530348 530358 531554 537568 540175 550712 559869 566009 572727 572744 583677 586624 591720 601658 608009 610201 614731 619417 619432 619452 621025 622622 622625 623512 624831 629111 630015 632682 642816 644697 652548 658224 658225 688606 692389 694129 694609 694610 712722 713526 717845 720299 720306 721368 740536 744704 745764 748643 748681 748684 748685 761580 762718 765710 773024 775979 776008 785021 789947 805168 808732 810242 818936 827862 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man asian"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин азиатк"
]
|
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.