Query Metrics
7
Database Queries
7
Different statements
170.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.52 ms (86.97%) |
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 260068 384493 418161 419248 420405 422408 426176 431731 448304 449222 457091 461064 479446 482828 483592 487297 487466 494626 499578 500818 511615 519624 520222 526717 529123 535289 536145 541301 544877 546146 547402 547876 553328 554975 555010 555992 559077 563949 574118 577901 581834 583343 588885 594413 607965 608609 611493 615411 616438 618119 619084 619689 623293 623918 628917 629554 630147 634902 639238 641764 642439 644072 647111 649066 654596 664557 666683 666890 667917 674502 675396 679274 679602 684874 684899 689981 695764 696336 699543 700726 702054 702855 703704 706742 708331 710244 711710 716367 717219 717546 723091 724475 726882 750627 762024 771002 775294 778211 778481 779150 780705 783471 784631 786541 789813 791636 791672 793084 794109 794418 794712 795038 795826 797101 799698 800956 802069 803311 807328 814421 ] |
||||||||||||||||||||||||||||||
|
12.30 ms (7.20%) |
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 699543 628917 630147 555992 641764 431731 448304 483592 724475 457091 418161 519624 526717 711710 717546 607965 795038 771002 750627 762024 800956 487297 559077 553328 577901 654596 667917 726882 700726 426176 461064 419248 449222 482828 384493 260068 422408 420405 814421 479446 494626 511615 535289 500818 520222 529123 499578 536145 487466 546146 574118 541301 547402 554975 583343 544877 547876 563949 649066 675396 684899 696336 703704 723091 647111 664557 679602 684874 689981 702855 716367 666683 666890 674502 679274 695764 702054 706742 708331 710244 717219 555010 581834 594413 618119 629554 634902 588885 608609 615411 619689 623293 642439 644072 616438 611493 619084 623918 639238 778481 779150 780705 784631 791672 794418 795826 802069 803311 807328 775294 778211 783471 786541 789813 791636 793084 794109 794712 797101 799698 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.83%) |
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 260068 384493 418161 419248 420405 422408 426176 431731 448304 449222 457091 461064 479446 482828 483592 487297 487466 494626 499578 500818 511615 519624 520222 526717 529123 535289 536145 541301 544877 546146 547402 547876 553328 554975 555010 555992 559077 563949 574118 577901 581834 583343 588885 594413 607965 608609 611493 615411 616438 618119 619084 619689 623293 623918 628917 629554 630147 634902 639238 641764 642439 644072 647111 649066 654596 664557 666683 666890 667917 674502 675396 679274 679602 684874 684899 689981 695764 696336 699543 700726 702054 702855 703704 706742 708331 710244 711710 716367 717219 717546 723091 724475 726882 750627 762024 771002 775294 778211 778481 779150 780705 783471 784631 786541 789813 791636 791672 793084 794109 794418 794712 795038 795826 797101 799698 800956 802069 803311 807328 814421 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm pussy cum"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм pussy cum"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм pussy cum"
]
|
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.