Query Metrics
7
Database Queries
7
Different statements
190.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.01 ms (86.29%) |
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 486143 517888 517901 529868 531052 531813 531842 532394 532400 532464 532479 532832 533154 533784 534692 534936 537067 537453 539552 543933 545042 550170 553155 553755 555214 557965 558110 560370 563687 563976 563979 565688 567121 570948 571108 571120 575922 577245 578643 580812 581381 582746 588371 596542 597905 601564 601760 602885 603311 604998 605169 607953 609727 610237 612979 615412 617082 618065 618510 622629 627696 628479 628763 629586 631307 634436 635129 636148 639683 640306 640993 642086 644217 645358 645750 648507 649347 649714 652971 658483 660036 660808 660846 666051 666142 666389 667349 668356 669861 669898 670939 676696 687113 699495 706430 710494 711777 712617 713097 713165 740554 741243 760656 769431 770049 782342 783278 787626 788031 790478 795716 803109 805718 806803 808306 811131 818566 819859 827529 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (7.65%) |
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 532394 545042 557965 711777 652971 644217 640306 760656 769431 770049 783278 808306 741243 635129 806803 570948 563687 818566 819859 827529 486143 713165 787626 782342 795716 788031 811131 740554 790478 803109 805718 517888 517901 532832 533154 533784 534692 531052 531813 531842 537067 539552 529868 532479 534936 537453 529752 532400 532464 550170 553755 567121 577245 563979 581381 543933 553155 558110 563976 565688 645750 660808 660846 666051 669898 676696 687113 660036 666389 667349 669861 670939 706430 712617 713097 645358 648507 649347 649714 658483 666142 668356 699495 710494 555214 560370 571108 571120 575922 578643 580812 582746 597905 601760 610237 629586 636148 639683 588371 602885 615412 628763 642086 604998 607953 609727 612979 617082 622629 627696 628479 596542 601564 603311 605169 631307 640993 618065 618510 634436 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.71%) |
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 486143 517888 517901 529868 531052 531813 531842 532394 532400 532464 532479 532832 533154 533784 534692 534936 537067 537453 539552 543933 545042 550170 553155 553755 555214 557965 558110 560370 563687 563976 563979 565688 567121 570948 571108 571120 575922 577245 578643 580812 581381 582746 588371 596542 597905 601564 601760 602885 603311 604998 605169 607953 609727 610237 612979 615412 617082 618065 618510 622629 627696 628479 628763 629586 631307 634436 635129 636148 639683 640306 640993 642086 644217 645358 645750 648507 649347 649714 652971 658483 660036 660808 660846 666051 666142 666389 667349 668356 669861 669898 670939 676696 687113 699495 706430 710494 711777 712617 713097 713165 740554 741243 760656 769431 770049 782342 783278 787626 788031 790478 795716 803109 805718 806803 808306 811131 818566 819859 827529 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade milf solo"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск milf соло"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск milf соло"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.77%) |
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.