Query Metrics
7
Database Queries
7
Different statements
238.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.87 ms (88.15%) |
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 382043 389662 411344 414357 419292 432963 441929 443491 445737 456705 457022 466637 468835 470175 473515 479816 479990 481142 483553 484692 489309 492000 496033 498279 501239 506098 518372 518725 519349 521775 523181 523640 528775 529154 530479 530789 531194 532674 532737 532837 532897 532960 534372 534988 537584 537771 541118 541854 543772 544796 544963 545876 545989 546762 549432 554989 557122 561573 561919 566784 567908 570873 577371 580166 585446 588689 589701 600037 600352 601517 601613 606254 624833 625412 631209 632283 633768 634556 636303 636414 637442 639762 642037 644962 645284 650198 650345 650830 651634 653870 668505 674966 677303 677801 677986 678117 678161 696582 704526 705800 716695 716901 736022 739089 741687 745384 747468 752973 757427 762062 784653 787627 794190 794205 797215 802817 803832 817157 817507 821409 ] |
||||||||||||||||||||||||||||||
|
17.82 ms (7.48%) |
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 537584 501239 530479 817157 549432 797215 762062 432963 644962 537771 532737 532960 532837 530789 678161 677801 677986 704526 639762 600352 636303 601517 633768 492000 496033 456705 532897 752973 468835 543772 577371 653870 817507 561573 389662 518372 544963 570873 705800 554989 606254 589701 803832 736022 739089 419292 523640 545989 624833 484692 534988 696582 674966 637442 745384 411344 445737 794190 498279 636414 479990 528775 529154 519349 546762 457022 585446 481142 650198 632283 784653 534372 541854 483553 541118 741687 625412 650830 518725 716695 600037 531194 544796 634556 567908 521775 580166 650345 566784 588689 757427 794205 802817 473515 414357 677303 678117 716901 651634 668505 601613 631209 470175 545876 532674 443491 479816 506098 523181 557122 642037 821409 441929 645284 382043 466637 561919 489309 787627 747468 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.25%) |
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 382043 389662 411344 414357 419292 432963 441929 443491 445737 456705 457022 466637 468835 470175 473515 479816 479990 481142 483553 484692 489309 492000 496033 498279 501239 506098 518372 518725 519349 521775 523181 523640 528775 529154 530479 530789 531194 532674 532737 532837 532897 532960 534372 534988 537584 537771 541118 541854 543772 544796 544963 545876 545989 546762 549432 554989 557122 561573 561919 566784 567908 570873 577371 580166 585446 588689 589701 600037 600352 601517 601613 606254 624833 625412 631209 632283 633768 634556 636303 636414 637442 639762 642037 644962 645284 650198 650345 650830 651634 653870 668505 674966 677303 677801 677986 678117 678161 696582 704526 705800 716695 716901 736022 739089 741687 745384 747468 752973 757427 762062 784653 787627 794190 794205 797215 802817 803832 817157 817507 821409 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dildo blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие дилд минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.73%) |
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.