Query Metrics
7
Database Queries
7
Different statements
168.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.41 ms (85.61%) |
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 418548 418799 419173 420426 447518 453043 463515 474403 486860 497720 501287 501979 509621 511288 514810 527194 529792 538407 542345 545477 555076 555101 555110 559178 563320 564452 570701 574068 581104 584234 584825 588143 590209 592034 595459 600204 600669 600730 602789 603287 604363 609381 610322 612703 616442 617783 618770 624196 628181 630507 631538 631976 632965 634229 646927 647085 654919 655186 662144 666850 668523 670952 673833 674815 681958 684695 685714 695901 699225 700715 703370 707501 715152 717157 717986 718810 719957 721096 721773 722101 723369 724475 738834 741785 744790 751118 755108 758483 759673 759926 761619 762327 763182 764441 764528 766223 767982 768615 768902 770958 771045 779951 786182 787442 790126 791409 791543 792700 794458 794851 795142 799476 800314 801316 802003 805005 805536 809310 810996 813192 ] |
||||||||||||||||||||||||||||||
|
13.47 ms (7.99%) |
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 768615 768902 770958 741785 771045 761619 766223 602789 699225 721096 779951 787442 792700 800314 801316 805536 810996 813192 447518 418799 685714 486860 529792 559178 666850 418548 419173 538407 511288 497720 545477 555101 570701 723369 662144 703370 655186 668523 700715 707501 717157 721773 595459 603287 609381 628181 632965 600204 616442 618770 631538 790126 794458 794851 799476 805005 744790 764441 786182 791409 791543 795142 724475 755108 762327 764528 759673 759926 763182 767982 738834 751118 758483 715152 802003 809310 592034 420426 463515 453043 501287 501979 509621 527194 514810 474403 563320 564452 574068 584234 581104 542345 674815 718810 646927 654919 670952 673833 684695 695901 719957 722101 647085 681958 717986 555076 555110 584825 590209 600669 604363 612703 617783 624196 630507 631976 610322 634229 600730 588143 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (2.00%) |
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 418548 418799 419173 420426 447518 453043 463515 474403 486860 497720 501287 501979 509621 511288 514810 527194 529792 538407 542345 545477 555076 555101 555110 559178 563320 564452 570701 574068 581104 584234 584825 588143 590209 592034 595459 600204 600669 600730 602789 603287 604363 609381 610322 612703 616442 617783 618770 624196 628181 630507 631538 631976 632965 634229 646927 647085 654919 655186 662144 666850 668523 670952 673833 674815 681958 684695 685714 695901 699225 700715 703370 707501 715152 717157 717986 718810 719957 721096 721773 722101 723369 724475 738834 741785 744790 751118 755108 758483 759673 759926 761619 762327 763182 764441 764528 766223 767982 768615 768902 770958 771045 779951 786182 787442 790126 791409 791543 792700 794458 794851 795142 799476 800314 801316 802003 805005 805536 809310 810996 813192 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum extreme"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum хардкор"
]
|
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.