Query Metrics
7
Database Queries
7
Different statements
200.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.67 ms (86.72%) |
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 387173 387925 391528 398749 401382 418566 434144 442643 460167 466763 467978 469350 474868 476305 480232 491862 492417 498759 502835 506310 509165 513199 515012 517693 517892 518544 518601 518784 520401 522206 524482 524485 526988 528856 528871 528885 530127 532295 532392 534162 534373 536565 537044 546556 547027 552094 553440 556576 556813 557020 561496 562182 562464 566074 567119 568337 569246 574318 577395 578432 579992 580872 580915 580920 582465 582747 584038 592930 594120 598321 598338 604916 605465 607177 609792 610594 615926 615935 617398 618291 620396 620467 621726 622733 627076 629269 630013 630614 633021 636456 644540 646166 649814 658991 662847 664154 681178 698014 707892 710491 715268 715478 723082 728649 738838 740153 741547 747975 748605 760456 770237 795276 796262 796438 796439 797308 805615 808058 812950 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (7.58%) |
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 630013 636456 805615 796262 808058 728649 740153 796438 796439 747975 748605 607177 710491 723082 812950 387925 391528 387173 398749 401382 532392 528885 532295 466763 474868 476305 561496 568337 646166 658991 715268 715478 577395 633021 741547 592930 491862 467978 480232 492417 506310 515012 517693 528871 534162 534373 518601 518784 537044 502835 530127 498759 518544 520401 524482 524485 536565 460167 552094 579992 580915 584038 547027 556813 569246 578432 580872 580920 582465 553440 556576 557020 562464 567119 574318 582747 649814 698014 707892 664154 662847 681178 546556 562182 598321 605465 617398 620396 621726 627076 630614 594120 604916 610594 615926 615935 620467 644540 598338 618291 797308 760456 760434 738838 770237 609792 622733 629269 795276 418566 509165 513199 566074 434144 442643 469350 522206 528856 517892 526988 ] |
||||||||||||||||||||||||||||||
|
4.33 ms (2.16%) |
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 387173 387925 391528 398749 401382 418566 434144 442643 460167 466763 467978 469350 474868 476305 480232 491862 492417 498759 502835 506310 509165 513199 515012 517693 517892 518544 518601 518784 520401 522206 524482 524485 526988 528856 528871 528885 530127 532295 532392 534162 534373 536565 537044 546556 547027 552094 553440 556576 556813 557020 561496 562182 562464 566074 567119 568337 569246 574318 577395 578432 579992 580872 580915 580920 582465 582747 584038 592930 594120 598321 598338 604916 605465 607177 609792 610594 615926 615935 617398 618291 620396 620467 621726 622733 627076 629269 630013 630614 633021 636456 644540 646166 649814 658991 662847 664154 681178 698014 707892 710491 715268 715478 723082 728649 738838 740153 741547 747975 748605 760456 770237 795276 796262 796438 796439 797308 805615 808058 812950 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно дойки"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"порн сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.71%) |
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.