Query Metrics
7
Database Queries
7
Different statements
192.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.25 ms (84.47%) |
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 31975 68945 219765 226368 339862 384038 387559 388208 390629 401570 417888 428891 444736 446108 447490 448489 451663 452082 457786 467597 474020 476419 476420 476423 477363 484850 487138 489594 490682 491364 491373 495701 495744 497547 497550 497565 497581 497584 497585 498101 504141 506782 509491 510443 510617 516882 520903 521966 523301 527070 534201 535867 540574 545592 545610 551235 551995 557938 557976 557977 560634 562253 562266 570407 572038 573768 582371 595770 595787 603168 614987 624178 625736 627804 632256 635210 636560 650547 651657 654181 659322 660882 661245 665918 668137 672423 676107 680111 680130 680154 680189 681570 683576 692436 693207 693454 698477 699645 702168 709699 714119 738440 742200 742205 745161 748128 755103 755176 756025 758676 768192 775792 775953 790088 790248 790965 807386 819514 820485 823476 ] |
||||||||||||||||||||||||||||||
|
19.33 ms (10.06%) |
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 562253 573768 560634 659322 665918 672423 680130 625736 614987 595770 635210 748128 756025 476419 387559 417888 446108 520903 521966 491364 489594 490682 491373 497550 497581 509491 497547 497584 497585 506782 510617 557938 484850 339862 636560 401570 390629 444736 448489 451663 534201 527070 551235 570407 582371 551995 557976 562266 680111 714119 668137 624178 790248 738440 745161 755176 632256 428891 477363 523301 487138 495744 497565 790088 660882 650547 545610 680189 219765 699645 823476 535867 447490 474020 516882 540574 557977 572038 680154 681570 676107 595787 603168 627804 807386 467597 476423 457786 476420 498101 504141 510443 495701 452082 702168 654181 709699 775953 790965 742200 775792 384038 68945 226368 31975 388208 820485 819514 545592 661245 693454 651657 683576 693207 698477 692436 742205 755103 758676 768192 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.52%) |
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 31975 68945 219765 226368 339862 384038 387559 388208 390629 401570 417888 428891 444736 446108 447490 448489 451663 452082 457786 467597 474020 476419 476420 476423 477363 484850 487138 489594 490682 491364 491373 495701 495744 497547 497550 497565 497581 497584 497585 498101 504141 506782 509491 510443 510617 516882 520903 521966 523301 527070 534201 535867 540574 545592 545610 551235 551995 557938 557976 557977 560634 562253 562266 570407 572038 573768 582371 595770 595787 603168 614987 624178 625736 627804 632256 635210 636560 650547 651657 654181 659322 660882 661245 665918 668137 672423 676107 680111 680130 680154 680189 681570 683576 692436 693207 693454 698477 699645 702168 709699 714119 738440 742200 742205 745161 748128 755103 755176 756025 758676 768192 775792 775953 790088 790248 790965 807386 819514 820485 823476 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group teens"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group teens"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group teens"
]
|
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.