Query Metrics
7
Database Queries
7
Different statements
190.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.06 ms (84.48%) |
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 185834 386099 404658 405221 409226 409404 410807 413111 413117 417384 417927 422347 425612 431026 432878 440689 443509 447202 448745 449743 451483 451850 451967 452030 452554 453102 453189 454056 454675 454750 455935 456396 456653 460629 461183 462425 465787 465970 466017 469405 470841 471166 471170 472858 473470 475263 475977 477116 477598 478155 479090 480363 485082 486883 488220 490948 491943 492000 495026 496995 498188 499862 499987 501144 503291 504142 505631 505775 506845 507224 510778 511325 516430 516544 516886 518208 519024 520049 521315 522933 525483 525823 526201 528203 532027 534990 537130 546943 550354 550839 555040 558276 560206 566226 570742 572533 574678 579695 584403 590267 603327 603429 615738 616940 619975 637746 646300 651635 671713 677815 678960 681276 681614 689074 695171 728966 737726 806323 810466 815897 ] |
||||||||||||||||||||||||||||||
|
17.75 ms (9.31%) |
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 477116 472858 413111 466017 431026 440689 185834 443509 413117 815897 451967 452030 453189 454750 516430 525483 495026 522933 506845 534990 505631 532027 462425 465787 480363 550839 646300 678960 651635 671713 677815 619975 603327 616940 810466 728966 386099 452554 473470 447202 456653 465970 479090 518208 490948 520049 496995 503291 510778 448745 417384 492000 590267 432878 409404 555040 505775 521315 501144 405221 498188 456396 526201 485082 584403 453102 451483 422347 525823 451850 519024 560206 615738 504142 471166 574678 695171 410807 507224 417927 558276 550354 546943 566226 572533 737726 806323 516544 491943 499987 528203 449743 478155 488220 425612 475263 409226 454675 469405 471170 404658 454056 477598 516886 455935 460629 475977 470841 511325 499862 537130 461183 486883 570742 681276 681614 689074 579695 637746 603429 ] |
||||||||||||||||||||||||||||||
|
4.13 ms (2.17%) |
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 185834 386099 404658 405221 409226 409404 410807 413111 413117 417384 417927 422347 425612 431026 432878 440689 443509 447202 448745 449743 451483 451850 451967 452030 452554 453102 453189 454056 454675 454750 455935 456396 456653 460629 461183 462425 465787 465970 466017 469405 470841 471166 471170 472858 473470 475263 475977 477116 477598 478155 479090 480363 485082 486883 488220 490948 491943 492000 495026 496995 498188 499862 499987 501144 503291 504142 505631 505775 506845 507224 510778 511325 516430 516544 516886 518208 519024 520049 521315 522933 525483 525823 526201 528203 532027 534990 537130 546943 550354 550839 555040 558276 560206 566226 570742 572533 574678 579695 584403 590267 603327 603429 615738 616940 619975 637746 646300 651635 671713 677815 678960 681276 681614 689074 695171 728966 737726 806323 810466 815897 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy panties"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy трусик нижн бел"
]
|
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.