Query Metrics
7
Database Queries
7
Different statements
220.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.50 ms (89.44%) |
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 385059 397562 398787 408136 420219 426277 440261 443724 457997 461406 464176 465897 467089 473904 475374 476884 483334 488454 526667 528632 533526 533771 534660 535363 536026 536282 536317 537167 538681 544289 549657 558928 559089 565008 570847 577439 587831 589235 593002 599738 602515 604044 604843 605019 617640 627158 650673 650945 651822 666970 675065 675126 675703 692740 705408 708842 710922 714547 723043 725492 728246 738331 739636 739889 741354 746580 746723 747058 748299 752865 760803 760988 779711 781299 784857 786095 788100 789295 789420 790696 790780 791518 791526 794778 795135 795202 796504 797020 798019 798949 799111 799730 801019 802571 803979 804975 806492 811458 812161 812472 814476 815242 815264 815539 817038 817845 817859 818445 818522 819242 819309 819742 823451 823950 827038 827538 828178 828648 ] |
||||||||||||||||||||||||||||||
|
13.24 ms (6.00%) |
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 465897 537167 790696 483334 817845 818445 819242 814476 819309 823950 826415 827038 827538 815242 815264 815539 817038 817859 818522 819742 823451 828178 828648 828531 526667 533771 535363 533526 536026 536317 534660 544289 558928 570847 650673 651822 650945 666970 692740 708842 587831 617640 589235 605019 627158 779711 788100 790780 795202 801019 804975 811458 812472 791518 791526 798019 802571 806492 748299 760803 781299 786095 789295 789420 794778 795135 798949 739636 752865 760988 746580 728246 738331 746723 739889 741354 747058 705408 710922 714547 723043 784857 796504 797020 799111 799730 803979 812161 443724 397562 385059 420219 473904 488454 467089 457997 536282 538681 476884 559089 549657 675065 602515 604044 604843 593002 440261 461406 565008 675703 599738 725492 528632 408136 577439 675126 475374 398787 426277 464176 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.34%) |
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 385059 397562 398787 408136 420219 426277 440261 443724 457997 461406 464176 465897 467089 473904 475374 476884 483334 488454 526667 528632 533526 533771 534660 535363 536026 536282 536317 537167 538681 544289 549657 558928 559089 565008 570847 577439 587831 589235 593002 599738 602515 604044 604843 605019 617640 627158 650673 650945 651822 666970 675065 675126 675703 692740 705408 708842 710922 714547 723043 725492 728246 738331 739636 739889 741354 746580 746723 747058 748299 752865 760803 760988 779711 781299 784857 786095 788100 789295 789420 790696 790780 791518 791526 794778 795135 795202 796504 797020 798019 798949 799111 799730 801019 802571 803979 804975 806492 811458 812161 812472 814476 815242 815264 815539 817038 817845 817859 818445 818522 819242 819309 819742 823451 823950 827038 827538 828178 828648 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf panties"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf трусик нижн бел"
]
|
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.