Query Metrics
7
Database Queries
7
Different statements
163.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.16 ms (84.14%) |
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 396094 408546 411829 415988 422599 430444 443603 444773 451009 453929 467096 475915 478427 483581 493324 499212 512198 513822 524574 525401 527484 531083 532599 533660 537113 540082 540086 542207 550735 551987 554418 559161 560215 561602 565481 565978 565985 570759 575715 580609 584339 585364 588115 592673 596856 596969 601160 604319 605024 606538 607845 612994 618753 622649 623572 630492 630521 633746 635351 638829 639783 643383 645525 645634 646776 648688 671172 672227 712089 712884 714304 717947 718995 722187 724285 724928 726647 736433 745892 745927 747169 749080 750118 752198 754877 755334 755335 759315 759881 761369 761565 767029 775584 776189 776935 778149 782413 784197 787845 788187 789999 790196 792547 795416 798403 800619 801193 802719 804085 805431 805789 807915 809462 810813 815893 817045 818371 818539 822721 ] |
||||||||||||||||||||||||||||||
|
16.26 ms (9.97%) |
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 588107 596969 638829 778149 787845 804085 745892 761369 784197 792547 798403 805789 754877 759315 759881 747169 755335 767029 745927 605024 622649 714304 790196 801193 788187 533660 554418 550735 592673 604319 499212 467096 561602 805431 776935 443603 422599 527484 596856 559161 565481 618753 633746 531083 607845 408546 444773 671172 810813 761565 755334 809462 551987 565978 560215 430444 580609 724285 724928 817045 815893 818371 822721 818539 451009 478427 493324 513822 540082 532599 540086 584339 672227 718995 712884 645525 645634 648688 712089 717947 722187 565985 585364 630492 630521 643383 588115 612994 789999 795416 800619 775584 776189 802719 749080 752198 726647 736433 750118 623572 635351 782413 807915 542207 606538 415988 639783 475915 537113 512198 525401 570759 575715 601160 483581 524574 396094 411829 453929 646776 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.47%) |
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 396094 408546 411829 415988 422599 430444 443603 444773 451009 453929 467096 475915 478427 483581 493324 499212 512198 513822 524574 525401 527484 531083 532599 533660 537113 540082 540086 542207 550735 551987 554418 559161 560215 561602 565481 565978 565985 570759 575715 580609 584339 585364 588115 592673 596856 596969 601160 604319 605024 606538 607845 612994 618753 622649 623572 630492 630521 633746 635351 638829 639783 643383 645525 645634 646776 648688 671172 672227 712089 712884 714304 717947 718995 722187 724285 724928 726647 736433 745892 745927 747169 749080 750118 752198 754877 755334 755335 759315 759881 761369 761565 767029 775584 776189 776935 778149 782413 784197 787845 788187 789999 790196 792547 795416 798403 800619 801193 802719 804085 805431 805789 807915 809462 810813 815893 817045 818371 818539 822721 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian big ass"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.87%) |
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.