Query Metrics
7
Database Queries
7
Different statements
176.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.19 ms (84.37%) |
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 389474 390518 397766 399568 401674 442171 444127 447478 453625 460684 469890 470322 473981 474007 474955 475143 477398 482085 482840 484667 484731 492609 495706 495741 497568 501382 501756 521925 544064 548727 548796 549778 559644 559716 560319 566780 570505 570627 574878 575086 576165 596604 598176 598538 598557 598783 600073 602859 620563 621394 622349 627118 651934 651944 652245 652617 652853 652877 652895 657023 661262 677003 677407 678557 678561 678579 678588 679050 679058 692584 694639 696748 701051 701495 703505 708134 709295 716406 718655 720774 720778 720799 721203 721569 721796 721837 721843 723481 723603 723609 729328 730210 736151 740594 741125 741127 741476 742046 742158 744246 751618 751646 757544 758404 759548 768571 776280 776316 776396 784142 787716 788443 792515 807439 807462 809620 809651 814320 814488 821837 ] |
||||||||||||||||||||||||||||||
|
17.53 ms (9.91%) |
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 730210 742046 492609 495741 678579 679058 720799 598783 621394 622349 598557 751646 759548 696748 821837 652617 651934 651944 570627 620563 807462 809651 598176 776396 560319 576165 661262 600073 399568 495706 447478 460684 473981 544064 474955 548796 575086 484731 574878 482840 501382 482085 484667 549778 397766 521925 677407 792515 807439 559716 444127 475143 721203 758404 814320 652853 720774 652877 776280 751618 627118 701051 721569 716406 701495 708134 453625 497568 596604 474007 470322 477398 721796 723481 720778 652245 657023 718655 602859 787716 788443 741125 742158 721837 401674 390518 442171 723609 559644 678588 548727 570505 709295 389474 469890 501756 814488 723603 566780 678557 677003 679050 652895 678561 692584 694639 598538 776316 741127 768571 784142 809620 741476 757544 729328 744246 736151 740594 703505 721843 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.81%) |
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 389474 390518 397766 399568 401674 442171 444127 447478 453625 460684 469890 470322 473981 474007 474955 475143 477398 482085 482840 484667 484731 492609 495706 495741 497568 501382 501756 521925 544064 548727 548796 549778 559644 559716 560319 566780 570505 570627 574878 575086 576165 596604 598176 598538 598557 598783 600073 602859 620563 621394 622349 627118 651934 651944 652245 652617 652853 652877 652895 657023 661262 677003 677407 678557 678561 678579 678588 679050 679058 692584 694639 696748 701051 701495 703505 708134 709295 716406 718655 720774 720778 720799 721203 721569 721796 721837 721843 723481 723603 723609 729328 730210 736151 740594 741125 741127 741476 742046 742158 744246 751618 751646 757544 758404 759548 768571 776280 776316 776396 784142 787716 788443 792515 807439 807462 809620 809651 814320 814488 821837 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"руское мжж"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.