Query Metrics
7
Database Queries
7
Different statements
177.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.83 ms (83.05%) |
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 33309 391934 399083 410210 410237 411352 411808 412180 412975 412985 413406 414259 414385 415859 416525 416600 416609 416696 416715 417850 418054 418738 419972 420151 423269 423969 424368 426810 427067 427126 427647 428280 428929 429869 432306 433220 433605 434334 440265 441095 442233 443464 443554 444487 446191 446416 447160 447631 447971 448607 448689 449169 450334 452462 452558 453235 453811 453921 455080 455983 456546 457825 458115 459666 465976 466720 467122 468845 468915 469537 469704 469750 471484 475631 477084 479544 480594 483752 484956 487730 487928 488713 493252 496189 503670 503985 505696 506387 510244 515356 518847 518854 520877 526548 552965 561286 564782 569418 572263 573731 573760 577385 581637 584699 585631 585650 587207 588306 592873 594929 599367 601844 603891 603986 614701 617402 663265 663854 670617 680267 ] |
||||||||||||||||||||||||||||||
|
20.35 ms (11.43%) |
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 488713 493252 506387 484956 33309 410237 411808 412975 415859 416609 433605 441095 443554 410210 412180 412985 413406 414385 418738 419972 443464 416715 423969 440265 416525 420151 428280 442233 416696 417850 418054 444487 446416 447631 448689 449169 453235 455080 456546 466720 468915 469537 469750 480594 446191 450334 453811 455983 457825 447160 452462 452558 453921 458115 459666 469704 477084 487928 496189 526548 505696 510244 518847 518854 503670 503985 515356 520877 465976 468845 471484 479544 483752 487730 564782 569418 561286 572263 577385 581637 552965 573731 573760 584699 663265 670617 680267 663854 592873 599367 585631 594929 603891 603986 585650 587207 601844 614701 617402 588306 399083 411352 414259 423269 424368 427067 427126 427647 428929 432306 447971 448607 467122 475631 391934 416600 426810 429869 433220 434334 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.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 33309 391934 399083 410210 410237 411352 411808 412180 412975 412985 413406 414259 414385 415859 416525 416600 416609 416696 416715 417850 418054 418738 419972 420151 423269 423969 424368 426810 427067 427126 427647 428280 428929 429869 432306 433220 433605 434334 440265 441095 442233 443464 443554 444487 446191 446416 447160 447631 447971 448607 448689 449169 450334 452462 452558 453235 453811 453921 455080 455983 456546 457825 458115 459666 465976 466720 467122 468845 468915 469537 469704 469750 471484 475631 477084 479544 480594 483752 484956 487730 487928 488713 493252 496189 503670 503985 505696 506387 510244 515356 518847 518854 520877 526548 552965 561286 564782 569418 572263 573731 573760 577385 581637 584699 585631 585650 587207 588306 592873 594929 599367 601844 603891 603986 614701 617402 663265 663854 670617 680267 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"голи"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"гол"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
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.