Query Metrics
7
Database Queries
7
Different statements
194.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.63 ms (85.23%) |
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 108555 387477 393222 396362 401193 418565 420825 448702 473692 485156 490325 495334 508625 510606 511615 522467 525293 525857 538658 539858 540874 541815 541947 542968 546698 547253 553422 554941 556579 558895 559988 560265 567642 569267 572279 576774 577717 580493 587340 591089 593825 595379 596314 596358 597978 598028 599276 603567 603617 608560 608780 609633 609643 609679 610968 612578 615506 616491 617859 622160 624649 625639 625646 632921 634011 634033 635029 641787 641796 642093 643777 645665 647074 648099 661044 661509 663780 666484 666680 667382 668942 671447 672259 673213 674938 678304 678879 679230 679296 679305 681710 682406 683407 686323 686589 689085 689830 696817 702960 703016 703026 703247 703280 703314 703325 705102 706531 708141 711867 720061 725627 739106 750407 753959 754172 798730 807319 812621 825748 ] |
||||||||||||||||||||||||||||||
|
18.08 ms (9.30%) |
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 667382 641787 706531 608560 420825 540874 490325 525857 495334 510606 525293 522467 539858 542968 560265 567642 580493 546698 556579 576774 645665 647074 648099 666680 671447 673213 674938 678304 678879 679230 679305 682406 683407 696817 702960 703026 703247 705102 720061 663780 672259 679296 681710 686589 689085 689830 703016 703280 703314 703325 661044 661509 666484 668942 686323 547253 553422 558895 569267 572279 596314 597978 598028 599276 608780 609633 615506 622160 625646 634011 634033 641796 587340 595379 643777 596358 603617 617859 635029 591089 593825 603567 609643 610968 616491 625639 642091 642093 753959 754172 739106 750407 725627 609679 612578 624649 632921 708141 711867 508625 387477 396362 798730 812621 807319 401193 108555 393222 418565 825748 485156 473692 448702 511615 538658 541815 577717 541947 554941 559988 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.66%) |
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 108555 387477 393222 396362 401193 418565 420825 448702 473692 485156 490325 495334 508625 510606 511615 522467 525293 525857 538658 539858 540874 541815 541947 542968 546698 547253 553422 554941 556579 558895 559988 560265 567642 569267 572279 576774 577717 580493 587340 591089 593825 595379 596314 596358 597978 598028 599276 603567 603617 608560 608780 609633 609643 609679 610968 612578 615506 616491 617859 622160 624649 625639 625646 632921 634011 634033 635029 641787 641796 642093 643777 645665 647074 648099 661044 661509 663780 666484 666680 667382 668942 671447 672259 673213 674938 678304 678879 679230 679296 679305 681710 682406 683407 686323 686589 689085 689830 696817 702960 703016 703026 703247 703280 703314 703325 705102 706531 708141 711867 720061 725627 739106 750407 753959 754172 798730 807319 812621 825748 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"студентки частное"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"студентк любительск"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"студентк любительск"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.