Query Metrics
7
Database Queries
7
Different statements
188.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.40 ms (85.21%) |
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 381435 393754 413426 415567 427494 431221 431991 439636 447140 448060 450762 451442 452234 453862 454886 455993 457081 458058 460970 461554 462234 462715 464339 465967 468635 471435 472908 473911 475962 477092 481877 482925 483362 483403 489612 490231 490331 491540 491563 492414 493143 496973 498416 498891 501244 501723 501770 501923 502476 502718 504603 505021 507726 507877 508047 508093 511773 512273 512279 516394 516650 516822 516979 518995 519608 520889 521382 522805 522831 523008 523051 524146 525486 525661 527329 528373 529127 529194 531541 532624 533328 534163 540617 547949 549879 551708 552340 552679 554635 554757 555874 556645 557951 558021 559064 560080 561686 562297 565982 566002 566074 566857 567383 567474 569886 570052 570165 570782 571852 572872 573960 574417 575799 576349 576687 583837 584506 823939 828057 ] |
||||||||||||||||||||||||||||||
|
17.32 ms (9.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 448060 461554 413426 431221 457081 458058 472908 475962 501770 501923 508047 512279 520889 524146 482925 489612 491540 507726 511773 512273 523051 525661 527329 483362 483403 490331 491563 498416 498891 504603 505021 516394 525486 528373 502718 507877 508093 516822 518995 519608 522805 522831 529194 534163 824020 828057 551708 823939 549879 570782 393754 381435 415567 431991 439636 427494 452234 453862 462234 477092 493143 450762 451442 462715 468635 481877 492414 447140 454886 455993 460970 464339 465967 501244 501723 523008 529127 533328 540617 496973 516650 531541 532624 521382 502476 516979 471435 473911 490231 547949 552679 554635 554757 558021 561686 565982 566002 567383 570052 571852 572872 575799 576687 583837 584506 552340 555874 556645 557951 559064 560080 562297 566074 566857 567474 569886 570165 573960 574417 576349 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.59%) |
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 381435 393754 413426 415567 427494 431221 431991 439636 447140 448060 450762 451442 452234 453862 454886 455993 457081 458058 460970 461554 462234 462715 464339 465967 468635 471435 472908 473911 475962 477092 481877 482925 483362 483403 489612 490231 490331 491540 491563 492414 493143 496973 498416 498891 501244 501723 501770 501923 502476 502718 504603 505021 507726 507877 508047 508093 511773 512273 512279 516394 516650 516822 516979 518995 519608 520889 521382 522805 522831 523008 523051 524146 525486 525661 527329 528373 529127 529194 531541 532624 533328 534163 540617 547949 549879 551708 552340 552679 554635 554757 555874 556645 557951 558021 559064 560080 561686 562297 565982 566002 566074 566857 567383 567474 569886 570052 570165 570782 571852 572872 573960 574417 575799 576349 576687 583837 584506 823939 828057 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поцел"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"целу"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поцел"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.84%) |
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.