Query Metrics
7
Database Queries
7
Different statements
153.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.31 ms (83.41%) |
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 107495 172294 383246 384066 384798 386678 389226 394528 398791 402564 403696 409692 410428 417272 422475 426031 426426 426893 432631 436691 440986 442280 446861 448077 448666 449066 449252 449321 460514 460853 464229 464721 472285 474809 475548 486619 490002 491443 493888 502378 507550 510841 511320 511383 511996 512580 512739 516188 518383 522708 522735 523008 533508 534462 547606 547910 550634 553722 555015 556936 560264 562381 565837 568799 570991 585859 592763 594411 596349 612414 612465 615380 617964 628463 630360 658216 667944 671479 672891 677862 693778 701199 703318 706909 711820 712073 723964 724407 727502 728724 730224 734017 740875 741508 743937 746958 748489 749328 750628 757167 760679 761273 764250 767148 775112 777202 778653 782079 785142 786791 790828 792215 796448 800611 802568 802884 808100 810023 816716 827152 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (10.03%) |
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 409692 724407 760679 615380 440986 442280 474809 728724 172294 749328 775112 777202 778653 810023 383246 410428 384066 398791 426426 816716 449252 516188 667944 703318 594411 628463 750628 796448 734017 767148 727502 748489 743937 740875 808100 389226 426893 827152 518383 672891 596349 617964 800611 757167 746958 460853 472285 562381 448077 706909 507550 417272 449066 511383 553722 677862 511996 512580 394528 523008 512739 550634 522735 490002 386678 671479 741508 384798 403696 711820 556936 802884 764250 426031 612414 502378 491443 693778 585859 786791 730224 422475 436691 448666 449321 510841 533508 570991 560264 592763 630360 790828 792215 723964 761273 782079 475548 402564 547606 568799 555015 565837 701199 712073 547910 612465 785142 802568 493888 446861 486619 511320 464721 460514 107495 432631 464229 522708 534462 658216 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.90%) |
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 107495 172294 383246 384066 384798 386678 389226 394528 398791 402564 403696 409692 410428 417272 422475 426031 426426 426893 432631 436691 440986 442280 446861 448077 448666 449066 449252 449321 460514 460853 464229 464721 472285 474809 475548 486619 490002 491443 493888 502378 507550 510841 511320 511383 511996 512580 512739 516188 518383 522708 522735 523008 533508 534462 547606 547910 550634 553722 555015 556936 560264 562381 565837 568799 570991 585859 592763 594411 596349 612414 612465 615380 617964 628463 630360 658216 667944 671479 672891 677862 693778 701199 703318 706909 711820 712073 723964 724407 727502 728724 730224 734017 740875 741508 743937 746958 748489 749328 750628 757167 760679 761273 764250 767148 775112 777202 778653 782079 785142 786791 790828 792215 796448 800611 802568 802884 808100 810023 816716 827152 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"face секс pussy"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"face секс pussy"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"face fuck 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.