Query Metrics
7
Database Queries
7
Different statements
199.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.13 ms (81.09%) |
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 16971 389418 389667 417177 418597 419192 420818 421157 421570 424013 424505 426035 427209 427851 432296 434492 436703 443733 444924 446064 452331 454731 461210 469690 476797 477355 480757 483057 483377 483777 487200 488560 500300 500429 500504 501173 502477 504268 505920 511838 514230 514652 514660 516078 516684 518012 519295 520270 521784 521813 522138 522307 526257 526293 526492 528044 528093 530661 532560 536744 537236 541832 543609 547478 547485 548837 551736 554721 555062 556883 563134 565256 576384 583425 583997 585446 590281 590854 590906 593470 595209 597841 601140 601400 603685 603724 605117 618874 619293 623736 625648 629963 633136 634782 635838 639258 646004 653524 660375 660399 665957 667646 669058 669074 671052 689613 699621 711904 719350 726315 726543 726553 742428 747140 780375 797560 798930 812790 ] |
||||||||||||||||||||||||||||||
|
27.26 ms (13.63%) |
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 519295 505920 500429 532560 547478 669074 671052 635838 699621 500504 488560 514230 555062 556883 625648 633136 436703 446064 554721 526492 424013 389667 427851 576384 583425 595209 520270 526257 726315 742428 719350 483057 483377 526293 543609 548837 660399 665957 590854 597841 502477 432296 421157 501173 528044 660375 812790 426035 603724 487200 593470 747140 500300 483777 419192 521813 427209 798930 514652 563134 780375 389418 452331 547485 646004 590281 601400 797560 424505 590906 605117 585446 418597 454731 603685 469690 511838 522307 669058 434492 443733 667646 623736 634782 726543 726553 601140 530661 516078 417177 477355 619293 514660 583997 16971 528093 516684 565256 476797 541832 689613 444924 480757 537236 653524 420818 461210 521784 518012 551736 629963 421570 639258 711904 536744 618874 504268 522138 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.54%) |
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 16971 389418 389667 417177 418597 419192 420818 421157 421570 424013 424505 426035 427209 427851 432296 434492 436703 443733 444924 446064 452331 454731 461210 469690 476797 477355 480757 483057 483377 483777 487200 488560 500300 500429 500504 501173 502477 504268 505920 511838 514230 514652 514660 516078 516684 518012 519295 520270 521784 521813 522138 522307 526257 526293 526492 528044 528093 530661 532560 536744 537236 541832 543609 547478 547485 548837 551736 554721 555062 556883 563134 565256 576384 583425 583997 585446 590281 590854 590906 593470 595209 597841 601140 601400 603685 603724 605117 618874 619293 623736 625648 629963 633136 634782 635838 639258 646004 653524 660375 660399 665957 667646 669058 669074 671052 689613 699621 711904 719350 726315 726543 726553 742428 747140 780375 797560 798930 812790 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"two girl masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"two девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"two девушк мастурбац"
]
|
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.