Query Metrics
7
Database Queries
7
Different statements
153.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.34 ms (82.75%) |
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 392538 392563 398940 402546 404280 408313 415235 416094 418867 419134 420502 421877 424781 434225 435941 440755 442966 443306 443348 444183 446302 448622 448942 450309 451104 452557 453036 453576 454959 455386 456212 456314 457339 457874 460410 461136 461406 463987 465467 466248 466295 467183 468969 470050 470614 470834 471067 472409 473515 474833 474903 475076 475680 476267 476739 477607 477995 478377 478381 483127 483677 484527 484751 485952 486173 486838 487519 489075 490522 492931 494451 495607 495794 497025 498321 498416 498447 499472 501549 502611 503104 503291 504899 504951 505779 506057 506430 507829 509057 510334 510672 512755 513334 513997 514596 516487 516777 517397 517962 518046 518244 518579 519279 519594 519832 520645 520649 521037 521107 522844 522978 524591 525541 526071 526473 526865 527058 527914 529294 529739 ] |
||||||||||||||||||||||||||||||
|
16.51 ms (10.73%) |
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 415235 456314 470050 474833 475076 475680 418867 421877 434225 443306 443348 448942 450309 452557 453036 457339 463987 465467 466248 468969 470834 477607 398940 442966 466295 471067 472409 476739 392563 404280 440755 444183 454959 456212 457874 461406 467183 470614 476267 477995 478377 478381 416094 424781 446302 448622 451104 453576 455386 460410 461136 473515 474903 506057 510334 513997 516487 519279 519832 522844 526473 484751 486838 489075 494451 498321 501549 502611 504899 509057 517962 518046 518579 521107 522978 524591 525541 526865 527914 529294 529739 483127 483677 484527 486173 490522 492931 495794 498416 498447 499472 503104 506430 510672 516777 519594 521037 526071 527058 485952 487519 495607 497025 503291 504951 505779 507829 512755 513334 514596 517397 518244 520645 520649 392538 402546 435941 408313 419134 420502 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.00%) |
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 392538 392563 398940 402546 404280 408313 415235 416094 418867 419134 420502 421877 424781 434225 435941 440755 442966 443306 443348 444183 446302 448622 448942 450309 451104 452557 453036 453576 454959 455386 456212 456314 457339 457874 460410 461136 461406 463987 465467 466248 466295 467183 468969 470050 470614 470834 471067 472409 473515 474833 474903 475076 475680 476267 476739 477607 477995 478377 478381 483127 483677 484527 484751 485952 486173 486838 487519 489075 490522 492931 494451 495607 495794 497025 498321 498416 498447 499472 501549 502611 503104 503291 504899 504951 505779 506057 506430 507829 509057 510334 510672 512755 513334 513997 514596 516487 516777 517397 517962 518046 518244 518579 519279 519594 519832 520645 520649 521037 521107 522844 522978 524591 525541 526071 526473 526865 527058 527914 529294 529739 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"форм"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"формы"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.06%) |
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.