Query Metrics
7
Database Queries
7
Different statements
148.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.50 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.81 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2024 teen"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.17 ms |
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 410776 441530 395278 389587 386673 388401 414956 3392 455888 506526 536251 535006 536262 666871 674959 392216 388962 396519 397294 398098 398446 397762 417821 428574 441479 814228 540844 821132 818828 515291 536245 538550 529061 529068 482526 559212 561012 543162 546057 552397 552629 583082 650230 656579 657143 658728 670048 670832 671529 671665 671952 707088 712583 720362 720397 722628 652955 658837 660597 662148 672070 672780 694492 696160 717890 719376 720223 647275 654346 656593 659329 660338 671670 680230 683092 691217 695993 700681 717235 722538 722649 575606 597798 597823 597968 603052 636049 640466 594183 595478 595497 600146 619780 620805 633870 590806 598544 621081 597029 598135 598754 624170 639552 776289 795859 805961 807519 774650 777056 781068 785582 792179 795684 805654 725405 742833 746802 747519 750316 752595 ] |
||||||||||||||||||||||||||||||
| 4 | 2.89 ms |
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 3392 386673 388401 388962 389587 392216 395278 396519 397294 397762 398098 398446 410776 414956 417821 428574 441479 441530 455888 482526 506526 515291 529061 529068 535006 536245 536251 536262 538550 540844 543162 546057 552397 552629 559212 561012 575606 583082 590806 594183 595478 595497 597029 597798 597823 597968 598135 598544 598754 600146 603052 619780 620805 621081 624170 633870 636049 639552 640466 647275 650230 652955 654346 656579 656593 657143 658728 658837 659329 660338 660597 662148 666871 670048 670832 671529 671665 671670 671952 672070 672780 674959 680230 683092 691217 694492 695993 696160 700681 707088 712583 717235 717890 719376 720223 720362 720397 722538 722628 722649 725405 742833 746802 747519 750316 752595 774650 776289 777056 781068 785582 792179 795684 795859 805654 805961 807519 814228 818828 821132 ] |
||||||||||||||||||||||||||||||
| 5 | 128.27 ms |
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 3392 386673 388401 388962 389587 392216 395278 396519 397294 397762 398098 398446 410776 414956 417821 428574 441479 441530 455888 482526 506526 515291 529061 529068 535006 536245 536251 536262 538550 540844 543162 546057 552397 552629 559212 561012 575606 583082 590806 594183 595478 595497 597029 597798 597823 597968 598135 598544 598754 600146 603052 619780 620805 621081 624170 633870 636049 639552 640466 647275 650230 652955 654346 656579 656593 657143 658728 658837 659329 660338 660597 662148 666871 670048 670832 671529 671665 671670 671952 672070 672780 674959 680230 683092 691217 694492 695993 696160 700681 707088 712583 717235 717890 719376 720223 720362 720397 722538 722628 722649 725405 742833 746802 747519 750316 752595 774650 776289 777056 781068 785582 792179 795684 795859 805654 805961 807519 814228 818828 821132 ] |
||||||||||||||||||||||||||||||
| 6 | 1.64 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.56 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.