Query Metrics
7
Database Queries
7
Different statements
145.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.19 ms (81.73%) |
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 383530 397494 413093 417833 421443 421555 421574 421618 422807 425149 426865 427575 429549 430558 432690 434786 442080 445460 445859 448362 450129 453434 453440 456597 457581 457702 461244 461751 463934 465405 466816 476526 496444 499516 515996 521041 541335 544535 553023 553256 558232 562409 567307 570955 571797 577930 579821 580134 580439 580572 582449 584088 586014 587885 589608 589633 590031 590112 593070 595245 596812 598088 598216 598907 599153 606974 615920 616056 620875 621246 621853 624196 627357 633651 638138 639083 640617 640672 642876 645527 648316 653039 656138 656651 693363 711988 729308 730668 731032 762430 763477 766572 766937 770615 776770 777260 777497 778017 782033 784740 785924 787977 790615 792050 794071 795469 797208 800652 800782 803896 808104 811086 811712 816180 817201 819864 827330 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (10.78%) |
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 808104 383530 580572 648316 693363 653039 553023 590112 616056 642876 776770 787977 800652 803896 811086 763477 769111 811712 595245 639083 615920 453434 426865 417833 589633 797208 800782 816180 827330 817201 656138 580134 571797 598216 413093 819864 645527 656651 633651 782033 766937 769682 764866 730668 421618 422807 427575 448362 476526 580439 541335 584088 586014 621853 596812 785924 777260 790615 792050 794071 762430 620875 784740 795469 430558 461751 711988 521041 582449 544535 397494 515996 640672 590031 778017 731032 766572 627357 638138 640617 777497 729308 421443 432690 453440 457702 499516 579821 593070 434786 421555 465405 425149 421574 442080 429549 445859 450129 461244 457581 463934 445460 456597 496444 466816 558232 553256 567307 570955 577930 562409 587885 589608 624196 598088 599153 621246 598907 770615 606974 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.17%) |
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 383530 397494 413093 417833 421443 421555 421574 421618 422807 425149 426865 427575 429549 430558 432690 434786 442080 445460 445859 448362 450129 453434 453440 456597 457581 457702 461244 461751 463934 465405 466816 476526 496444 499516 515996 521041 541335 544535 553023 553256 558232 562409 567307 570955 571797 577930 579821 580134 580439 580572 582449 584088 586014 587885 589608 589633 590031 590112 593070 595245 596812 598088 598216 598907 599153 606974 615920 616056 620875 621246 621853 624196 627357 633651 638138 639083 640617 640672 642876 645527 648316 653039 656138 656651 693363 711988 729308 730668 731032 762430 763477 766572 766937 770615 776770 777260 777497 778017 782033 784740 785924 787977 790615 792050 794071 795469 797208 800652 800782 803896 808104 811086 811712 816180 817201 819864 827330 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass pov doggy"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп пов рак"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп пов рак"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.