Query Metrics
7
Database Queries
7
Different statements
166.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.02 ms (84.54%) |
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 291314 382545 396989 397122 398689 403291 413309 416853 418762 426477 441368 443025 449316 456166 457546 459938 462887 464872 472742 479432 480624 504729 514633 530004 534812 557959 566062 576240 577293 590117 597156 598260 598282 598339 598384 598628 599488 600233 605402 609908 610342 615197 615855 620029 620248 621099 623439 626340 634249 635456 641153 642308 644943 653215 655908 661607 663236 673125 697325 699905 705141 705442 706521 709083 719162 723043 727759 732684 736954 738960 753651 753871 757401 760491 760612 763518 766034 771554 771870 772350 775224 776266 776477 778352 779425 780760 781218 781494 782778 789688 789750 789967 792811 793855 800063 800107 801139 801245 802831 803178 806081 806287 806895 807200 809155 811338 811777 812053 814008 815226 815779 817938 818346 819197 827836 827837 827881 827893 827904 ] |
||||||||||||||||||||||||||||||
|
14.91 ms (8.94%) |
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 771870 757401 610342 464872 818346 827837 557959 673125 699905 598384 590117 605402 778352 789967 781218 738960 736954 760491 771554 723043 800063 806287 644943 727759 827881 396989 534812 626340 621099 576240 620248 443025 403291 418762 653215 599488 814008 634249 753871 780760 459938 441368 514633 709083 598260 635456 779425 772350 705442 775224 413309 456166 697325 705141 600233 801245 789750 802831 753651 623439 803178 504729 597156 807200 382545 457546 776266 397122 815779 566062 661607 719162 655908 706521 615197 641153 792811 760612 815226 642308 598628 615855 800107 812053 479432 416853 811777 449316 480624 426477 398689 462887 766034 291314 817938 819197 827836 827893 827904 472742 530004 577293 663236 598282 598339 609908 620029 781494 782778 793855 801139 809155 780814 811338 732684 763518 776477 789688 806081 806895 ] |
||||||||||||||||||||||||||||||
|
4.23 ms (2.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 291314 382545 396989 397122 398689 403291 413309 416853 418762 426477 441368 443025 449316 456166 457546 459938 462887 464872 472742 479432 480624 504729 514633 530004 534812 557959 566062 576240 577293 590117 597156 598260 598282 598339 598384 598628 599488 600233 605402 609908 610342 615197 615855 620029 620248 621099 623439 626340 634249 635456 641153 642308 644943 653215 655908 661607 663236 673125 697325 699905 705141 705442 706521 709083 719162 723043 727759 732684 736954 738960 753651 753871 757401 760491 760612 763518 766034 771554 771870 772350 775224 776266 776477 778352 779425 780760 781218 781494 782778 789688 789750 789967 792811 793855 800063 800107 801139 801245 802831 803178 806081 806287 806895 807200 809155 811338 811777 812053 814008 815226 815779 817938 818346 819197 827836 827837 827881 827893 827904 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob perfect"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс perfect"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс perfect"
]
|
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.