Query Metrics
7
Database Queries
7
Different statements
153.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.02 ms (81.64%) |
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 389700 405468 413277 413971 416751 417889 418009 420226 422958 424530 427187 434075 439772 440426 443089 449557 452953 454523 457003 461004 465820 465954 471464 474680 478090 478575 480400 480707 486341 486413 489489 492338 495568 500241 502369 509554 510103 510880 511376 512508 513782 523130 523427 525243 528386 531075 533697 534280 541650 542189 542956 545803 554742 555016 565150 570118 574244 581968 584474 588264 589656 589681 590079 590796 591784 595510 596900 601559 602371 604316 608037 608407 609958 616336 616800 616807 621125 621472 625437 639742 642751 647897 665672 681660 696518 702061 712694 717852 720480 724178 740118 742817 742887 745928 747194 747209 747222 750115 750788 750789 750790 789878 791358 807927 809293 810663 813532 814235 814245 814746 ] |
||||||||||||||||||||||||||||||
|
18.94 ms (12.37%) |
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 590079 602371 601559 465954 489489 495568 747209 439772 417889 814245 534280 565150 665672 717852 712694 443089 510880 420226 616807 742817 440426 405468 492338 478575 696518 807927 813532 724178 745928 720480 413277 465820 511376 454523 509554 528386 533697 486413 584474 596900 589681 480400 750789 742887 616336 642751 486341 570118 809293 416751 814746 639742 702061 413971 434075 647897 422958 418009 523427 545803 681660 474680 525243 513782 604316 424530 500241 608407 814235 478090 389700 555016 621472 789878 595510 512508 747222 531075 452953 480707 590796 457003 750790 750115 750788 740118 608037 461004 502369 554742 589656 574244 625437 542189 621125 541650 542956 510103 523130 588264 791358 810663 747194 449557 616800 609958 427187 471464 581968 591784 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.50%) |
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 389700 405468 413277 413971 416751 417889 418009 420226 422958 424530 427187 434075 439772 440426 443089 449557 452953 454523 457003 461004 465820 465954 471464 474680 478090 478575 480400 480707 486341 486413 489489 492338 495568 500241 502369 509554 510103 510880 511376 512508 513782 523130 523427 525243 528386 531075 533697 534280 541650 542189 542956 545803 554742 555016 565150 570118 574244 581968 584474 588264 589656 589681 590079 590796 591784 595510 596900 601559 602371 604316 608037 608407 609958 616336 616800 616807 621125 621472 625437 639742 642751 647897 665672 681660 696518 702061 712694 717852 720480 724178 740118 742817 742887 745928 747194 747209 747222 750115 750788 750789 750790 789878 791358 807927 809293 810663 813532 814235 814245 814746 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"любить анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"люб анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.89%) |
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.