Query Metrics
7
Database Queries
7
Different statements
694.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
239.01 ms (34.41%) |
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 4279 9853 265858 314850 382204 395174 396279 398451 401585 402259 418226 419972 422043 423981 423987 424000 426316 427113 428616 431719 432404 432479 432531 432624 433039 433078 434261 441194 441644 447881 451568 451787 452017 452692 455551 455620 456236 457569 457761 459298 460930 461256 465926 466904 468105 468256 472847 474845 476668 478247 483342 485295 487008 488023 488603 489579 491982 492013 492616 494546 494943 499806 500377 500746 503682 505716 505996 506590 512500 517662 520490 520501 520640 522122 522332 522578 522953 525668 525883 528733 528946 531278 533806 538687 541484 543353 552966 554607 556496 560302 560329 569589 573919 579396 580329 585455 588710 591107 597060 598388 602882 605457 615836 623124 625446 626569 650749 681773 706640 718985 740224 750195 751321 752842 762345 784510 785327 806596 817976 818241 ] |
||||||||||||||||||||||||||||||
|
216.88 ms (31.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
216.78 ms (31.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
15.74 ms (2.27%) |
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 505716 494943 500377 580329 585455 488023 531278 512500 432531 525883 533806 538687 650749 706640 806596 784510 751321 752842 750195 785327 762345 506590 483342 451787 441644 465926 427113 398451 573919 451568 528733 452017 9853 818241 817976 681773 718985 602882 740224 265858 314850 396279 556496 459298 422043 426316 452692 472847 474845 455620 488603 505996 517662 466904 476668 560302 560329 569589 588710 598388 623124 591107 382204 402259 424000 431719 457761 441194 447881 455551 401585 418226 423987 395174 432624 461256 468105 468256 491982 503682 489579 492013 520490 520640 485295 4279 520501 543353 625446 423981 428616 419972 457569 494546 528946 525668 499806 522332 487008 554607 579396 541484 552966 597060 605457 615836 626569 432404 432479 434261 456236 433078 433039 478247 460930 522953 500746 522122 492616 522578 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (0.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 4279 9853 265858 314850 382204 395174 396279 398451 401585 402259 418226 419972 422043 423981 423987 424000 426316 427113 428616 431719 432404 432479 432531 432624 433039 433078 434261 441194 441644 447881 451568 451787 452017 452692 455551 455620 456236 457569 457761 459298 460930 461256 465926 466904 468105 468256 472847 474845 476668 478247 483342 485295 487008 488023 488603 489579 491982 492013 492616 494546 494943 499806 500377 500746 503682 505716 505996 506590 512500 517662 520490 520501 520640 522122 522332 522578 522953 525668 525883 528733 528946 531278 533806 538687 541484 543353 552966 554607 556496 560302 560329 569589 573919 579396 580329 585455 588710 591107 597060 598388 602882 605457 615836 623124 625446 626569 650749 681773 706640 718985 740224 750195 751321 752842 762345 784510 785327 806596 817976 818241 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens stockings"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.23%) |
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.