Query Metrics
7
Database Queries
7
Different statements
163.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.37 ms (83.91%) |
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 31822 38890 65336 207718 299335 323393 365056 382788 385405 386028 386732 393113 393692 397510 401368 409374 414119 414256 416192 421369 423266 424202 434345 434350 434683 435355 441280 441843 442114 445988 447432 451470 454165 454688 456091 462233 464667 468207 468256 469546 471001 471184 478720 483569 485296 485440 488934 492029 492537 496690 496879 496893 497296 499364 500956 503372 512841 516572 521604 521799 525399 529393 529794 531050 533397 536090 537990 538537 553222 553436 558402 569572 576841 584178 590720 595455 595625 600731 604419 606795 613943 618930 618934 619982 626092 626325 627060 637756 643146 666014 667097 679204 684839 684843 684855 684883 684888 684891 692543 695857 697703 703255 706473 714487 739316 742080 746709 748511 754647 758878 777339 783183 784045 785650 787019 793122 796381 808125 810753 814429 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (9.75%) |
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 468207 492537 619982 386028 497296 435355 468256 414119 434683 454688 414256 434345 434350 462233 471001 714487 393692 492029 451470 409374 401368 323393 382788 397510 525399 445988 569572 679204 442114 464667 478720 416192 421369 590720 469546 454165 423266 447432 604419 38890 441280 456091 488934 814429 529794 441843 483569 521604 576841 31822 606795 666014 692543 500956 529393 485296 499364 553222 299335 754647 697703 793122 784045 810753 516572 503372 496879 584178 595625 531050 537990 684883 746709 742080 706473 385405 386732 533397 521799 595455 600731 684839 695857 626092 618930 783183 808125 748511 758878 739316 618934 703255 777339 796381 667097 424202 65336 536090 538537 393113 485440 496893 626325 785650 496690 365056 558402 627060 471184 637756 787019 207718 512841 553436 684888 684891 684843 684855 643146 613943 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.18%) |
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 31822 38890 65336 207718 299335 323393 365056 382788 385405 386028 386732 393113 393692 397510 401368 409374 414119 414256 416192 421369 423266 424202 434345 434350 434683 435355 441280 441843 442114 445988 447432 451470 454165 454688 456091 462233 464667 468207 468256 469546 471001 471184 478720 483569 485296 485440 488934 492029 492537 496690 496879 496893 497296 499364 500956 503372 512841 516572 521604 521799 525399 529393 529794 531050 533397 536090 537990 538537 553222 553436 558402 569572 576841 584178 590720 595455 595625 600731 604419 606795 613943 618930 618934 619982 626092 626325 627060 637756 643146 666014 667097 679204 684839 684843 684855 684883 684888 684891 692543 695857 697703 703255 706473 714487 739316 742080 746709 748511 754647 758878 777339 783183 784045 785650 787019 793122 796381 808125 810753 814429 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.86%) |
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.