Query Metrics
7
Database Queries
7
Different statements
200.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.59 ms (86.17%) |
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 12731 21594 29429 95864 96843 123554 123955 191356 206202 223551 310715 334950 382129 382438 383491 385799 386408 386460 390437 395740 396015 396234 396936 396951 398756 399162 404240 404615 406621 406992 408241 411943 412189 413597 417837 422227 423567 433212 443685 447962 451015 451798 456445 460684 464165 464949 470504 473981 478618 487383 487582 487746 490227 491272 496117 503831 504252 514718 521993 531164 538449 543232 545586 558786 562888 573394 576685 584710 585013 597852 610007 613872 624225 625400 628416 628707 631185 633051 636545 644259 650843 663444 665497 669410 670820 672469 680691 684914 694641 699621 704044 707434 710832 721072 721738 724411 724528 726252 731431 733178 748715 756234 758603 758972 770143 770790 770820 790961 792493 792627 797849 798797 800049 807191 807518 809934 810685 810694 817518 ] |
||||||||||||||||||||||||||||||
|
16.75 ms (8.36%) |
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 665497 721738 724411 731431 770143 800049 726252 733178 756234 748715 770790 624225 721072 792493 809934 123554 422227 12731 396951 412189 487746 807191 824207 585013 538449 704044 610007 625400 810685 810694 633051 385799 206202 223551 310715 334950 382129 390437 396015 398756 399162 406621 417837 413597 406992 408241 470504 447962 451798 464165 451015 464949 531164 514718 504252 478618 576685 663444 707434 650843 669410 680691 684914 670820 694641 710832 562888 584710 613872 631185 628416 644259 597852 628707 807518 792627 724528 758972 636545 699621 797849 382438 386460 404240 423567 95864 96843 383491 395740 396234 460684 191356 443685 473981 404615 456445 491272 490227 496117 521993 487582 386408 123955 21594 29429 396936 817518 543232 790961 758603 770820 798797 411943 558786 672469 545586 433212 487383 503831 573394 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (1.85%) |
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 12731 21594 29429 95864 96843 123554 123955 191356 206202 223551 310715 334950 382129 382438 383491 385799 386408 386460 390437 395740 396015 396234 396936 396951 398756 399162 404240 404615 406621 406992 408241 411943 412189 413597 417837 422227 423567 433212 443685 447962 451015 451798 456445 460684 464165 464949 470504 473981 478618 487383 487582 487746 490227 491272 496117 503831 504252 514718 521993 531164 538449 543232 545586 558786 562888 573394 576685 584710 585013 597852 610007 613872 624225 625400 628416 628707 631185 633051 636545 644259 650843 663444 665497 669410 670820 672469 680691 684914 694641 699621 704044 707434 710832 721072 721738 724411 724528 726252 731431 733178 748715 756234 758603 758972 770143 770790 770820 790961 792493 792627 797849 798797 800049 807191 807518 809934 810685 810694 817518 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно секс ролики"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн секс ролик"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.72%) |
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.