Query Metrics
7
Database Queries
7
Different statements
355.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.81 ms (58.43%) |
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 95991 389765 390533 400689 401282 410937 413237 415294 416599 416683 417367 417940 418848 421050 422441 425118 428229 436230 439138 444538 445961 445975 447305 448257 450484 450572 451775 456220 456222 456238 456240 457512 459198 461704 461924 465148 466475 467588 471688 474284 476737 476785 477246 478775 487428 490507 495470 497482 498294 499288 500335 501098 504781 506105 506119 511864 512442 514043 516579 517425 518671 519699 521927 526905 528055 531177 533765 534028 534032 534561 538977 541274 542705 543659 544404 548157 554070 556884 565247 595373 595459 596989 597190 597499 597534 598489 598540 598544 598565 600087 611572 624925 630511 641830 642097 654401 656935 662046 677343 683259 714497 722384 727643 737052 740251 742846 744896 745125 745126 745136 766461 770410 770821 782790 785871 801280 806325 810848 813573 813906 ] |
||||||||||||||||||||||||||||||
|
125.26 ms (35.22%) |
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 95991 389765 390533 400689 401282 410937 413237 415294 416599 416683 417367 417940 418848 421050 422441 425118 428229 436230 439138 444538 445961 445975 447305 448257 450484 450572 451775 456220 456222 456238 456240 457512 459198 461704 461924 465148 466475 467588 471688 474284 476737 476785 477246 478775 487428 490507 495470 497482 498294 499288 500335 501098 504781 506105 506119 511864 512442 514043 516579 517425 518671 519699 521927 526905 528055 531177 533765 534028 534032 534561 538977 541274 542705 543659 544404 548157 554070 556884 565247 595373 595459 596989 597190 597499 597534 598489 598540 598544 598565 600087 611572 624925 630511 641830 642097 654401 656935 662046 677343 683259 714497 722384 727643 737052 740251 742846 744896 745125 745126 745136 766461 770410 770821 782790 785871 801280 806325 810848 813573 813906 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (4.41%) |
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 497482 506119 521927 501098 598544 554070 598565 543659 742846 534028 436230 533765 511864 512442 514043 538977 526905 541274 548157 542705 544404 662046 656935 722384 556884 641830 597190 596989 597534 600087 782790 770821 806325 745126 745125 745136 770410 400689 416599 466475 389765 413237 450572 456238 516579 517425 487428 499288 630511 595373 727643 744896 598489 418848 624925 654401 597499 766461 518671 714497 390533 425118 448257 95991 504781 417367 461924 444538 465148 421050 447305 476785 477246 445961 456240 500335 534561 495470 506105 519699 528055 813906 677343 642097 595459 531177 683259 565247 478775 490507 813573 534032 598540 611572 785871 737052 801280 810848 740251 417940 439138 450484 456222 461704 415294 451775 456220 457512 467588 476737 401282 410937 416683 422441 459198 471688 428229 445975 474284 498294 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teen hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teen хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teen хардкор"
]
|
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.