Query Metrics
7
Database Queries
7
Different statements
221.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.77 ms (90.39%) |
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 89021 247330 386630 390288 394552 395998 401214 406896 411920 413223 414736 420375 422345 434239 440771 443793 444255 445089 454055 454089 454164 456842 459421 463319 464484 464556 465822 466244 466893 467960 471895 472864 473488 475051 477574 477794 481317 486798 489995 491639 492633 493220 495253 505739 506411 507798 509320 511117 512993 515347 525266 525496 533991 537483 546763 549670 551949 555987 558724 562444 563021 563450 565261 565649 567344 576676 580862 582404 583572 583573 589587 590928 591376 602018 629849 631683 681539 693072 696316 697182 698158 707361 716794 721748 728119 728352 730163 730315 742560 742566 744179 746604 754158 756321 756878 758225 759759 761234 761469 766669 768406 778055 780687 781758 783977 784240 788073 788544 788559 791548 792678 794442 796272 801090 802312 803746 808049 808434 820586 822121 ] |
||||||||||||||||||||||||||||||
|
11.29 ms (5.11%) |
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 505739 466244 390288 802312 820586 792678 801090 759759 780687 386630 565649 788559 440771 401214 454089 489995 549670 525496 533991 562444 591376 794442 758225 563450 707361 466893 791548 247330 507798 681539 454055 475051 420375 602018 563021 509320 515347 822121 766669 756878 486798 472864 493220 693072 567344 590928 756321 716794 422345 506411 444255 511117 580862 803746 565261 576676 464484 698158 781758 728119 761234 414736 471895 411920 464556 459421 788073 783977 465822 477794 454164 808049 697182 395998 406896 583573 754158 742566 730315 721748 456842 491639 492633 582404 546763 434239 445089 551949 796272 537483 696316 761469 467960 555987 631683 394552 589587 730163 742560 768406 746604 558724 784240 808434 744179 89021 728352 477574 495253 525266 512993 583572 629849 443793 463319 413223 778055 788544 481317 473488 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.11%) |
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 89021 247330 386630 390288 394552 395998 401214 406896 411920 413223 414736 420375 422345 434239 440771 443793 444255 445089 454055 454089 454164 456842 459421 463319 464484 464556 465822 466244 466893 467960 471895 472864 473488 475051 477574 477794 481317 486798 489995 491639 492633 493220 495253 505739 506411 507798 509320 511117 512993 515347 525266 525496 533991 537483 546763 549670 551949 555987 558724 562444 563021 563450 565261 565649 567344 576676 580862 582404 583572 583573 589587 590928 591376 602018 629849 631683 681539 693072 696316 697182 698158 707361 716794 721748 728119 728352 730163 730315 742560 742566 744179 746604 754158 756321 756878 758225 759759 761234 761469 766669 768406 778055 780687 781758 783977 784240 788073 788544 788559 791548 792678 794442 796272 801090 802312 803746 808049 808434 820586 822121 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женщины кончают сиськ…"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин сперм сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.71%) |
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.