Query Metrics
7
Database Queries
7
Different statements
188.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.00 ms (90.10%) |
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 382540 383773 384902 389144 392170 398680 407122 423920 425331 426539 427244 435182 435999 436825 437959 443122 445756 447314 451582 453089 453986 455227 456126 456607 458773 459531 459666 460393 460617 466284 470677 470796 471991 473645 475010 476527 479165 479437 480669 481307 481580 482444 483326 483874 484086 485105 487120 487626 491010 495264 495303 496123 496169 499025 502639 502975 504485 504695 505189 506316 506873 507095 510404 511130 511334 513243 514300 516555 520825 522545 524202 526355 527931 528645 528909 529144 532029 542456 544610 546340 548785 549814 551448 552366 558267 558288 559051 559370 559716 563332 564239 564566 566524 566680 571077 572273 573744 576545 577350 579417 581035 602934 603317 606615 614258 614328 614376 618199 621360 623063 637765 655268 669017 760897 761136 765922 783161 789851 824033 828252 ] |
||||||||||||||||||||||||||||||
|
10.31 ms (5.47%) |
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 559716 618199 504695 548785 527931 606615 783161 506873 558267 558288 435999 443122 456126 505189 506316 528645 614258 529144 456607 383773 407122 426539 482444 480669 487626 552366 481307 427244 459531 460393 425331 511130 526355 389144 470677 460617 470796 614376 789851 466284 451582 504485 496123 532029 392170 479437 491010 445756 602934 566680 384902 577350 765922 824033 669017 576545 614328 436825 603317 572273 579417 382540 564566 398680 559051 581035 447314 485105 483326 546340 761136 475010 510404 551448 573744 502639 499025 563332 473645 520825 516555 514300 435182 459666 423920 524202 511334 655268 621360 559370 528909 522545 544610 571077 453986 476527 495264 542456 479165 496169 564239 623063 637765 760897 455227 507095 566524 495303 513243 549814 484086 458773 437959 502975 453089 487120 471991 481580 483874 828252 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.18%) |
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 382540 383773 384902 389144 392170 398680 407122 423920 425331 426539 427244 435182 435999 436825 437959 443122 445756 447314 451582 453089 453986 455227 456126 456607 458773 459531 459666 460393 460617 466284 470677 470796 471991 473645 475010 476527 479165 479437 480669 481307 481580 482444 483326 483874 484086 485105 487120 487626 491010 495264 495303 496123 496169 499025 502639 502975 504485 504695 505189 506316 506873 507095 510404 511130 511334 513243 514300 516555 520825 522545 524202 526355 527931 528645 528909 529144 532029 542456 544610 546340 548785 549814 551448 552366 558267 558288 559051 559370 559716 563332 564239 564566 566524 566680 571077 572273 573744 576545 577350 579417 581035 602934 603317 606615 614258 614328 614376 618199 621360 623063 637765 655268 669017 760897 761136 765922 783161 789851 824033 828252 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лес секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лес природ секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лес природ секс"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.