Query Metrics
7
Database Queries
7
Different statements
141.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.36 ms (82.47%) |
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 24149 167756 382950 385590 385607 389525 389899 420499 421310 422618 422747 422769 422859 423023 423062 423243 423266 427494 428960 429569 429628 435648 440646 446893 447853 447908 453081 454741 456005 456132 456400 457209 457274 457812 460020 462573 472952 473756 477404 478028 483230 484374 486837 496441 503797 505384 507258 510579 510580 512200 512210 512213 512955 513802 540175 540187 546086 551950 551953 552021 552913 552935 556379 556382 558367 559854 564771 565480 565993 566605 572734 572740 572744 577695 579347 580649 590924 591720 591836 591955 592027 600583 602559 609992 610201 613857 619412 619417 619445 619452 622266 622622 622652 622655 622656 623510 623606 629111 629319 639310 642442 650953 653192 662071 666722 671724 673048 702582 702609 712144 712154 712187 735852 737105 740362 743901 767284 776008 825368 825405 ] |
||||||||||||||||||||||||||||||
|
14.78 ms (10.48%) |
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 580649 662071 673048 712154 653192 552021 552913 622266 622656 639310 737105 735852 767284 420499 422859 510579 825368 457274 478028 558367 565993 566605 702582 556382 743901 650953 423243 435648 456005 454741 505384 551950 613857 666722 429628 602559 385607 385590 382950 167756 24149 422747 440646 422618 457812 462573 447908 456132 457209 460020 447853 483230 496441 540187 510580 540175 507258 472952 473756 552935 564771 565480 572744 577695 572740 579347 556379 712187 671724 590924 622652 591720 619445 619452 622655 642442 610201 619417 592027 609992 619412 622622 740362 623510 623606 629111 629319 776008 453081 423062 429569 456400 422769 512210 503797 486837 484374 389899 423023 477404 423266 389525 825405 446893 513802 512200 551953 546086 572734 702609 712144 559854 591836 591955 600583 428960 421310 427494 512955 512213 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.94%) |
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 24149 167756 382950 385590 385607 389525 389899 420499 421310 422618 422747 422769 422859 423023 423062 423243 423266 427494 428960 429569 429628 435648 440646 446893 447853 447908 453081 454741 456005 456132 456400 457209 457274 457812 460020 462573 472952 473756 477404 478028 483230 484374 486837 496441 503797 505384 507258 510579 510580 512200 512210 512213 512955 513802 540175 540187 546086 551950 551953 552021 552913 552935 556379 556382 558367 559854 564771 565480 565993 566605 572734 572740 572744 577695 579347 580649 590924 591720 591836 591955 592027 600583 602559 609992 610201 613857 619412 619417 619445 619452 622266 622622 622652 622655 622656 623510 623606 629111 629319 639310 642442 650953 653192 662071 666722 671724 673048 702582 702609 712144 712154 712187 735852 737105 740362 743901 767284 776008 825368 825405 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy asian"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.14%) |
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.