Query Metrics
7
Database Queries
7
Different statements
193.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.32 ms (78.74%) |
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 545014 562779 565777 567389 570147 572664 577461 583858 585728 588636 589712 592150 592297 595578 596937 605065 606755 610275 612154 612334 612644 614790 614793 617294 617319 618504 619435 620441 620905 622334 622412 622735 624157 624972 624994 626281 638556 645370 649598 652601 654124 659459 665506 671325 671349 671928 672161 672898 674229 674381 675628 676527 676979 678008 678217 678554 682223 683126 683579 684208 685931 686021 687238 687505 687506 691669 692503 693794 694158 696106 697322 697650 698039 698959 700905 702279 703534 706612 713838 714819 716010 716068 716178 719208 719310 719778 722701 724638 725580 726453 726874 727299 727398 729198 730429 730931 732051 736352 736690 738459 739612 744386 746142 748682 749172 753866 755727 756298 756426 760944 761222 765160 779939 780029 783612 796214 801261 802510 807296 810880 ] |
||||||||||||||||||||||||||||||
|
30.59 ms (15.81%) |
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 570147 572664 577461 583858 654124 672161 676979 678217 683126 687238 693794 698039 714819 716068 716178 719208 645370 652601 671928 672898 674229 678008 684208 685931 687506 691669 692503 694158 696106 698959 713838 719310 722701 649598 659459 665506 671325 671349 674381 675628 676527 678554 682223 683579 686021 687505 697322 697650 700905 702279 703534 706612 716010 719778 545014 562779 565777 567389 585728 589712 592150 592297 605065 612644 617294 617319 622412 638556 612334 620441 622334 624994 626281 595578 619435 622735 624972 588636 596937 606755 610275 612154 614790 614793 618504 620905 624157 780029 783612 779939 810880 725580 727299 736352 739612 748682 749172 761222 765160 796214 801261 802510 807296 726874 727398 730931 732051 744386 756426 760944 724638 726453 729198 730429 736690 738459 746142 753866 755727 756298 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (2.11%) |
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 545014 562779 565777 567389 570147 572664 577461 583858 585728 588636 589712 592150 592297 595578 596937 605065 606755 610275 612154 612334 612644 614790 614793 617294 617319 618504 619435 620441 620905 622334 622412 622735 624157 624972 624994 626281 638556 645370 649598 652601 654124 659459 665506 671325 671349 671928 672161 672898 674229 674381 675628 676527 676979 678008 678217 678554 682223 683126 683579 684208 685931 686021 687238 687505 687506 691669 692503 693794 694158 696106 697322 697650 698039 698959 700905 702279 703534 706612 713838 714819 716010 716068 716178 719208 719310 719778 722701 724638 725580 726453 726874 727299 727398 729198 730429 730931 732051 736352 736690 738459 739612 744386 746142 748682 749172 753866 755727 756298 756426 760944 761222 765160 779939 780029 783612 796214 801261 802510 807296 810880 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping cock"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ cock"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спящ cock"
]
|
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.