Query Metrics
7
Database Queries
7
Different statements
151.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.63 ms (82.25%) |
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 418024 418158 423812 423814 426121 426127 426894 427144 435560 438447 438646 438957 448752 459622 459721 466379 472672 479585 484277 484923 486840 486928 486933 489797 494175 494176 494193 499568 502823 503487 508986 510166 516548 517878 524562 527271 527821 527828 528390 541478 552371 553746 554545 556756 557873 560681 562464 563592 568809 572190 575988 577105 579381 579448 580355 586298 586689 587504 588767 593289 599377 599679 601174 601555 605706 606912 607118 612715 614600 619678 626383 627344 629108 632090 632177 634951 644178 663281 663544 666496 670853 674474 680570 689862 689864 708585 712423 714188 714534 715483 717116 725527 726506 731165 734008 734144 741217 746124 746125 746512 746719 747226 749038 751354 753051 760178 763931 769567 777006 777733 782096 783211 790459 790710 793116 794251 796096 797341 802083 810395 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (11.20%) |
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 459721 472672 516548 557873 560681 568809 572190 663281 689864 712423 714534 586298 629108 593289 627344 810395 726506 734008 746125 783211 793116 734144 731165 749038 746512 746719 747226 746124 751354 632177 715483 717116 438646 459622 426894 438957 448752 427144 486933 666496 605706 494193 644178 763931 486840 484923 494176 527271 528390 541478 554545 563592 579381 577105 579448 580355 552371 562464 663544 670853 680570 689862 708585 714188 553746 575988 599377 612715 586689 599679 606912 619678 626383 587504 601555 607118 614600 634951 782096 790459 777006 794251 796096 802083 741217 760178 797341 753051 769567 777733 790710 466379 479585 426121 423812 426127 435560 438447 418024 503487 527828 489797 494175 502823 508986 517878 486928 524562 484277 527821 632090 418158 556756 588767 423814 499568 674474 601174 725527 510166 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.55%) |
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 418024 418158 423812 423814 426121 426127 426894 427144 435560 438447 438646 438957 448752 459622 459721 466379 472672 479585 484277 484923 486840 486928 486933 489797 494175 494176 494193 499568 502823 503487 508986 510166 516548 517878 524562 527271 527821 527828 528390 541478 552371 553746 554545 556756 557873 560681 562464 563592 568809 572190 575988 577105 579381 579448 580355 586298 586689 587504 588767 593289 599377 599679 601174 601555 605706 606912 607118 612715 614600 619678 626383 627344 629108 632090 632177 634951 644178 663281 663544 666496 670853 674474 680570 689862 689864 708585 712423 714188 714534 715483 717116 725527 726506 731165 734008 734144 741217 746124 746125 746512 746719 747226 749038 751354 753051 760178 763931 769567 777006 777733 782096 783211 790459 790710 793116 794251 796096 797341 802083 810395 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife masturbate"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен masturbate"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен masturbate"
]
|
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.