Query Metrics
7
Database Queries
7
Different statements
142.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.37 ms (81.12%) |
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 415044 459199 472859 479239 480724 483133 486873 489400 493544 494174 496524 497287 498209 498611 499371 500217 502609 507240 509475 513157 513894 514931 516742 517824 518577 518747 519203 519438 519462 520664 520752 521591 521669 522081 523207 523211 523564 523781 524004 526182 526755 526857 527663 528399 528578 528884 529268 531154 531178 532328 533361 533971 535155 535175 536826 537126 537224 538021 538437 541207 550226 554315 554985 555340 555912 556967 557382 558536 559242 559548 562336 570910 572975 577980 579372 579505 580424 582050 584071 584498 584528 585740 585767 586610 586941 587047 587066 587954 591422 591613 591983 592446 592687 594906 596192 597912 598869 599974 601662 602843 604324 606284 606755 611069 615660 618795 619458 620156 621300 622029 624877 624884 625008 630033 636249 636486 653486 669409 672740 673667 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (11.49%) |
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 615660 618795 619458 620156 630033 586610 587954 591422 602843 606284 621300 636486 611069 415044 538437 499371 527663 535175 517824 521591 522081 523211 529268 537224 496524 523781 524004 532328 554985 555340 556967 570910 580424 582050 584498 557382 559242 584071 579372 579505 584528 672740 673667 653486 555912 572975 577980 585767 597912 599974 601662 624877 592687 624884 585740 591613 636249 586941 592446 594906 625008 498209 591983 526857 541207 562336 500217 550226 622029 598869 606755 494174 519203 520664 523207 502609 528399 559548 554315 669409 604324 587047 518747 596192 587066 486873 489400 479239 459199 483133 514931 519462 521669 533971 537126 497287 513157 513894 518577 519438 523564 526182 533361 538021 498611 520752 531154 536826 507240 509475 516742 526755 528578 528884 531178 535155 472859 480724 493544 558536 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (2.14%) |
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 415044 459199 472859 479239 480724 483133 486873 489400 493544 494174 496524 497287 498209 498611 499371 500217 502609 507240 509475 513157 513894 514931 516742 517824 518577 518747 519203 519438 519462 520664 520752 521591 521669 522081 523207 523211 523564 523781 524004 526182 526755 526857 527663 528399 528578 528884 529268 531154 531178 532328 533361 533971 535155 535175 536826 537126 537224 538021 538437 541207 550226 554315 554985 555340 555912 556967 557382 558536 559242 559548 562336 570910 572975 577980 579372 579505 580424 582050 584071 584498 584528 585740 585767 586610 586941 587047 587066 587954 591422 591613 591983 592446 592687 594906 596192 597912 598869 599974 601662 602843 604324 606284 606755 611069 615660 618795 619458 620156 621300 622029 624877 624884 625008 630033 636249 636486 653486 669409 672740 673667 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сосет из попы"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сосет жоп"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.17%) |
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.