Query Metrics
7
Database Queries
7
Different statements
156.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.23 ms (82.58%) |
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 41433 182435 182754 272725 357457 383701 387293 394648 404172 413404 414676 418827 428773 429518 437708 437791 443244 444540 456127 456699 457812 457815 459388 469078 470073 472394 475417 476050 476672 477503 478028 480211 485280 486243 495211 513221 515253 515259 515272 520763 522156 533841 545677 554907 555236 555771 559749 560913 568479 569725 570911 579206 580397 588236 590713 606127 618592 620957 633463 634180 662856 667254 670956 671531 702336 702341 702342 702357 704425 708570 713143 714438 720593 730073 730102 731758 731762 731794 734844 734852 734868 738482 738486 738499 739174 740310 741157 743745 746116 749593 751486 752292 752532 752550 755936 760471 762561 766294 770258 772077 773308 774811 782823 782942 784641 788646 790442 790479 791895 796266 796687 803611 806444 806543 806650 806687 806965 808644 808994 811329 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (10.60%) |
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 730073 738486 522156 41433 414676 478028 559749 560913 702341 708570 569725 618592 774811 790442 751486 782823 731758 752292 752532 749593 713143 383701 387293 182754 480211 485280 469078 568479 580397 702336 714438 671531 667254 588236 620957 606127 782942 788646 811329 803611 806965 772077 784641 791895 731762 739174 740310 755936 730102 734852 738499 702342 702357 720593 796266 459388 443244 456699 475417 182435 515253 704425 633463 634180 806543 808644 796687 806650 806687 808994 734844 743745 752550 770258 773308 731794 272725 394648 418827 746116 476672 476050 545677 570911 437708 437791 520763 357457 413404 457815 486243 533841 495211 515259 555236 579206 554907 555771 662856 790479 762561 806444 734868 738482 760471 741157 766294 477503 429518 444540 457812 456127 470073 472394 513221 670956 590713 404172 428773 515272 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.20%) |
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 41433 182435 182754 272725 357457 383701 387293 394648 404172 413404 414676 418827 428773 429518 437708 437791 443244 444540 456127 456699 457812 457815 459388 469078 470073 472394 475417 476050 476672 477503 478028 480211 485280 486243 495211 513221 515253 515259 515272 520763 522156 533841 545677 554907 555236 555771 559749 560913 568479 569725 570911 579206 580397 588236 590713 606127 618592 620957 633463 634180 662856 667254 670956 671531 702336 702341 702342 702357 704425 708570 713143 714438 720593 730073 730102 731758 731762 731794 734844 734852 734868 738482 738486 738499 739174 740310 741157 743745 746116 749593 751486 752292 752532 752550 755936 760471 762561 766294 770258 772077 773308 774811 782823 782942 784641 788646 790442 790479 791895 796266 796687 803611 806444 806543 806650 806687 806965 808644 808994 811329 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation machine"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац machine"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац machine"
]
|
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.