Query Metrics
7
Database Queries
7
Different statements
220.57 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.57 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.84 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife squirt masturbation"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.18 ms |
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 538530 457063 430374 650895 620657 784966 779272 797082 761521 752713 784409 785012 486126 100685 710360 783963 786339 787779 749081 476429 806683 820092 469460 533561 571304 669860 720058 651584 660053 669896 669897 555383 625462 621558 586375 600590 784462 794934 796859 778686 796878 726725 761530 766258 784416 802328 726122 749671 756505 738326 742346 768125 727540 757291 768229 736014 746272 765695 697768 714547 783933 784974 800682 801810 806454 807827 809628 418334 684500 617552 785362 91344 418111 434336 421199 462071 467908 492716 500957 539607 475647 550817 555402 583184 717550 585253 803046 439117 455471 418142 451273 439233 422134 434335 512994 507193 800655 641806 434654 460860 456937 495747 500299 827505 478055 529997 540118 787774 753199 784127 796327 810377 425248 648744 667325 785365 784120 473747 794228 455079 ] |
||||||||||||||||||||||||||||||
| 4 | 2.74 ms |
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 91344 100685 418111 418142 418334 421199 422134 425248 430374 434335 434336 434654 439117 439233 451273 455079 455471 456937 457063 460860 462071 467908 469460 473747 475647 476429 478055 486126 492716 495747 500299 500957 507193 512994 529997 533561 538530 539607 540118 550817 555383 555402 571304 583184 585253 586375 600590 617552 620657 621558 625462 641806 648744 650895 651584 660053 667325 669860 669896 669897 684500 697768 710360 714547 717550 720058 726122 726725 727540 736014 738326 742346 746272 749081 749671 752713 753199 756505 757291 761521 761530 765695 766258 768125 768229 778686 779272 783933 783963 784120 784127 784409 784416 784462 784966 784974 785012 785362 785365 786339 787774 787779 794228 794934 796327 796859 796878 797082 800655 800682 801810 802328 803046 806454 806683 807827 809628 810377 820092 827505 ] |
||||||||||||||||||||||||||||||
| 5 | 193.72 ms |
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 91344 100685 418111 418142 418334 421199 422134 425248 430374 434335 434336 434654 439117 439233 451273 455079 455471 456937 457063 460860 462071 467908 469460 473747 475647 476429 478055 486126 492716 495747 500299 500957 507193 512994 529997 533561 538530 539607 540118 550817 555383 555402 571304 583184 585253 586375 600590 617552 620657 621558 625462 641806 648744 650895 651584 660053 667325 669860 669896 669897 684500 697768 710360 714547 717550 720058 726122 726725 727540 736014 738326 742346 746272 749081 749671 752713 753199 756505 757291 761521 761530 765695 766258 768125 768229 778686 779272 783933 783963 784120 784127 784409 784416 784462 784966 784974 785012 785362 785365 786339 787774 787779 794228 794934 796327 796859 796878 797082 800655 800682 801810 802328 803046 806454 806683 807827 809628 810377 820092 827505 ] |
||||||||||||||||||||||||||||||
| 6 | 2.09 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен сквирт оргазм мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.44 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.