Query Metrics
7
Database Queries
7
Different statements
143.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.16 ms (81.88%) |
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 3512 3599 58636 146006 146078 187928 386218 387415 388913 389697 395513 395660 396041 397930 402876 407384 409371 409934 411604 411720 411738 412976 419147 419524 424421 443278 450782 452925 452968 454890 457459 457631 458842 460003 460659 466893 468835 469113 469489 470215 474104 474478 474862 475904 476224 480478 483333 484358 484379 490404 491118 495038 498456 500412 502868 503952 507844 508698 510844 518901 535324 537558 541626 548065 557340 558700 563088 563939 570891 571133 578162 587184 589619 590260 591044 599218 601840 604488 605340 620159 620172 629528 640677 664857 703097 708774 714386 714414 715473 716331 720275 726572 726588 728119 728254 728290 729124 730822 733073 733319 740117 741611 741764 744191 744806 746673 747071 770120 771164 775436 777361 778527 783777 789204 796458 797236 797266 802651 808500 808506 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (10.98%) |
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 703097 714386 664857 708774 716331 640677 590260 599218 601840 604488 605340 620159 620172 740117 726588 726572 728254 771164 741611 714414 715473 775436 777361 783777 802651 808500 808506 397930 411720 469113 187928 452925 457631 500412 541626 733073 744191 396041 146006 58636 3512 3599 389697 407384 535324 563088 720275 548065 570891 629528 591044 797236 778527 744806 789204 796458 797266 730822 728119 728290 729124 746673 770120 747071 387415 587184 503952 507844 491118 537558 469489 495038 386218 395513 388913 402876 411604 412976 419147 411738 409934 452968 474862 476224 480478 450782 458842 460003 510844 558700 563939 571133 578162 557340 589619 733319 741764 409371 460659 474104 474478 483333 498456 484358 502868 508698 484379 518901 419524 424421 454890 457459 443278 470215 475904 490404 468835 466893 146078 395660 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.92%) |
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 3512 3599 58636 146006 146078 187928 386218 387415 388913 389697 395513 395660 396041 397930 402876 407384 409371 409934 411604 411720 411738 412976 419147 419524 424421 443278 450782 452925 452968 454890 457459 457631 458842 460003 460659 466893 468835 469113 469489 470215 474104 474478 474862 475904 476224 480478 483333 484358 484379 490404 491118 495038 498456 500412 502868 503952 507844 508698 510844 518901 535324 537558 541626 548065 557340 558700 563088 563939 570891 571133 578162 587184 589619 590260 591044 599218 601840 604488 605340 620159 620172 629528 640677 664857 703097 708774 714386 714414 715473 716331 720275 726572 726588 728119 728254 728290 729124 730822 733073 733319 740117 741611 741764 744191 744806 746673 747071 770120 771164 775436 777361 778527 783777 789204 796458 797236 797266 802651 808500 808506 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural mature woman"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.07%) |
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.