Query Metrics
7
Database Queries
7
Different statements
360.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
226.36 ms (62.83%) |
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 666579 671714 506048 675022 457772 456791 458432 573211 674128 824052 522882 674492 571136 807196 699744 545444 318795 520753 583982 386935 805594 515545 591882 233446 748239 568061 755145 635614 95855 400928 411572 551070 760240 760928 457776 802062 787387 387720 484656 388492 191575 683826 411134 459178 414360 465618 670108 603151 735430 390378 396568 393067 597870 406881 536210 717724 671740 631913 644296 826118 828420 546449 693931 721746 612419 810771 398773 814893 469436 475466 696355 589208 595772 703091 775818 516686 391744 396336 427224 784621 184359 818323 95700 820768 670773 645233 648819 775810 795139 805600 424634 397781 645249 697173 513850 631211 384786 381883 426394 714014 692796 817349 478445 524955 651082 669567 671751 634477 790382 756023 621323 457762 454277 466103 814382 708829 690809 739613 477705 399628 ] |
||||||||||||||||||||||||||||||
|
123.48 ms (34.27%) |
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 95700 95855 184359 191575 233446 318795 381883 384786 386935 387720 388492 390378 391744 393067 396336 396568 397781 398773 399628 400928 406881 411134 411572 414360 424634 426394 427224 454277 456791 457762 457772 457776 458432 459178 465618 466103 469436 475466 477705 478445 484656 506048 513850 515545 516686 520753 522882 524955 536210 545444 546449 551070 568061 571136 573211 583982 589208 591882 595772 597870 603151 612419 621323 631211 631913 634477 635614 644296 645233 645249 648819 651082 666579 669567 670108 670773 671714 671740 671751 674128 674492 675022 683826 690809 692796 693931 696355 697173 699744 703091 708829 714014 717724 721746 735430 739613 748239 755145 756023 760240 760928 775810 775818 784621 787387 790382 795139 802062 805594 805600 807196 810771 814382 814893 817349 818323 820768 824052 826118 828420 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (0.97%) |
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 95700 95855 184359 191575 233446 318795 381883 384786 386935 387720 388492 390378 391744 393067 396336 396568 397781 398773 399628 400928 406881 411134 411572 414360 424634 426394 427224 454277 456791 457762 457772 457776 458432 459178 465618 466103 469436 475466 477705 478445 484656 506048 513850 515545 516686 520753 522882 524955 536210 545444 546449 551070 568061 571136 573211 583982 589208 591882 595772 597870 603151 612419 621323 631211 631913 634477 635614 644296 645233 645249 648819 651082 666579 669567 670108 670773 671714 671740 671751 674128 674492 675022 683826 690809 692796 693931 696355 697173 699744 703091 708829 714014 717724 721746 735430 739613 748239 755145 756023 760240 760928 775810 775818 784621 787387 790382 795139 802062 805594 805600 807196 810771 814382 814893 817349 818323 820768 824052 826118 828420 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"групповой секс мама"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"группов секс мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.46 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.