Query Metrics
7
Database Queries
7
Different statements
364.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.79 ms (56.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm porn"
]
|
||||||||||||||||||||||||||||||
|
137.62 ms (37.71%) |
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 384880 395889 444123 444643 449652 450787 454066 456977 459699 461120 473522 480191 490111 491656 491663 491672 491686 491705 491722 500576 501325 501415 504132 505922 507625 507823 508767 511722 511820 512235 512236 512237 512283 512306 512827 513281 513284 513292 513299 513589 517574 517676 518556 520099 522583 522593 523285 523926 524359 524579 524694 525496 527316 528697 529173 540286 541135 543821 544571 548919 549787 551212 552798 555882 558839 558846 560438 564488 565771 566020 567206 573616 574605 574889 575477 575535 576081 576633 576709 579215 581273 583240 584465 584609 585156 588234 591494 591728 595137 599162 599531 613823 621745 630544 633708 634505 641414 660137 667810 670306 691137 696225 696429 697666 700727 716693 722404 726536 727796 730946 732970 733008 752977 768716 780737 783232 799103 800589 801232 801517 ] |
||||||||||||||||||||||||||||||
|
12.70 ms (3.48%) |
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 507625 508767 511722 512236 513292 517574 491663 491672 505922 512283 512827 513284 518556 522583 523285 524694 490111 491656 491686 491705 491722 507823 512235 512237 513281 513299 524359 527316 523926 548919 573616 697666 595137 799103 783232 801517 800589 730946 733008 768716 727796 732970 752977 583240 585156 384880 444123 449652 456977 461120 480191 450787 513589 522593 511820 517676 528697 529173 540286 524579 473522 544571 560438 575477 581273 574889 576633 541135 558839 558846 564488 566020 574605 660137 700727 696429 667810 670306 696225 716693 549787 551212 552798 555882 565771 579215 591728 599162 613823 621745 591494 630544 634505 780737 444643 454066 459699 520099 501325 512306 500576 501415 504132 576709 543821 567206 584465 691137 641414 525496 584609 722404 576081 588234 801232 726536 633708 575535 599531 395889 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (0.86%) |
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 384880 395889 444123 444643 449652 450787 454066 456977 459699 461120 473522 480191 490111 491656 491663 491672 491686 491705 491722 500576 501325 501415 504132 505922 507625 507823 508767 511722 511820 512235 512236 512237 512283 512306 512827 513281 513284 513292 513299 513589 517574 517676 518556 520099 522583 522593 523285 523926 524359 524579 524694 525496 527316 528697 529173 540286 541135 543821 544571 548919 549787 551212 552798 555882 558839 558846 560438 564488 565771 566020 567206 573616 574605 574889 575477 575535 576081 576633 576709 579215 581273 583240 584465 584609 585156 588234 591494 591728 595137 599162 599531 613823 621745 630544 633708 634505 641414 660137 667810 670306 691137 696225 696429 697666 700727 716693 722404 726536 727796 730946 732970 733008 752977 768716 780737 783232 799103 800589 801232 801517 ] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм porn"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм porn"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.43%) |
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.