Query Metrics
7
Database Queries
7
Different statements
1027.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
672.46 ms (65.44%) |
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 474072 398784 459600 391881 447083 498900 504251 513282 400463 570051 597043 473979 512754 185714 414962 453860 551256 495549 493553 549762 471331 476749 477146 482767 558599 552211 572467 561669 552248 562226 573826 480028 441759 461150 470334 425889 461776 473905 477908 481187 480831 456262 503706 541734 492818 486833 494396 498822 482763 596670 412528 537960 483213 778970 392632 559021 563359 572755 595398 596619 590609 397065 470484 475597 486465 490619 562248 496959 413180 547389 802622 760909 413199 444221 500747 562277 561270 565589 598674 598700 598503 596673 462231 471169 381775 400723 448340 449590 412134 529463 512303 524010 398801 500741 552425 412515 428259 448359 443736 477137 570040 572363 573543 573596 570198 570506 573675 573711 573954 574588 563993 570280 570307 560942 570204 578997 462728 479613 402219 439049 ] |
||||||||||||||||||||||||||||||
|
208.71 ms (20.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐÇÐâÐüÐüð║ð░ÐÅ ÐàÐâð┤ÐïðÁ ð┤ðÁð▓ÐâÐêð║ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
137.91 ms (13.42%) |
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 185714 381775 391881 392632 397065 398784 398801 400463 400723 402219 412134 412515 412528 413180 413199 414962 425889 428259 439049 441759 443736 444221 447083 448340 448359 449590 453860 456262 459600 461150 461776 462231 462728 470334 470484 471169 471331 473905 473979 474072 475597 476749 477137 477146 477908 479613 480028 480831 481187 482763 482767 483213 486465 486833 490619 492818 493553 494396 495549 496959 498822 498900 500741 500747 503706 504251 512303 512754 513282 524010 529463 537960 541734 547389 549762 551256 552211 552248 552425 558599 559021 560942 561270 561669 562226 562248 562277 563359 563993 565589 570040 570051 570198 570204 570280 570307 570506 572363 572467 572755 573543 573596 573675 573711 573826 573954 574588 578997 590609 595398 596619 596670 596673 597043 598503 598674 598700 760909 778970 802622 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (0.36%) |
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 185714 381775 391881 392632 397065 398784 398801 400463 400723 402219 412134 412515 412528 413180 413199 414962 425889 428259 439049 441759 443736 444221 447083 448340 448359 449590 453860 456262 459600 461150 461776 462231 462728 470334 470484 471169 471331 473905 473979 474072 475597 476749 477137 477146 477908 479613 480028 480831 481187 482763 482767 483213 486465 486833 490619 492818 493553 494396 495549 496959 498822 498900 500741 500747 503706 504251 512303 512754 513282 524010 529463 537960 541734 547389 549762 551256 552211 552248 552425 558599 559021 560942 561270 561669 562226 562248 562277 563359 563993 565589 570040 570051 570198 570204 570280 570307 570506 572363 572467 572755 573543 573596 573675 573711 573826 573954 574588 578997 590609 595398 596619 596670 596673 597043 598503 598674 598700 760909 778970 802622 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск худая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.14%) |
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.