Query Metrics
7
Database Queries
7
Different statements
203.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.53 ms (87.75%) |
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 9021 14392 34016 54301 114645 142253 161731 187567 382058 382368 383521 386865 400100 415558 422629 430342 443941 449855 449880 464531 466255 466910 477361 482794 490265 491828 492609 502021 505922 507675 520162 534396 543421 551277 557944 563449 564661 567159 572202 574281 579938 583873 585340 596096 603507 603548 603572 608331 609284 612383 622349 629362 634851 637569 641465 644388 645946 645999 649208 649221 650790 653328 659339 663884 664828 670689 676402 678576 678579 679058 681785 682001 693188 693990 694128 696283 699065 701490 703038 703511 705629 710320 712466 715192 720799 721070 721792 722861 724038 724198 729233 730095 732799 736247 742603 742876 744212 751495 756231 784525 785376 792487 792801 800632 804613 805537 805859 810763 814236 815345 818169 818459 820394 820783 821406 821523 821837 822027 822960 826280 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (7.58%) |
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 543421 826280 491828 449855 477361 564661 712466 732799 505922 736247 821406 187567 492609 650790 664828 682001 114645 676402 551277 490265 583873 415558 534396 386865 466255 482794 703038 742603 670689 693990 603548 563449 645999 785376 820394 729233 422629 520162 653328 715192 609284 724198 641465 663884 557944 644388 818459 820783 721070 649221 810763 703511 54301 637569 822960 815345 821523 699065 805537 724038 800632 805859 784525 161731 579938 751495 705629 634851 792801 818169 814236 710320 382058 596096 567159 449880 603507 612383 744212 382368 659339 742876 721792 792487 142253 466910 9021 574281 34016 572202 502021 822027 678576 804613 694128 693188 603572 678579 679058 720799 622349 756231 629362 585340 383521 821837 730095 464531 701490 400100 507675 696283 649208 722861 608331 14392 430342 681785 443941 645946 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.12%) |
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 9021 14392 34016 54301 114645 142253 161731 187567 382058 382368 383521 386865 400100 415558 422629 430342 443941 449855 449880 464531 466255 466910 477361 482794 490265 491828 492609 502021 505922 507675 520162 534396 543421 551277 557944 563449 564661 567159 572202 574281 579938 583873 585340 596096 603507 603548 603572 608331 609284 612383 622349 629362 634851 637569 641465 644388 645946 645999 649208 649221 650790 653328 659339 663884 664828 670689 676402 678576 678579 679058 681785 682001 693188 693990 694128 696283 699065 701490 703038 703511 705629 710320 712466 715192 720799 721070 721792 722861 724038 724198 729233 730095 732799 736247 742603 742876 744212 751495 756231 784525 785376 792487 792801 800632 804613 805537 805859 810763 814236 815345 818169 818459 820394 820783 821406 821523 821837 822027 822960 826280 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жмж натуральные сиськ…"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жмж секс втро натуральные сиськ без силикон"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро натуральные сиськ без силикон"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.