Query Metrics
7
Database Queries
7
Different statements
202.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.87 ms (84.06%) |
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 191575 215337 384275 390980 414177 415745 419816 424129 424701 430397 430709 432637 437579 439256 443516 446315 450287 452229 453213 454541 454641 454743 454802 456931 459657 464889 467835 468269 469758 470992 472536 476657 476773 477631 479083 481807 481904 483006 500789 502826 506228 509019 509439 519313 522310 526501 531105 532360 532576 532680 532940 534984 540727 541839 543772 546716 548392 557937 558457 560424 562342 566761 570413 580223 580227 582336 586102 587852 590102 595275 597203 597750 604865 605742 607509 615918 620391 623178 643542 645861 648924 663968 664660 666867 674936 678532 683449 724954 729818 734253 742415 747597 750453 752523 758335 759987 760859 766503 774699 777688 781990 785920 789559 791012 795403 799591 803040 803392 806668 807619 807830 808962 809439 812749 813227 814434 814935 814958 815370 825751 ] |
||||||||||||||||||||||||||||||
|
20.46 ms (10.12%) |
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 476657 454802 532360 678532 454541 456931 683449 560424 570413 620391 808962 724954 734253 758335 766503 747597 742415 785920 789559 807830 509019 590102 605742 415745 481904 215337 439256 454641 580227 674936 803040 384275 519313 432637 597750 509439 476773 814958 483006 663968 586102 424129 191575 604865 664660 582336 809439 534984 558457 803392 752523 419816 430397 459657 532576 540727 543772 531105 825751 468269 532940 597203 607509 795403 750453 791012 807619 580223 430709 452229 526501 472536 548392 595275 774699 812749 813227 454743 506228 645861 532680 541839 566761 424701 479083 814935 557937 623178 587852 390980 414177 467835 500789 643542 777688 615918 815370 666867 781990 477631 469758 799591 759987 437579 470992 502826 546716 648924 729818 481807 453213 464889 562342 760859 806668 446315 522310 443516 814434 450287 ] |
||||||||||||||||||||||||||||||
|
4.43 ms (2.19%) |
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 191575 215337 384275 390980 414177 415745 419816 424129 424701 430397 430709 432637 437579 439256 443516 446315 450287 452229 453213 454541 454641 454743 454802 456931 459657 464889 467835 468269 469758 470992 472536 476657 476773 477631 479083 481807 481904 483006 500789 502826 506228 509019 509439 519313 522310 526501 531105 532360 532576 532680 532940 534984 540727 541839 543772 546716 548392 557937 558457 560424 562342 566761 570413 580223 580227 582336 586102 587852 590102 595275 597203 597750 604865 605742 607509 615918 620391 623178 643542 645861 648924 663968 664660 666867 674936 678532 683449 724954 729818 734253 742415 747597 750453 752523 758335 759987 760859 766503 774699 777688 781990 785920 789559 791012 795403 799591 803040 803392 806668 807619 807830 808962 809439 812749 813227 814434 814935 814958 815370 825751 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo sex hot"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд секс hot"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд секс hot"
]
|
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.