Query Metrics
7
Database Queries
7
Different statements
146.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.77 ms (82.91%) |
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 416989 429805 435959 439733 439854 443040 444586 446657 452174 456240 456452 457963 461454 467553 471612 475247 476223 477342 487348 488811 491751 491858 492273 493356 495198 498357 504758 504759 507647 508185 508786 509204 509698 511009 511724 513539 515565 517571 517928 518153 518586 519239 519325 519331 520346 520700 522125 522238 523139 524301 524866 527292 527341 528146 529229 533426 540723 544474 553269 553648 556017 558244 562399 565914 567290 568371 570708 572333 572344 572640 573920 588724 589086 589597 593154 593975 595178 597170 597240 598199 599199 601387 602829 603047 605661 606799 608203 608553 610661 614058 615826 625172 628811 630536 632632 648560 654466 660964 661578 663992 679004 690149 696203 697000 698124 726508 745312 793384 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (10.61%) |
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 461454 477342 456240 507647 508185 520700 508786 498357 504758 511724 509698 415963 443040 517571 524866 475247 487348 544474 568371 567290 553648 572333 690149 696203 565914 572640 589597 605661 588724 602829 793384 726508 745312 601387 697000 435959 439733 456452 444586 452174 439854 446657 457963 509204 515565 493356 519239 527341 519325 519331 491751 524301 504759 492273 528146 517928 518153 529229 562399 661578 663992 556017 610661 614058 615826 540723 522125 429805 471612 495198 558244 570708 679004 654466 660964 628811 599199 593975 595178 476223 522238 416989 553269 648560 589086 593154 597170 527292 488811 513539 533426 573920 698124 603047 625172 598199 608203 608553 467553 491858 520346 518586 630536 632632 606799 511009 523139 572344 597240 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (2.17%) |
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 416989 429805 435959 439733 439854 443040 444586 446657 452174 456240 456452 457963 461454 467553 471612 475247 476223 477342 487348 488811 491751 491858 492273 493356 495198 498357 504758 504759 507647 508185 508786 509204 509698 511009 511724 513539 515565 517571 517928 518153 518586 519239 519325 519331 520346 520700 522125 522238 523139 524301 524866 527292 527341 528146 529229 533426 540723 544474 553269 553648 556017 558244 562399 565914 567290 568371 570708 572333 572344 572640 573920 588724 589086 589597 593154 593975 595178 597170 597240 598199 599199 601387 602829 603047 605661 606799 608203 608553 610661 614058 615826 625172 628811 630536 632632 648560 654466 660964 661578 663992 679004 690149 696203 697000 698124 726508 745312 793384 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"very long hair"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"very длинные hair"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"very длинные hair"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.97%) |
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.