Query Metrics
7
Database Queries
7
Different statements
155.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.47 ms (85.08%) |
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 2651 119798 181043 346173 373859 388067 388202 390225 390418 392857 395354 397395 398299 398638 399038 399959 404023 408627 410129 412872 420353 420385 421315 421967 424238 425686 426777 429855 432374 432529 432563 433890 434093 436694 441613 444179 444655 445360 445642 449281 450046 450398 451532 453976 455398 457577 458464 459571 459631 461115 462670 463403 471679 471980 476768 478258 478561 479268 487263 487820 489768 492906 493338 499421 499467 504834 509704 511151 515855 515939 522539 528112 529057 533776 533972 539109 542386 544484 546361 549165 553503 558563 559459 559906 562676 565837 569389 570973 571335 585442 592004 592382 594616 595456 598617 599540 610532 612687 617107 618415 630115 633183 651664 666495 671222 674330 679369 682675 717504 734853 739904 758026 758229 761809 762568 789790 817604 822010 824489 828566 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (9.47%) |
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 436694 445360 471679 492906 499467 499421 2651 399038 441613 444179 493338 539109 544484 565837 651664 679369 671222 682675 717504 553503 562676 618415 595456 610532 633183 598617 585442 789790 762568 758229 734853 761809 404023 432529 511151 119798 388202 449281 458464 674330 666495 594616 758026 392857 487820 489768 487263 421967 463403 739904 373859 817604 459631 346173 388067 397395 390225 398638 408627 395354 410129 421315 420353 433890 444655 445642 461115 462670 450398 453976 476768 509704 546361 549165 570973 559459 559906 571335 612687 426777 459571 399959 429855 455398 471980 478561 479268 181043 412872 420385 425686 432563 434093 504834 522539 515939 390418 529057 432374 398299 451532 478258 630115 569389 424238 450046 457577 542386 592004 592382 617107 515855 528112 599540 533972 558563 824489 822010 828566 533776 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.45%) |
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 2651 119798 181043 346173 373859 388067 388202 390225 390418 392857 395354 397395 398299 398638 399038 399959 404023 408627 410129 412872 420353 420385 421315 421967 424238 425686 426777 429855 432374 432529 432563 433890 434093 436694 441613 444179 444655 445360 445642 449281 450046 450398 451532 453976 455398 457577 458464 459571 459631 461115 462670 463403 471679 471980 476768 478258 478561 479268 487263 487820 489768 492906 493338 499421 499467 504834 509704 511151 515855 515939 522539 528112 529057 533776 533972 539109 542386 544484 546361 549165 553503 558563 559459 559906 562676 565837 569389 570973 571335 585442 592004 592382 594616 595456 598617 599540 610532 612687 617107 618415 630115 633183 651664 666495 671222 674330 679369 682675 717504 734853 739904 758026 758229 761809 762568 789790 817604 822010 824489 828566 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens stockings"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens чулк нижн бел"
]
|
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.