Query Metrics
7
Database Queries
7
Different statements
151.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.69 ms (83.55%) |
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 181804 382020 382413 382450 382812 384880 388819 390734 391576 393770 395620 396395 396740 398209 400166 401602 403006 406086 406179 409100 413280 416178 417979 422299 423884 424255 424946 426796 427100 427174 427467 428051 428450 429541 432886 434849 439326 443472 445440 446026 446560 447077 448553 449484 453322 461944 462392 462699 462708 463545 464699 465441 471969 472683 474613 478510 478990 480680 481083 481354 481484 483952 486105 486277 486705 489098 490129 490592 495040 495194 496454 497210 503887 507241 509079 509430 510051 512189 513537 513971 515767 518291 520123 521194 521342 522905 523138 523862 524124 524723 525587 525693 525884 527180 528144 528161 529376 533461 541767 548789 555056 556004 556850 558261 558465 560385 572260 574595 578010 584705 588318 590721 594088 598050 600458 602562 605117 613275 619884 625001 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (10.60%) |
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 510051 625001 427174 396740 594088 572260 462392 474613 598050 448553 462699 480680 541767 521342 525587 388819 481484 496454 574595 478990 181804 427100 490592 384880 428051 453322 495194 382450 413280 426796 393770 416178 462708 524124 486705 513537 495040 528144 588318 445440 584705 391576 401602 403006 406086 409100 422299 423884 471969 509079 528161 578010 396395 398209 429541 449484 434849 461944 486105 497210 529376 522905 382020 513971 472683 548789 555056 556004 556850 390734 481083 465441 503887 524723 382812 417979 446560 483952 428450 424255 478510 486277 512189 558261 558465 382413 509430 515767 520123 490129 590721 602562 406179 527180 464699 463545 521194 424946 427467 432886 443472 489098 518291 523138 525884 600458 400166 439326 613275 447077 446026 605117 395620 560385 481354 533461 507241 523862 525693 619884 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.47%) |
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 181804 382020 382413 382450 382812 384880 388819 390734 391576 393770 395620 396395 396740 398209 400166 401602 403006 406086 406179 409100 413280 416178 417979 422299 423884 424255 424946 426796 427100 427174 427467 428051 428450 429541 432886 434849 439326 443472 445440 446026 446560 447077 448553 449484 453322 461944 462392 462699 462708 463545 464699 465441 471969 472683 474613 478510 478990 480680 481083 481354 481484 483952 486105 486277 486705 489098 490129 490592 495040 495194 496454 497210 503887 507241 509079 509430 510051 512189 513537 513971 515767 518291 520123 521194 521342 522905 523138 523862 524124 524723 525587 525693 525884 527180 528144 528161 529376 533461 541767 548789 555056 556004 556850 558261 558465 560385 572260 574595 578010 584705 588318 590721 594088 598050 600458 602562 605117 613275 619884 625001 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ласкают киску"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ласка вагин"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.97%) |
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.