Query Metrics
7
Database Queries
7
Different statements
172.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.66 ms (85.16%) |
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 96200 130089 381883 383517 384786 388411 396336 397232 397781 398773 399628 401396 402030 405406 406881 408969 411134 411953 424634 426394 427224 427530 440713 443738 459158 469436 475466 476178 478445 490038 500364 504213 514697 515569 524955 525626 526130 532361 532670 533595 536210 538888 540497 544792 551997 554313 569192 570741 589208 590421 595741 595772 597870 601544 603151 603259 604493 606511 606561 612062 612419 614529 621323 631913 634477 644296 645233 645891 645948 648819 649964 651082 661882 663410 663927 664321 669567 670108 670773 671740 671751 672015 683826 686835 690809 692796 694207 694485 696355 703091 710102 713635 714014 717724 718974 738821 739613 748226 748231 748240 748245 756023 775810 775818 775880 775889 784621 790382 795139 805600 806022 810771 814893 817349 817929 819493 820768 823313 823806 827829 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (8.65%) |
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 401396 645891 96200 398773 399628 406881 411953 814893 817349 820768 469436 475466 476178 478445 524955 536210 649964 651082 664321 670773 717724 645233 670108 683826 696355 648819 669567 671740 671751 631913 589208 590421 634477 603151 595772 601544 775810 806022 748226 790382 795139 748245 748240 756023 621323 644296 703091 775818 805600 388411 130089 424634 551997 603259 427530 440713 526130 525626 500364 554313 606561 504213 408969 748231 443738 570741 384786 381883 396336 397232 397781 402030 405406 426394 427224 823806 827829 459158 663410 690809 714014 692796 713635 612419 810771 739613 738821 784621 645948 383517 411134 823313 817929 819493 533595 515569 538888 540497 514697 532361 532670 490038 544792 661882 718974 672015 686835 663927 694207 694485 710102 569192 595741 604493 597870 606511 612062 614529 775880 775889 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.84%) |
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 96200 130089 381883 383517 384786 388411 396336 397232 397781 398773 399628 401396 402030 405406 406881 408969 411134 411953 424634 426394 427224 427530 440713 443738 459158 469436 475466 476178 478445 490038 500364 504213 514697 515569 524955 525626 526130 532361 532670 533595 536210 538888 540497 544792 551997 554313 569192 570741 589208 590421 595741 595772 597870 601544 603151 603259 604493 606511 606561 612062 612419 614529 621323 631913 634477 644296 645233 645891 645948 648819 649964 651082 661882 663410 663927 664321 669567 670108 670773 671740 671751 672015 683826 686835 690809 692796 694207 694485 696355 703091 710102 713635 714014 717724 718974 738821 739613 748226 748231 748240 748245 756023 775810 775818 775880 775889 784621 790382 795139 805600 806022 810771 814893 817349 817929 819493 820768 823313 823806 827829 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"групповое порно женщин"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"группов порн женщин"
]
|
||||||||||||||||||||||||||||||
|
1.48 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.