Advertisement
Guest User

Untitled

a guest
Apr 21st, 2022
23
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.28 KB | None | 0 0
  1. Url: "/?s=&post_type=product&wpsolr_sort=sort_by_relevancy_desc&wpsolr_fq[0]=product_cat_str%3AFashion&wpsolr_fq[1]=product_cat_str%3AWomen&wpsolr_fq[2]=product_cat_str%3AWomen%20Bags&wpsolr_fq[3]=product_cat_str%3ATotes"
  2. Index: "new_index"
  3. Nb results shown: 20
  4. Total nb results: 66
  5. Speed: 398 ms
  6. Query: {
  7. "from": 0,
  8. "size": 20,
  9. "_source": [
  10. "id",
  11. "PID",
  12. "type",
  13. "meta_type_s",
  14. "title",
  15. "numcomments",
  16. "comments",
  17. "displaydate",
  18. "displaymodified",
  19. "*categories_str",
  20. "author",
  21. "*post_thumbnail_href_str",
  22. "*post_href_str",
  23. "snippet_s"
  24. ],
  25. "query": {
  26. "function_score": {
  27. "functions": [
  28. {
  29. "filter": {
  30. "match": {
  31. "product_cat_str": "Smartphones"
  32. }
  33. },
  34. "weight": 3
  35. },
  36. {
  37. "filter": {
  38. "match": {
  39. "product_cat_str": "Smartwatch Accessories"
  40. }
  41. },
  42. "weight": 2.5
  43. },
  44. {
  45. "filter": {
  46. "match": {
  47. "product_cat_str": "Grocery"
  48. }
  49. },
  50. "weight": 7
  51. },
  52. {
  53. "filter": {
  54. "match": {
  55. "product_cat_str": "eggs"
  56. }
  57. },
  58. "weight": 1
  59. },
  60. {
  61. "filter": {
  62. "match": {
  63. "product_brand_str": "Hugo Boss"
  64. }
  65. },
  66. "weight": 2
  67. },
  68. {
  69. "filter": {
  70. "match": {
  71. "product_brand_str": "Aamrai"
  72. }
  73. },
  74. "weight": 4
  75. },
  76. {
  77. "filter": {
  78. "match": {
  79. "product_brand_str": "Del Monte"
  80. }
  81. },
  82. "weight": 3
  83. },
  84. {
  85. "filter": {
  86. "match": {
  87. "product_brand_str": "Crest"
  88. }
  89. },
  90. "weight": 3
  91. },
  92. {
  93. "filter": {
  94. "match": {
  95. "author": "italist"
  96. }
  97. },
  98. "weight": 3
  99. }
  100. ],
  101. "query": {
  102. "bool": {
  103. "must": {
  104. "query_string": {
  105. "fields": [
  106. "title^5",
  107. "content^2",
  108. "product_cat_str^10",
  109. "product_brand_str",
  110. "author"
  111. ],
  112. "query": "(*)",
  113. "default_operator": "AND"
  114. }
  115. },
  116. "filter": {
  117. "bool": {
  118. "must": [
  119. {
  120. "bool": {
  121. "must_not": [
  122. {
  123. "terms": {
  124. "post_status_s": [
  125. "draft",
  126. "pending",
  127. "trash",
  128. "future",
  129. "private",
  130. "auto-draft"
  131. ]
  132. }
  133. }
  134. ]
  135. }
  136. },
  137. {
  138. "bool": {
  139. "must": {
  140. "bool": {
  141. "must": [
  142. {
  143. "terms": {
  144. "non_flat_hierarchy_product_cat_str": [
  145. "Fashion"
  146. ]
  147. }
  148. },
  149. {
  150. "terms": {
  151. "non_flat_hierarchy_product_cat_str": [
  152. "Women"
  153. ]
  154. }
  155. },
  156. {
  157. "terms": {
  158. "non_flat_hierarchy_product_cat_str": [
  159. "Women Bags"
  160. ]
  161. }
  162. },
  163. {
  164. "terms": {
  165. "non_flat_hierarchy_product_cat_str": [
  166. "Totes"
  167. ]
  168. }
  169. }
  170. ]
  171. }
  172. }
  173. }
  174. },
  175. {
  176. "bool": {
  177. "must_not": [
  178. {
  179. "terms": {
  180. "type": [
  181. "shop_order"
  182. ]
  183. }
  184. }
  185. ]
  186. }
  187. },
  188. {
  189. "bool": {
  190. "should": [
  191. {
  192. "bool": {
  193. "must_not": [
  194. {
  195. "terms": {
  196. "type": [
  197. "product"
  198. ]
  199. }
  200. }
  201. ]
  202. }
  203. },
  204. {
  205. "bool": {
  206. "should": [
  207. {
  208. "bool": {
  209. "must_not": [
  210. {
  211. "exists": {
  212. "field": "product_visibility_str"
  213. }
  214. }
  215. ]
  216. }
  217. },
  218. {
  219. "bool": {
  220. "must_not": [
  221. {
  222. "terms": {
  223. "product_visibility_str": [
  224. "exclude-from-search"
  225. ]
  226. }
  227. }
  228. ]
  229. }
  230. }
  231. ]
  232. }
  233. }
  234. ]
  235. }
  236. },
  237. {
  238. "bool": {
  239. "should": [
  240. {
  241. "bool": {
  242. "must_not": [
  243. {
  244. "terms": {
  245. "type": [
  246. "product"
  247. ]
  248. }
  249. }
  250. ]
  251. }
  252. },
  253. {
  254. "terms": {
  255. "product_stock_str": [
  256. "y"
  257. ]
  258. }
  259. }
  260. ]
  261. }
  262. },
  263. {
  264. "bool": {
  265. "should": [
  266. {
  267. "bool": {
  268. "must_not": [
  269. {
  270. "bool": {
  271. "must": {
  272. "exists": {
  273. "field": "is_excluded_s"
  274. }
  275. }
  276. }
  277. }
  278. ]
  279. }
  280. },
  281. {
  282. "terms": {
  283. "is_excluded_s": [
  284. "n"
  285. ]
  286. }
  287. }
  288. ]
  289. }
  290. },
  291. {
  292. "bool": {
  293. "must_not": [
  294. {
  295. "terms": {
  296. "_id": [
  297. "wpsolr_doc_id_attachment"
  298. ]
  299. }
  300. }
  301. ]
  302. }
  303. }
  304. ]
  305. }
  306. }
  307. }
  308. }
  309. }
  310. },
  311. "post_filter": {
  312. "bool": {
  313. "must": [
  314. {
  315. "bool": {
  316. "must": [
  317. {
  318. "terms": {
  319. "type": [
  320. "product"
  321. ]
  322. }
  323. }
  324. ]
  325. }
  326. }
  327. ]
  328. }
  329. },
  330. "aggs": {
  331. "_price_f": {
  332. "filter": {
  333. "bool": {
  334. "must": [
  335. {
  336. "bool": {
  337. "must": [
  338. {
  339. "terms": {
  340. "type": [
  341. "product"
  342. ]
  343. }
  344. }
  345. ]
  346. }
  347. }
  348. ]
  349. }
  350. },
  351. "aggs": {
  352. "_price_f": {
  353. "filter": {
  354. "match_all": {}
  355. },
  356. "aggs": {
  357. "_price_f": {
  358. "stats": {
  359. "field": "_price_f"
  360. }
  361. }
  362. }
  363. }
  364. }
  365. },
  366. "product_brand_str": {
  367. "filter": {
  368. "bool": {
  369. "must": [
  370. {
  371. "bool": {
  372. "must": [
  373. {
  374. "terms": {
  375. "type": [
  376. "product"
  377. ]
  378. }
  379. }
  380. ]
  381. }
  382. }
  383. ]
  384. }
  385. },
  386. "aggs": {
  387. "product_brand_str": {
  388. "filter": {
  389. "match_all": {}
  390. },
  391. "aggs": {
  392. "product_brand_str": {
  393. "terms": {
  394. "field": "product_brand_str",
  395. "size": 20
  396. }
  397. }
  398. }
  399. }
  400. }
  401. },
  402. "pa_gender_str": {
  403. "filter": {
  404. "bool": {
  405. "must": [
  406. {
  407. "bool": {
  408. "must": [
  409. {
  410. "terms": {
  411. "type": [
  412. "product"
  413. ]
  414. }
  415. }
  416. ]
  417. }
  418. }
  419. ]
  420. }
  421. },
  422. "aggs": {
  423. "pa_gender_str": {
  424. "filter": {
  425. "match_all": {}
  426. },
  427. "aggs": {
  428. "pa_gender_str": {
  429. "terms": {
  430. "field": "pa_gender_str",
  431. "size": 20
  432. }
  433. }
  434. }
  435. }
  436. }
  437. },
  438. "pa_color_str": {
  439. "filter": {
  440. "bool": {
  441. "must": [
  442. {
  443. "bool": {
  444. "must": [
  445. {
  446. "terms": {
  447. "type": [
  448. "product"
  449. ]
  450. }
  451. }
  452. ]
  453. }
  454. }
  455. ]
  456. }
  457. },
  458. "aggs": {
  459. "pa_color_str": {
  460. "filter": {
  461. "match_all": {}
  462. },
  463. "aggs": {
  464. "pa_color_str": {
  465. "terms": {
  466. "field": "pa_color_str",
  467. "size": 20
  468. }
  469. }
  470. }
  471. }
  472. }
  473. },
  474. "pa_health-facts_str": {
  475. "filter": {
  476. "bool": {
  477. "must": [
  478. {
  479. "bool": {
  480. "must": [
  481. {
  482. "terms": {
  483. "type": [
  484. "product"
  485. ]
  486. }
  487. }
  488. ]
  489. }
  490. }
  491. ]
  492. }
  493. },
  494. "aggs": {
  495. "pa_health-facts_str": {
  496. "filter": {
  497. "match_all": {}
  498. },
  499. "aggs": {
  500. "pa_health-facts_str": {
  501. "terms": {
  502. "field": "pa_health-facts_str",
  503. "size": 20
  504. }
  505. }
  506. }
  507. }
  508. }
  509. },
  510. "pa_artisana_str": {
  511. "filter": {
  512. "bool": {
  513. "must": [
  514. {
  515. "bool": {
  516. "must": [
  517. {
  518. "terms": {
  519. "type": [
  520. "product"
  521. ]
  522. }
  523. }
  524. ]
  525. }
  526. }
  527. ]
  528. }
  529. },
  530. "aggs": {
  531. "pa_artisana_str": {
  532. "filter": {
  533. "match_all": {}
  534. },
  535. "aggs": {
  536. "pa_artisana_str": {
  537. "terms": {
  538. "field": "pa_artisana_str",
  539. "size": 20
  540. }
  541. }
  542. }
  543. }
  544. }
  545. },
  546. "flat_hierarchy_product_cat_str": {
  547. "filter": {
  548. "bool": {
  549. "must": [
  550. {
  551. "bool": {
  552. "must": [
  553. {
  554. "terms": {
  555. "type": [
  556. "product"
  557. ]
  558. }
  559. }
  560. ]
  561. }
  562. }
  563. ]
  564. }
  565. },
  566. "aggs": {
  567. "flat_hierarchy_product_cat_str": {
  568. "filter": {
  569. "match_all": {}
  570. },
  571. "aggs": {
  572. "flat_hierarchy_product_cat_str": {
  573. "terms": {
  574. "field": "flat_hierarchy_product_cat_str",
  575. "size": 20
  576. }
  577. }
  578. }
  579. }
  580. }
  581. }
  582. }
  583. }
  584.  
  585. "pa_artisana_str": {
  586. "doc_count": 66,
  587. "pa_artisana_str": {
  588. "doc_count": 66,
  589. "pa_artisana_str": {
  590. "doc_count_error_upper_bound": 0,
  591. "sum_other_doc_count": 0,
  592. "buckets": [
  593. {
  594. "key": "Artisana products",
  595. "doc_count": 3
  596. }
  597. ]
  598. }
  599. }
  600. },
  601. "pa_health-facts_str": {
  602. "doc_count": 66,
  603. "pa_health-facts_str": {
  604. "doc_count": 66,
  605. "pa_health-facts_str": {
  606. "doc_count_error_upper_bound": 0,
  607. "sum_other_doc_count": 0,
  608. "buckets": []
  609. }
  610. }
  611. },
  612. "_price_f": {
  613. "doc_count": 66,
  614. "_price_f": {
  615. "doc_count": 66,
  616. "_price_f": {
  617. "count": 67,
  618. "min": 109,
  619. "max": 17957.099609375,
  620. "avg": 7275.810374473458,
  621. "sum": 487479.2950897217
  622. }
  623. }
  624. },
  625. "pa_gender_str": {
  626. "doc_count": 66,
  627. "pa_gender_str": {
  628. "doc_count": 66,
  629. "pa_gender_str": {
  630. "doc_count_error_upper_bound": 0,
  631. "sum_other_doc_count": 0,
  632. "buckets": [
  633. {
  634. "key": "Women",
  635. "doc_count": 7
  636. }
  637. ]
  638. }
  639. }
  640. },
  641. "flat_hierarchy_product_cat_str": {
  642. "doc_count": 66,
  643. "flat_hierarchy_product_cat_str": {
  644. "doc_count": 66,
  645. "flat_hierarchy_product_cat_str": {
  646. "doc_count_error_upper_bound": 0,
  647. "sum_other_doc_count": 0,
  648. "buckets": [
  649. {
  650. "key": "Fashion",
  651. "doc_count": 66
  652. },
  653. {
  654. "key": "Fashion->Women",
  655. "doc_count": 66
  656. },
  657. {
  658. "key": "Fashion->Women->Women Bags",
  659. "doc_count": 66
  660. },
  661. {
  662. "key": "Fashion->Women->Women Bags->Totes",
  663. "doc_count": 66
  664. }
  665. ]
  666. }
  667. }
  668. },
  669. "pa_color_str": {
  670. "doc_count": 66,
  671. "pa_color_str": {
  672. "doc_count": 66,
  673. "pa_color_str": {
  674. "doc_count_error_upper_bound": 0,
  675. "sum_other_doc_count": 2,
  676. "buckets": [
  677. {
  678. "key": "Black",
  679. "doc_count": 19
  680. },
  681. {
  682. "key": "Brown",
  683. "doc_count": 8
  684. },
  685. {
  686. "key": "Red",
  687. "doc_count": 8
  688. },
  689. {
  690. "key": "Beige",
  691. "doc_count": 4
  692. },
  693. {
  694. "key": "Burgundy",
  695. "doc_count": 3
  696. },
  697. {
  698. "key": "Nude",
  699. "doc_count": 3
  700. },
  701. {
  702. "key": "Blue",
  703. "doc_count": 2
  704. },
  705. {
  706. "key": "Gray",
  707. "doc_count": 2
  708. },
  709. {
  710. "key": "Maroon",
  711. "doc_count": 2
  712. },
  713. {
  714. "key": "Rose",
  715. "doc_count": 2
  716. },
  717. {
  718. "key": "Black\/Gold",
  719. "doc_count": 1
  720. },
  721. {
  722. "key": "Black\/Silver",
  723. "doc_count": 1
  724. },
  725. {
  726. "key": "Black\/White",
  727. "doc_count": 1
  728. },
  729. {
  730. "key": "Candy",
  731. "doc_count": 1
  732. },
  733. {
  734. "key": "Khaki",
  735. "doc_count": 1
  736. },
  737. {
  738. "key": "Light Pink",
  739. "doc_count": 1
  740. },
  741. {
  742. "key": "Multicolor",
  743. "doc_count": 1
  744. },
  745. {
  746. "key": "Navy Blue",
  747. "doc_count": 1
  748. },
  749. {
  750. "key": "Pale Pink",
  751. "doc_count": 1
  752. },
  753. {
  754. "key": "Pink",
  755. "doc_count": 1
  756. }
  757. ]
  758. }
  759. }
  760. }
  761. }
  762. }
  763.  
  764.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement