Query Metrics
7
Database Queries
7
Different statements
189.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.46 ms (85.01%) |
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 61536 61726 385947 386209 399416 401642 409274 410267 410745 414341 414767 415745 415755 416025 418952 421820 427258 429869 432883 438430 439797 441203 444117 446012 453409 455746 463973 466204 466905 468241 479768 481335 485374 490381 490731 501342 504124 506765 515265 517235 523882 526837 529512 544799 544816 549740 560932 562461 565261 567427 575983 576772 578301 578586 585296 589866 593155 600951 607665 607685 616165 620391 623997 627254 630083 631615 632823 634746 637456 640350 642928 649528 664579 664594 665294 665586 666446 667011 667756 669324 670185 685527 708202 710142 710590 713122 713635 714378 724309 728146 741685 744360 744985 753033 754843 769474 770103 781785 781825 781862 781936 794223 794647 796808 799934 800542 800727 800733 800753 803520 804444 804729 804802 808067 808160 808161 812755 813808 814037 825419 ] |
||||||||||||||||||||||||||||||
|
17.59 ms (9.26%) |
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 529512 501342 490731 634746 479768 670185 665586 589866 800727 576772 600951 804444 804729 623997 804802 415755 414341 578586 61726 713635 803520 401642 468241 429869 444117 410745 825419 455746 466905 490381 446012 560932 549740 562461 667011 710142 713122 649528 664579 666446 642928 781785 781862 781825 800753 799934 800542 808161 744985 753033 770103 741685 754843 728146 744360 769474 781936 796808 800733 808067 427258 439797 441203 453409 463973 410267 504124 578301 415745 418952 517235 575983 664594 627254 620391 794223 812755 523882 61536 544799 585296 631615 808160 794647 813808 515265 665294 632823 724309 399416 526837 506765 544816 416025 565261 567427 630083 466204 432883 421820 485374 414767 386209 385947 438430 409274 814037 481335 669324 667756 685527 708202 710590 714378 593155 616165 637456 640350 607665 607685 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.81%) |
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 61536 61726 385947 386209 399416 401642 409274 410267 410745 414341 414767 415745 415755 416025 418952 421820 427258 429869 432883 438430 439797 441203 444117 446012 453409 455746 463973 466204 466905 468241 479768 481335 485374 490381 490731 501342 504124 506765 515265 517235 523882 526837 529512 544799 544816 549740 560932 562461 565261 567427 575983 576772 578301 578586 585296 589866 593155 600951 607665 607685 616165 620391 623997 627254 630083 631615 632823 634746 637456 640350 642928 649528 664579 664594 665294 665586 666446 667011 667756 669324 670185 685527 708202 710142 710590 713122 713635 714378 724309 728146 741685 744360 744985 753033 754843 769474 770103 781785 781825 781862 781936 794223 794647 796808 799934 800542 800727 800733 800753 803520 804444 804729 804802 808067 808160 808161 812755 813808 814037 825419 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby big dildo"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby большие дилд"
]
|
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.