Query Metrics
7
Database Queries
7
Different statements
274.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
247.98 ms (90.23%) |
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 146112 357595 381853 382569 382724 382971 383390 388722 388785 398769 405859 407637 407769 411540 411630 411926 412985 413461 414038 431762 451445 454253 454259 455026 456897 459919 462101 462106 462562 464325 464917 465363 466069 466792 466979 466997 467240 469336 471062 472151 472593 474382 474399 474818 474833 474870 475220 476257 476260 476353 476856 479063 480731 483139 484379 485706 485714 485725 485727 485733 486821 487338 488308 496524 496552 498300 502025 502030 502932 505642 506847 513833 514335 518874 518875 519145 519705 520141 521131 523367 524882 529390 531531 544464 549583 549880 554519 558295 559328 563431 565578 580884 592951 593532 593535 601904 665254 666163 666811 667319 667320 667486 667850 707282 712806 712825 716254 716470 723377 726591 731193 743406 744987 781667 781729 810773 810775 814125 817406 818656 ] |
||||||||||||||||||||||||||||||
|
17.42 ms (6.34%) |
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 520141 523367 514335 531531 474382 558295 723377 744987 743406 726591 398769 474833 357595 464325 467240 476353 474399 411540 485706 502932 518874 554519 462101 476856 466069 814125 549880 707282 712825 466979 474818 488308 524882 382724 405859 411926 407637 412985 413461 454253 456897 469336 472151 474870 502025 496524 475220 479063 559328 544464 563431 666811 667320 593535 810773 381853 462106 388785 454259 465363 383390 455026 462562 388722 472593 480731 471062 519705 485714 485725 486821 487338 513833 484379 817406 781667 712806 529390 601904 464917 521131 818656 665254 716470 666163 667319 667850 781729 731193 716254 146112 382569 382971 407769 411630 414038 431762 476257 483139 485727 466792 476260 485733 502030 506847 518875 519145 498300 505642 496552 459919 466997 549583 565578 580884 667486 592951 593532 810775 451445 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.12%) |
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 146112 357595 381853 382569 382724 382971 383390 388722 388785 398769 405859 407637 407769 411540 411630 411926 412985 413461 414038 431762 451445 454253 454259 455026 456897 459919 462101 462106 462562 464325 464917 465363 466069 466792 466979 466997 467240 469336 471062 472151 472593 474382 474399 474818 474833 474870 475220 476257 476260 476353 476856 479063 480731 483139 484379 485706 485714 485725 485727 485733 486821 487338 488308 496524 496552 498300 502025 502030 502932 505642 506847 513833 514335 518874 518875 519145 519705 520141 521131 523367 524882 529390 531531 544464 549583 549880 554519 558295 559328 563431 565578 580884 592951 593532 593535 601904 665254 666163 666811 667319 667320 667486 667850 707282 712806 712825 716254 716470 723377 726591 731193 743406 744987 781667 781729 810773 810775 814125 817406 818656 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"старые бабки"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старые бабушк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.49%) |
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.