Query Metrics
7
Database Queries
7
Different statements
372.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.29 ms (56.16%) |
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 389921 405531 406042 406171 412081 413649 416934 418934 419371 422171 422512 422513 422863 424482 424648 428530 439529 439754 440987 443299 443635 444542 444611 447978 454147 454215 457564 465524 465963 466996 467451 469472 470100 470196 474559 474561 475058 476409 477730 482377 484670 485267 491270 491644 493164 495112 508487 508527 511528 511534 512059 515916 516769 516782 517004 518870 518879 520540 523737 524213 525129 526727 527412 528081 529184 529854 530018 530494 531231 532738 532984 533517 533747 534215 534229 534288 536639 536691 537199 539938 541874 542864 543376 544455 545604 546766 548550 550571 551254 559942 565249 565254 574204 590408 593470 609136 615718 620620 628294 631957 632001 637078 643411 647960 663380 663495 665139 668872 677142 702163 702164 702168 704256 714511 720927 726487 739535 752563 802109 807327 ] |
||||||||||||||||||||||||||||||
|
133.21 ms (35.75%) |
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 389921 405531 406042 406171 412081 413649 416934 418934 419371 422171 422512 422513 422863 424482 424648 428530 439529 439754 440987 443299 443635 444542 444611 447978 454147 454215 457564 465524 465963 466996 467451 469472 470100 470196 474559 474561 475058 476409 477730 482377 484670 485267 491270 491644 493164 495112 508487 508527 511528 511534 512059 515916 516769 516782 517004 518870 518879 520540 523737 524213 525129 526727 527412 528081 529184 529854 530018 530494 531231 532738 532984 533517 533747 534215 534229 534288 536639 536691 537199 539938 541874 542864 543376 544455 545604 546766 548550 550571 551254 559942 565249 565254 574204 590408 593470 609136 615718 620620 628294 631957 632001 637078 643411 647960 663380 663495 665139 668872 677142 702163 702164 702168 704256 714511 720927 726487 739535 752563 802109 807327 ] |
||||||||||||||||||||||||||||||
|
22.67 ms (6.08%) |
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 466996 485267 508527 529854 516782 529184 530018 533517 539938 530494 511528 511534 532984 548550 551254 574204 565249 559942 663380 702164 663495 704256 720927 628294 637078 593470 609136 807327 802109 428530 457564 416934 424482 424648 469472 470196 405531 439754 422863 465963 528081 484670 495112 518879 523737 527412 493164 518870 491644 520540 526727 668872 665139 512059 536691 590408 620620 406042 389921 406171 443635 474559 525129 536639 508487 565254 546766 677142 714511 632001 726487 422171 439529 454147 482377 412081 467451 422513 440987 444542 470100 477730 491270 515916 524213 419371 422512 474561 476409 447978 454215 516769 517004 532738 534229 534288 537199 531231 533747 465524 543376 545604 544455 702168 615718 643411 739535 752563 413649 475058 631957 444611 418934 443299 534215 541874 542864 550571 647960 702163 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old dildo"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old дилд"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old дилд"
]
|
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.