Query Metrics
7
Database Queries
7
Different statements
158.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.76 ms (83.20%) |
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 418453 444720 445735 446314 447036 447038 454294 458346 459159 462904 466355 470614 470691 478553 484477 484628 484695 501262 502518 502537 502539 502540 502554 504171 508180 513265 513269 516634 517124 518072 520468 522423 524018 527031 529457 530873 536977 542148 543425 545009 545052 545187 546564 547947 548191 555653 556865 557648 558338 560368 561096 568180 571308 575338 577428 577437 578411 579541 581433 585753 587703 587860 588039 590437 591174 591908 598207 599533 603544 603604 603605 603618 603640 603652 604710 604746 604955 605453 605532 605703 606533 608772 610311 615394 618332 618591 623221 625322 626154 628426 628654 632413 634474 635786 648939 649211 650539 651285 653435 653601 654270 659391 661970 668559 680787 688993 699398 699399 712651 719862 721988 726754 732592 732704 732838 733179 733204 748326 755457 759672 ] |
||||||||||||||||||||||||||||||
|
18.28 ms (11.54%) |
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 571308 585753 604955 605703 598207 591908 603618 604746 615394 603652 605453 454294 444720 527031 484477 568180 732704 732592 732838 542148 625322 447036 445735 502554 516634 545009 548191 560368 579541 651285 577437 587860 610311 628654 591174 603605 604710 590437 484695 522423 733179 755457 536977 712651 502539 502537 502518 502540 462904 543425 558338 561096 659391 546564 608772 606533 603604 603640 733204 418453 466355 484628 628426 588039 547947 555653 635786 623221 721988 458346 518072 508180 556865 599533 605532 529457 501262 530873 545052 719862 648939 632413 759672 726754 470691 581433 524018 578411 668559 626154 748326 447038 504171 513269 557648 577428 653435 654270 680787 699399 653601 699398 575338 618332 634474 603544 618591 459159 446314 470614 478553 513265 520468 517124 688993 650539 649211 661970 545187 587703 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.32%) |
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 418453 444720 445735 446314 447036 447038 454294 458346 459159 462904 466355 470614 470691 478553 484477 484628 484695 501262 502518 502537 502539 502540 502554 504171 508180 513265 513269 516634 517124 518072 520468 522423 524018 527031 529457 530873 536977 542148 543425 545009 545052 545187 546564 547947 548191 555653 556865 557648 558338 560368 561096 568180 571308 575338 577428 577437 578411 579541 581433 585753 587703 587860 588039 590437 591174 591908 598207 599533 603544 603604 603605 603618 603640 603652 604710 604746 604955 605453 605532 605703 606533 608772 610311 615394 618332 618591 623221 625322 626154 628426 628654 632413 634474 635786 648939 649211 650539 651285 653435 653601 654270 659391 661970 668559 680787 688993 699398 699399 712651 719862 721988 726754 732592 732704 732838 733179 733204 748326 755457 759672 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swingers cuckold"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер куколд"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"свингер куколд"
]
|
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.