Query Metrics
7
Database Queries
7
Different statements
164.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.45 ms (81.68%) |
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 391925 400989 401575 419619 423856 423972 437599 438324 439715 442913 447204 460540 460754 470064 470690 470898 491429 495562 495700 497345 499643 504211 507197 508393 508678 510504 513374 513592 516941 517304 517816 522931 525470 527180 539366 540713 540746 546720 547748 547751 547780 548024 559467 563029 564647 571508 573732 579883 582500 588988 590205 590246 592862 596841 606032 609432 609966 611506 620233 623398 624888 656138 660696 672809 689161 697720 705022 707507 711590 712308 714319 714322 714336 714346 714789 718774 722955 724809 725464 730987 736905 737438 738365 740919 742839 744479 751570 751576 754037 755022 756601 765821 765828 765845 771576 775848 776035 777727 777823 779566 780340 782317 786428 788084 789460 790534 791516 791759 791921 793295 796538 803142 804927 806952 807353 812593 814226 816691 818368 ] |
||||||||||||||||||||||||||||||
|
19.99 ms (12.14%) |
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 786428 790534 791759 803142 391925 513374 423972 571508 775848 517816 527180 401575 470064 547751 606032 596841 590205 419619 439715 513592 460754 548024 656138 504211 442913 495562 491429 818368 816691 497345 540746 714336 714346 714322 547780 579883 590246 620233 624888 611506 779566 807353 812593 777727 793295 796538 806952 737438 742839 751576 791516 765821 736905 755022 765845 751570 756601 765828 724809 740919 754037 771576 609966 623398 711590 776035 777823 780340 782317 791921 438324 470898 499643 522931 525470 507197 788084 564647 592862 495700 539366 559467 470690 730987 725464 804927 563029 609432 546720 588988 400989 460540 447204 508393 510504 516941 573732 660696 423856 437599 508678 513476 722955 789460 744479 738365 672809 689161 707507 712308 714789 705022 517304 814226 540713 582500 697720 714319 718774 547748 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.74%) |
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 391925 400989 401575 419619 423856 423972 437599 438324 439715 442913 447204 460540 460754 470064 470690 470898 491429 495562 495700 497345 499643 504211 507197 508393 508678 510504 513374 513592 516941 517304 517816 522931 525470 527180 539366 540713 540746 546720 547748 547751 547780 548024 559467 563029 564647 571508 573732 579883 582500 588988 590205 590246 592862 596841 606032 609432 609966 611506 620233 623398 624888 656138 660696 672809 689161 697720 705022 707507 711590 712308 714319 714322 714336 714346 714789 718774 722955 724809 725464 730987 736905 737438 738365 740919 742839 744479 751570 751576 754037 755022 756601 765821 765828 765845 771576 775848 776035 777727 777823 779566 780340 782317 786428 788084 789460 790534 791516 791759 791921 793295 796538 803142 804927 806952 807353 812593 814226 816691 818368 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русская милфа домашне…"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск милф домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.04%) |
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.