Query Metrics
7
Database Queries
7
Different statements
152.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.22 ms (83.35%) |
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 538951 539503 541376 542494 542992 544279 544445 544591 544864 559118 560381 562844 563188 563210 563538 566366 566684 566689 566866 566941 568258 570003 570021 572603 574263 577358 580775 581359 583851 583882 589204 592426 592451 592518 599577 601166 602461 603161 603468 605342 608352 611505 617650 618301 618962 621682 622361 627061 628301 628308 634692 643007 644264 644288 644323 644327 644330 648206 648598 649105 649151 649152 649615 651078 651199 651597 651630 652240 653300 661899 665651 666856 668441 669570 670097 670109 670110 671721 671724 671898 672151 672181 677705 681085 681797 681908 682822 685728 687130 690947 692013 693026 693032 693869 694192 694201 694206 694221 694524 694554 695948 699574 699606 699686 699730 699745 700281 703059 703093 703512 703514 703537 703553 705537 708424 708433 716746 719058 720382 744596 ] |
||||||||||||||||||||||||||||||
|
14.82 ms (9.71%) |
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 670110 671898 682822 648598 653300 666856 672181 677705 694554 669570 681908 690947 703553 570003 570021 592426 605342 618962 628308 611505 644327 603468 627061 628301 644330 699730 716746 539503 544864 559118 566866 542494 563538 566366 542992 544591 563210 581359 648206 649105 661899 694206 649615 665651 668441 670109 685728 692013 693032 694524 699574 699686 703512 651597 681085 681797 687130 693026 693869 563188 574263 622361 599577 621682 601166 608352 592518 744596 617650 634692 644323 699745 703059 703514 580775 538951 541376 544445 560381 572603 577358 583851 583882 544279 566684 566689 566941 568258 649152 694201 703537 708424 719058 720382 649151 651078 651199 651630 670097 671721 672151 694192 695948 699606 700281 703093 652240 671724 694221 705537 708433 562844 589204 644264 644288 602461 618301 603161 643007 592451 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.11%) |
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 538951 539503 541376 542494 542992 544279 544445 544591 544864 559118 560381 562844 563188 563210 563538 566366 566684 566689 566866 566941 568258 570003 570021 572603 574263 577358 580775 581359 583851 583882 589204 592426 592451 592518 599577 601166 602461 603161 603468 605342 608352 611505 617650 618301 618962 621682 622361 627061 628301 628308 634692 643007 644264 644288 644323 644327 644330 648206 648598 649105 649151 649152 649615 651078 651199 651597 651630 652240 653300 661899 665651 666856 668441 669570 670097 670109 670110 671721 671724 671898 672151 672181 677705 681085 681797 681908 682822 685728 687130 690947 692013 693026 693032 693869 694192 694201 694206 694221 694524 694554 695948 699574 699606 699686 699730 699745 700281 703059 703093 703512 703514 703537 703553 705537 708424 708433 716746 719058 720382 744596 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro girls"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр девушк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
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.