Query Metrics
7
Database Queries
7
Different statements
378.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.09 ms (55.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double penetration vagina"
]
|
||||||||||||||||||||||||||||||
|
143.74 ms (37.98%) |
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 7196 95988 268222 383097 387251 387636 390024 390871 390950 390994 391450 401325 404415 407357 411747 413391 415081 415618 417674 423480 423647 423657 424259 424362 429799 431412 436718 440775 442971 445493 448552 448632 448832 449450 459383 467555 468626 468631 471792 473511 473782 478215 482605 484721 488805 493521 494151 496792 500717 506324 507646 509805 509875 510392 510394 510395 515892 522283 522910 523312 530268 530798 531854 535644 536202 536206 536650 541336 545416 547242 548454 550285 550669 550798 554857 555126 559298 559363 583715 584001 597239 597566 600225 600275 601559 601635 603209 615918 620663 631937 636292 639023 640783 642000 642149 645327 646152 647928 648704 650459 656301 656916 658777 676092 680215 708525 712942 720072 720138 720156 720627 723494 731877 741542 744744 756479 756687 775946 805990 808327 ] |
||||||||||||||||||||||||||||||
|
17.59 ms (4.65%) |
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 390950 411747 436718 482605 473782 494151 523312 530798 509875 530268 550669 646152 650459 720627 645327 647928 631937 597566 601559 741542 808327 731877 424362 7196 407357 478215 522910 488805 510392 536202 550798 387251 390871 440775 449450 473511 500717 600225 459383 423480 431412 468626 555126 720072 584001 620663 640783 424259 445493 391450 471792 496792 583715 720156 680215 720138 615918 506324 559363 656301 642149 756687 404415 423647 95988 442971 712942 468631 708525 429799 423657 515892 535644 536650 509805 493521 541336 676092 642000 600275 601635 636292 756479 510395 484721 510394 522283 507646 390024 390994 415081 448552 545416 775946 805990 383097 387636 413391 531854 554857 548454 656916 658777 723494 639023 744744 401325 550285 603209 415618 547242 417674 448832 467555 448632 648704 268222 597239 536206 559298 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (0.64%) |
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 7196 95988 268222 383097 387251 387636 390024 390871 390950 390994 391450 401325 404415 407357 411747 413391 415081 415618 417674 423480 423647 423657 424259 424362 429799 431412 436718 440775 442971 445493 448552 448632 448832 449450 459383 467555 468626 468631 471792 473511 473782 478215 482605 484721 488805 493521 494151 496792 500717 506324 507646 509805 509875 510392 510394 510395 515892 522283 522910 523312 530268 530798 531854 535644 536202 536206 536650 541336 545416 547242 548454 550285 550669 550798 554857 555126 559298 559363 583715 584001 597239 597566 600225 600275 601559 601635 603209 615918 620663 631937 636292 639023 640783 642000 642149 645327 646152 647928 648704 650459 656301 656916 658777 676092 680215 708525 712942 720072 720138 720156 720627 723494 731877 741542 744744 756479 756687 775946 805990 808327 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double penetration вагин"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double penetration вагин"
]
|
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.