Query Metrics
7
Database Queries
7
Different statements
156.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.18 ms (82.10%) |
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 388685 388715 395392 395574 397494 401267 409682 410406 412288 412311 414082 430095 432414 433639 436627 441442 449218 453484 485389 499121 505978 506619 507685 509997 518403 522695 547557 551444 559083 563873 563876 565093 574184 574979 581237 587479 590812 593972 595463 598784 607900 610804 613983 616500 625950 630773 639893 646135 649268 654299 662217 685384 688677 692528 692818 696089 696235 698312 702087 702521 702688 704727 714460 715765 718191 722684 724131 724739 724966 726171 731280 732215 734626 736155 736614 736918 737051 737856 740490 742250 746242 746355 748815 759383 760436 760513 761771 762577 767060 767071 767092 767223 767327 767417 768244 769101 769472 770590 771138 771168 773552 781584 782532 790521 793228 794922 799700 800619 800643 800793 801763 803294 804905 805186 810838 811847 819064 820205 821628 826292 ] |
||||||||||||||||||||||||||||||
|
15.87 ms (10.16%) |
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 718191 587479 639893 593972 724966 794922 767092 732215 759383 761771 769101 737051 793228 799700 449218 505978 565093 547557 574184 409682 430095 395574 388715 397494 820205 485389 522695 649268 715765 654299 702087 801763 736155 760436 770590 724131 724739 731280 746355 762577 768244 782532 800643 811847 410406 401267 395392 412311 506619 551444 625950 436627 453484 414082 819064 821628 826292 581237 685384 646135 688677 692818 714460 595463 590812 616500 630773 804905 805186 800793 803294 737856 740490 773552 736614 767417 760513 704727 790521 432414 388685 412288 518403 509997 698312 441442 499121 507685 433639 559083 563873 563876 574979 662217 702521 692528 696089 702688 722684 696235 598784 610804 613983 607900 800619 810838 726171 734626 746242 767223 767327 771138 781584 769472 742250 767060 767071 771168 736918 748815 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.00%) |
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 388685 388715 395392 395574 397494 401267 409682 410406 412288 412311 414082 430095 432414 433639 436627 441442 449218 453484 485389 499121 505978 506619 507685 509997 518403 522695 547557 551444 559083 563873 563876 565093 574184 574979 581237 587479 590812 593972 595463 598784 607900 610804 613983 616500 625950 630773 639893 646135 649268 654299 662217 685384 688677 692528 692818 696089 696235 698312 702087 702521 702688 704727 714460 715765 718191 722684 724131 724739 724966 726171 731280 732215 734626 736155 736614 736918 737051 737856 740490 742250 746242 746355 748815 759383 760436 760513 761771 762577 767060 767071 767092 767223 767327 767417 768244 769101 769472 770590 771138 771168 773552 781584 782532 790521 793228 794922 799700 800619 800643 800793 801763 803294 804905 805186 810838 811847 819064 820205 821628 826292 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step teen"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step teen"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step teen"
]
|
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.