Query Metrics
7
Database Queries
7
Different statements
178.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.53 ms (83.32%) |
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 79520 91578 152765 231163 388241 388773 388850 389132 394161 395258 400325 402941 432402 432408 439691 441518 454255 464885 470635 479074 484995 486271 496357 506088 507229 509246 514108 514348 518499 518912 521627 525980 536438 537215 540888 546148 553645 555110 559748 559994 564695 567591 571506 573514 577214 580251 582591 584291 585307 585783 586558 588016 589277 591411 591705 591965 594517 598907 603606 604452 608620 610063 617377 625107 626184 628026 628506 638446 671461 673241 674282 685318 688799 689947 695777 716773 717062 725533 727021 727543 736465 739938 741514 742534 745954 747899 748441 749658 750235 752744 752783 757233 757250 761361 766478 769311 778476 790817 791848 794475 794582 796498 800392 800635 800830 800855 801584 802376 802652 808052 809503 810037 810323 814712 817798 824701 ] |
||||||||||||||||||||||||||||||
|
19.38 ms (10.87%) |
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 402941 628506 810037 747899 567591 536438 518499 484995 464885 496357 809503 739938 716773 585783 594517 752744 824701 454255 231163 617377 814712 553645 555110 400325 591411 546148 608620 794582 757233 808052 486271 796498 800392 727021 810323 441518 748441 589277 573514 584291 586558 769311 394161 514348 689947 685318 638446 625107 791848 800635 388850 439691 525980 626184 585307 671461 603606 388773 518912 571506 509246 591705 766118 817798 742534 674282 800830 801584 432402 761361 521627 794475 559994 778476 610063 628026 395258 564695 749658 580251 802652 479074 800855 577214 673241 744936 741514 757250 470635 389132 582591 588016 91578 750235 152765 506088 695777 598907 717062 514108 388241 537215 591965 604452 790817 736465 757048 752783 764183 745954 432408 802376 727543 559748 688799 766478 507229 79520 725533 540888 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.74%) |
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 79520 91578 152765 231163 388241 388773 388850 389132 394161 395258 400325 402941 432402 432408 439691 441518 454255 464885 470635 479074 484995 486271 496357 506088 507229 509246 514108 514348 518499 518912 521627 525980 536438 537215 540888 546148 553645 555110 559748 559994 564695 567591 571506 573514 577214 580251 582591 584291 585307 585783 586558 588016 589277 591411 591705 591965 594517 598907 603606 604452 608620 610063 617377 625107 626184 628026 628506 638446 671461 673241 674282 685318 688799 689947 695777 716773 717062 725533 727021 727543 736465 739938 741514 742534 745954 747899 748441 749658 750235 752744 752783 757233 757250 761361 766478 769311 778476 790817 791848 794475 794582 796498 800392 800635 800830 800855 801584 802376 802652 808052 809503 810037 810323 814712 817798 824701 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife ass fuck"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.95%) |
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.