Query Metrics
7
Database Queries
7
Different statements
194.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.97 ms (87.01%) |
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 187349 383823 411187 411321 411725 419531 422243 422347 423984 424418 424457 424471 424474 426691 427088 428890 429574 429863 429892 432404 438013 443839 451469 453109 454135 454247 454248 454259 455302 456030 458281 459476 462105 464944 466120 466170 466244 466995 467835 468836 470047 470504 470768 471113 472673 473400 474251 476282 476339 476619 476628 477715 477722 477930 479254 483382 484362 484375 484423 485741 486333 489187 489301 490394 491986 493082 496028 499551 501028 503376 503400 504174 506454 508736 509435 511086 513333 516270 518862 519139 520867 525468 526714 527953 528563 529512 532813 539512 544489 546483 552460 555055 555969 556565 556609 558276 560453 561283 563001 563125 563143 563673 567383 574086 592985 597477 599354 620090 628649 659385 664241 671219 678716 731034 742404 746126 760859 792580 796804 796831 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (8.38%) |
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 476628 411321 424457 443839 464944 466120 473400 423984 429574 438013 453109 476339 426691 470047 454248 468836 503400 509435 511086 526714 496028 484375 503376 491986 513333 516270 527953 470504 462105 490394 520867 539512 501028 528563 476282 558276 563001 563125 567383 574086 546483 555055 555969 556565 544489 560453 563673 659385 664241 678716 671219 552460 556609 561283 563143 592985 597477 599354 620090 628649 792580 796831 731034 742404 796804 760859 746126 187349 383823 411187 422243 424471 424474 427088 428890 432404 470768 472673 477722 477930 424418 454135 454247 454259 456030 466170 466995 411725 451469 458281 467835 471113 474251 476619 419531 422347 429863 466244 477715 479254 429892 455302 459476 529512 483382 486333 489301 499551 504174 506454 518862 525468 532813 484362 484423 489187 493082 508736 519139 485741 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.33%) |
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 187349 383823 411187 411321 411725 419531 422243 422347 423984 424418 424457 424471 424474 426691 427088 428890 429574 429863 429892 432404 438013 443839 451469 453109 454135 454247 454248 454259 455302 456030 458281 459476 462105 464944 466120 466170 466244 466995 467835 468836 470047 470504 470768 471113 472673 473400 474251 476282 476339 476619 476628 477715 477722 477930 479254 483382 484362 484375 484423 485741 486333 489187 489301 490394 491986 493082 496028 499551 501028 503376 503400 504174 506454 508736 509435 511086 513333 516270 518862 519139 520867 525468 526714 527953 528563 529512 532813 539512 544489 546483 552460 555055 555969 556565 556609 558276 560453 561283 563001 563125 563143 563673 567383 574086 592985 597477 599354 620090 628649 659385 664241 671219 678716 731034 742404 746126 760859 792580 796804 796831 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy chubby russian"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy chubby русск"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy chubby русск"
]
|
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.