Query Metrics
7
Database Queries
7
Different statements
174.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.15 ms (83.60%) |
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 404368 406085 410682 414339 419116 419758 439993 441517 442117 485527 486784 496802 511379 512943 523851 530028 530370 530381 530476 530486 530487 530630 530941 531087 531089 531126 531163 531165 531206 531215 531225 531232 531419 532754 532772 532837 532838 532948 532984 533367 533368 533371 533374 533375 533378 533463 533942 534028 535584 537654 537911 537917 540400 540405 542583 544827 545429 545430 547467 582323 583609 599847 600185 600312 600334 600415 601517 601535 603391 630522 631249 632618 632671 632978 633451 634482 634504 634787 639748 640762 640800 642002 642032 642359 642658 642751 645276 645284 646786 647340 647936 648499 648841 649596 656625 683261 696582 704529 713667 719333 723219 724105 724129 724978 725416 727785 730788 759926 761594 761691 765756 765940 775219 779002 783271 791233 792175 796126 805146 813181 ] |
||||||||||||||||||||||||||||||
|
18.04 ms (10.32%) |
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 533371 533942 813181 713667 537654 645276 656625 775219 723219 779002 406085 410682 512943 530381 531225 531232 533368 540400 530476 532948 533367 533378 547467 545429 648499 631249 634787 640800 600334 601517 640762 704529 805146 419116 533463 523851 534028 545430 404368 486784 485527 531206 537917 442117 791233 724129 724105 765756 647936 633451 531215 533375 724978 439993 532838 532837 542583 511379 531126 719333 531163 531165 531419 496802 535584 632618 601535 632978 583609 730788 696582 603391 783271 792175 761594 796126 441517 599847 530486 532754 533374 530630 530941 531089 532772 530028 530487 540405 582323 648841 683261 646786 647340 600185 630522 642002 642658 600312 642751 639748 419758 642359 634504 725416 765940 759926 761691 727785 645284 642032 414339 530370 531087 537911 532984 544827 649596 634482 600415 632671 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.60%) |
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 404368 406085 410682 414339 419116 419758 439993 441517 442117 485527 486784 496802 511379 512943 523851 530028 530370 530381 530476 530486 530487 530630 530941 531087 531089 531126 531163 531165 531206 531215 531225 531232 531419 532754 532772 532837 532838 532948 532984 533367 533368 533371 533374 533375 533378 533463 533942 534028 535584 537654 537911 537917 540400 540405 542583 544827 545429 545430 547467 582323 583609 599847 600185 600312 600334 600415 601517 601535 603391 630522 631249 632618 632671 632978 633451 634482 634504 634787 639748 640762 640800 642002 642032 642359 642658 642751 645276 645284 646786 647340 647936 648499 648841 649596 656625 683261 696582 704529 713667 719333 723219 724105 724129 724978 725416 727785 730788 759926 761594 761691 765756 765940 775219 779002 783271 791233 792175 796126 805146 813181 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hardcore deep anal"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор deep анал"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор deep анал"
]
|
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.