Query Metrics
7
Database Queries
7
Different statements
183.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.62 ms (85.90%) |
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 6710 132341 381752 383188 383705 387905 395240 396404 397918 404742 417174 423056 424458 424475 424482 425945 429741 438001 442964 444321 447132 452638 453037 454658 457984 460188 460922 463764 464139 465661 466855 468478 470971 471612 478437 480283 480457 481501 482527 484553 496337 500623 501499 506801 510360 511274 511856 513025 514911 515641 516314 516940 518494 518599 518957 519034 522608 529345 533040 533897 538949 540952 552800 564227 567909 569129 572697 576702 579379 587987 589747 591109 591357 592945 594491 601203 619464 620248 620249 625801 626399 631683 634108 640837 641997 663944 669075 700975 705450 705530 706924 713176 719099 720127 721830 739532 739535 749340 757331 761028 761102 761756 761842 765712 767585 776312 781459 786114 786406 788608 788860 790228 800604 802161 812552 813556 814971 814981 815320 815608 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (8.52%) |
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 515641 516314 510360 513025 620248 132341 397918 478437 700975 705530 552800 781459 757331 790228 460188 429741 496337 569129 383705 706924 381752 404742 471612 739535 482527 518599 425945 438001 454658 480283 540952 587987 739532 424482 424475 572697 452638 518957 424458 501499 383188 442964 813556 457984 564227 663944 576702 594491 634108 749340 786114 522608 500623 514911 6710 815608 814981 815320 468478 480457 533897 511274 533040 719099 669075 720127 721830 591357 592945 641997 800604 786406 802161 788608 788860 761756 767585 761102 761028 761842 765712 626399 447132 463764 529345 519034 776312 705450 620249 812552 506801 567909 713176 814971 453037 460922 466855 481501 516940 538949 511856 579379 619464 601203 625801 631683 396404 417174 470971 395240 465661 518494 444321 484553 589747 591109 640837 423056 464139 387905 ] |
||||||||||||||||||||||||||||||
|
2.72 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 6710 132341 381752 383188 383705 387905 395240 396404 397918 404742 417174 423056 424458 424475 424482 425945 429741 438001 442964 444321 447132 452638 453037 454658 457984 460188 460922 463764 464139 465661 466855 468478 470971 471612 478437 480283 480457 481501 482527 484553 496337 500623 501499 506801 510360 511274 511856 513025 514911 515641 516314 516940 518494 518599 518957 519034 522608 529345 533040 533897 538949 540952 552800 564227 567909 569129 572697 576702 579379 587987 589747 591109 591357 592945 594491 601203 619464 620248 620249 625801 626399 631683 634108 640837 641997 663944 669075 700975 705450 705530 706924 713176 719099 720127 721830 739532 739535 749340 757331 761028 761102 761756 761842 765712 767585 776312 781459 786114 786406 788608 788860 790228 800604 802161 812552 813556 814971 814981 815320 815608 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal glasses"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.89%) |
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.