Query Metrics
7
Database Queries
7
Different statements
177.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.49 ms (84.16%) |
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 383643 394685 398284 398955 405816 415594 418974 428685 434189 434609 437434 448042 450847 452178 453746 457804 463780 466952 472396 475590 477131 477875 484495 485074 485319 486725 487153 490684 491444 491983 495906 498730 506014 506536 508595 512687 512786 514275 514295 515511 517100 517564 520448 522172 523257 523462 523608 525150 525159 525273 526478 526728 527058 534359 534757 535013 535546 541890 543849 545365 546838 549391 559841 561117 563473 569742 572548 573376 578492 580234 585971 587436 590505 595905 601622 611507 613319 619204 622978 624229 647612 678734 683973 687972 712540 715394 716271 720711 737089 745015 746366 751563 751616 752185 756504 757331 760781 760788 762664 770200 774172 776035 779610 779682 781164 784652 789310 800030 800162 801273 803472 806445 809023 809521 814778 815208 817115 817768 820574 825764 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (9.82%) |
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 770200 774172 784652 751563 751616 756504 745015 760781 760788 776035 801273 803472 398284 398955 428685 434609 475590 418974 394685 415594 448042 457804 491444 506014 484495 491983 512786 526728 495906 561117 563473 590505 622978 587436 613319 450847 463780 514295 517564 498730 520448 405816 434189 817115 820574 814778 815208 817768 485319 477875 525150 534359 535546 515511 523257 534757 525273 512687 472396 546838 569742 572548 541890 549391 573376 647612 683973 687972 678734 720711 712540 715394 545365 559841 578492 580234 624229 585971 611507 619204 601622 779682 789310 800030 809023 779610 781164 800162 809521 746366 757331 762664 716271 806445 383643 453746 477131 466952 437434 508595 523462 485074 487153 490684 506536 526478 527058 486725 514275 517100 522172 523608 525159 452178 543849 595905 535013 825764 752185 737089 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.91%) |
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 383643 394685 398284 398955 405816 415594 418974 428685 434189 434609 437434 448042 450847 452178 453746 457804 463780 466952 472396 475590 477131 477875 484495 485074 485319 486725 487153 490684 491444 491983 495906 498730 506014 506536 508595 512687 512786 514275 514295 515511 517100 517564 520448 522172 523257 523462 523608 525150 525159 525273 526478 526728 527058 534359 534757 535013 535546 541890 543849 545365 546838 549391 559841 561117 563473 569742 572548 573376 578492 580234 585971 587436 590505 595905 601622 611507 613319 619204 622978 624229 647612 678734 683973 687972 712540 715394 716271 720711 737089 745015 746366 751563 751616 752185 756504 757331 760781 760788 762664 770200 774172 776035 779610 779682 781164 784652 789310 800030 800162 801273 803472 806445 809023 809521 814778 815208 817115 817768 820574 825764 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm mom"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм mom"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм mom"
]
|
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.