Query Metrics
7
Database Queries
7
Different statements
203.51 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.89 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.81 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелки анал мастурбац…"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.93 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 794895 118008 720614 714562 555048 476176 480676 493254 813597 817171 531887 532872 534534 547454 710368 553130 777581 786519 765683 555359 607228 736519 750294 745462 702268 452964 513641 473446 795731 819235 728348 637503 715090 630423 531884 530679 580989 671032 672926 723469 605155 699385 563050 819238 791916 423516 561002 477128 815174 814343 815965 473437 531878 661593 628112 799880 824483 672913 605136 744210 759901 471116 467886 466238 547857 555407 666736 791580 790575 88591 467114 457998 405177 480478 476164 456230 581126 766381 742321 519350 471696 515441 531866 534559 545342 547464 547476 559360 664226 669016 781332 766860 751627 639736 781019 443168 576906 821005 547609 784162 817878 555425 547236 751571 641946 388642 154171 605026 747468 469331 751017 415300 473450 539741 573303 576503 555337 670356 547471 624837 ] |
||||||||||||||||||||||||||||||
| 4 | 2.64 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 88591 118008 154171 388642 405177 415300 423516 443168 452964 456230 457998 466238 467114 467886 469331 471116 471696 473437 473446 473450 476164 476176 477128 480478 480676 493254 513641 515441 519350 530679 531866 531878 531884 531887 532872 534534 534559 539741 545342 547236 547454 547464 547471 547476 547609 547857 553130 555048 555337 555359 555407 555425 559360 561002 563050 573303 576503 576906 580989 581126 605026 605136 605155 607228 624837 628112 630423 637503 639736 641946 661593 664226 666736 669016 670356 671032 672913 672926 699385 702268 710368 714562 715090 720614 723469 728348 736519 742321 744210 745462 747468 750294 751017 751571 751627 759901 765683 766381 766860 777581 781019 781332 784162 786519 790575 791580 791916 794895 795731 799880 813597 814343 815174 815965 817171 817878 819235 819238 821005 824483 ] |
||||||||||||||||||||||||||||||
| 5 | 181.20 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 88591 118008 154171 388642 405177 415300 423516 443168 452964 456230 457998 466238 467114 467886 469331 471116 471696 473437 473446 473450 476164 476176 477128 480478 480676 493254 513641 515441 519350 530679 531866 531878 531884 531887 532872 534534 534559 539741 545342 547236 547454 547464 547471 547476 547609 547857 553130 555048 555337 555359 555407 555425 559360 561002 563050 573303 576503 576906 580989 581126 605026 605136 605155 607228 624837 628112 630423 637503 639736 641946 661593 664226 666736 669016 670356 671032 672913 672926 699385 702268 710368 714562 715090 720614 723469 728348 736519 742321 744210 745462 747468 750294 751017 751571 751627 759901 765683 766381 766860 777581 781019 781332 784162 786519 790575 791580 791916 794895 795731 799880 813597 814343 815174 815965 817171 817878 819235 819238 821005 824483 ] |
||||||||||||||||||||||||||||||
| 6 | 1.63 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин анал мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.42 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.