Query Metrics
7
Database Queries
7
Different statements
163.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.89 ms (85.11%) |
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 220769 519251 538948 539610 540668 542464 542489 542960 543467 544288 544297 547912 547980 549302 549780 556796 557372 558715 560078 560084 562595 562857 563433 566394 567395 567988 567993 568011 568186 571206 572173 572545 576671 576711 581389 585089 589739 590555 592419 592514 604977 604985 615737 617800 617807 622316 622354 622692 622845 624157 625755 629265 644261 645260 645838 647308 648211 649536 651151 652856 652971 654130 660605 661900 668562 670052 670062 670765 671725 671856 671878 672105 672723 673497 674119 677714 678433 681159 690834 690865 690885 691499 691518 692023 692103 692360 693051 693486 694023 694052 694207 694441 694455 694485 694559 694565 695247 695941 697774 697971 700275 703109 703534 703833 704534 705541 714504 716570 717947 719059 722212 728885 734375 734556 736768 740124 741959 742137 790393 819508 ] |
||||||||||||||||||||||||||||||
|
13.54 ms (8.29%) |
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 539610 557372 544297 562595 648211 668562 694052 694455 716570 670052 672723 690834 693486 694023 694565 695941 645838 652856 652971 672105 692360 556796 563433 571206 622354 625755 622692 590555 592419 622845 615737 703109 714504 819508 542489 547980 566394 670765 697971 674119 681159 694485 644261 589739 604985 629265 790393 734375 740124 519251 544288 703833 585089 560078 549302 549780 678433 692103 693051 695247 719059 660605 671725 651151 690865 690885 694441 703534 717947 562857 568011 728885 741959 704534 542960 576711 220769 540668 567395 568186 543467 649536 654130 661900 677714 691518 700275 722212 691499 645260 647308 670062 671856 671878 673497 692023 694207 694559 567993 622316 624157 742137 736768 734556 604977 617800 617807 697774 705541 592514 538948 558715 572545 581389 542464 547912 567988 572173 560084 576671 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.99%) |
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 220769 519251 538948 539610 540668 542464 542489 542960 543467 544288 544297 547912 547980 549302 549780 556796 557372 558715 560078 560084 562595 562857 563433 566394 567395 567988 567993 568011 568186 571206 572173 572545 576671 576711 581389 585089 589739 590555 592419 592514 604977 604985 615737 617800 617807 622316 622354 622692 622845 624157 625755 629265 644261 645260 645838 647308 648211 649536 651151 652856 652971 654130 660605 661900 668562 670052 670062 670765 671725 671856 671878 672105 672723 673497 674119 677714 678433 681159 690834 690865 690885 691499 691518 692023 692103 692360 693051 693486 694023 694052 694207 694441 694455 694485 694559 694565 695247 695941 697774 697971 700275 703109 703534 703833 704534 705541 714504 716570 717947 719059 722212 728885 734375 734556 736768 740124 741959 742137 790393 819508 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro sex"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.05%) |
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.