Query Metrics
7
Database Queries
7
Different statements
445.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
218.38 ms (49.03%) |
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 6669 95668 383249 383429 384390 384762 386893 388062 388755 389538 390525 392191 393476 393571 393670 396050 397304 397912 398176 398195 401122 401336 401531 402450 405749 408330 410636 411215 415875 439034 447149 451495 452864 456198 461680 462027 464042 464198 464235 468176 468421 468690 469503 470406 471769 472446 477253 477515 478078 479174 479712 485903 487059 487724 488298 489881 490536 490848 490859 491601 493515 494431 495008 495437 496730 497730 498081 499083 499457 502784 503308 508916 509104 509606 511270 512711 512911 513457 514957 517715 519243 522190 525905 530496 531283 531769 533460 533782 534331 534748 535522 535618 537217 537245 537664 538664 538824 539559 540056 541062 544209 546666 557269 644974 698711 710250 720195 723159 723579 737553 747437 760931 761132 815939 817329 820459 821892 822205 823092 824094 ] |
||||||||||||||||||||||||||||||
|
206.76 ms (46.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white anal"
]
|
||||||||||||||||||||||||||||||
|
12.79 ms (2.87%) |
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 534748 496730 533782 494431 495008 502784 525905 462027 468421 471769 472446 487724 389538 393670 452864 383249 451495 456198 468690 478078 479174 411215 509606 512911 464198 461680 464042 495437 508916 511270 539559 439034 497730 498081 384762 393476 6669 386893 397912 398195 410636 723579 821892 815939 820459 824094 817329 477253 493515 479712 530496 534331 535522 537217 531769 517715 540056 531283 464235 557269 546666 760931 761132 747437 698711 720195 396050 401336 401531 408330 405749 388062 393571 384390 383429 392191 95668 388755 390525 397304 398176 401122 402450 415875 822205 644974 823092 469503 485903 487059 489881 490536 490848 490859 447149 470406 477515 491601 499083 513457 519243 522190 533460 535618 537245 537664 509104 512711 514957 538664 538824 499457 503308 468176 488298 541062 544209 710250 723159 737553 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (0.60%) |
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 6669 95668 383249 383429 384390 384762 386893 388062 388755 389538 390525 392191 393476 393571 393670 396050 397304 397912 398176 398195 401122 401336 401531 402450 405749 408330 410636 411215 415875 439034 447149 451495 452864 456198 461680 462027 464042 464198 464235 468176 468421 468690 469503 470406 471769 472446 477253 477515 478078 479174 479712 485903 487059 487724 488298 489881 490536 490848 490859 491601 493515 494431 495008 495437 496730 497730 498081 499083 499457 502784 503308 508916 509104 509606 511270 512711 512911 513457 514957 517715 519243 522190 525905 530496 531283 531769 533460 533782 534331 534748 535522 535618 537217 537245 537664 538664 538824 539559 540056 541062 544209 546666 557269 644974 698711 710250 720195 723159 723579 737553 747437 760931 761132 815939 817329 820459 821892 822205 823092 824094 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white анал"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white анал"
]
|
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.