Query Metrics
7
Database Queries
7
Different statements
152.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.55 ms (80.37%) |
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 388532 396740 399908 399912 400915 408460 413404 413584 413685 418578 418607 424362 424593 427311 432268 435078 435722 439256 439504 444956 445180 447697 447759 450579 452572 453963 463793 464188 470892 475416 485102 495208 497924 500299 503292 504488 508692 512073 515440 517974 527428 531677 531868 533944 535279 543476 545469 546571 552567 552608 565470 566729 579457 579797 583665 592576 594131 594285 594293 595977 598524 599990 602614 609926 624942 627724 628401 631947 642060 642323 648527 652612 653268 653455 656931 661455 666880 666894 679799 685807 688581 693502 696103 703142 704275 704910 705239 707391 713163 713877 720828 733887 735772 744021 744323 748927 748965 752652 754470 755188 757395 760254 766611 769792 770271 771452 782547 782731 787952 788954 790069 791365 802317 805039 805335 806924 820652 826455 827404 ] |
||||||||||||||||||||||||||||||
|
19.94 ms (13.08%) |
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 435722 447697 475416 552608 552567 631947 624942 642060 807580 432268 424362 447759 418578 418607 439504 515440 500299 566729 653455 602614 445180 826455 463793 531868 531677 565470 648527 713877 653268 661455 705239 685807 782731 791365 806924 771452 802317 769792 748965 754470 704275 399908 503292 609926 413584 707391 666880 666894 545469 396740 413685 452572 508692 693502 704910 408460 439256 435078 464188 527428 535279 679799 688581 595977 628401 599990 770271 427311 450579 444956 512073 388532 413404 517974 495208 579797 543476 579457 696103 713163 642323 594285 782547 805335 787952 788954 790069 760254 748927 752652 733887 755188 735772 744021 744323 757395 766611 400915 533944 583665 546571 594293 627724 805039 504488 598524 399912 424593 820652 827404 453963 470892 485102 497924 656931 703142 652612 720828 594131 592576 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.85%) |
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 388532 396740 399908 399912 400915 408460 413404 413584 413685 418578 418607 424362 424593 427311 432268 435078 435722 439256 439504 444956 445180 447697 447759 450579 452572 453963 463793 464188 470892 475416 485102 495208 497924 500299 503292 504488 508692 512073 515440 517974 527428 531677 531868 533944 535279 543476 545469 546571 552567 552608 565470 566729 579457 579797 583665 592576 594131 594285 594293 595977 598524 599990 602614 609926 624942 627724 628401 631947 642060 642323 648527 652612 653268 653455 656931 661455 666880 666894 679799 685807 688581 693502 696103 703142 704275 704910 705239 707391 713163 713877 720828 733887 735772 744021 744323 748927 748965 752652 754470 755188 757395 760254 766611 769792 770271 771452 782547 782731 787952 788954 790069 791365 802317 805039 805335 806924 820652 826455 827404 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen squirt"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.12%) |
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.