Query Metrics
7
Database Queries
7
Different statements
162.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.13 ms (82.98%) |
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 450539 459162 460259 461260 462366 471370 474551 478445 479750 479837 482172 484829 488883 497963 506301 508162 509400 518740 524955 530139 533840 533856 536886 543413 543416 552597 554360 554751 554889 561365 574166 583947 583995 584717 584731 588262 589146 589154 589208 595722 595728 595765 595772 595776 595817 598903 599999 601657 603151 603162 603242 604633 605525 607155 614407 618462 631913 633508 634477 635486 643725 644264 645232 645235 646228 648259 648554 649543 649964 650603 660427 664321 665455 666778 667230 669391 670773 675236 675921 675951 676309 676342 676397 676895 676896 679396 679441 679444 679447 679471 681087 681158 684126 688351 692506 694212 696355 699584 703538 706644 708823 709784 710216 712712 714193 715096 715395 715507 716373 717517 717724 717731 718521 721990 775751 820768 820778 822011 822642 823501 ] |
||||||||||||||||||||||||||||||
|
16.68 ms (10.24%) |
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 820768 820778 822011 822642 823501 462366 471370 479837 488883 482172 484829 450539 459162 460259 478445 479750 497963 506301 518740 524955 530139 533840 509400 533856 536886 508162 461260 474551 543413 543416 554360 574166 552597 554751 584731 554889 646228 648259 649964 650603 664321 665455 669391 670773 676397 679444 679447 679471 709784 712712 715096 715395 717517 717724 721990 645235 648554 660427 667230 675951 676309 676342 692506 696355 699584 706644 714193 716373 717731 718521 645232 649543 666778 675236 675921 676895 676896 679396 679441 681087 681158 684126 688351 694212 703538 708823 710216 715507 561365 583947 583995 584717 589154 595728 598903 603162 603242 604633 631913 644264 588262 589208 595722 595765 595776 599999 634477 635486 643725 589146 595817 601657 603151 595772 605525 607155 614407 618462 633508 775751 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.60%) |
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 450539 459162 460259 461260 462366 471370 474551 478445 479750 479837 482172 484829 488883 497963 506301 508162 509400 518740 524955 530139 533840 533856 536886 543413 543416 552597 554360 554751 554889 561365 574166 583947 583995 584717 584731 588262 589146 589154 589208 595722 595728 595765 595772 595776 595817 598903 599999 601657 603151 603162 603242 604633 605525 607155 614407 618462 631913 633508 634477 635486 643725 644264 645232 645235 646228 648259 648554 649543 649964 650603 660427 664321 665455 666778 667230 669391 670773 675236 675921 675951 676309 676342 676397 676895 676896 679396 679441 679444 679447 679471 681087 681158 684126 688351 692506 694212 696355 699584 703538 706644 708823 709784 710216 712712 714193 715096 715395 715507 716373 717517 717724 717731 718521 721990 775751 820768 820778 822011 822642 823501 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs group"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs group"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs group"
]
|
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.