Query Metrics
7
Database Queries
7
Different statements
160.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.57 ms (84.39%) |
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 95991 411313 425745 426145 426150 427108 427469 435434 438769 444691 444900 446118 446449 446604 456196 457280 457340 458066 458286 458810 460548 461415 461562 462038 462089 463161 463654 464503 468412 468959 471935 472296 473523 476567 476609 478890 480140 483238 485588 485663 486978 487380 489702 491307 491705 491723 492505 493387 494371 494822 495622 497573 499441 500397 501303 501747 501912 501923 504271 504834 505105 507007 507877 508513 509180 516914 518722 522118 524428 524691 524708 525759 526239 527713 527969 534126 546377 549769 553974 556715 557940 558846 558850 558999 560977 561988 564803 566554 568845 573817 573959 574585 574838 575059 580678 584781 586057 590375 597215 609641 614487 673415 676951 693246 709994 713928 729442 740157 758365 764806 773399 779247 781061 782350 804817 807504 810783 811611 814562 825555 ] |
||||||||||||||||||||||||||||||
|
15.08 ms (9.39%) |
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 492505 524708 807504 758365 476609 468412 463654 458810 573959 461562 462089 500397 491307 709994 810783 458066 464503 446118 480140 825555 693246 558999 444900 476567 461415 493387 501303 509180 501747 501923 524691 713928 673415 804817 740157 609641 411313 553974 764806 773399 782350 458286 549769 568845 456196 457280 501912 507007 526239 485663 486978 516914 556715 426145 95991 597215 491705 590375 471935 472296 527713 489702 427108 426150 504834 525759 507877 508513 446449 483238 487380 504271 584781 779247 729442 781061 522118 425745 444691 446604 485588 527969 546377 811611 457340 814562 574838 573817 499441 473523 575059 557940 561988 574585 586057 505105 558846 676951 494822 558850 524428 494371 478890 468959 460548 614487 427469 497573 566554 438769 518722 495622 560977 564803 463161 435434 491723 534126 580678 462038 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.93%) |
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 95991 411313 425745 426145 426150 427108 427469 435434 438769 444691 444900 446118 446449 446604 456196 457280 457340 458066 458286 458810 460548 461415 461562 462038 462089 463161 463654 464503 468412 468959 471935 472296 473523 476567 476609 478890 480140 483238 485588 485663 486978 487380 489702 491307 491705 491723 492505 493387 494371 494822 495622 497573 499441 500397 501303 501747 501912 501923 504271 504834 505105 507007 507877 508513 509180 516914 518722 522118 524428 524691 524708 525759 526239 527713 527969 534126 546377 549769 553974 556715 557940 558846 558850 558999 560977 561988 564803 566554 568845 573817 573959 574585 574838 575059 580678 584781 586057 590375 597215 609641 614487 673415 676951 693246 709994 713928 729442 740157 758365 764806 773399 779247 781061 782350 804817 807504 810783 811611 814562 825555 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс с русской девушк…"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс русск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
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.