Query Metrics
7
Database Queries
7
Different statements
196.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.58 ms (87.18%) |
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 992 91891 96445 114631 391715 395867 396609 397366 400237 402835 403834 404922 409995 413185 414038 421839 425466 425832 426031 426117 430324 433966 436040 439226 445575 445608 447142 447861 447928 448038 448097 470791 475975 475989 478463 478779 478787 479523 481149 481339 484161 484609 486694 490035 492338 499588 504268 512261 512265 514738 516449 524121 528181 535585 538190 542502 543609 544268 544640 545584 547300 549412 550432 550681 550741 551262 559384 559867 559878 560616 562765 565369 569672 573263 576343 583608 587267 587723 590860 600005 603206 603548 619168 620616 624998 641757 644321 644538 649138 650593 651317 655720 656028 657426 658669 668996 672466 673555 676530 676945 678541 692172 703391 720883 722836 724709 736663 742199 745663 746889 749465 770856 788717 795148 797574 799754 821157 821163 822953 825628 ] |
||||||||||||||||||||||||||||||
|
15.32 ms (7.78%) |
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 478779 492338 447861 478463 551262 583608 475989 436040 479523 470791 538190 528181 395867 481149 992 545584 565369 651317 676530 624998 414038 486694 543609 544640 569672 720883 439226 475975 397366 400237 402835 409995 512261 512265 722836 96445 821163 547300 649138 650593 692172 678541 559878 724709 749465 799754 788717 403834 549412 447142 484161 490035 448038 448097 560616 550432 590860 426117 404922 425466 433966 478787 484609 516449 562765 91891 822953 559867 559384 676945 672466 795148 770856 821157 825628 544268 655720 656028 673555 657426 658669 587723 600005 425832 430324 445608 481339 573263 587267 413185 504268 742199 445575 703391 576343 499588 535585 668996 524121 644538 603206 447928 619168 114631 550681 644321 797574 514738 542502 603548 620616 746889 391715 396609 421839 550741 641757 736663 745663 426031 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.70%) |
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 992 91891 96445 114631 391715 395867 396609 397366 400237 402835 403834 404922 409995 413185 414038 421839 425466 425832 426031 426117 430324 433966 436040 439226 445575 445608 447142 447861 447928 448038 448097 470791 475975 475989 478463 478779 478787 479523 481149 481339 484161 484609 486694 490035 492338 499588 504268 512261 512265 514738 516449 524121 528181 535585 538190 542502 543609 544268 544640 545584 547300 549412 550432 550681 550741 551262 559384 559867 559878 560616 562765 565369 569672 573263 576343 583608 587267 587723 590860 600005 603206 603548 619168 620616 624998 641757 644321 644538 649138 650593 651317 655720 656028 657426 658669 668996 672466 673555 676530 676945 678541 692172 703391 720883 722836 724709 736663 742199 745663 746889 749465 770856 788717 795148 797574 799754 821157 821163 822953 825628 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худая втроём"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худая секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.