Query Metrics
7
Database Queries
7
Different statements
152.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.12 ms (85.44%) |
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 387320 387915 394685 398497 400818 406705 406976 407773 411401 415221 417011 419051 421795 423628 427251 428767 428855 429741 432731 433351 433917 440032 440441 440927 441448 441943 442629 443408 443998 445404 445464 447204 448542 448837 449225 451960 452025 452088 452415 452579 452772 453243 454110 454430 454701 455025 455935 457289 458336 458908 459259 459910 460179 460187 464018 465457 466185 466786 467957 469373 469386 470966 471073 471442 471770 473435 474194 475681 476732 477099 478993 480645 483983 484399 485242 485949 486688 486917 489301 489947 491989 493316 497213 503481 505955 506301 507884 508337 515051 517074 518325 518585 520204 521358 526571 532101 534670 544485 549850 565034 565703 574756 579213 584607 616049 622856 645837 673612 694507 707475 709612 712789 726879 734734 757228 783212 804527 810297 811110 819028 ] |
||||||||||||||||||||||||||||||
|
12.12 ms (7.96%) |
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 433917 400818 440441 442629 460187 469373 455025 457289 460179 406705 452772 520204 429741 478993 473435 518325 819028 449225 707475 757228 505955 506301 565703 712789 394685 452025 470966 486917 411401 515051 534670 441448 427251 451960 453243 419051 475681 544485 726879 432731 464018 503481 579213 734734 477099 532101 485949 454110 474194 508337 526571 455935 459910 476732 521358 616049 447204 489301 491989 497213 440032 480645 448542 454430 471442 486688 471073 458336 465457 493316 517074 387915 406976 407773 445464 673612 415221 443408 445404 428855 440927 398497 484399 574756 810297 441943 417011 423628 428767 483983 448837 452415 459259 622856 421795 466185 443998 452088 694507 709612 565034 584607 804527 811110 507884 485242 549850 433351 387320 467957 452579 518585 469386 489947 458908 466786 471770 454701 645837 783212 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.43%) |
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 387320 387915 394685 398497 400818 406705 406976 407773 411401 415221 417011 419051 421795 423628 427251 428767 428855 429741 432731 433351 433917 440032 440441 440927 441448 441943 442629 443408 443998 445404 445464 447204 448542 448837 449225 451960 452025 452088 452415 452579 452772 453243 454110 454430 454701 455025 455935 457289 458336 458908 459259 459910 460179 460187 464018 465457 466185 466786 467957 469373 469386 470966 471073 471442 471770 473435 474194 475681 476732 477099 478993 480645 483983 484399 485242 485949 486688 486917 489301 489947 491989 493316 497213 503481 505955 506301 507884 508337 515051 517074 518325 518585 520204 521358 526571 532101 534670 544485 549850 565034 565703 574756 579213 584607 616049 622856 645837 673612 694507 707475 709612 712789 726879 734734 757228 783212 804527 810297 811110 819028 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ðÂðÁð¢Ðëð©ð¢Ðï ð│ð¥ð╗ÐïðÁ Ðü Ðçð╗ðÁð¢ð¥ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"женщин голые член"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.