Query Metrics
7
Database Queries
7
Different statements
368.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
344.66 ms (93.53%) |
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 389703 394574 396784 398122 415749 423763 428171 429366 429861 443233 443317 454793 457476 457650 467633 467634 467636 468146 471074 472815 476664 477052 477462 483738 483777 491103 511278 511856 512072 514155 514233 516843 526653 532639 534772 535363 538484 550952 552704 554369 555599 558158 561034 564518 567063 571726 574391 576848 580069 580832 584183 584996 585680 586100 588045 589185 594619 595177 595213 613559 619026 619322 636730 641806 642965 648696 649372 660412 662046 666967 668305 669056 671002 671018 671045 672939 681388 686106 686183 695869 697876 703668 704100 736014 739125 739131 740841 745092 745111 745276 745915 751546 752633 753202 756251 781298 781420 782057 788530 788531 791132 792726 793017 796071 796689 796965 798457 801495 803534 803771 804636 806834 807590 808265 808507 811331 813796 826237 827290 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (3.90%) |
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 483777 558158 561034 695869 808265 739131 751546 752633 443233 415749 467634 514233 642965 808507 703668 552704 813796 619026 811331 796965 745276 753202 516843 636730 429366 477462 671002 668305 796071 745092 792726 745111 745915 791132 806834 389703 584183 571726 429861 468146 398122 477052 554369 443317 454793 483738 512072 662046 576848 619322 686183 804636 514155 511856 567063 666967 555599 756251 511278 471074 457650 534772 467633 564310 672939 660412 669056 671018 671045 686106 807590 739125 538484 588045 595177 740841 798457 491103 827290 476664 472815 550952 423763 394574 535363 532639 648696 697876 704100 613559 595213 788530 781298 788531 801495 803771 781420 793017 736014 796689 641806 457476 467636 564518 574391 580832 580069 585680 589185 594619 782057 803534 396784 428171 526653 826237 584996 649372 681388 586100 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (0.69%) |
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 389703 394574 396784 398122 415749 423763 428171 429366 429861 443233 443317 454793 457476 457650 467633 467634 467636 468146 471074 472815 476664 477052 477462 483738 483777 491103 511278 511856 512072 514155 514233 516843 526653 532639 534772 535363 538484 550952 552704 554369 555599 558158 561034 564518 567063 571726 574391 576848 580069 580832 584183 584996 585680 586100 588045 589185 594619 595177 595213 613559 619026 619322 636730 641806 642965 648696 649372 660412 662046 666967 668305 669056 671002 671018 671045 672939 681388 686106 686183 695869 697876 703668 704100 736014 739125 739131 740841 745092 745111 745276 745915 751546 752633 753202 756251 781298 781420 782057 788530 788531 791132 792726 793017 796071 796689 796965 798457 801495 803534 803771 804636 806834 807590 808265 808507 811331 813796 826237 827290 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dildo wife"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие дилд жен"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.39%) |
1 |
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.