Query Metrics
7
Database Queries
7
Different statements
292.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
272.14 ms (93.06%) |
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 3 385301 389814 400645 421585 424153 444698 446963 453076 453183 455676 456264 467733 469707 470685 471970 472471 475000 477156 479254 479625 481277 484002 485351 485463 485609 487093 487917 488984 489679 489697 496941 498914 502805 504685 504767 504895 505984 506575 507033 508630 510412 512136 512823 516552 518380 518545 520262 525203 526676 527583 527929 527931 532029 537278 538768 539290 543598 543603 543615 544564 544867 546282 546747 548231 548395 548602 552768 553330 554965 557628 559262 560538 560763 561096 562618 562713 564566 565088 565353 565494 567142 570910 571061 572891 576698 576720 578961 579417 580256 583984 587681 588033 590329 592041 592146 592730 593812 604732 606812 614264 614350 614353 614381 614392 617770 618906 622893 636633 644901 654253 655541 658865 663769 667919 692967 718742 744070 757808 794924 ] |
||||||||||||||||||||||||||||||
|
10.83 ms (3.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 527929 588033 583984 516552 548231 592730 527931 578961 606812 570910 565088 532029 604732 667919 543598 504685 525203 579417 564566 561096 590329 537278 565353 475000 576698 544867 557628 477156 512136 489697 593812 472471 479254 512823 489679 505984 526676 518545 504895 543603 487093 485463 487917 546747 543615 618906 453076 444698 479625 538768 567142 446963 580256 453183 576720 470685 587681 481277 389814 617770 424153 614392 548395 614381 3 385301 527583 507033 560763 510412 502805 506575 644901 636633 592146 485351 496941 692967 544564 548602 559262 560538 520262 484002 562713 504767 562618 614350 592041 469707 663769 744070 485609 498914 546282 518380 552768 554965 655541 757808 658865 553330 622893 654253 614353 467733 718742 488984 539290 400645 614264 421585 456264 455676 471970 508630 794924 571061 572891 565494 ] |
||||||||||||||||||||||||||||||
|
3.27 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 3 385301 389814 400645 421585 424153 444698 446963 453076 453183 455676 456264 467733 469707 470685 471970 472471 475000 477156 479254 479625 481277 484002 485351 485463 485609 487093 487917 488984 489679 489697 496941 498914 502805 504685 504767 504895 505984 506575 507033 508630 510412 512136 512823 516552 518380 518545 520262 525203 526676 527583 527929 527931 532029 537278 538768 539290 543598 543603 543615 544564 544867 546282 546747 548231 548395 548602 552768 553330 554965 557628 559262 560538 560763 561096 562618 562713 564566 565088 565353 565494 567142 570910 571061 572891 576698 576720 578961 579417 580256 583984 587681 588033 590329 592041 592146 592730 593812 604732 606812 614264 614350 614353 614381 614392 617770 618906 622893 636633 644901 654253 655541 658865 663769 667919 692967 718742 744070 757808 794924 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс лес природ"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс лес"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.48%) |
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.