Query Metrics
7
Database Queries
7
Different statements
171.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.80 ms (84.98%) |
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 119927 382578 383599 392177 412062 413444 415857 418139 434286 434337 434350 434358 434367 434763 435008 435550 437518 441108 441113 444413 445401 446038 446181 448002 448369 450410 450697 452572 452637 454004 454518 454801 460001 467867 467886 469250 470473 472625 476654 483731 492714 493258 495566 496772 499857 502868 506516 508187 512938 513842 514568 526894 529739 529999 531880 532765 534546 534566 534574 540032 550362 583866 588014 590410 590788 591197 593096 606576 609083 619361 629808 632107 639060 649921 656935 658789 709128 709723 710161 718766 718788 722420 728145 728200 738827 739568 741241 745136 745938 747098 750285 751435 751572 752602 752704 754127 765256 766694 775855 776940 778941 780642 781779 782450 784974 786876 786879 787818 788196 788344 789647 795404 796351 798775 800698 801259 802803 814523 817510 ] |
||||||||||||||||||||||||||||||
|
15.35 ms (8.95%) |
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 710161 512938 590410 532765 534546 722420 786879 795404 741241 787818 750285 798775 800698 434358 802803 591197 444413 434350 441113 469250 496772 531880 460001 649921 658789 766694 728200 745136 752602 470473 593096 526894 437518 817510 452572 745938 450697 529739 441108 448002 476654 588014 492714 619361 609083 739568 784974 119927 508187 632107 639060 467867 392177 454004 483731 529999 534566 514568 583866 656935 780642 781779 801259 786876 789647 382578 448369 513842 383599 796351 502868 434763 540032 718766 718788 629808 782450 775855 728145 747098 751435 754127 709128 776940 467886 412062 434367 493258 499857 413444 452637 454518 550362 590788 415857 446181 434286 435550 450410 495566 435008 446038 788344 787989 506516 765256 418139 434337 445401 814523 454801 534574 472625 709723 606576 788196 778941 738827 751572 752704 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.48%) |
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 119927 382578 383599 392177 412062 413444 415857 418139 434286 434337 434350 434358 434367 434763 435008 435550 437518 441108 441113 444413 445401 446038 446181 448002 448369 450410 450697 452572 452637 454004 454518 454801 460001 467867 467886 469250 470473 472625 476654 483731 492714 493258 495566 496772 499857 502868 506516 508187 512938 513842 514568 526894 529739 529999 531880 532765 534546 534566 534574 540032 550362 583866 588014 590410 590788 591197 593096 606576 609083 619361 629808 632107 639060 649921 656935 658789 709128 709723 710161 718766 718788 722420 728145 728200 738827 739568 741241 745136 745938 747098 750285 751435 751572 752602 752704 754127 765256 766694 775855 776940 778941 780642 781779 782450 784974 786876 786879 787818 788196 788344 789647 795404 796351 798775 800698 801259 802803 814523 817510 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife anal squirt"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен анал сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
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.