Query Metrics
7
Database Queries
7
Different statements
164.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.15 ms (84.53%) |
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 21109 78412 80203 233934 382130 383763 385260 385357 391543 398384 410299 426670 427755 459665 460939 472755 472865 492310 518772 527610 529498 540213 542183 552437 557584 565003 575549 585913 586452 593281 595540 595598 607802 607903 612807 617183 619448 635153 639915 642093 644014 650118 652522 656028 657931 659623 663390 665754 665906 669858 671531 673125 673776 675396 683774 683797 683877 687971 698809 709802 719813 723819 725282 728217 731881 736139 736342 736889 739411 740366 740763 742160 742504 743232 745361 746075 746803 752513 753525 753853 756070 756144 757423 763276 763748 766055 766472 766758 767177 767306 772076 772416 773126 777132 779233 780043 781407 782109 783579 789901 790053 790134 792384 796982 800534 802752 803640 806644 807275 808082 809810 812178 815131 817022 817819 819372 819607 820086 823528 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (8.50%) |
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 639915 812178 756070 766758 772416 782109 790134 808082 742504 773126 772076 779233 781407 459665 426670 383763 382130 410299 817819 820086 823528 472755 527610 492310 542183 575549 552437 673125 675396 683774 669858 683797 607903 644014 619448 595540 607802 792384 806644 785992 796982 800534 739411 745361 802752 803640 731881 736889 756144 740366 746803 767306 753525 763276 763748 766055 698809 809810 78412 21109 780043 789901 656028 790053 767177 385260 460939 719813 659623 777132 783579 723819 725282 766472 753853 736139 752513 742160 757423 398384 233934 819607 472865 540213 652522 657931 665906 671531 687971 709802 557584 585913 617183 642093 807275 736342 740763 728217 746075 743232 612807 80203 385357 391543 427755 817022 819372 815131 529498 518772 565003 650118 665754 673776 663390 683877 595598 593281 635153 586452 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.99%) |
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 21109 78412 80203 233934 382130 383763 385260 385357 391543 398384 410299 426670 427755 459665 460939 472755 472865 492310 518772 527610 529498 540213 542183 552437 557584 565003 575549 585913 586452 593281 595540 595598 607802 607903 612807 617183 619448 635153 639915 642093 644014 650118 652522 656028 657931 659623 663390 665754 665906 669858 671531 673125 673776 675396 683774 683797 683877 687971 698809 709802 719813 723819 725282 728217 731881 736139 736342 736889 739411 740366 740763 742160 742504 743232 745361 746075 746803 752513 753525 753853 756070 756144 757423 763276 763748 766055 766472 766758 767177 767306 772076 772416 773126 777132 779233 780043 781407 782109 783579 789901 790053 790134 792384 796982 800534 802752 803640 806644 807275 808082 809810 812178 815131 817022 817819 819372 819607 820086 823528 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex cute"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс cute"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс cute"
]
|
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.