Query Metrics
7
Database Queries
7
Different statements
146.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.78 ms (82.72%) |
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 11177 16882 33443 81734 88182 88246 118201 154127 154206 154463 154692 159291 375135 382404 382813 383217 383672 385713 388312 389541 392427 392839 392843 393326 394639 396071 401178 401353 402626 407436 413006 413341 414271 415859 416029 416525 416580 416581 416648 416653 416668 416675 416680 416700 416720 418112 423592 423995 424574 424614 428229 428568 432683 435136 435557 435559 437859 439059 439531 441040 441081 441120 444283 445984 447151 448431 448878 449023 449104 450969 451266 451336 452746 452889 462381 467112 467155 467568 471654 474284 475649 479542 480848 483742 484065 485527 487418 488713 493477 495762 495763 496126 496149 496339 496722 497030 498037 500721 502795 505575 508556 510801 513639 515572 519699 519712 524147 525992 532849 542707 555012 556880 559062 633748 639722 669376 669386 735906 803009 810914 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (11.04%) |
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 496149 498037 513639 154206 392843 16882 154127 394639 382404 424614 416700 441040 413341 467112 556880 735906 471654 416668 435557 451336 519712 496339 510801 448878 633748 467155 393326 33443 803009 159291 639722 401178 415859 418112 428568 441120 416029 416580 416720 416525 495763 500721 515572 487418 407436 441081 416581 416675 452889 479542 428229 505575 524147 525992 483742 496126 81734 532849 493477 383217 118201 413006 445984 495762 508556 396071 88246 382813 154692 154463 11177 402626 416653 416648 423592 435136 423995 444283 449023 467568 480848 450969 555012 437859 448431 474284 559062 414271 449104 447151 485527 497030 475649 484065 542707 669376 669386 424574 439531 416680 439059 451266 496722 502795 519699 462381 385713 383672 88182 392427 389541 388312 401353 432683 435559 452746 810914 392839 375135 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.81%) |
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 11177 16882 33443 81734 88182 88246 118201 154127 154206 154463 154692 159291 375135 382404 382813 383217 383672 385713 388312 389541 392427 392839 392843 393326 394639 396071 401178 401353 402626 407436 413006 413341 414271 415859 416029 416525 416580 416581 416648 416653 416668 416675 416680 416700 416720 418112 423592 423995 424574 424614 428229 428568 432683 435136 435557 435559 437859 439059 439531 441040 441081 441120 444283 445984 447151 448431 448878 449023 449104 450969 451266 451336 452746 452889 462381 467112 467155 467568 471654 474284 475649 479542 480848 483742 484065 485527 487418 488713 493477 495762 495763 496126 496149 496339 496722 497030 498037 500721 502795 505575 508556 510801 513639 515572 519699 519712 524147 525992 532849 542707 555012 556880 559062 633748 639722 669376 669386 735906 803009 810914 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"Ðäð©ÐüÐéð©ð¢ð│ÐâÐÄÐé ð©ðÀð▓ÐÇð░ÐëðÁð¢ð║ÐÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.90%) |
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.