Query Metrics
7
Database Queries
7
Different statements
144.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.10 ms (83.56%) |
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 396303 398499 413687 418117 418146 418622 434328 434345 434376 439244 441396 442527 450162 459213 466510 467885 468658 469794 473607 494546 496345 498795 500875 500945 505805 507713 513562 515874 528407 531291 531301 542181 547580 547795 555760 555821 556898 559368 564757 565547 574319 579863 582571 583807 587899 589623 595339 618750 622065 624839 652777 655517 657236 659343 665641 677839 678834 678842 680614 681486 719152 720576 721083 729301 732795 735888 735987 739810 740894 744150 744457 744782 748488 750626 757730 767753 768946 769338 772602 773254 773868 783921 783947 784048 784097 784138 784965 785075 785197 785320 786075 791492 791857 793201 794462 795818 795832 796365 796516 797036 797075 800054 801534 801795 801811 801842 803040 803568 804064 804711 807578 808321 808629 808659 808962 814419 820308 825685 826143 826973 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (9.63%) |
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 531291 531301 555760 719152 652777 657236 556898 589623 796365 796516 729301 744150 783947 786075 804711 748488 735987 768946 595339 659343 418622 418146 441396 559368 469794 496345 505805 515874 507713 655517 681486 564757 565547 624839 785197 797036 801811 803040 784965 808962 773254 783921 791857 795832 807578 808321 808659 618750 791492 801795 804064 808629 418117 434328 459213 467885 547580 665641 678842 677839 720576 784138 772602 803568 500945 450162 826143 820308 826973 825685 721083 680614 574319 794462 795818 797075 784097 744457 785075 785320 767753 769338 773868 740894 744782 732795 739810 757730 793201 801842 398499 814419 542181 678834 582571 622065 800054 801534 750626 784048 494546 528407 500875 579863 547795 583807 587899 439244 498795 555821 434376 735888 396303 442527 413687 434345 468658 473607 466510 513562 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.95%) |
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 396303 398499 413687 418117 418146 418622 434328 434345 434376 439244 441396 442527 450162 459213 466510 467885 468658 469794 473607 494546 496345 498795 500875 500945 505805 507713 513562 515874 528407 531291 531301 542181 547580 547795 555760 555821 556898 559368 564757 565547 574319 579863 582571 583807 587899 589623 595339 618750 622065 624839 652777 655517 657236 659343 665641 677839 678834 678842 680614 681486 719152 720576 721083 729301 732795 735888 735987 739810 740894 744150 744457 744782 748488 750626 757730 767753 768946 769338 772602 773254 773868 783921 783947 784048 784097 784138 784965 785075 785197 785320 786075 791492 791857 793201 794462 795818 795832 796365 796516 797036 797075 800054 801534 801795 801811 801842 803040 803568 804064 804711 807578 808321 808629 808659 808962 814419 820308 825685 826143 826973 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жена сквирт"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.08%) |
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.