Query Metrics
7
Database Queries
7
Different statements
169.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.08 ms (82.04%) |
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 357595 381853 382724 382971 383390 388722 388785 398769 405859 407637 407769 411540 411616 411630 411926 412985 413458 413461 414038 431762 443842 451445 452232 454253 454259 455026 456897 459919 460340 462106 462256 462562 462567 464325 464917 465363 466792 466997 467240 469336 471062 472151 474382 474399 474833 474846 474870 475080 475220 476257 476260 476353 479063 480480 480731 480764 483139 484379 484702 485706 485714 485725 485727 485733 485737 485752 486821 486835 487338 487933 496524 496549 496552 498300 502025 502030 502932 504861 505642 506847 511664 513785 513833 514335 518874 518875 519143 519144 519145 519151 519705 519752 520141 521131 523367 532125 544464 549583 558295 559328 562183 563431 565578 580667 580884 592951 592970 593532 593535 601904 666811 667320 667486 716450 723377 726591 743406 744987 810773 810775 ] |
||||||||||||||||||||||||||||||
|
19.75 ms (11.65%) |
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 413458 443842 411616 474846 462256 462567 480764 485737 496549 504861 519144 520141 523367 514335 474382 558295 723377 744987 743406 726591 398769 474833 357595 464325 467240 476353 474399 411540 485706 502932 518874 601904 464917 521131 562183 716450 592970 413461 475220 484379 382724 405859 411926 407637 412985 454253 456897 469336 472151 474870 502025 496524 479063 559328 544464 563431 666811 667320 593535 810773 381853 462106 388785 454259 465363 383390 455026 462562 388722 480731 471062 519705 485714 485725 486821 487338 513833 476257 459919 580667 486835 532125 382971 407769 411630 414038 431762 475080 483139 485727 466792 476260 485733 502030 506847 518875 519145 498300 505642 496552 466997 549583 565578 580884 667486 592951 593532 810775 451445 452232 480480 460340 511664 519151 485752 513785 519143 487933 519752 484702 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.80%) |
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 357595 381853 382724 382971 383390 388722 388785 398769 405859 407637 407769 411540 411616 411630 411926 412985 413458 413461 414038 431762 443842 451445 452232 454253 454259 455026 456897 459919 460340 462106 462256 462562 462567 464325 464917 465363 466792 466997 467240 469336 471062 472151 474382 474399 474833 474846 474870 475080 475220 476257 476260 476353 479063 480480 480731 480764 483139 484379 484702 485706 485714 485725 485727 485733 485737 485752 486821 486835 487338 487933 496524 496549 496552 498300 502025 502030 502932 504861 505642 506847 511664 513785 513833 514335 518874 518875 519143 519144 519145 519151 519705 519752 520141 521131 523367 532125 544464 549583 558295 559328 562183 563431 565578 580667 580884 592951 592970 593532 593535 601904 666811 667320 667486 716450 723377 726591 743406 744987 810773 810775 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скачать бабки с молодыми"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скача бабушк молодые"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
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.