Query Metrics
7
Database Queries
7
Different statements
158.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.73 ms (85.21%) |
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 65533 384911 386326 388715 391310 391510 392817 393531 393571 394012 395392 396168 396292 397087 397130 399922 404633 408439 408598 415520 416172 416847 417135 418369 420613 421747 423205 423580 423650 429009 432504 443467 443499 443589 446157 446162 464100 467597 473773 475070 478842 479190 482087 484464 495022 501652 507460 508265 511733 514470 515848 519559 523802 523999 524089 525778 533049 556033 556334 561361 561880 562637 566516 568936 577350 580624 595458 597498 605335 617134 619806 621691 630266 633474 649569 655062 674119 678726 678763 678769 686059 687927 688677 691994 696219 702633 708457 709703 716027 716161 720376 720484 720505 721298 721325 722751 725112 725409 740596 741539 753815 753853 758496 759575 759595 761076 771344 775698 776016 776878 807537 810701 810711 811669 812361 813599 814133 821329 821628 822172 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (9.13%) |
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 65533 388715 408598 421747 821329 514470 655062 720376 720505 678763 709703 619806 807537 393531 395392 621691 396168 495022 568936 519559 479190 467597 577350 617134 484464 720484 674119 775698 776878 759575 761076 432504 478842 507460 580624 523802 384911 423205 482087 562637 678769 418369 386326 394012 391510 391310 396292 397130 397087 404633 821628 813599 822172 814133 525778 464100 556033 678726 686059 691994 702633 708457 687927 688677 776016 810711 759595 753815 753853 771344 716161 392817 393571 475070 508265 416172 416847 423580 415520 417135 443467 473773 533049 566516 556334 561880 561361 696219 649569 722751 716027 633474 595458 597498 605335 810701 811669 725409 758496 725112 741539 740596 630266 721298 721325 812361 408439 429009 446157 446162 399922 443499 443589 501652 515848 523999 420613 524089 423650 511733 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.39%) |
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 65533 384911 386326 388715 391310 391510 392817 393531 393571 394012 395392 396168 396292 397087 397130 399922 404633 408439 408598 415520 416172 416847 417135 418369 420613 421747 423205 423580 423650 429009 432504 443467 443499 443589 446157 446162 464100 467597 473773 475070 478842 479190 482087 484464 495022 501652 507460 508265 511733 514470 515848 519559 523802 523999 524089 525778 533049 556033 556334 561361 561880 562637 566516 568936 577350 580624 595458 597498 605335 617134 619806 621691 630266 633474 649569 655062 674119 678726 678763 678769 686059 687927 688677 691994 696219 702633 708457 709703 716027 716161 720376 720484 720505 721298 721325 722751 725112 725409 740596 741539 753815 753853 758496 759575 759595 761076 771344 775698 776016 776878 807537 810701 810711 811669 812361 813599 814133 821329 821628 822172 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen man sperm"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen мужчин сперм"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen мужчин сперм"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.93%) |
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.