Query Metrics
7
Database Queries
7
Different statements
213.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.82 ms (85.62%) |
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 421377 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 545407 554338 563992 564642 565246 566035 584393 590908 599916 601575 605483 610808 611572 622066 625901 628094 631203 633767 637034 637537 645812 648832 650333 651136 674959 676111 678063 696450 699526 699682 710943 722273 724330 724459 740141 740251 741504 747468 752973 756192 759344 812043 813579 816728 ] |
||||||||||||||||||||||||||||||
|
19.67 ms (9.21%) |
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 628094 633767 599916 601575 605483 611572 631203 812043 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 421377 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 676111 696450 699526 645812 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.35%) |
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 421377 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 545407 554338 563992 564642 565246 566035 584393 590908 599916 601575 605483 610808 611572 622066 625901 628094 631203 633767 637034 637537 645812 648832 650333 651136 674959 676111 678063 696450 699526 699682 710943 722273 724330 724459 740141 740251 741504 747468 752973 756192 759344 812043 813579 816728 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo cock"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд cock"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд cock"
]
|
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.