Query Metrics
7
Database Queries
7
Different statements
154.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.68 ms (82.58%) |
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 6968 7502 11013 55966 341608 381771 385344 386232 386813 388687 389197 390533 395701 396724 397045 398307 403348 404935 405468 413594 414778 424648 427475 431948 433085 433156 433166 433212 433238 433497 452648 464127 473969 474642 475227 479844 491474 516307 524213 525516 536614 565168 587191 591612 604470 605344 608446 616336 620130 622656 632557 635274 637072 638565 643114 649129 649133 649135 649172 649931 652284 654189 662562 672130 674733 676448 678954 679090 683564 683584 684200 693049 693980 696250 697266 697364 697372 697785 697973 699632 699667 699755 700282 703432 705791 707328 707347 708468 708525 709589 711643 711902 712001 720385 720835 721332 721367 722871 733889 741097 741274 741280 741284 744103 746980 751512 752935 766605 770797 770875 772664 775795 777140 778533 784247 793427 799582 814268 815102 827404 ] |
||||||||||||||||||||||||||||||
|
15.79 ms (10.22%) |
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 741280 390533 381771 55966 11013 398307 678954 707328 662562 587191 605344 766605 427475 395701 433497 516307 424648 616336 474642 565168 386232 536614 684200 697266 708468 784247 777140 733889 746980 479844 491474 620130 433156 433166 652284 622656 591612 707347 632557 744103 6968 751512 635274 433085 413594 433238 7502 431948 697785 721332 703432 649129 649133 649135 676448 699632 699667 775795 741274 711643 712001 433212 827404 814268 525516 697973 705791 679090 683584 708525 770797 741097 772664 721367 793427 396724 637072 752935 389197 473969 388687 464127 405468 815102 693980 696250 697364 700282 649172 649931 672130 683564 720835 654189 674733 693049 699755 608446 643114 778533 799582 770875 741284 697372 709589 711902 720385 404935 604470 403348 475227 397045 722871 524213 386813 452648 385344 414778 341608 638565 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.00%) |
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 6968 7502 11013 55966 341608 381771 385344 386232 386813 388687 389197 390533 395701 396724 397045 398307 403348 404935 405468 413594 414778 424648 427475 431948 433085 433156 433166 433212 433238 433497 452648 464127 473969 474642 475227 479844 491474 516307 524213 525516 536614 565168 587191 591612 604470 605344 608446 616336 620130 622656 632557 635274 637072 638565 643114 649129 649133 649135 649172 649931 652284 654189 662562 672130 674733 676448 678954 679090 683564 683584 684200 693049 693980 696250 697266 697364 697372 697785 697973 699632 699667 699755 700282 703432 705791 707328 707347 708468 708525 709589 711643 711902 712001 720385 720835 721332 721367 722871 733889 741097 741274 741280 741284 744103 746980 751512 752935 766605 770797 770875 772664 775795 777140 778533 784247 793427 799582 814268 815102 827404 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens анал секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens anal threesome"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens анал секс втро"
]
|
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.