Query Metrics
7
Database Queries
7
Different statements
388.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.72 ms (52.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock dick mature"
]
|
||||||||||||||||||||||||||||||
|
159.06 ms (40.92%) |
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 370755 384124 405830 411321 411696 418080 419535 428102 443999 451445 453269 454178 458924 463158 464553 464649 465825 465834 465952 465953 466025 466208 466229 466722 466725 466875 466958 467045 467233 467457 467949 470158 470424 471885 472891 474073 474405 474478 474627 474652 474877 475198 475895 476285 476349 477721 479073 479080 479103 479112 479144 480290 480377 481906 482322 484405 484435 484598 484607 484608 484621 484635 484696 484718 487318 487353 490872 493095 493120 495396 497391 500795 500832 502008 503961 506829 506908 508736 510882 511518 511529 512536 514581 514681 515841 515912 516470 516562 520569 520899 522478 522504 523874 524351 525834 526833 527873 528198 529398 544493 544504 558020 558295 563161 563226 563436 563548 569149 582583 589662 591877 592914 593842 629847 665414 678805 724233 726543 726594 729819 ] |
||||||||||||||||||||||||||||||
|
17.69 ms (4.55%) |
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 384124 405830 419535 465825 465834 479073 479103 479112 482322 470158 474478 500832 502008 516470 516562 520899 523874 528198 484435 511529 515912 520569 487318 490872 508736 484598 484608 484621 484718 506829 515841 525834 453269 497391 500795 582583 544504 558020 558295 563436 563226 569149 665414 592914 589662 591877 593842 729819 724233 629847 526833 466208 463158 726594 474652 474627 411696 678805 522478 480290 466229 484696 477721 506908 524351 464553 466725 544493 726543 370755 428102 471885 480377 484405 466722 481906 458924 464649 467949 474877 475895 487353 514681 529398 510882 512536 527873 495396 514581 465953 470424 474073 474405 476349 484635 493095 493120 563161 563548 451445 466958 475198 411321 418080 466875 467457 479080 479144 443999 454178 466025 476285 465952 467045 467233 472891 484607 503961 511518 522504 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (0.64%) |
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 370755 384124 405830 411321 411696 418080 419535 428102 443999 451445 453269 454178 458924 463158 464553 464649 465825 465834 465952 465953 466025 466208 466229 466722 466725 466875 466958 467045 467233 467457 467949 470158 470424 471885 472891 474073 474405 474478 474627 474652 474877 475198 475895 476285 476349 477721 479073 479080 479103 479112 479144 480290 480377 481906 482322 484405 484435 484598 484607 484608 484621 484635 484696 484718 487318 487353 490872 493095 493120 495396 497391 500795 500832 502008 503961 506829 506908 508736 510882 511518 511529 512536 514581 514681 515841 515912 516470 516562 520569 520899 522478 522504 523874 524351 525834 526833 527873 528198 529398 544493 544504 558020 558295 563161 563226 563436 563548 569149 582583 589662 591877 592914 593842 629847 665414 678805 724233 726543 726594 729819 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock член mature"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock член mature"
]
|
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.