Query Metrics
7
Database Queries
7
Different statements
377.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.15 ms (56.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen постел"
]
|
||||||||||||||||||||||||||||||
|
135.54 ms (35.95%) |
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 21576 96530 351640 388826 393761 398453 398585 400035 400126 401631 403496 415053 417454 419567 420284 420860 423595 426001 428048 428281 428305 429185 429595 432421 432678 432711 432732 433618 433706 433990 434017 434208 434710 435400 439465 440202 440923 441538 441560 441610 442400 442469 442486 443509 444060 448559 448651 449946 453033 453678 453816 454118 454417 455879 456667 457234 459366 459494 459881 460080 461316 461680 461681 462740 464874 467959 468503 468695 469102 469787 470132 474021 477775 479748 480017 480075 481548 483717 483726 485196 485259 485811 486425 487013 488247 489931 491537 491684 494382 494818 496746 497636 500332 503193 504967 506077 508916 509078 509975 510496 511255 511267 511819 512520 513247 513459 514845 514849 519554 521835 523709 533053 541422 594370 595401 596645 597501 598042 598510 684465 ] |
||||||||||||||||||||||||||||||
|
16.99 ms (4.51%) |
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 426001 435400 459494 461316 461681 470132 474021 480017 480075 21576 351640 400035 401631 423595 428281 428305 429185 433618 434017 453033 453678 468695 479748 415053 417454 441560 460080 462740 500332 503193 509078 514849 519554 491684 504967 513247 514845 483726 485196 485259 486425 488247 489931 491537 494382 494818 510496 509975 521835 523709 541422 434710 533053 595401 598042 594370 597501 596645 598510 96530 393761 388826 398585 400126 398453 403496 420860 429595 439465 441538 443509 432421 432711 432732 434208 442486 444060 433706 433990 440923 441610 428048 432678 442400 419567 420284 440202 442469 684465 448651 454118 456667 459366 467959 469102 483717 487013 448559 449946 453816 461680 477775 454417 455879 457234 459881 464874 468503 469787 481548 485811 496746 497636 506077 508916 511255 511267 511819 512520 513459 ] |
||||||||||||||||||||||||||||||
|
4.56 ms (1.21%) |
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 21576 96530 351640 388826 393761 398453 398585 400035 400126 401631 403496 415053 417454 419567 420284 420860 423595 426001 428048 428281 428305 429185 429595 432421 432678 432711 432732 433618 433706 433990 434017 434208 434710 435400 439465 440202 440923 441538 441560 441610 442400 442469 442486 443509 444060 448559 448651 449946 453033 453678 453816 454118 454417 455879 456667 457234 459366 459494 459881 460080 461316 461680 461681 462740 464874 467959 468503 468695 469102 469787 470132 474021 477775 479748 480017 480075 481548 483717 483726 485196 485259 485811 486425 487013 488247 489931 491537 491684 494382 494818 496746 497636 500332 503193 504967 506077 508916 509078 509975 510496 511255 511267 511819 512520 513247 513459 514845 514849 519554 521835 523709 533053 541422 594370 595401 596645 597501 598042 598510 684465 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen постел"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen bed"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.49%) |
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.