Query Metrics
7
Database Queries
7
Different statements
147.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.52 ms (81.61%) |
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 338098 385185 393453 395577 397000 403262 406981 416312 417091 419176 422629 423376 438424 459370 490063 491768 495881 504161 505922 513787 526429 554974 559644 567052 590857 593253 600425 603507 603548 603549 605626 606575 607285 613001 623718 634305 634851 641679 644331 647372 648206 649152 649208 651896 653551 663274 669570 671730 672122 676907 682914 690294 693772 694032 694071 697278 697414 699164 699684 699723 701040 701495 702769 703059 703207 703514 703540 709295 718059 721203 721397 721791 721795 721836 723507 724253 729217 729258 729270 732742 741655 745663 759743 761576 770490 775907 784074 786153 789689 793915 797574 800266 801473 802018 802120 805166 805959 807471 807495 807513 808180 809403 809580 814236 815110 815738 816039 816917 820512 820822 821147 821216 821220 821376 821469 821924 822426 823018 825073 825102 ] |
||||||||||||||||||||||||||||||
|
15.89 ms (10.76%) |
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 821220 821924 815110 649152 649208 721397 723507 647372 669570 721791 789689 786153 802120 807513 724253 703207 721836 775907 807495 422629 395577 397000 821469 823018 513787 554974 653551 699164 699723 694071 607285 801473 809403 784074 729217 729258 697278 703059 703514 495881 605626 741655 644331 385185 419176 820822 718059 697414 671730 593253 641679 505922 393453 338098 403262 820512 822426 816039 816917 821216 815738 821147 825073 699684 651896 663274 701040 690294 623718 606575 805166 805959 802018 759743 732742 702769 809580 821376 613001 807471 490063 721795 504161 648206 793915 761576 600425 800266 603549 682914 703540 634851 797574 459370 676907 590857 634305 814236 603548 729270 672122 603507 770490 745663 825102 808180 438424 423376 721203 694032 701495 406981 526429 559644 709295 693772 416312 491768 417091 567052 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.92%) |
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 338098 385185 393453 395577 397000 403262 406981 416312 417091 419176 422629 423376 438424 459370 490063 491768 495881 504161 505922 513787 526429 554974 559644 567052 590857 593253 600425 603507 603548 603549 605626 606575 607285 613001 623718 634305 634851 641679 644331 647372 648206 649152 649208 651896 653551 663274 669570 671730 672122 676907 682914 690294 693772 694032 694071 697278 697414 699164 699684 699723 701040 701495 702769 703059 703207 703514 703540 709295 718059 721203 721397 721791 721795 721836 723507 724253 729217 729258 729270 732742 741655 745663 759743 761576 770490 775907 784074 786153 789689 793915 797574 800266 801473 802018 802120 805166 805959 807471 807495 807513 808180 809403 809580 814236 815110 815738 816039 816917 820512 820822 821147 821216 821220 821376 821469 821924 822426 823018 825073 825102 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жмж кончил"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро сперм"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.18%) |
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.