Query Metrics
7
Database Queries
7
Different statements
414.33 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.66 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.78 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sea xxx"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.94 ms |
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 741548 752679 738619 461912 480989 482030 521083 486641 650224 453069 578494 428703 385121 421627 457742 503850 507166 535080 532444 539599 479676 567091 561309 599149 604941 600457 776969 415087 431316 487219 521933 444313 650291 504098 514980 383748 282138 388390 690153 458013 494150 523245 532969 543356 555695 637597 591715 619132 802379 759365 766847 813101 452645 598040 444849 511780 477463 541620 577031 631656 790793 790799 604537 455610 460287 444015 523306 487138 501227 501651 558180 631171 595568 616097 439582 471749 522920 528729 475275 557526 596904 444238 549343 596652 561410 519198 542188 608336 564009 647893 ] |
||||||||||||||||||||||||||||||
| 4 | 2.40 ms |
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 282138 383748 385121 388390 415087 421627 428703 431316 439582 444015 444238 444313 444849 452645 453069 455610 457742 458013 460287 461912 471749 475275 477463 479676 480989 482030 486641 487138 487219 494150 501227 501651 503850 504098 507166 511780 514980 519198 521083 521933 522920 523245 523306 528729 532444 532969 535080 539599 541620 542188 543356 549343 555695 557526 558180 561309 561410 564009 567091 577031 578494 591715 595568 596652 596904 598040 599149 600457 604537 604941 608336 616097 619132 631171 631656 637597 647893 650224 650291 690153 738619 741548 752679 759365 766847 776969 790793 790799 802379 813101 ] |
||||||||||||||||||||||||||||||
| 5 | 391.40 ms |
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 282138 383748 385121 388390 415087 421627 428703 431316 439582 444015 444238 444313 444849 452645 453069 455610 457742 458013 460287 461912 471749 475275 477463 479676 480989 482030 486641 487138 487219 494150 501227 501651 503850 504098 507166 511780 514980 519198 521083 521933 522920 523245 523306 528729 532444 532969 535080 539599 541620 542188 543356 549343 555695 557526 558180 561309 561410 564009 567091 577031 578494 591715 595568 596652 596904 598040 599149 600457 604537 604941 608336 616097 619132 631171 631656 637597 647893 650224 650291 690153 738619 741548 752679 759365 766847 776969 790793 790799 802379 813101 ] |
||||||||||||||||||||||||||||||
| 6 | 1.52 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мор природ xxx"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.63 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мор природ xxx"
]
|
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.