Query Metrics
7
Database Queries
7
Different statements
157.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.28 ms (83.35%) |
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 444041 445327 452916 453323 466101 466729 474878 478572 480062 484801 486864 489712 490047 492533 494174 501244 502887 503029 503381 503730 503754 504919 508133 510397 511780 516407 517047 518168 518188 518282 518745 519605 520151 520205 522110 523451 523768 524455 525277 527387 529430 537517 538251 541316 543615 544281 545829 545851 546419 547027 548233 548646 549680 551034 551817 555435 557154 558768 560439 560512 560746 560797 565167 565737 565785 567363 569223 569274 572760 575387 578494 579816 580134 581620 581662 582100 583170 583989 584857 585332 588209 589290 589773 590362 591079 591109 591171 592651 592713 592959 593641 597587 598567 598906 599531 600843 605162 605984 608279 609540 610712 614553 614691 619082 619398 620739 621305 624484 626576 631424 632551 650056 666472 676117 680953 687318 690916 724954 751111 813271 ] |
||||||||||||||||||||||||||||||
|
16.26 ms (10.33%) |
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 518745 581662 551817 444041 548646 551034 593641 590362 631424 523451 490047 517047 546419 565785 549680 588209 591171 445327 555435 813271 584857 592651 560512 609540 565167 537517 598906 527387 608279 511780 597587 624484 520151 600843 503754 599531 502887 453323 560746 632551 687318 751111 501244 516407 572760 541316 592713 610712 582100 484801 508133 589773 529430 518188 560797 626576 518168 510397 545851 614691 523768 557154 666472 504919 591109 614553 621305 522110 569223 578494 605162 579816 560439 676117 585332 474878 494174 518282 567363 605984 592959 478572 548233 619082 545829 544281 452916 583170 547027 724954 538251 650056 620739 581620 598567 466101 690916 589290 591079 583989 466729 503730 519605 524455 492533 558768 580134 565737 480062 503381 489712 575387 619398 525277 543615 503029 520205 486864 680953 569274 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.94%) |
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 444041 445327 452916 453323 466101 466729 474878 478572 480062 484801 486864 489712 490047 492533 494174 501244 502887 503029 503381 503730 503754 504919 508133 510397 511780 516407 517047 518168 518188 518282 518745 519605 520151 520205 522110 523451 523768 524455 525277 527387 529430 537517 538251 541316 543615 544281 545829 545851 546419 547027 548233 548646 549680 551034 551817 555435 557154 558768 560439 560512 560746 560797 565167 565737 565785 567363 569223 569274 572760 575387 578494 579816 580134 581620 581662 582100 583170 583989 584857 585332 588209 589290 589773 590362 591079 591109 591171 592651 592713 592959 593641 597587 598567 598906 599531 600843 605162 605984 608279 609540 610712 614553 614691 619082 619398 620739 621305 624484 626576 631424 632551 650056 666472 676117 680953 687318 690916 724954 751111 813271 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"миньет и много спермы…"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс мног сперм"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.93%) |
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.