Query Metrics
7
Database Queries
7
Different statements
145.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.23 ms (81.86%) |
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 20190 87974 209216 349135 392848 396707 397478 415300 416032 416537 416686 416695 416737 417348 427539 428253 428255 441102 443317 448370 456700 457476 457483 459203 466427 467715 469080 469221 471671 471685 471687 476166 477587 486768 487425 505140 505368 505382 509422 514248 514854 514876 517509 529897 530674 531222 532732 533544 534535 534548 534578 535467 536227 540509 541328 544132 544143 545222 545376 545415 547453 547465 547471 550899 556899 559289 559359 572655 575859 576503 576548 593274 597163 613032 614355 619607 621682 634100 634109 648673 660365 662856 663306 664193 666898 669565 672850 677295 680252 703574 709562 710877 713184 722377 722392 724580 729691 730074 738814 740932 742363 745086 749282 749672 751710 751773 752598 752655 752673 752784 757445 761625 770225 778427 784775 786850 786873 791047 809364 814519 ] |
||||||||||||||||||||||||||||||
|
16.57 ms (11.38%) |
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 669565 660365 593274 634100 634109 729691 757445 749672 710877 20190 209216 471671 467715 749282 514876 791047 505382 469221 677295 738814 477587 415300 448370 457476 476166 576503 547471 751773 752598 87974 459203 471685 536227 648673 417348 349135 545376 770225 443317 428253 416695 457483 614355 597163 730074 416686 509422 396707 722392 416032 514248 416537 505368 514854 534535 544143 664193 778427 752655 761625 397478 471687 533544 530674 534548 466427 559289 575859 545222 556899 544132 672850 703574 713184 662856 663306 666898 680252 709562 722377 545415 572655 576548 619607 613032 621682 786850 784775 786873 809364 740932 751710 752673 724580 742363 745086 752784 392848 416737 427539 428255 441102 814519 469080 456700 505140 531222 517509 535467 529897 532732 534578 540509 486768 487425 547465 559359 541328 547453 550899 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.75%) |
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 20190 87974 209216 349135 392848 396707 397478 415300 416032 416537 416686 416695 416737 417348 427539 428253 428255 441102 443317 448370 456700 457476 457483 459203 466427 467715 469080 469221 471671 471685 471687 476166 477587 486768 487425 505140 505368 505382 509422 514248 514854 514876 517509 529897 530674 531222 532732 533544 534535 534548 534578 535467 536227 540509 541328 544132 544143 545222 545376 545415 547453 547465 547471 550899 556899 559289 559359 572655 575859 576503 576548 593274 597163 613032 614355 619607 621682 634100 634109 648673 660365 662856 663306 664193 666898 669565 672850 677295 680252 703574 709562 710877 713184 722377 722392 724580 729691 730074 738814 740932 742363 745086 749282 749672 751710 751773 752598 752655 752673 752784 757445 761625 770225 778427 784775 786850 786873 791047 809364 814519 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal extreme toys"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал хардкор toys"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал хардкор toys"
]
|
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.