Query Metrics
7
Database Queries
7
Different statements
375.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.46 ms (56.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая волосатая вагин"
]
|
||||||||||||||||||||||||||||||
|
138.40 ms (36.89%) |
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 382188 384491 386735 391715 395496 395659 395682 395703 395759 396110 400438 400621 401103 401361 402997 403240 404576 408060 408585 409316 415029 415584 416371 418371 420912 424407 424850 425294 426868 428653 429200 429261 430285 430379 435748 435830 445051 445930 448726 449579 449623 450147 457498 457755 457947 458498 458504 459997 460501 460653 462807 465981 466459 466630 468471 468910 469432 470734 470788 473108 473774 477335 477409 477553 481942 484498 485091 485307 485885 491587 492182 493150 494530 496066 497225 498668 498875 498890 499829 500324 503905 504054 505719 509457 510662 511815 512051 517488 522409 522830 526888 529307 549308 550019 551951 552045 559876 560341 561388 561730 562904 567002 570274 576339 586619 592395 593750 595819 601524 601813 613391 618734 639637 644286 684304 708292 722463 784705 786026 787530 ] |
||||||||||||||||||||||||||||||
|
15.77 ms (4.20%) |
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 613391 618734 644286 722463 784705 786026 787530 395659 401103 418371 505719 503905 477335 391715 459997 561730 448726 395682 468910 469432 497225 435748 458504 493150 500324 529307 499829 684304 570274 595819 601813 401361 400621 449623 430379 457755 494530 586619 484498 384491 395759 426868 429261 445051 450147 466459 445930 477553 458498 576339 409316 415029 477409 386735 395703 424407 462807 466630 415584 470734 457947 504054 510662 498668 512051 429200 408060 435830 460501 498890 517488 492182 549308 551951 559876 561388 550019 639637 424850 468471 428653 449579 562904 395496 402997 481942 408585 457498 526888 496066 396110 473774 460653 485885 560341 567002 708292 552045 592395 593750 601524 382188 425294 430285 470788 473108 404576 465981 420912 400438 403240 416371 511815 522830 485091 491587 509457 522409 485307 498875 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (0.70%) |
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 382188 384491 386735 391715 395496 395659 395682 395703 395759 396110 400438 400621 401103 401361 402997 403240 404576 408060 408585 409316 415029 415584 416371 418371 420912 424407 424850 425294 426868 428653 429200 429261 430285 430379 435748 435830 445051 445930 448726 449579 449623 450147 457498 457755 457947 458498 458504 459997 460501 460653 462807 465981 466459 466630 468471 468910 469432 470734 470788 473108 473774 477335 477409 477553 481942 484498 485091 485307 485885 491587 492182 493150 494530 496066 497225 498668 498875 498890 499829 500324 503905 504054 505719 509457 510662 511815 512051 517488 522409 522830 526888 529307 549308 550019 551951 552045 559876 560341 561388 561730 562904 567002 570274 576339 586619 592395 593750 595819 601524 601813 613391 618734 639637 644286 684304 708292 722463 784705 786026 787530 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красивые волосатые пи…"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая волосатая вагин"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.40%) |
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.