Query Metrics
7
Database Queries
7
Different statements
146.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.53 ms (83.85%) |
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 6651 34171 58313 68383 74811 187643 202846 203497 212959 382091 382935 383432 383588 384162 384472 384550 385040 386296 386775 387226 387696 387953 388673 389522 389565 389743 392977 393687 397203 397685 398602 398766 399747 403139 404438 404532 405455 405827 405852 406330 407503 408740 413070 413206 413733 417233 417599 418182 421606 422117 425870 426234 426293 426731 428289 428405 428632 429911 431897 433395 433464 435632 435888 436899 437712 438017 441762 442027 442150 442344 445088 445984 446525 449110 450047 451730 452356 453961 454015 454086 454818 456733 457090 457949 459231 462768 465555 467085 468580 469825 470990 471146 472537 477436 478035 478768 483702 483776 483892 485610 486364 486480 487843 490600 490847 491051 491225 491476 501904 505062 506660 509585 510670 515392 517958 519830 520281 522162 525073 529819 ] |
||||||||||||||||||||||||||||||
|
13.27 ms (9.08%) |
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 383432 397203 397685 399747 404532 405455 413733 425870 426731 428289 442150 465555 478768 426234 472537 477436 505062 515392 519830 529819 483702 483776 486480 490600 490847 509585 517958 522162 483892 486364 520281 525073 487843 501904 506660 510670 386775 386296 383588 68383 74811 384550 385040 384162 384472 382935 203497 212959 187643 202846 393687 392977 382091 34171 58313 6651 389522 389565 389743 388673 387226 387696 387953 398766 398602 404438 403139 405827 405852 406330 407503 417599 436899 438017 408740 413070 417233 418182 435888 437712 442027 442344 421606 426293 428405 413206 422117 429911 433395 441762 445088 428632 431897 433464 435632 446525 450047 454086 454818 467085 468580 445984 451730 452356 453961 456733 457090 491225 491476 449110 454015 457949 459231 462768 469825 470990 471146 478035 485610 491051 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (2.08%) |
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 6651 34171 58313 68383 74811 187643 202846 203497 212959 382091 382935 383432 383588 384162 384472 384550 385040 386296 386775 387226 387696 387953 388673 389522 389565 389743 392977 393687 397203 397685 398602 398766 399747 403139 404438 404532 405455 405827 405852 406330 407503 408740 413070 413206 413733 417233 417599 418182 421606 422117 425870 426234 426293 426731 428289 428405 428632 429911 431897 433395 433464 435632 435888 436899 437712 438017 441762 442027 442150 442344 445088 445984 446525 449110 450047 451730 452356 453961 454015 454086 454818 456733 457090 457949 459231 462768 465555 467085 468580 469825 470990 471146 472537 477436 478035 478768 483702 483776 483892 485610 486364 486480 487843 490600 490847 491051 491225 491476 501904 505062 506660 509585 510670 515392 517958 519830 520281 522162 525073 529819 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"нача"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"начал"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
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.