Query Metrics
7
Database Queries
7
Different statements
157.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.96 ms (83.40%) |
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 133695 221827 298519 384390 387334 387711 390407 392524 395311 397927 404206 412101 415028 423916 424224 426429 427135 427480 434106 434124 435590 436538 437726 438459 438596 438629 440372 440840 446240 447376 456542 456992 457524 458485 460426 461341 461832 461901 464056 465538 465559 465986 466796 468339 468372 472372 473442 473473 475637 475851 483055 485295 486052 486617 487850 490612 492963 494068 496091 511349 512155 512792 515541 516197 516542 520287 521519 521521 526541 529045 529396 532326 535900 538348 540068 543365 543767 546075 548064 550825 554324 557097 558374 561047 563807 564546 564876 565760 572035 574356 574466 579556 579649 583328 589081 590506 590956 591562 593838 600745 602894 603417 603637 609303 625108 629717 631383 631800 637487 641004 658042 670695 670833 675686 697440 708667 718808 726317 763875 785535 ] |
||||||||||||||||||||||||||||||
|
14.09 ms (8.98%) |
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 563807 591562 590506 785535 387711 438459 461341 461832 221827 435590 516197 561047 574466 395311 529045 554324 572035 550825 658042 631800 515541 461901 436538 526541 675686 589081 726317 426429 521521 404206 423916 415028 564546 457524 543767 564876 558374 600745 434124 496091 298519 468339 492963 133695 390407 427480 437726 464056 473473 485295 490612 521519 532326 494068 511349 540068 538348 465538 465559 466796 475637 543365 583328 574356 697440 718808 670833 557097 579556 579649 593838 603637 637487 590956 603417 609303 629717 631383 641004 763875 438629 472372 424224 438596 475851 516542 483055 487850 486052 486617 512155 412101 458485 446240 456542 427135 456992 465986 440840 434106 468372 565760 670695 708667 546075 548064 602894 625108 384390 392524 387334 397927 440372 447376 460426 473442 512792 520287 529396 535900 ] |
||||||||||||||||||||||||||||||
|
3.73 ms (2.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"стринг нижн бел"
]
|
||||||||||||||||||||||||||||||
|
2.71 ms (1.73%) |
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 133695 221827 298519 384390 387334 387711 390407 392524 395311 397927 404206 412101 415028 423916 424224 426429 427135 427480 434106 434124 435590 436538 437726 438459 438596 438629 440372 440840 446240 447376 456542 456992 457524 458485 460426 461341 461832 461901 464056 465538 465559 465986 466796 468339 468372 472372 473442 473473 475637 475851 483055 485295 486052 486617 487850 490612 492963 494068 496091 511349 512155 512792 515541 516197 516542 520287 521519 521521 526541 529045 529396 532326 535900 538348 540068 543365 543767 546075 548064 550825 554324 557097 558374 561047 563807 564546 564876 565760 572035 574356 574466 579556 579649 583328 589081 590506 590956 591562 593838 600745 602894 603417 603637 609303 625108 629717 631383 631800 637487 641004 658042 670695 670833 675686 697440 708667 718808 726317 763875 785535 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стрингах"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
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.