Query Metrics
7
Database Queries
7
Different statements
217.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.82 ms (88.31%) |
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 261656 382067 384243 405249 412429 420464 429937 431805 434359 438029 443852 443881 443986 444343 457349 466551 467317 469651 471548 471574 472344 472346 475541 476484 480025 480904 480917 481561 484346 485748 487475 488297 488432 491387 492705 497284 497783 498115 500871 504389 506316 506356 509945 510093 510699 510796 517858 518109 521333 521914 522439 523269 523628 526801 537371 543325 543400 546920 550702 551193 553644 555643 559442 559480 560037 564083 564932 566491 567231 568837 569587 570029 572537 573874 576007 578047 578081 578189 580997 584885 587172 590406 590860 594784 594945 596186 596676 597836 598615 606007 609596 614273 636178 659340 673415 693347 713124 715449 718569 719880 731438 731447 733957 745656 762641 765964 773262 782694 791733 798743 799025 807322 809340 813297 817681 818673 819867 824289 827785 827916 ] |
||||||||||||||||||||||||||||||
|
16.22 ms (7.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 443986 827785 480904 537371 405249 466551 472346 500871 498115 506316 551193 523269 487475 572537 590860 543400 578189 488297 510796 523628 546920 510699 497284 434359 444343 384243 606007 457349 492705 485748 713124 799025 762641 594784 475541 469651 526801 471548 568837 559480 481561 566491 718569 719880 567231 261656 480025 522439 506356 443852 590406 420464 521914 819867 827916 553644 731447 559442 673415 564083 594945 438029 510093 521333 809340 431805 824289 471574 472344 484346 443881 609596 587172 550702 578081 480917 488432 818673 560037 765964 731438 773262 614273 564932 573874 429937 518109 509945 517858 476484 596186 596676 598615 597836 693347 807322 813297 576007 817681 497783 782694 791733 745656 733957 636178 659340 491387 382067 580997 570029 798743 578047 555643 569587 412429 467317 504389 715449 543325 584885 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.12%) |
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 261656 382067 384243 405249 412429 420464 429937 431805 434359 438029 443852 443881 443986 444343 457349 466551 467317 469651 471548 471574 472344 472346 475541 476484 480025 480904 480917 481561 484346 485748 487475 488297 488432 491387 492705 497284 497783 498115 500871 504389 506316 506356 509945 510093 510699 510796 517858 518109 521333 521914 522439 523269 523628 526801 537371 543325 543400 546920 550702 551193 553644 555643 559442 559480 560037 564083 564932 566491 567231 568837 569587 570029 572537 573874 576007 578047 578081 578189 580997 584885 587172 590406 590860 594784 594945 596186 596676 597836 598615 606007 609596 614273 636178 659340 673415 693347 713124 715449 718569 719880 731438 731447 733957 745656 762641 765964 773262 782694 791733 798743 799025 807322 809340 813297 817681 818673 819867 824289 827785 827916 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian car sex"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск вмашин секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск вмашин секс"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.64%) |
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.