Query Metrics
7
Database Queries
7
Different statements
265.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
230.22 ms (86.77%) |
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 45856 163370 383785 384757 420163 424721 439405 443245 451246 451651 454511 457092 457950 458296 471146 472749 473055 475752 476798 490399 495542 497799 500342 513015 515542 516035 527531 528057 532741 543061 547485 550535 553684 553845 555171 556483 558736 560943 566862 568759 576759 580184 580265 584460 590255 590281 594293 596779 598388 601672 606578 609644 613224 616141 624751 626096 632687 639742 641938 648206 648882 652772 669012 669545 670442 672821 672822 675079 679891 686323 689525 692187 697860 701223 706022 706133 710142 710354 734852 742005 744051 744619 749577 749929 751045 754903 755038 755085 755342 758331 761344 767196 767701 770226 778863 779119 783610 783733 783989 785752 786291 786929 787370 790648 794035 797046 797050 797060 800672 806444 806793 807241 807571 808160 809057 809608 815699 825560 826715 ] |
||||||||||||||||||||||||||||||
|
24.20 ms (9.12%) |
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 806793 439405 451246 497799 476798 669545 679891 686323 550535 778863 783989 755085 767196 786929 794035 807241 809608 749577 755342 734852 758331 744619 706022 45856 590255 547485 584460 590281 825560 473055 471146 553684 555171 648882 706133 697860 624751 616141 626096 800672 783610 786291 807571 755038 761344 783733 797050 383785 443245 815699 454511 495542 558736 553845 580265 596779 598388 601672 604621 594293 420163 457092 490399 528057 513015 669012 632687 457950 500342 556483 472749 580184 648206 652772 710354 675079 689525 576759 641938 809057 785752 749929 790648 806444 754903 742005 609644 701223 787370 797046 163370 543061 384757 532741 639742 606578 451651 424721 527531 475752 566862 560943 568759 515542 826715 458296 672821 692187 710142 670442 672822 613224 808160 744051 767701 751045 770226 779119 797060 516035 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.20%) |
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 45856 163370 383785 384757 420163 424721 439405 443245 451246 451651 454511 457092 457950 458296 471146 472749 473055 475752 476798 490399 495542 497799 500342 513015 515542 516035 527531 528057 532741 543061 547485 550535 553684 553845 555171 556483 558736 560943 566862 568759 576759 580184 580265 584460 590255 590281 594293 596779 598388 601672 606578 609644 613224 616141 624751 626096 632687 639742 641938 648206 648882 652772 669012 669545 670442 672821 672822 675079 679891 686323 689525 692187 697860 701223 706022 706133 710142 710354 734852 742005 744051 744619 749577 749929 751045 754903 755038 755085 755342 758331 761344 767196 767701 770226 778863 779119 783610 783733 783989 785752 786291 786929 787370 790648 794035 797046 797050 797060 800672 806444 806793 807241 807571 808160 809057 809608 815699 825560 826715 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy dildo"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy дилд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy дилд"
]
|
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.