Query Metrics
7
Database Queries
7
Different statements
179.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.00 ms (88.63%) |
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 7748 263868 359456 392778 392785 392790 395530 400881 410177 412274 412620 417018 425998 428468 428828 428857 432189 448974 450773 473954 489960 496536 515802 524651 532111 532113 550720 556659 558778 561589 562408 563100 565004 579227 581878 581893 586416 587215 590260 591276 591530 591944 606884 610114 611389 618998 621637 624285 629479 631358 639127 643386 650625 651216 665940 670748 670753 687195 687942 692365 694707 695186 698235 704987 710523 710568 716535 716935 721822 724706 725362 725571 726843 726887 726891 727205 730955 734227 743817 744187 746242 746621 751655 753582 755383 757568 758414 758564 764919 765045 771243 775254 777154 777220 777270 777697 777792 778852 780602 782564 786462 787342 787636 789551 793121 793223 793372 796154 797783 805367 807365 807367 807371 807456 807490 808859 813118 815333 818488 825112 ] |
||||||||||||||||||||||||||||||
|
11.32 ms (6.31%) |
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 550720 670753 586416 621637 591276 777154 778852 793223 793372 796154 807371 746242 758414 782564 807365 808859 734227 727205 751655 746621 743817 757568 716535 777792 807367 7748 448974 412620 359456 400881 412274 496536 392790 417018 428857 410177 428468 815333 825112 450773 532113 532111 524651 687195 687942 710523 650625 651216 716935 562408 563100 591944 611389 624285 643386 590260 587215 591530 606884 618998 777220 777270 813118 753582 726843 726887 755383 765045 744187 764919 629479 780602 787342 789551 797783 807456 473954 392785 263868 392778 395530 428828 425998 515802 432189 818488 489960 565004 581893 558778 561589 581878 665940 670748 692365 695186 704987 721822 694707 556659 579227 610114 631358 775254 777697 805367 807490 725571 730955 771243 786462 787636 793121 724706 725362 726891 758564 639127 698235 710568 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.18%) |
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 7748 263868 359456 392778 392785 392790 395530 400881 410177 412274 412620 417018 425998 428468 428828 428857 432189 448974 450773 473954 489960 496536 515802 524651 532111 532113 550720 556659 558778 561589 562408 563100 565004 579227 581878 581893 586416 587215 590260 591276 591530 591944 606884 610114 611389 618998 621637 624285 629479 631358 639127 643386 650625 651216 665940 670748 670753 687195 687942 692365 694707 695186 698235 704987 710523 710568 716535 716935 721822 724706 725362 725571 726843 726887 726891 727205 730955 734227 743817 744187 746242 746621 751655 753582 755383 757568 758414 758564 764919 765045 771243 775254 777154 777220 777270 777697 777792 778852 780602 782564 786462 787342 787636 789551 793121 793223 793372 796154 797783 805367 807365 807367 807371 807456 807490 808859 813118 815333 818488 825112 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom-mom"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom mom"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom mom"
]
|
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.