Query Metrics
7
Database Queries
7
Different statements
178.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.97 ms (80.69%) |
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 78926 130105 143010 382352 386303 388726 389690 395492 395845 396744 400684 404568 410954 416365 420139 421289 422732 423350 423480 424523 427217 429523 432586 432662 433038 433040 433047 434701 446694 447102 448121 452279 452282 454801 460328 460689 461714 464201 465040 468387 468433 470412 471814 473461 475479 477084 478110 478488 478608 482775 482776 482780 483752 484811 485155 486214 496060 497885 498830 503241 503274 508179 509204 512029 514797 516590 517864 518494 518766 521367 523883 524874 527091 528776 531557 535559 536438 547366 552253 555798 555847 556181 558416 558626 559112 560669 560941 563654 567144 571751 580472 581013 583428 583566 585431 586398 590879 592038 595101 595337 597753 601423 602617 604061 620726 634190 644056 662143 704233 708810 712775 721106 727744 732771 748547 766744 769400 811666 825001 827915 ] |
||||||||||||||||||||||||||||||
|
21.99 ms (12.32%) |
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 766744 708810 395492 400684 460328 468387 478110 460689 516590 535559 524874 423480 382352 727744 811666 732771 712775 581013 521367 523883 567144 433040 433038 422732 482776 508179 583566 558416 592038 432586 514797 130105 416365 620726 512029 389690 496060 827915 531557 528776 471814 464201 721106 704233 748547 434701 555798 552253 429523 527091 559112 473461 484811 518766 454801 477084 536438 662143 555847 590879 597753 769400 421289 503241 518494 386303 410954 478488 395845 517864 452279 503274 580472 475479 497885 423350 388726 427217 483752 595337 602617 595101 644056 482775 447102 556181 563654 586398 486214 634190 446694 465040 482780 461714 396744 583428 78926 420139 448121 470412 478608 604061 433047 424523 509204 452282 143010 404568 485155 560669 468433 432662 825001 498830 547366 558626 560941 571751 601423 585431 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (2.12%) |
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 78926 130105 143010 382352 386303 388726 389690 395492 395845 396744 400684 404568 410954 416365 420139 421289 422732 423350 423480 424523 427217 429523 432586 432662 433038 433040 433047 434701 446694 447102 448121 452279 452282 454801 460328 460689 461714 464201 465040 468387 468433 470412 471814 473461 475479 477084 478110 478488 478608 482775 482776 482780 483752 484811 485155 486214 496060 497885 498830 503241 503274 508179 509204 512029 514797 516590 517864 518494 518766 521367 523883 524874 527091 528776 531557 535559 536438 547366 552253 555798 555847 556181 558416 558626 559112 560669 560941 563654 567144 571751 580472 581013 583428 583566 585431 586398 590879 592038 595101 595337 597753 601423 602617 604061 620726 634190 644056 662143 704233 708810 712775 721106 727744 732771 748547 766744 769400 811666 825001 827915 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал межрасов любительск"
]
|
||||||||||||||||||||||||||||||
|
2.23 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал межрасов любительск"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal interracial amateur"
]
|
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.