Query Metrics
7
Database Queries
7
Different statements
154.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.47 ms (83.01%) |
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 120415 182526 320879 383479 387281 387295 389023 391922 397296 398585 401009 401057 407346 421842 422989 423605 423989 424556 425952 426259 426898 428883 428885 431463 433946 442674 448483 449531 450192 450912 451797 452772 455631 457336 457842 461932 462623 463641 465739 466199 466714 467065 468329 468514 468641 468730 469213 469784 470354 470572 470988 475940 476225 478113 478437 482501 483498 491786 496813 498092 499327 500238 500590 502180 502222 503502 503756 504201 506435 507348 507533 507557 509752 512552 512738 512745 514366 516115 521048 528636 529177 529347 532056 534186 541859 545050 549241 549293 550667 551532 552229 555149 557989 558286 560434 565659 566760 570716 573798 575198 578023 578509 578823 582689 585390 586649 587315 587358 595805 596857 601659 605503 607709 620432 625312 639551 652758 664836 671085 768575 ] |
||||||||||||||||||||||||||||||
|
16.54 ms (10.69%) |
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 442674 465739 463641 457336 466199 514366 502222 552229 401057 389023 468514 433946 462623 516115 605503 423605 182526 455631 423989 391922 387281 398585 451797 470354 470572 478437 461932 468329 475940 557989 578509 586649 407346 421842 426898 448483 431463 449531 500238 503756 509752 512552 558286 450912 503502 120415 545050 428885 502180 587358 452772 534186 476225 496813 428883 507533 468641 582689 521048 620432 478113 500590 560434 387295 639551 506435 469213 566760 549293 507348 467065 424556 512738 512745 607709 468730 401009 549241 664836 587315 466714 578023 671085 768575 397296 320879 499327 457842 570716 575198 601659 383479 450192 532056 483498 578823 541859 482501 491786 422989 469784 498092 652758 573798 565659 529177 504201 625312 550667 529347 551532 555149 528636 425952 426259 507557 585390 595805 596857 470988 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.78%) |
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 120415 182526 320879 383479 387281 387295 389023 391922 397296 398585 401009 401057 407346 421842 422989 423605 423989 424556 425952 426259 426898 428883 428885 431463 433946 442674 448483 449531 450192 450912 451797 452772 455631 457336 457842 461932 462623 463641 465739 466199 466714 467065 468329 468514 468641 468730 469213 469784 470354 470572 470988 475940 476225 478113 478437 482501 483498 491786 496813 498092 499327 500238 500590 502180 502222 503502 503756 504201 506435 507348 507533 507557 509752 512552 512738 512745 514366 516115 521048 528636 529177 529347 532056 534186 541859 545050 549241 549293 550667 551532 552229 555149 557989 558286 560434 565659 566760 570716 573798 575198 578023 578509 578823 582689 585390 586649 587315 587358 595805 596857 601659 605503 607709 620432 625312 639551 652758 664836 671085 768575 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в чулках на кровате"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел на кроват"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.95%) |
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.