Query Metrics
7
Database Queries
7
Different statements
178.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.66 ms (83.43%) |
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 391651 394453 411351 421852 422270 422349 423923 424466 426822 433361 433371 439609 444528 448296 450368 452301 455118 456457 457678 458793 460941 461921 462592 462777 462956 463160 464546 465372 465914 466157 466217 466374 467708 467851 470295 470590 470673 471107 472148 472855 474182 474205 474786 476421 476494 476588 477373 478365 479585 484439 486894 487693 488118 489207 489224 490849 491089 492038 492668 492689 493155 493555 496003 496935 497919 499241 500378 503136 506422 509204 510340 510763 511529 511530 513936 516039 516923 518128 519363 520402 521520 522437 522517 524103 524251 525847 526040 527159 527161 534119 537377 538022 540793 547834 550179 550219 555048 558005 558236 563609 565861 566498 571326 571455 573801 575180 577990 584197 588242 590528 591131 603852 616680 619920 660137 663740 751536 764123 811399 811411 ] |
||||||||||||||||||||||||||||||
|
19.19 ms (10.77%) |
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 563609 472148 423923 550179 472855 506422 496935 509204 527159 616680 492689 424466 490849 489224 467708 462592 513936 463160 526040 391651 764123 422270 500378 516039 520402 466157 474182 461921 492668 565861 476421 458793 488118 524103 411351 577990 590528 426822 510763 524251 663740 751536 476494 444528 464546 474205 479585 457678 460941 486894 465372 462777 566498 462956 466217 558236 521520 456457 511529 503136 450368 465914 474786 477373 518128 537377 439609 478365 493155 591131 489207 811399 811411 422349 470295 534119 499241 547834 467851 471107 448296 510340 584197 571455 550219 452301 394453 511530 525847 516923 571326 588242 455118 619920 555048 433361 538022 421852 522437 487693 527161 484439 476588 491089 496003 558005 470673 519363 522517 492038 433371 540793 466374 497919 493555 573801 470590 603852 575180 660137 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (2.00%) |
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 391651 394453 411351 421852 422270 422349 423923 424466 426822 433361 433371 439609 444528 448296 450368 452301 455118 456457 457678 458793 460941 461921 462592 462777 462956 463160 464546 465372 465914 466157 466217 466374 467708 467851 470295 470590 470673 471107 472148 472855 474182 474205 474786 476421 476494 476588 477373 478365 479585 484439 486894 487693 488118 489207 489224 490849 491089 492038 492668 492689 493155 493555 496003 496935 497919 499241 500378 503136 506422 509204 510340 510763 511529 511530 513936 516039 516923 518128 519363 520402 521520 522437 522517 524103 524251 525847 526040 527159 527161 534119 537377 538022 540793 547834 550179 550219 555048 558005 558236 563609 565861 566498 571326 571455 573801 575180 577990 584197 588242 590528 591131 603852 616680 619920 660137 663740 751536 764123 811399 811411 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в постели с мамой русское"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в постел мам женщин русск"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.76%) |
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.