Query Metrics
7
Database Queries
7
Different statements
191.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.85 ms (87.53%) |
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 401127 437451 440702 453495 461918 462742 467581 467606 476259 491626 497578 500505 502489 509425 512275 523027 523312 523708 530256 531117 531420 532751 535724 536538 540559 542477 545389 545409 545410 545488 548668 559716 565245 566786 566789 568288 571213 576175 583502 584995 617427 620711 620785 625694 632601 634198 636510 643103 644300 645861 647898 648560 651306 651310 652805 653917 661335 661891 670110 673361 673369 675806 677307 678568 680176 681053 692450 696009 701463 703055 703095 705520 709259 709517 719335 720873 721367 726419 730210 732666 733816 735198 740057 742219 744263 747017 747560 748357 755191 757549 760240 762257 764373 767399 770872 772084 775212 775766 775950 776316 787628 797908 798135 799582 803645 803906 803928 807981 809941 814574 815784 815927 816568 816711 817080 817537 817866 818191 818868 820771 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (7.15%) |
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 767399 764373 803906 809941 462742 502489 566789 648560 565245 467581 548668 559716 775950 814574 817080 692450 696009 709517 651310 673361 673369 742219 732666 755191 620785 703095 661891 532751 531117 536538 677307 643103 500505 530256 568288 818191 818868 467606 681053 709259 720873 401127 491626 576175 636510 787628 747560 512275 571213 647898 632601 545389 545409 545410 545488 634198 523027 523312 762257 437451 523708 815927 817537 817866 705520 678568 703055 644300 803645 730210 733816 744263 770872 760240 740057 747017 757549 620711 701463 721367 803928 509425 476259 531420 540559 566786 617427 816568 816711 461918 651306 719335 735198 453495 497578 440702 584995 815784 820771 535724 542477 670110 675806 652805 653917 661335 583502 625694 776316 748357 726419 807981 645861 680176 797908 775212 775766 799582 772084 798135 ] |
||||||||||||||||||||||||||||||
|
2.58 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 401127 437451 440702 453495 461918 462742 467581 467606 476259 491626 497578 500505 502489 509425 512275 523027 523312 523708 530256 531117 531420 532751 535724 536538 540559 542477 545389 545409 545410 545488 548668 559716 565245 566786 566789 568288 571213 576175 583502 584995 617427 620711 620785 625694 632601 634198 636510 643103 644300 645861 647898 648560 651306 651310 652805 653917 661335 661891 670110 673361 673369 675806 677307 678568 680176 681053 692450 696009 701463 703055 703095 705520 709259 709517 719335 720873 721367 726419 730210 732666 733816 735198 740057 742219 744263 747017 747560 748357 755191 757549 760240 762257 764373 767399 770872 772084 775212 775766 775950 776316 787628 797908 798135 799582 803645 803906 803928 807981 809941 814574 815784 815927 816568 816711 817080 817537 817866 818191 818868 820771 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double handjob"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double дрочк член"
]
|
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.