Query Metrics
7
Database Queries
7
Different statements
195.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.71 ms (87.64%) |
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 261891 390050 391722 401243 411196 411300 418426 427559 435589 435614 456866 456867 466985 468926 471172 475731 475756 481609 488213 493090 498125 504081 505768 506302 507624 517039 522725 526557 529692 529884 532222 532273 532440 532470 532476 532607 534076 539218 541150 545125 545628 548165 553708 563687 564609 565137 565290 566011 571167 573131 576509 576522 577142 579672 580519 585475 588506 588615 591571 593007 593057 596732 598533 601163 605109 607850 610171 614562 615614 629313 631830 633034 633480 636582 641250 646877 650986 655449 666155 666193 666428 671085 675329 686792 692777 698483 710677 714634 729466 736973 737752 738242 740575 741824 743506 745469 749645 750387 750514 751332 755741 762153 765650 769408 769963 771530 775668 776570 776607 779564 784022 787534 795725 802287 803489 808153 811256 814379 823889 ] |
||||||||||||||||||||||||||||||
|
13.94 ms (7.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 548165 585475 629313 631830 636582 596732 607850 641250 775668 811256 787534 802287 729466 769408 769963 765650 737752 743506 738242 740575 749645 771530 633480 698483 795725 808153 435589 505768 390050 411196 814379 468926 456867 532470 506302 532440 532476 539218 529884 488213 553708 579672 545628 571167 563687 565137 666193 692777 714634 650986 655449 666155 686792 545125 564609 593007 615614 588506 588615 610171 633034 593057 598533 601163 605109 614562 591571 776570 779564 784022 803489 736973 741824 750387 751332 755741 750514 762153 745469 776607 427559 481609 435614 456866 475731 498125 526557 517039 532222 541150 391722 261891 401243 411300 418426 823889 475756 448762 493090 471172 529692 534076 504081 522725 532273 532607 507624 466985 566011 576522 565290 573131 576509 577142 580519 646877 666428 671085 710677 675329 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.71%) |
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 261891 390050 391722 401243 411196 411300 418426 427559 435589 435614 456866 456867 466985 468926 471172 475731 475756 481609 488213 493090 498125 504081 505768 506302 507624 517039 522725 526557 529692 529884 532222 532273 532440 532470 532476 532607 534076 539218 541150 545125 545628 548165 553708 563687 564609 565137 565290 566011 571167 573131 576509 576522 577142 579672 580519 585475 588506 588615 591571 593007 593057 596732 598533 601163 605109 607850 610171 614562 615614 629313 631830 633034 633480 636582 641250 646877 650986 655449 666155 666193 666428 671085 675329 686792 692777 698483 710677 714634 729466 736973 737752 738242 740575 741824 743506 745469 749645 750387 750514 751332 755741 762153 765650 769408 769963 771530 775668 776570 776607 779564 784022 787534 795725 802287 803489 808153 811256 814379 823889 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic video"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик video"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик video"
]
|
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.