Query Metrics
7
Database Queries
7
Different statements
171.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.53 ms (85.68%) |
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 415963 415964 417490 422070 428701 429153 434319 437440 437751 443040 443946 443973 446031 447337 448519 448726 451433 453557 454998 455225 455360 455601 456240 456287 457617 457888 461454 461930 464703 465952 467405 470067 470868 475247 477114 477314 477342 478076 479128 483370 487170 487348 488282 489583 490704 492535 498357 504758 505885 506252 507582 507647 508185 508530 508786 509384 509698 510238 511411 511724 513954 514046 514383 516336 516469 517571 519694 520700 522442 524866 528921 529365 529478 540595 543906 544474 550307 553648 559430 559934 559936 560019 561067 562332 564107 565346 565914 566459 567290 568371 568835 572333 572338 572640 574407 579764 582689 588724 589597 590813 591253 592363 599550 602829 605661 606019 608620 608688 609604 610668 614077 616025 642359 644056 653526 663221 690149 696203 714380 726594 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (9.47%) |
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 608620 644056 479128 437440 437751 443946 451433 461930 470067 429153 456287 415964 422070 455360 455601 478076 505885 510238 519694 528921 483370 506252 529478 489583 507582 508530 514046 514383 522442 487170 488282 490704 492535 434319 417490 428701 455225 446031 509384 540595 516469 543906 560019 568835 574407 572338 579764 559430 559936 565346 582689 714380 653526 663221 559934 561067 562332 564107 566459 592363 606019 616025 591253 610668 642359 590813 599550 614077 726594 608688 448726 464703 454998 477314 443973 448519 470868 447337 457617 461454 467405 477114 477342 456240 465952 507647 508185 513954 520700 508786 498357 504758 511411 511724 509698 516336 415963 443040 457888 453557 517571 529365 524866 475247 487348 544474 568371 567290 553648 572333 690149 696203 550307 565914 572640 589597 605661 588724 602829 609604 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.46%) |
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 415963 415964 417490 422070 428701 429153 434319 437440 437751 443040 443946 443973 446031 447337 448519 448726 451433 453557 454998 455225 455360 455601 456240 456287 457617 457888 461454 461930 464703 465952 467405 470067 470868 475247 477114 477314 477342 478076 479128 483370 487170 487348 488282 489583 490704 492535 498357 504758 505885 506252 507582 507647 508185 508530 508786 509384 509698 510238 511411 511724 513954 514046 514383 516336 516469 517571 519694 520700 522442 524866 528921 529365 529478 540595 543906 544474 550307 553648 559430 559934 559936 560019 561067 562332 564107 565346 565914 566459 567290 568371 568835 572333 572338 572640 574407 579764 582689 588724 589597 590813 591253 592363 599550 602829 605661 606019 608620 608688 609604 610668 614077 616025 642359 644056 653526 663221 690149 696203 714380 726594 ] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"very hair"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"very hair"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"very hair"
]
|
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.