Query Metrics
7
Database Queries
7
Different statements
380.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.71 ms (55.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"a skinny man"
]
|
||||||||||||||||||||||||||||||
|
141.62 ms (37.17%) |
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 23065 192691 249773 395392 395585 395895 400459 401987 416288 416797 419855 422978 422993 423006 423023 425707 425832 426159 429234 429748 430057 430949 431975 444935 445803 446518 447247 451708 461714 467225 468714 485197 494820 501892 509448 518330 534178 539381 544349 544350 546703 547389 549258 552014 552599 552711 559605 565545 565944 568018 572611 573565 574001 579950 585140 591520 599406 601689 603126 606124 606260 607291 609866 610243 618901 624238 646343 654619 656361 656751 657420 658014 658296 659161 659642 663899 668814 670038 670313 674536 682600 685355 685612 687187 694541 697168 700541 702674 703510 710959 719997 720505 720766 721813 724572 735985 737417 737763 744443 748584 761071 775621 789299 789313 790971 797705 802560 807537 810234 810843 817035 817385 817622 817630 817685 818379 819993 820205 822137 823534 ] |
||||||||||||||||||||||||||||||
|
19.21 ms (5.04%) |
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 400459 461714 430949 468714 501892 509448 534178 494820 518330 485197 249773 23065 192691 817385 820205 817035 817630 817685 817622 818379 819993 822137 823534 467225 539381 547389 552599 573565 579950 549258 565545 565944 544349 544350 552014 552711 559605 568018 657420 659161 670313 685355 685612 719997 720505 646343 658296 659642 663899 670038 682600 694541 697168 720766 654619 656361 656751 658014 668814 674536 687187 700541 702674 710959 721813 546703 572611 574001 599406 603126 606124 606260 591520 601689 607291 624238 610243 618901 797705 802560 724572 735985 737417 790971 810234 748584 737763 761071 744443 609866 703510 775621 789299 789313 807537 810843 395585 395392 395895 401987 416288 422978 422993 423006 423023 425707 426159 429748 419855 425832 431975 444935 416797 429234 430057 585140 446518 447247 451708 445803 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (0.90%) |
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 23065 192691 249773 395392 395585 395895 400459 401987 416288 416797 419855 422978 422993 423006 423023 425707 425832 426159 429234 429748 430057 430949 431975 444935 445803 446518 447247 451708 461714 467225 468714 485197 494820 501892 509448 518330 534178 539381 544349 544350 546703 547389 549258 552014 552599 552711 559605 565545 565944 568018 572611 573565 574001 579950 585140 591520 599406 601689 603126 606124 606260 607291 609866 610243 618901 624238 646343 654619 656361 656751 657420 658014 658296 659161 659642 663899 668814 670038 670313 674536 682600 685355 685612 687187 694541 697168 700541 702674 703510 710959 719997 720505 720766 721813 724572 735985 737417 737763 744443 748584 761071 775621 789299 789313 790971 797705 802560 807537 810234 810843 817035 817385 817622 817630 817685 818379 819993 820205 822137 823534 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.40%) |
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.