Query Metrics
7
Database Queries
7
Different statements
178.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.78 ms (80.14%) |
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 383722 388642 398467 412541 421817 427897 437175 439808 444888 446908 448971 450910 452677 454972 456328 458788 461730 461795 467053 473177 474125 484119 484225 485706 488556 494837 499072 500701 505106 505796 509740 510345 510575 513575 515699 516325 516632 517343 517736 517824 518118 518501 519203 521138 522705 523436 524310 525169 526280 526316 527519 528864 528911 529106 529111 529126 536414 537148 543404 543554 545692 547523 548232 552296 552414 554415 554863 559348 559734 561481 563042 565738 566939 567112 569194 569312 569442 571349 572211 575784 577332 578723 581855 582053 582680 585756 588988 591694 598246 598602 599061 599277 601456 601852 606162 606836 609096 613202 614565 618759 621305 624090 624139 636559 659407 659451 663935 665479 667876 678778 692253 714470 720610 731767 780710 784669 788229 804940 808160 814621 ] |
||||||||||||||||||||||||||||||
|
16.60 ms (9.31%) |
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 499072 452677 517736 524310 474125 569194 582053 609096 458788 678778 621305 636559 510345 569442 618759 505796 528911 523436 585756 485706 484225 601456 547523 446908 517824 529126 543404 554863 559734 591694 598602 421817 444888 613202 516632 510575 554415 528864 516325 526280 563042 814621 663935 667876 804940 731767 780710 581855 383722 714470 788229 808160 784669 513575 398467 565738 454972 526316 572211 545692 566939 659451 588988 598246 461795 488556 529111 548232 518118 582680 578723 388642 461730 519203 552296 577332 624090 439808 614565 659407 536414 599061 517343 500701 561481 601852 521138 509740 412541 529106 505106 527519 473177 543554 567112 575784 606162 624139 456328 484119 525169 494837 522705 427897 518501 569312 606836 448971 450910 437175 552414 571349 515699 537148 559348 665479 692253 720610 599277 467053 ] |
||||||||||||||||||||||||||||||
|
4.24 ms (2.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бабушк куннилингус оральн секс стринг нижн бел"
]
|
||||||||||||||||||||||||||||||
|
4.23 ms (2.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
4.09 ms (2.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"старушки куни стринги…"
]
|
||||||||||||||||||||||||||||||
|
3.78 ms (2.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бабушк куннилингус оральн секс стринг нижн бел"
]
|
||||||||||||||||||||||||||||||
|
2.45 ms (1.38%) |
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 383722 388642 398467 412541 421817 427897 437175 439808 444888 446908 448971 450910 452677 454972 456328 458788 461730 461795 467053 473177 474125 484119 484225 485706 488556 494837 499072 500701 505106 505796 509740 510345 510575 513575 515699 516325 516632 517343 517736 517824 518118 518501 519203 521138 522705 523436 524310 525169 526280 526316 527519 528864 528911 529106 529111 529126 536414 537148 543404 543554 545692 547523 548232 552296 552414 554415 554863 559348 559734 561481 563042 565738 566939 567112 569194 569312 569442 571349 572211 575784 577332 578723 581855 582053 582680 585756 588988 591694 598246 598602 599061 599277 601456 601852 606162 606836 609096 613202 614565 618759 621305 624090 624139 636559 659407 659451 663935 665479 667876 678778 692253 714470 720610 731767 780710 784669 788229 804940 808160 814621 ] |
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.