Query Metrics
7
Database Queries
7
Different statements
429.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.94 ms (49.62%) |
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 426101 432778 435177 441495 448636 449018 449053 455897 456207 457380 457531 461306 461778 461968 463922 469079 471554 475472 482769 484318 488238 490477 491588 491802 492275 493573 494619 494648 498163 500955 503271 508560 509123 509600 510230 511481 511868 512506 513036 513508 515003 517854 520790 521468 526402 529082 534801 534848 538266 545598 546473 559999 560643 560844 561388 561703 574643 579469 580210 584955 590748 592399 592614 593248 593372 602862 603824 603833 604706 606697 607928 609582 609878 611348 618021 618133 618364 623968 625186 634600 637802 638938 640792 642723 644655 650104 653866 657160 658222 663171 671396 673093 695892 695900 696081 697885 703457 703713 707955 708276 709781 717820 720284 720828 722072 722583 722640 724052 742861 744843 748687 752224 757394 759673 759961 779010 788893 796168 800404 819182 ] |
||||||||||||||||||||||||||||||
|
193.52 ms (45.09%) |
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 426101 432778 435177 441495 448636 449018 449053 455897 456207 457380 457531 461306 461778 461968 463922 469079 471554 475472 482769 484318 488238 490477 491588 491802 492275 493573 494619 494648 498163 500955 503271 508560 509123 509600 510230 511481 511868 512506 513036 513508 515003 517854 520790 521468 526402 529082 534801 534848 538266 545598 546473 559999 560643 560844 561388 561703 574643 579469 580210 584955 590748 592399 592614 593248 593372 602862 603824 603833 604706 606697 607928 609582 609878 611348 618021 618133 618364 623968 625186 634600 637802 638938 640792 642723 644655 650104 653866 657160 658222 663171 671396 673093 695892 695900 696081 697885 703457 703713 707955 708276 709781 717820 720284 720828 722072 722583 722640 724052 742861 744843 748687 752224 757394 759673 759961 779010 788893 796168 800404 819182 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (3.64%) |
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 752224 724052 606697 819182 449018 546473 650104 695892 720284 657160 663171 703457 722583 638938 640792 602862 644655 779010 748687 800404 707955 592614 526402 618133 618021 744843 593372 482769 484318 448636 471554 515003 456207 493573 513036 625186 457531 618364 722072 512506 469079 604706 623968 634600 717820 492275 561388 559999 560643 561703 653866 697885 703713 720828 545598 607928 592399 637802 742861 757394 759673 759961 722640 593248 441495 426101 449053 461306 491588 455897 457380 475472 488238 498163 520790 509123 509600 503271 508560 529082 494619 494648 511481 435177 461778 432778 463922 461968 500955 510230 517854 538266 511868 513508 490477 521468 491802 642723 534801 534848 579469 584955 560844 574643 580210 658222 696081 709781 671396 673093 695900 708276 609878 611348 603824 603833 590748 609582 796168 788893 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крича вперв большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"painful big cock"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"крича вперв большие cock"
]
|
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.