Query Metrics
7
Database Queries
7
Different statements
193.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.64 ms (84.46%) |
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 383641 391275 395552 414337 423657 425263 426032 426368 429763 431412 434275 436718 439850 444645 445493 447470 451572 451651 452311 452843 468626 471792 474610 481147 482605 493521 496792 503673 510394 515892 522043 522283 522899 522909 525089 530010 531177 531230 533517 533949 534627 536339 536650 537686 537925 537933 540404 540944 545416 558119 559121 565241 565243 565247 565249 565253 573914 589761 597239 597566 598057 600275 600968 601150 601635 615918 617412 620794 621656 625412 628376 629333 632669 632699 633806 633818 634145 636292 636321 637008 637016 637031 637042 640534 640783 642000 645749 646152 647937 650175 663551 666546 666548 666897 675021 676066 676092 676110 676624 678067 678517 679728 679742 683259 702675 704205 720072 720708 722597 725608 731877 741542 745928 752611 756479 775946 786120 805990 809468 ] |
||||||||||||||||||||||||||||||
|
19.75 ms (10.19%) |
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 621656 439850 531177 683259 589761 629333 634145 642000 600968 637031 636292 640783 720708 471792 414337 525089 522283 573914 510394 637016 786120 663551 752611 391275 426032 436718 429763 452843 482605 537933 540944 545416 646152 679742 647937 666548 676066 633818 597566 632699 637042 632669 640534 775946 805990 807580 741542 731877 745928 617412 702675 809468 383641 474610 423657 425263 468626 522899 536339 515892 537925 650175 678067 678517 720072 675021 676092 676624 565253 496792 522909 503673 645749 704205 637008 725608 444645 452311 558119 666546 601150 625412 615918 620794 434275 522043 481147 426368 537686 597239 722597 431412 530010 531230 534627 533517 533949 536650 540404 493521 565243 565249 559121 679728 676110 666897 565241 565247 598057 628376 636321 600275 601635 756479 633806 395552 445493 451572 447470 451651 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.66%) |
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 383641 391275 395552 414337 423657 425263 426032 426368 429763 431412 434275 436718 439850 444645 445493 447470 451572 451651 452311 452843 468626 471792 474610 481147 482605 493521 496792 503673 510394 515892 522043 522283 522899 522909 525089 530010 531177 531230 533517 533949 534627 536339 536650 537686 537925 537933 540404 540944 545416 558119 559121 565241 565243 565247 565249 565253 573914 589761 597239 597566 598057 600275 600968 601150 601635 615918 617412 620794 621656 625412 628376 629333 632669 632699 633806 633818 634145 636292 636321 637008 637016 637031 637042 640534 640783 642000 645749 646152 647937 650175 663551 666546 666548 666897 675021 676066 676092 676110 676624 678067 678517 679728 679742 683259 702675 704205 720072 720708 722597 725608 731877 741542 745928 752611 756479 775946 786120 805990 809468 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal penetration long"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал penetration длинные"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал penetration длинные"
]
|
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.