Query Metrics
7
Database Queries
7
Different statements
165.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.31 ms (80.08%) |
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 7051 44120 89895 95673 187709 322284 326115 341802 358887 366004 382172 386033 388169 388718 388725 388766 389518 390242 392909 395240 401491 404584 404740 411345 411896 413518 414666 414729 414938 416635 421629 421954 422152 424281 426549 429954 430262 430561 433137 433312 437947 441074 443491 447442 449094 452115 453047 457953 460535 463790 463884 464125 464597 465961 466088 466198 466746 467910 469169 469508 469603 470012 470425 470437 471792 472237 472951 474857 474969 476147 477873 482690 485061 485148 486192 491899 493163 494985 497869 499384 506406 506801 509825 510063 510631 511431 515793 521544 521575 521832 521843 521889 523360 526117 528064 538270 541688 543848 544472 549841 559233 560924 562825 574384 586564 589656 593343 594231 605586 608771 613179 615881 626215 626497 627725 636268 653537 654422 656322 673775 ] |
||||||||||||||||||||||||||||||
|
22.64 ms (13.70%) |
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 605586 416635 7051 401491 366004 430561 506801 653537 636268 593343 388169 44120 382172 322284 433312 589656 586564 608771 404584 654422 626215 476147 515793 544472 615881 627725 477873 538270 474857 541688 187709 411896 388725 89895 511431 449094 453047 390242 499384 521889 386033 326115 464597 388718 474969 486192 528064 424281 493163 389518 613179 594231 521544 521843 441074 562825 510063 341802 413518 392909 470425 470437 464125 465961 509825 543848 523360 574384 521575 467910 388766 414666 447442 421629 472951 426549 485148 411345 422152 463884 395240 457953 510631 626497 494985 559233 430262 466198 491899 497869 95673 437947 460535 469603 421954 414938 470012 414729 469169 482690 469508 452115 463790 433137 466746 358887 471792 429954 404740 472237 485061 673775 526117 443491 466088 506406 521832 549841 656322 560924 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.40%) |
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 7051 44120 89895 95673 187709 322284 326115 341802 358887 366004 382172 386033 388169 388718 388725 388766 389518 390242 392909 395240 401491 404584 404740 411345 411896 413518 414666 414729 414938 416635 421629 421954 422152 424281 426549 429954 430262 430561 433137 433312 437947 441074 443491 447442 449094 452115 453047 457953 460535 463790 463884 464125 464597 465961 466088 466198 466746 467910 469169 469508 469603 470012 470425 470437 471792 472237 472951 474857 474969 476147 477873 482690 485061 485148 486192 491899 493163 494985 497869 499384 506406 506801 509825 510063 510631 511431 515793 521544 521575 521832 521843 521889 523360 526117 528064 538270 541688 543848 544472 549841 559233 560924 562825 574384 586564 589656 593343 594231 605586 608771 613179 615881 626215 626497 627725 636268 653537 654422 656322 673775 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"долб анал"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"долбят в очко"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
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.