Query Metrics
7
Database Queries
7
Different statements
175.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.09 ms (85.76%) |
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 6941 92307 162000 310758 352189 387647 394941 396331 398618 399904 402425 412733 421189 421814 424190 426024 428024 432656 434342 435793 436694 440087 440261 441353 441566 448756 450587 455885 456564 464202 464246 464705 469420 470425 475805 478446 483557 485344 489381 500620 521127 525142 526054 528878 532300 535450 538681 541776 543629 547418 547858 555149 555593 564565 564876 576628 580595 583062 583121 584229 593787 606651 607325 617851 620158 635558 642335 643602 644406 650262 657186 657230 679171 680442 688617 700327 710877 712272 715892 726776 729333 738686 739132 750498 756789 759895 761570 761679 765589 766799 770612 776222 778628 780706 781412 783275 787283 788450 789182 789595 791493 792671 794067 794765 795425 797332 800355 801306 810301 812069 812905 817194 817256 817275 817832 821576 822686 824200 826290 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (8.30%) |
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 761570 770612 739132 750498 620158 643602 710877 715892 780706 787283 788450 789182 387647 448756 424190 428024 483557 532300 538681 475805 547418 555593 399904 440261 456564 470425 525142 576628 464202 455885 688617 817194 817256 817275 822686 617851 794309 800355 435793 396331 817832 824200 543629 547858 680442 635558 776222 759895 738686 812069 464246 450587 489381 564565 398618 821576 657186 657230 712272 679171 650262 644406 642335 778628 791493 792671 797332 801306 766799 781412 789595 794067 794765 812905 726776 761679 765589 729333 756789 700327 783275 795425 810301 526054 583062 555149 607325 521127 535450 826290 580595 593787 606651 162000 478446 564876 352189 436694 485344 402425 394941 310758 432656 441353 440087 412733 441566 469420 500620 464705 583121 584229 92307 6941 421189 421814 426024 434342 528878 541776 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.51%) |
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 6941 92307 162000 310758 352189 387647 394941 396331 398618 399904 402425 412733 421189 421814 424190 426024 428024 432656 434342 435793 436694 440087 440261 441353 441566 448756 450587 455885 456564 464202 464246 464705 469420 470425 475805 478446 483557 485344 489381 500620 521127 525142 526054 528878 532300 535450 538681 541776 543629 547418 547858 555149 555593 564565 564876 576628 580595 583062 583121 584229 593787 606651 607325 617851 620158 635558 642335 643602 644406 650262 657186 657230 679171 680442 688617 700327 710877 712272 715892 726776 729333 738686 739132 750498 756789 759895 761570 761679 765589 766799 770612 776222 778628 780706 781412 783275 787283 788450 789182 789595 791493 792671 794067 794765 795425 797332 800355 801306 810301 812069 812905 817194 817256 817275 817832 821576 822686 824200 826290 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal no panties"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.00%) |
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.