Query Metrics
7
Database Queries
7
Different statements
123.77 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.83 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.85 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex in sea"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.96 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 634873 797637 482030 572305 581050 800538 797788 461912 650224 405320 480989 505805 548043 670634 741548 752679 486641 428703 453069 578494 385121 479676 599149 415087 521933 776969 457742 507166 567091 561309 431316 504098 421627 444313 503850 532444 514980 766847 383748 282138 802379 759365 543356 813101 637597 591715 388390 458013 494150 532969 555695 619132 690153 523245 790793 790799 523306 444015 477463 631656 487138 501651 604537 501227 444849 460287 577031 541620 631171 558180 439582 616097 471749 557526 522920 475275 444238 596904 528729 549343 596652 561410 519198 542188 608336 564009 647893 ] |
||||||||||||||||||||||||||||||
| 4 | 4.00 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 405320 415087 421627 428703 431316 439582 444015 444238 444313 444849 453069 457742 458013 460287 461912 471749 475275 477463 479676 480989 482030 486641 487138 494150 501227 501651 503850 504098 505805 507166 514980 519198 521933 522920 523245 523306 528729 532444 532969 541620 542188 543356 548043 549343 555695 557526 558180 561309 561410 564009 567091 572305 577031 578494 581050 591715 596652 596904 599149 604537 608336 616097 619132 631171 631656 634873 637597 647893 650224 670634 690153 741548 752679 759365 766847 776969 790793 790799 797637 797788 800538 802379 813101 ] |
||||||||||||||||||||||||||||||
| 5 | 97.07 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 405320 415087 421627 428703 431316 439582 444015 444238 444313 444849 453069 457742 458013 460287 461912 471749 475275 477463 479676 480989 482030 486641 487138 494150 501227 501651 503850 504098 505805 507166 514980 519198 521933 522920 523245 523306 528729 532444 532969 541620 542188 543356 548043 549343 555695 557526 558180 561309 561410 564009 567091 572305 577031 578494 581050 591715 596652 596904 599149 604537 608336 616097 619132 631171 631656 634873 637597 647893 650224 670634 690153 741548 752679 759365 766847 776969 790793 790799 797637 797788 800538 802379 813101 ] |
||||||||||||||||||||||||||||||
| 6 | 1.71 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мор природ"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.34 ms |
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.