Query Metrics
7
Database Queries
7
Different statements
138.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.98 ms (83.74%) |
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 415534 458277 459920 466238 471847 480998 483879 491867 507805 509381 510288 530036 531645 536177 536634 537454 545513 545561 545786 554846 566555 566894 569069 588715 598143 600515 601955 604098 604590 606167 610260 617382 621674 624409 625464 625473 628685 630767 633338 633381 635099 639229 647797 653754 654137 656868 659075 661099 661789 663690 665578 665900 666347 668939 669500 671446 682872 684880 689894 691584 692904 693395 698603 699122 699564 701207 704804 705806 707044 707143 710945 715379 715692 718654 720149 722031 723090 726999 728551 728945 732041 733461 734264 738276 739200 743990 745923 747372 748055 750467 751244 751899 752292 755688 757239 757465 764083 771206 777855 783338 800775 803640 806489 817573 818304 821005 821556 822704 823163 823397 823723 823999 824863 825301 826110 827257 827930 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (9.31%) |
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 823163 458277 530036 531645 471847 569069 659075 701207 691584 566894 621674 604098 624409 606167 728551 739200 750467 751244 755688 783338 803640 734264 738276 752292 757465 728945 604590 633338 459920 536634 827257 821556 554846 669500 707044 689894 723090 682872 707143 625464 598143 732041 751899 601955 466238 415534 509381 823397 825301 480998 483879 491867 536177 507805 510288 537454 566555 665900 688681 715379 668939 671446 715692 628685 633381 617382 630767 733461 748055 757239 771206 764083 743990 726999 745923 747372 639229 698603 699564 806489 823723 824863 826110 822704 825178 817573 818304 821005 823999 827930 545513 545786 647797 656868 666347 699122 704804 720149 653754 663690 705806 710945 718654 654137 661099 661789 665578 684880 692904 693395 722031 545561 610260 625473 635099 588715 639401 600515 777855 800775 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.81%) |
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 415534 458277 459920 466238 471847 480998 483879 491867 507805 509381 510288 530036 531645 536177 536634 537454 545513 545561 545786 554846 566555 566894 569069 588715 598143 600515 601955 604098 604590 606167 610260 617382 621674 624409 625464 625473 628685 630767 633338 633381 635099 639229 647797 653754 654137 656868 659075 661099 661789 663690 665578 665900 666347 668939 669500 671446 682872 684880 689894 691584 692904 693395 698603 699122 699564 701207 704804 705806 707044 707143 710945 715379 715692 718654 720149 722031 723090 726999 728551 728945 732041 733461 734264 738276 739200 743990 745923 747372 748055 750467 751244 751899 752292 755688 757239 757465 764083 771206 777855 783338 800775 803640 806489 817573 818304 821005 821556 822704 823163 823397 823723 823999 824863 825301 826110 827257 827930 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation big cock"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.08%) |
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.