Query Metrics
7
Database Queries
7
Different statements
186.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.39 ms (86.70%) |
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 96371 108925 123340 311897 387937 405468 409667 414342 427526 429766 431416 431960 442998 447327 447573 448031 454633 456131 459139 460072 466416 470430 474126 477496 478463 486510 490498 496999 500506 502468 507696 509665 511721 514369 521544 521850 523568 524198 525315 526042 530375 530482 530623 530643 530765 530854 531183 531206 531304 532748 532854 532906 532942 532962 533012 533051 533376 534150 535005 536259 536266 536281 536292 536344 536580 537899 537901 537902 537906 537917 540575 540944 542524 543899 545117 545407 554338 563992 564642 565246 566035 584393 588899 590908 599894 599916 600280 601575 605483 610808 611572 622066 625901 628094 631203 633767 635993 637034 637537 648832 650333 651136 674959 678063 699682 708465 710943 722273 724330 724459 740141 740251 741504 747468 752973 756192 759344 813579 816728 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (7.91%) |
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 708465 545117 599894 635993 588899 600280 628094 633767 599916 601575 605483 611572 631203 752973 756192 740251 741504 747468 724330 759344 699682 710943 427526 431416 123340 311897 431960 447573 454633 108925 511721 525315 486510 521544 521850 674959 678063 637034 543899 584393 724459 816728 459139 722273 622066 589305 740141 442998 490498 610808 625901 447327 514369 409667 448031 502468 532942 530482 566035 542524 637537 590908 524198 96371 387937 405468 414342 429766 813579 456131 470430 474126 460072 466416 477496 478463 500506 526042 531206 532906 532962 534150 536281 523568 530375 530765 531304 532748 533012 533051 533376 535005 536259 536344 536580 537899 496999 507696 530854 531183 532854 536266 537901 537906 537917 540575 509665 530623 530643 536292 537902 540944 545407 563992 564642 565246 554338 648832 650333 651136 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.72%) |
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 96371 108925 123340 311897 387937 405468 409667 414342 427526 429766 431416 431960 442998 447327 447573 448031 454633 456131 459139 460072 466416 470430 474126 477496 478463 486510 490498 496999 500506 502468 507696 509665 511721 514369 521544 521850 523568 524198 525315 526042 530375 530482 530623 530643 530765 530854 531183 531206 531304 532748 532854 532906 532942 532962 533012 533051 533376 534150 535005 536259 536266 536281 536292 536344 536580 537899 537901 537902 537906 537917 540575 540944 542524 543899 545117 545407 554338 563992 564642 565246 566035 584393 588899 590908 599894 599916 600280 601575 605483 610808 611572 622066 625901 628094 631203 633767 635993 637034 637537 648832 650333 651136 674959 678063 699682 708465 710943 722273 724330 724459 740141 740251 741504 747468 752973 756192 759344 813579 816728 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock дилд"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock дилд"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock dildo"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.