Query Metrics
7
Database Queries
7
Different statements
161.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.28 ms (86.97%) |
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 46788 353774 382939 385138 385507 386775 388620 401525 402570 403049 405331 411912 413316 420540 429150 429830 431213 435520 436646 437509 448517 448709 450762 457388 461742 467207 467566 467638 468690 469710 470625 471435 473833 475576 477640 477884 478343 478844 481781 482564 483362 484260 485476 487826 488502 489612 490799 490806 491570 492335 496397 496848 501326 501923 506876 508574 510630 510642 511202 512637 512644 517040 521370 521712 523051 531541 532050 532069 537705 537727 538996 543792 545524 547322 547335 547344 549347 551157 554635 556843 559129 560574 564417 566007 566857 567387 569417 571852 571895 572446 573777 574576 576420 579322 584042 584436 585526 595667 595803 598344 615532 638473 638570 655611 673552 675801 699671 724718 728286 771590 787177 792888 793557 795258 800409 802698 803228 803984 804118 813773 ] |
||||||||||||||||||||||||||||||
|
12.01 ms (7.45%) |
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 382939 429830 403049 508574 470625 595803 496397 569417 595667 490806 388620 482564 468690 487826 437509 488502 402570 549347 547322 436646 512644 490799 467638 554635 566007 429150 532050 510630 385138 431213 386775 353774 510642 571895 435520 538996 511202 556843 675801 567387 537705 547335 484260 475576 543792 491570 673552 385507 405331 448709 461742 467566 469710 467207 560574 572446 579322 478343 448517 473833 481781 477640 496848 501326 787177 547344 638473 802698 800409 771590 793557 401525 478844 532069 506876 545524 576420 573777 584436 585526 420540 501923 489612 523051 483362 485476 512637 537727 551157 559129 638570 795258 792888 521712 584042 655611 615532 803228 724718 728286 699671 803984 804118 450762 531541 471435 571852 566857 574576 564417 598344 477884 411912 517040 521370 492335 46788 413316 813773 457388 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.50%) |
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 46788 353774 382939 385138 385507 386775 388620 401525 402570 403049 405331 411912 413316 420540 429150 429830 431213 435520 436646 437509 448517 448709 450762 457388 461742 467207 467566 467638 468690 469710 470625 471435 473833 475576 477640 477884 478343 478844 481781 482564 483362 484260 485476 487826 488502 489612 490799 490806 491570 492335 496397 496848 501326 501923 506876 508574 510630 510642 511202 512637 512644 517040 521370 521712 523051 531541 532050 532069 537705 537727 538996 543792 545524 547322 547335 547344 549347 551157 554635 556843 559129 560574 564417 566007 566857 567387 569417 571852 571895 572446 573777 574576 576420 579322 584042 584436 585526 595667 595803 598344 615532 638473 638570 655611 673552 675801 699671 724718 728286 771590 787177 792888 793557 795258 800409 802698 803228 803984 804118 813773 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поцел сексуальн"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð┐ð¥ÐåðÁð╗Ðâð© ð© ÐüðÁð║ÐüÐâð░ð╗Ðîð¢Ðïð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.