Query Metrics
7
Database Queries
7
Different statements
162.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.56 ms (85.85%) |
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 402566 466439 480353 487661 490168 495990 500777 508649 519401 522034 526990 530569 533800 535203 535953 540563 540858 545154 546389 547030 547608 548190 555150 555493 556197 560678 563325 565111 566625 567981 569383 576127 576605 579180 584437 585483 588840 589589 590522 592102 592172 592938 592986 593065 600671 601816 602887 604110 609089 614063 615103 615886 617549 619101 622336 622592 623115 629780 629794 629853 637401 639856 640483 644041 644172 648477 649062 650108 665602 666378 666602 668343 669244 669689 670569 674264 681787 684477 690290 704188 708530 709691 712398 719103 734005 734103 734958 736008 738949 739094 741681 741947 744685 745296 746697 746826 747159 749376 749393 751002 751392 752852 753119 755733 759338 765954 772500 772768 773031 773181 774706 777997 778110 784547 784720 785100 793008 812134 818808 820026 ] |
||||||||||||||||||||||||||||||
|
12.02 ms (7.40%) |
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 547608 547030 556197 560678 629794 588840 785100 784547 765954 784720 812134 759338 738949 739094 746826 753119 777997 530569 690290 708530 650108 669689 669244 670569 674264 704188 569383 614063 615886 640483 623115 639856 602887 592172 593065 601816 644041 567981 747159 576605 772768 490168 565111 487661 535953 526990 649062 585483 617549 619101 644172 749376 755733 773181 734103 741947 751392 773031 751002 745296 734958 736008 744685 749393 719103 522034 563325 622592 480353 774706 566625 519401 589589 604110 741681 546389 508649 533800 535203 579180 545154 576127 668343 681787 648477 666378 665602 709691 548190 555150 590522 615103 629780 592102 734005 629853 540563 555493 584437 712398 666602 622336 609089 793008 778110 540858 820026 772500 752852 746697 500777 495990 466439 592938 592986 637401 600671 818808 684477 402566 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.83%) |
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 402566 466439 480353 487661 490168 495990 500777 508649 519401 522034 526990 530569 533800 535203 535953 540563 540858 545154 546389 547030 547608 548190 555150 555493 556197 560678 563325 565111 566625 567981 569383 576127 576605 579180 584437 585483 588840 589589 590522 592102 592172 592938 592986 593065 600671 601816 602887 604110 609089 614063 615103 615886 617549 619101 622336 622592 623115 629780 629794 629853 637401 639856 640483 644041 644172 648477 649062 650108 665602 666378 666602 668343 669244 669689 670569 674264 681787 684477 690290 704188 708530 709691 712398 719103 734005 734103 734958 736008 738949 739094 741681 741947 744685 745296 746697 746826 747159 749376 749393 751002 751392 752852 753119 755733 759338 765954 772500 772768 773031 773181 774706 777997 778110 784547 784720 785100 793008 812134 818808 820026 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"эротический реальный секс"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.