Query Metrics
7
Database Queries
7
Different statements
194.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.03 ms (83.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 341596 396349 410934 420427 424060 426416 426459 428397 431262 434055 444238 450239 451974 452136 453841 456451 457781 460733 462321 463175 465336 465394 466316 466994 468044 468630 468717 470028 470622 474643 475630 478557 480290 482313 483549 484706 485270 485313 486569 494567 495022 496934 499112 499324 502283 502538 502890 504456 505814 508725 508860 511345 512927 513607 514435 514717 514980 516397 516874 517033 518090 519198 520005 520354 520697 522013 524943 525511 526052 527608 528041 530808 531540 541650 542747 545642 549225 550434 553190 556047 560497 562029 562531 562832 562879 563441 564203 567281 567748 572711 576726 578397 581809 584708 590579 590628 591959 597240 603002 603255 604298 604478 605117 609958 612434 612792 614273 617212 621317 621764 623716 625239 626892 641127 643316 659347 666405 666438 670951 673589 ] |
||||||||||||||||||||||||||||||
|
22.05 ms (11.35%) |
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 470028 428397 508860 482313 513607 468630 673589 560497 511345 420427 520005 483549 450239 556047 463175 434055 581809 410934 623716 341596 466994 562832 670951 452136 591959 465394 495022 486569 431262 621317 572711 502283 396349 499324 518090 562029 545642 468717 444238 466316 524943 457781 485270 496934 426416 453841 505814 530808 621764 626892 641127 474643 480290 462321 528041 502890 605117 604298 549225 502538 584708 520354 460733 504456 484706 517033 512927 465336 562531 590628 516397 542747 567748 478557 470622 456451 666438 666405 508725 550434 609958 578397 485313 541650 526052 527608 576726 494567 516874 531540 590579 426459 562879 514980 520697 614273 643316 617212 659347 553190 563441 625239 451974 567281 603002 468044 424060 514435 514717 612434 522013 604478 603255 525511 519198 499112 564203 475630 597240 612792 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.31%) |
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 341596 396349 410934 420427 424060 426416 426459 428397 431262 434055 444238 450239 451974 452136 453841 456451 457781 460733 462321 463175 465336 465394 466316 466994 468044 468630 468717 470028 470622 474643 475630 478557 480290 482313 483549 484706 485270 485313 486569 494567 495022 496934 499112 499324 502283 502538 502890 504456 505814 508725 508860 511345 512927 513607 514435 514717 514980 516397 516874 517033 518090 519198 520005 520354 520697 522013 524943 525511 526052 527608 528041 530808 531540 541650 542747 545642 549225 550434 553190 556047 560497 562029 562531 562832 562879 563441 564203 567281 567748 572711 576726 578397 581809 584708 590579 590628 591959 597240 603002 603255 604298 604478 605117 609958 612434 612792 614273 617212 621317 621764 623716 625239 626892 641127 643316 659347 666405 666438 670951 673589 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женщина с двумя пиздами"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин двум вагин"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.71%) |
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.