Query Metrics
7
Database Queries
7
Different statements
185.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.99 ms (82.87%) |
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 24724 30533 79962 213692 385745 388630 389211 391493 396567 398812 399209 399717 408284 412095 421569 422184 424457 424923 426466 431422 433699 439745 442501 444073 444249 445408 446800 448749 449717 451988 452170 453374 453469 453473 453776 454961 457438 457444 459988 460100 460309 461424 465248 465844 466046 467316 468049 468825 469453 470335 470375 470492 471459 471897 473020 473923 474091 475724 475927 477727 480012 483036 483223 485790 486332 490172 491407 496674 497264 497917 498425 501548 506081 508673 512320 512538 515454 516748 517237 519676 520248 522441 524637 537257 538270 546794 551313 554518 556808 559132 561998 566272 566566 567139 568589 573759 578219 584634 591056 591235 594490 596627 597975 598785 599290 601327 601891 602672 605359 605996 610303 611892 617056 617117 624131 628426 654315 657004 679076 689013 ] |
||||||||||||||||||||||||||||||
|
20.74 ms (11.16%) |
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 453473 385745 454961 468049 516748 524637 424923 452170 461424 459988 471459 466046 519676 490172 496674 485790 498425 475724 439745 522441 474091 473020 389211 426466 457444 424457 444073 422184 442501 453469 477727 470335 517237 491407 470375 475927 520248 497264 512320 399209 421569 449717 457438 506081 431422 465844 515454 408284 445408 657004 605359 537257 546794 584634 601891 486332 568589 473923 602672 467316 399717 654315 79962 512538 554518 601327 551313 594490 617117 559132 566566 611892 213692 444249 391493 465248 468825 598785 599290 497917 398812 573759 469453 567139 679076 556808 610303 617056 591056 388630 597975 596627 561998 566272 578219 412095 483036 24724 453374 460309 448749 480012 460100 470492 433699 446800 471897 396567 451988 453776 689013 30533 483223 591235 624131 628426 501548 605996 538270 508673 ] |
||||||||||||||||||||||||||||||
|
3.99 ms (2.15%) |
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 24724 30533 79962 213692 385745 388630 389211 391493 396567 398812 399209 399717 408284 412095 421569 422184 424457 424923 426466 431422 433699 439745 442501 444073 444249 445408 446800 448749 449717 451988 452170 453374 453469 453473 453776 454961 457438 457444 459988 460100 460309 461424 465248 465844 466046 467316 468049 468825 469453 470335 470375 470492 471459 471897 473020 473923 474091 475724 475927 477727 480012 483036 483223 485790 486332 490172 491407 496674 497264 497917 498425 501548 506081 508673 512320 512538 515454 516748 517237 519676 520248 522441 524637 537257 538270 546794 551313 554518 556808 559132 561998 566272 566566 567139 568589 573759 578219 584634 591056 591235 594490 596627 597975 598785 599290 601327 601891 602672 605359 605996 610303 611892 617056 617117 624131 628426 654315 657004 679076 689013 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хуй за щеку"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член щек"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член щек"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.80%) |
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.