Query Metrics
7
Database Queries
7
Different statements
180.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.16 ms (86.90%) |
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 396266 408558 415197 418648 421630 423780 425340 425776 426176 426663 428315 436687 446359 448100 448148 449120 449299 450013 450870 451333 451383 452444 453935 455373 455936 463634 465999 468703 479197 486005 487862 493453 493493 495126 499180 500538 501203 504810 507184 508397 508563 509709 511505 512192 516402 516511 519502 521984 523066 523279 524248 533065 533968 534771 542053 542512 550608 553085 555797 555847 560969 563464 563757 564010 566962 568357 568541 569033 570691 572176 572211 573411 576959 577641 579811 580196 581242 582944 583444 583614 583984 584442 584915 586066 586533 587176 587453 587883 587899 588306 591452 591550 591795 594106 594151 594380 598760 599339 600510 602016 604301 608765 612804 619012 622400 636264 643660 648814 654338 654352 656575 666008 666534 686942 702634 727082 769400 771918 810665 814069 ] |
||||||||||||||||||||||||||||||
|
13.08 ms (7.23%) |
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 418648 446359 421630 426176 455373 423780 448148 453935 463634 479197 436687 450870 451333 451383 465999 508397 493453 508563 519502 521984 523066 524248 507184 511505 533968 428315 448100 654352 598760 396266 425776 408558 415197 425340 814069 487862 449120 450013 452444 449299 455936 468703 493493 495126 499180 500538 512192 523279 504810 516402 516511 533065 534771 501203 509709 486005 560969 563757 572211 576959 577641 583444 542053 550608 568357 572176 579811 583614 583984 542512 553085 555797 564010 566962 568541 570691 580196 582944 584915 648814 666008 656575 666534 686942 654338 702634 555847 563464 569033 573411 581242 584442 586533 594106 602016 622400 586066 587176 587899 591795 619012 591452 594380 599339 600510 587453 587883 588306 591550 594151 604301 608765 643660 810665 769400 727082 771918 612804 636264 426663 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.89%) |
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 396266 408558 415197 418648 421630 423780 425340 425776 426176 426663 428315 436687 446359 448100 448148 449120 449299 450013 450870 451333 451383 452444 453935 455373 455936 463634 465999 468703 479197 486005 487862 493453 493493 495126 499180 500538 501203 504810 507184 508397 508563 509709 511505 512192 516402 516511 519502 521984 523066 523279 524248 533065 533968 534771 542053 542512 550608 553085 555797 555847 560969 563464 563757 564010 566962 568357 568541 569033 570691 572176 572211 573411 576959 577641 579811 580196 581242 582944 583444 583614 583984 584442 584915 586066 586533 587176 587453 587883 587899 588306 591452 591550 591795 594106 594151 594380 598760 599339 600510 602016 604301 608765 612804 619012 622400 636264 643660 648814 654338 654352 656575 666008 666534 686942 702634 727082 769400 771918 810665 814069 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny girl creampie"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая creampie"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худая creampie"
]
|
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.