Query Metrics
7
Database Queries
7
Different statements
373.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.42 ms (56.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
139.69 ms (37.44%) |
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 395320 404859 424240 444893 453514 459092 460123 460435 463031 474931 479137 479451 484035 484312 484952 491310 495858 502209 506713 508509 509618 515102 515282 516569 522406 526759 527250 530328 543171 544519 547392 548038 553254 555905 563102 564239 567644 569388 571343 571406 574659 575529 578247 580105 585122 593022 593741 598232 598733 600683 605030 605999 606961 607117 616650 616757 619352 628798 631674 644139 650134 658762 670415 671923 672753 672819 675156 678821 680561 682625 685023 692832 697416 700966 703685 707292 716834 728487 731432 731549 731781 732117 732808 733231 736905 740077 744436 746358 761436 762468 763613 764958 765846 768344 769315 770599 772358 772419 773821 775997 777533 777570 783162 784613 785175 785912 789026 789767 790702 791330 791808 793172 796349 801157 806092 807894 809663 810409 814712 827776 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (4.09%) |
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 791330 807894 731549 732117 732808 772358 761436 765846 772419 773821 763613 605030 605999 703685 777533 777570 784613 785912 790702 793172 806092 459092 479137 395320 453514 424240 506713 491310 508509 509618 404859 444893 585122 814712 827776 463031 474931 460123 460435 479451 484312 484952 484035 515102 522406 526759 530328 495858 502209 516569 527250 515282 555905 574659 543171 544519 569388 547392 571343 578247 658762 675156 678821 680561 682625 707292 650134 672819 700966 670415 671923 672753 685023 692832 697416 716834 548038 553254 563102 564239 567644 571406 575529 580105 593741 598733 600683 606961 631674 628798 644139 598232 616650 616757 619352 593022 607117 801157 775997 783162 789767 796349 810409 740077 744436 770599 785175 789026 791808 809663 731432 731781 728487 736905 746358 762468 764958 733231 768344 769315 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (0.92%) |
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 395320 404859 424240 444893 453514 459092 460123 460435 463031 474931 479137 479451 484035 484312 484952 491310 495858 502209 506713 508509 509618 515102 515282 516569 522406 526759 527250 530328 543171 544519 547392 548038 553254 555905 563102 564239 567644 569388 571343 571406 574659 575529 578247 580105 585122 593022 593741 598232 598733 600683 605030 605999 606961 607117 616650 616757 619352 628798 631674 644139 650134 658762 670415 671923 672753 672819 675156 678821 680561 682625 685023 692832 697416 700966 703685 707292 716834 728487 731432 731549 731781 732117 732808 733231 736905 740077 744436 746358 761436 762468 763613 764958 765846 768344 769315 770599 772358 772419 773821 775997 777533 777570 783162 784613 785175 785912 789026 789767 790702 791330 791808 793172 796349 801157 806092 807894 809663 810409 814712 827776 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sucked"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sucked"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sucked"
]
|
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.