Query Metrics
7
Database Queries
7
Different statements
166.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.76 ms (81.98%) |
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 109176 373768 382180 385755 386468 387937 397265 398421 414070 416620 416680 416685 416824 416873 417580 417621 418367 419352 420277 420816 421352 421971 422101 423783 424271 425370 429555 429766 432694 434080 434104 434278 434293 434339 435568 437947 438615 439112 439653 441952 442431 442855 444052 445323 446446 446785 446796 447337 448000 448696 448914 451266 452362 452781 452922 453649 456131 456161 456928 457074 458034 458772 459005 460338 460378 463689 464844 468813 470068 470430 471088 473428 473723 473750 474126 476646 476666 478030 478519 478986 479727 480203 493553 498538 499059 499934 501239 507696 509984 510807 512143 516320 516686 522046 523393 525577 526584 527503 546059 547767 552761 554286 558171 563154 567077 567676 570115 572339 577513 579344 581083 582552 588846 594208 597810 601880 713125 743029 775539 827498 ] |
||||||||||||||||||||||||||||||
|
19.20 ms (11.51%) |
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 432694 434080 441952 416685 434278 417621 434104 453649 464844 493553 457074 473428 476646 526584 499934 460378 473723 558171 570115 572339 582552 546059 552761 567077 577513 563154 567676 601880 588846 597810 109176 416873 438615 456928 468813 373768 397265 416620 421971 435568 452362 459005 479727 417580 422101 448914 458772 478986 480203 416824 418367 452922 456161 458034 476666 478519 424271 442431 470068 527503 499059 512143 498538 509984 523393 510807 516320 827498 743029 398421 382180 516686 421352 452781 446446 554286 439653 448696 471088 423783 386468 425370 434339 442855 448000 713125 775539 419352 429555 439112 522046 525577 387937 414070 420277 420816 429766 437947 446796 456131 470430 474126 478030 446785 507696 501239 581083 579344 547767 594208 434293 463689 460338 416680 444052 451266 473750 385755 445323 447337 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.91%) |
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 109176 373768 382180 385755 386468 387937 397265 398421 414070 416620 416680 416685 416824 416873 417580 417621 418367 419352 420277 420816 421352 421971 422101 423783 424271 425370 429555 429766 432694 434080 434104 434278 434293 434339 435568 437947 438615 439112 439653 441952 442431 442855 444052 445323 446446 446785 446796 447337 448000 448696 448914 451266 452362 452781 452922 453649 456131 456161 456928 457074 458034 458772 459005 460338 460378 463689 464844 468813 470068 470430 471088 473428 473723 473750 474126 476646 476666 478030 478519 478986 479727 480203 493553 498538 499059 499934 501239 507696 509984 510807 512143 516320 516686 522046 523393 525577 526584 527503 546059 547767 552761 554286 558171 563154 567077 567676 570115 572339 577513 579344 581083 582552 588846 594208 597810 601880 713125 743029 775539 827498 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дилдо бабы"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.95%) |
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.