Query Metrics
7
Database Queries
7
Different statements
186.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.08 ms (82.79%) |
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 16897 87974 154491 159380 163135 281942 397509 397685 403896 408911 414050 414099 414253 414256 414595 415303 416174 416531 416561 416669 416690 416707 416725 418219 418780 419188 421993 424195 425243 428728 430103 431439 436132 439343 452780 473745 495747 500333 506115 512486 522639 526905 527922 529296 535295 540868 545459 548941 574377 576539 580782 580832 584337 594143 594230 594389 596649 598797 600144 602136 608076 609920 612997 619286 619570 628105 628106 630054 642149 642165 655242 657562 658850 659209 661455 691286 692657 697614 703277 705476 720186 729327 735703 738515 739139 739804 740315 740503 740931 741557 743208 744047 746096 749215 750145 751438 752592 752648 752753 758740 760513 766941 770261 770814 782854 783043 784217 785579 786899 791386 799759 799938 800318 803092 803632 804939 806924 806938 813195 ] |
||||||||||||||||||||||||||||||
|
22.55 ms (12.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 800318 729327 739804 743208 746096 750145 752592 760513 799938 803092 803632 397685 495747 596649 436132 418219 415303 416561 416725 416669 527922 619286 512486 154491 431439 416174 414595 414099 414253 540868 506115 522639 574377 545459 580782 580832 720186 655242 608076 628105 609920 594143 600144 782854 770814 806938 735703 752648 628106 87974 414050 418780 16897 758740 403896 416707 500333 526905 421993 576539 419188 414256 281942 159380 163135 439343 428728 584337 602136 397509 424195 813195 430103 473745 594389 416531 408911 416690 425243 659209 548941 744047 752753 770261 739139 452780 598797 529296 535295 512930 658850 661455 691286 692657 697614 657562 705476 612997 642149 630054 642165 594230 619570 784217 785579 786899 791386 799759 806924 740315 749215 751438 804939 741557 766941 740503 738515 740931 703277 783043 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.36%) |
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 16897 87974 154491 159380 163135 281942 397509 397685 403896 408911 414050 414099 414253 414256 414595 415303 416174 416531 416561 416669 416690 416707 416725 418219 418780 419188 421993 424195 425243 428728 430103 431439 436132 439343 452780 473745 495747 500333 506115 512486 522639 526905 527922 529296 535295 540868 545459 548941 574377 576539 580782 580832 584337 594143 594230 594389 596649 598797 600144 602136 608076 609920 612997 619286 619570 628105 628106 630054 642149 642165 655242 657562 658850 659209 661455 691286 692657 697614 703277 705476 720186 729327 735703 738515 739139 739804 740315 740503 740931 741557 743208 744047 746096 749215 750145 751438 752592 752648 752753 758740 760513 766941 770261 770814 782854 783043 784217 785579 786899 791386 799759 799938 800318 803092 803632 804939 806924 806938 813195 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд teen вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo teen webcam"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд teen вебкамер"
]
|
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.