Query Metrics
7
Database Queries
7
Different statements
182.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.61 ms (84.02%) |
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 270601 398652 403891 403928 407156 407756 407800 407812 409506 409909 410352 410429 422012 428616 429526 432707 442943 446034 447333 447865 448641 453379 457081 457572 461382 461745 462229 463083 463873 464185 464520 467705 468908 469017 469763 470855 471809 474095 475226 477158 478025 479607 491591 492575 493402 496721 497317 497887 499551 500298 500458 501713 503370 504955 508130 509702 510463 511622 512533 512966 513908 518210 520126 521794 521929 522870 523811 523815 529564 530494 530950 533538 533832 534312 534769 536538 536657 537670 543772 551116 556485 560664 563424 563787 565013 565162 565922 567756 584180 584873 589107 591918 593193 596330 601537 612455 614605 615761 617115 628175 636053 640732 650419 668137 670763 680182 710174 725613 736770 738446 770836 770899 779647 793082 806086 808679 810665 811005 812141 817469 ] |
||||||||||||||||||||||||||||||
|
18.30 ms (10.01%) |
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 808679 770836 738446 270601 398652 448641 462229 479607 461382 477158 513908 521929 496721 432707 447333 403928 407756 407812 429526 409909 817469 468908 457572 470855 491591 521794 530950 563424 565922 636053 615761 806086 770899 725613 710174 811005 812141 410429 453379 422012 442943 457081 508130 497887 503370 493402 403891 428616 467705 475226 463083 533832 500298 584180 551116 670763 591918 614605 810665 736770 779647 793082 511622 512966 520126 529564 497317 499551 512533 407800 446034 447865 523811 534769 504955 518210 471809 668137 596330 640732 617115 464520 461745 464185 501713 492575 589107 410352 500458 533538 530494 560664 565013 409506 463873 478025 407156 469763 509702 523815 474095 536657 537670 650419 565162 567756 628175 593193 469017 510463 522870 534312 680182 563787 536538 556485 601537 543772 584873 612455 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.67%) |
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 270601 398652 403891 403928 407156 407756 407800 407812 409506 409909 410352 410429 422012 428616 429526 432707 442943 446034 447333 447865 448641 453379 457081 457572 461382 461745 462229 463083 463873 464185 464520 467705 468908 469017 469763 470855 471809 474095 475226 477158 478025 479607 491591 492575 493402 496721 497317 497887 499551 500298 500458 501713 503370 504955 508130 509702 510463 511622 512533 512966 513908 518210 520126 521794 521929 522870 523811 523815 529564 530494 530950 533538 533832 534312 534769 536538 536657 537670 543772 551116 556485 560664 563424 563787 565013 565162 565922 567756 584180 584873 589107 591918 593193 596330 601537 612455 614605 615761 617115 628175 636053 640732 650419 668137 670763 680182 710174 725613 736770 738446 770836 770899 779647 793082 806086 808679 810665 811005 812141 817469 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"super pussy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"super pussy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"super pussy"
]
|
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.