Query Metrics
7
Database Queries
7
Different statements
155.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.10 ms (82.15%) |
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 204605 365924 384911 399622 402530 406342 421482 422096 428849 429434 433867 437244 438929 438972 442985 446064 451161 453870 456262 457582 459752 463289 463710 464502 466042 466958 469749 472817 475032 479167 484038 486708 487557 488409 492576 494323 497565 498734 502663 504102 504809 508750 510371 511141 513664 514276 515833 516012 519657 521596 531412 533256 534040 535427 536525 537424 539318 542002 542600 542959 545820 547561 548227 550996 556472 560269 560777 562275 562277 562708 564688 570013 571219 571932 572322 572445 572523 573674 578817 589315 601194 604726 605872 605918 607123 613239 613365 637522 639252 649964 651611 668437 678166 687431 689616 693246 710343 717620 720743 777173 777921 778471 778623 778994 780030 783235 784744 784755 786359 787896 794091 801026 802120 804982 805242 806842 806919 816755 816963 821044 ] |
||||||||||||||||||||||||||||||
|
17.13 ms (10.99%) |
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 777173 777921 778623 784744 402530 421482 437244 399622 433867 204605 442985 463289 365924 429434 466042 456262 494323 498734 486708 504809 514276 539318 605918 466958 422096 438929 446064 438972 469749 472817 504102 521596 484038 488409 510371 513664 519657 492576 497565 502663 511141 515833 384911 406342 428849 816963 821044 816755 463710 464502 453870 459752 479167 451161 457582 475032 487557 533256 516012 536525 508750 531412 537424 534040 535427 542002 550996 556472 560269 560777 562277 571932 572322 542600 562275 562708 572445 572523 573674 542959 545820 548227 578817 649964 668437 693246 717620 651611 689616 720743 678166 687431 710343 547561 564688 570013 571219 589315 607123 637522 639252 604726 613239 601194 605872 613365 778471 778994 784755 804982 805242 806919 780030 783235 786359 787896 794091 801026 802120 806842 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.98%) |
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 204605 365924 384911 399622 402530 406342 421482 422096 428849 429434 433867 437244 438929 438972 442985 446064 451161 453870 456262 457582 459752 463289 463710 464502 466042 466958 469749 472817 475032 479167 484038 486708 487557 488409 492576 494323 497565 498734 502663 504102 504809 508750 510371 511141 513664 514276 515833 516012 519657 521596 531412 533256 534040 535427 536525 537424 539318 542002 542600 542959 545820 547561 548227 550996 556472 560269 560777 562275 562277 562708 564688 570013 571219 571932 572322 572445 572523 573674 578817 589315 601194 604726 605872 605918 607123 613239 613365 637522 639252 649964 651611 668437 678166 687431 689616 693246 710343 717620 720743 777173 777921 778471 778623 778994 780030 783235 784744 784755 786359 787896 794091 801026 802120 804982 805242 806842 806919 816755 816963 821044 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð║ð¥ð╗ð│ð¥Ðéð║ð© ð║ÐÇð░Ðüð©ð▓ÐïðÁ ð┐ð¥ðÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"колготк красивая"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.