API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 19th, 2022
24
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.50 KB | None | 0 0
raw download clone embed print report
  1. Url: "/product-category/fashion-3/?wpsolr_fq%5B0%5D=product_cat_str%3AMen&wpsolr_fq%5B1%5D=product_cat_str%3AEyewear&wpsolr_fq%5B2%5D=product_cat_str%3AEyeglasses&wpsolr_sort=sort_by_relevancy_desc"
  2. Index: "new_index"
  3. Nb results shown: 20
  4. Total nb results: 3297
  5. Speed: 368 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": "Apples"
  48. }
  49. },
  50. "weight": 3
  51. },
  52. {
  53. "filter": {
  54. "match": {
  55. "product_cat_str": "Juice"
  56. }
  57. },
  58. "weight": 3
  59. },
  60. {
  61. "filter": {
  62. "match": {
  63. "product_cat_str": "Pie"
  64. }
  65. },
  66. "weight": 2
  67. },
  68. {
  69. "filter": {
  70. "match": {
  71. "product_cat_str": "Mangos"
  72. }
  73. },
  74. "weight": 7
  75. },
  76. {
  77. "filter": {
  78. "match": {
  79. "product_brand_str": "Hugo Boss"
  80. }
  81. },
  82. "weight": 2
  83. },
  84. {
  85. "filter": {
  86. "match": {
  87. "product_brand_str": "Aamrai"
  88. }
  89. },
  90. "weight": 4
  91. },
  92. {
  93. "filter": {
  94. "match": {
  95. "product_brand_str": "Del Monte"
  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",
  109. "product_brand_str"
  110. ],
  111. "query": "(*)",
  112. "default_operator": "AND"
  113. }
  114. },
  115. "filter": {
  116. "bool": {
  117. "must": [
  118. {
  119. "bool": {
  120. "must_not": [
  121. {
  122. "terms": {
  123. "post_status_s": [
  124. "draft",
  125. "pending",
  126. "trash",
  127. "future",
  128. "private",
  129. "auto-draft"
  130. ]
  131. }
  132. }
  133. ]
  134. }
  135. },
  136. {
  137. "bool": {
  138. "must": {
  139. "term": {
  140. "non_flat_hierarchy_product_cat_str": "Fashion"
  141. }
  142. }
  143. }
  144. },
  145. {
  146. "bool": {
  147. "should": [
  148. {
  149. "bool": {
  150. "must_not": [
  151. {
  152. "terms": {
  153. "type": [
  154. "product"
  155. ]
  156. }
  157. }
  158. ]
  159. }
  160. },
  161. {
  162. "bool": {
  163. "should": [
  164. {
  165. "bool": {
  166. "must_not": [
  167. {
  168. "exists": {
  169. "field": "product_visibility_str"
  170. }
  171. }
  172. ]
  173. }
  174. },
  175. {
  176. "bool": {
  177. "must_not": [
  178. {
  179. "terms": {
  180. "product_visibility_str": [
  181. "exclude-from-catalog"
  182. ]
  183. }
  184. }
  185. ]
  186. }
  187. }
  188. ]
  189. }
  190. }
  191. ]
  192. }
  193. },
  194. {
  195. "bool": {
  196. "should": [
  197. {
  198. "bool": {
  199. "must_not": [
  200. {
  201. "terms": {
  202. "type": [
  203. "product"
  204. ]
  205. }
  206. }
  207. ]
  208. }
  209. },
  210. {
  211. "terms": {
  212. "product_stock_str": [
  213. "y"
  214. ]
  215. }
  216. }
  217. ]
  218. }
  219. },
  220. {
  221. "bool": {
  222. "should": [
  223. {
  224. "bool": {
  225. "must_not": [
  226. {
  227. "bool": {
  228. "must": {
  229. "exists": {
  230. "field": "is_excluded_s"
  231. }
  232. }
  233. }
  234. }
  235. ]
  236. }
  237. },
  238. {
  239. "terms": {
  240. "is_excluded_s": [
  241. "n"
  242. ]
  243. }
  244. }
  245. ]
  246. }
  247. },
  248. {
  249. "bool": {
  250. "must_not": [
  251. {
  252. "terms": {
  253. "_id": [
  254. "wpsolr_doc_id_attachment"
  255. ]
  256. }
  257. }
  258. ]
  259. }
  260. }
  261. ]
  262. }
  263. }
  264. }
  265. }
  266. }
  267. },
  268. "post_filter": {
  269. "bool": {
  270. "must": [
  271. {
  272. "bool": {
  273. "must": [
  274. {
  275. "terms": {
  276. "type": [
  277. "product"
  278. ]
  279. }
  280. }
  281. ]
  282. }
  283. }
  284. ]
  285. }
  286. },
  287. "aggs": {
  288. "_price_f": {
  289. "filter": {
  290. "bool": {
  291. "must": [
  292. {
  293. "bool": {
  294. "must": [
  295. {
  296. "terms": {
  297. "type": [
  298. "product"
  299. ]
  300. }
  301. }
  302. ]
  303. }
  304. }
  305. ]
  306. }
  307. },
  308. "aggs": {
  309. "_price_f": {
  310. "filter": {
  311. "match_all": {}
  312. },
  313. "aggs": {
  314. "_price_f": {
  315. "stats": {
  316. "field": "_price_f"
  317. }
  318. }
  319. }
  320. }
  321. }
  322. },
  323. "product_brand_str": {
  324. "filter": {
  325. "bool": {
  326. "must": [
  327. {
  328. "bool": {
  329. "must": [
  330. {
  331. "terms": {
  332. "type": [
  333. "product"
  334. ]
  335. }
  336. }
  337. ]
  338. }
  339. }
  340. ]
  341. }
  342. },
  343. "aggs": {
  344. "product_brand_str": {
  345. "filter": {
  346. "match_all": {}
  347. },
  348. "aggs": {
  349. "product_brand_str": {
  350. "terms": {
  351. "field": "product_brand_str",
  352. "size": 20
  353. }
  354. }
  355. }
  356. }
  357. }
  358. },
  359. "pa_gender_str": {
  360. "filter": {
  361. "bool": {
  362. "must": [
  363. {
  364. "bool": {
  365. "must": [
  366. {
  367. "terms": {
  368. "type": [
  369. "product"
  370. ]
  371. }
  372. }
  373. ]
  374. }
  375. }
  376. ]
  377. }
  378. },
  379. "aggs": {
  380. "pa_gender_str": {
  381. "filter": {
  382. "match_all": {}
  383. },
  384. "aggs": {
  385. "pa_gender_str": {
  386. "terms": {
  387. "field": "pa_gender_str",
  388. "size": 20
  389. }
  390. }
  391. }
  392. }
  393. }
  394. },
  395. "pa_color_str": {
  396. "filter": {
  397. "bool": {
  398. "must": [
  399. {
  400. "bool": {
  401. "must": [
  402. {
  403. "terms": {
  404. "type": [
  405. "product"
  406. ]
  407. }
  408. }
  409. ]
  410. }
  411. }
  412. ]
  413. }
  414. },
  415. "aggs": {
  416. "pa_color_str": {
  417. "filter": {
  418. "match_all": {}
  419. },
  420. "aggs": {
  421. "pa_color_str": {
  422. "terms": {
  423. "field": "pa_color_str",
  424. "size": 20
  425. }
  426. }
  427. }
  428. }
  429. }
  430. },
  431. "pa_health-facts_str": {
  432. "filter": {
  433. "bool": {
  434. "must": [
  435. {
  436. "bool": {
  437. "must": [
  438. {
  439. "terms": {
  440. "type": [
  441. "product"
  442. ]
  443. }
  444. }
  445. ]
  446. }
  447. }
  448. ]
  449. }
  450. },
  451. "aggs": {
  452. "pa_health-facts_str": {
  453. "filter": {
  454. "match_all": {}
  455. },
  456. "aggs": {
  457. "pa_health-facts_str": {
  458. "terms": {
  459. "field": "pa_health-facts_str",
  460. "size": 20
  461. }
  462. }
  463. }
  464. }
  465. }
  466. },
  467. "flat_hierarchy_product_cat_str": {
  468. "filter": {
  469. "bool": {
  470. "must": [
  471. {
  472. "bool": {
  473. "must": [
  474. {
  475. "terms": {
  476. "type": [
  477. "product"
  478. ]
  479. }
  480. }
  481. ]
  482. }
  483. }
  484. ]
  485. }
  486. },
  487. "aggs": {
  488. "flat_hierarchy_product_cat_str": {
  489. "filter": {
  490. "match_all": {}
  491. },
  492. "aggs": {
  493. "flat_hierarchy_product_cat_str": {
  494. "terms": {
  495. "field": "flat_hierarchy_product_cat_str",
  496. "size": 20
  497. }
  498. }
  499. }
  500. }
  501. }
  502. }
  503. }
  504. }
  505.  
  506. "aggregations": {
  507. "product_brand_str": {
  508. "doc_count": 3297,
  509. "product_brand_str": {
  510. "doc_count": 3297,
  511. "product_brand_str": {
  512. "doc_count_error_upper_bound": 0,
  513. "sum_other_doc_count": 834,
  514. "buckets": [
  515. {
  516. "key": "Twinkle Hands",
  517. "doc_count": 382
  518. },
  519. {
  520. "key": "Pronovias",
  521. "doc_count": 121
  522. },
  523. {
  524. "key": "Beach&Bandits",
  525. "doc_count": 119
  526. },
  527. {
  528. "key": "Paul & Shark",
  529. "doc_count": 111
  530. },
  531. {
  532. "key": "AbyKay",
  533. "doc_count": 105
  534. },
  535. {
  536. "key": "SprayGround",
  537. "doc_count": 100
  538. },
  539. {
  540. "key": "Trixie",
  541. "doc_count": 92
  542. },
  543. {
  544. "key": "New Balance",
  545. "doc_count": 84
  546. },
  547. {
  548. "key": "Ray-Ban",
  549. "doc_count": 82
  550. },
  551. {
  552. "key": "Polaroid",
  553. "doc_count": 77
  554. },
  555. {
  556. "key": "Just Cavalli",
  557. "doc_count": 75
  558. },
  559. {
  560. "key": "Karl Lagerfeld",
  561. "doc_count": 75
  562. },
  563. {
  564. "key": "Indietales",
  565. "doc_count": 66
  566. },
  567. {
  568. "key": "Versace",
  569. "doc_count": 52
  570. },
  571. {
  572. "key": "Carrera",
  573. "doc_count": 50
  574. },
  575. {
  576. "key": "Timberland",
  577. "doc_count": 45
  578. },
  579. {
  580. "key": "Armani Exchange",
  581. "doc_count": 43
  582. },
  583. {
  584. "key": "Swarovski",
  585. "doc_count": 42
  586. },
  587. {
  588. "key": "Salvatore Ferragamo",
  589. "doc_count": 36
  590. },
  591. {
  592. "key": "Vogue",
  593. "doc_count": 35
  594. }
  595. ]
  596. }
  597. }
  598. },
  599. "pa_health-facts_str": {
  600. "doc_count": 3297,
  601. "pa_health-facts_str": {
  602. "doc_count": 3297,
  603. "pa_health-facts_str": {
  604. "doc_count_error_upper_bound": 0,
  605. "sum_other_doc_count": 0,
  606. "buckets": []
  607. }
  608. }
  609. },
  610. "_price_f": {
  611. "doc_count": 3297,
  612. "_price_f": {
  613. "doc_count": 3297,
  614. "_price_f": {
  615. "count": 3324,
  616. "min": 0,
  617. "max": 89351.8515625,
  618. "avg": 1657.1589078401114,
  619. "sum": 5508396.20966053
  620. }
  621. }
  622. },
  623. "pa_gender_str": {
  624. "doc_count": 3297,
  625. "pa_gender_str": {
  626. "doc_count": 3297,
  627. "pa_gender_str": {
  628. "doc_count_error_upper_bound": 0,
  629. "sum_other_doc_count": 0,
  630. "buckets": [
  631. {
  632. "key": "Women",
  633. "doc_count": 82
  634. },
  635. {
  636. "key": "Men",
  637. "doc_count": 24
  638. },
  639. {
  640. "key": "Boys",
  641. "doc_count": 2
  642. },
  643. {
  644. "key": "Unisex",
  645. "doc_count": 2
  646. }
  647. ]
  648. }
  649. }
  650. },
  651. "flat_hierarchy_product_cat_str": {
  652. "doc_count": 3297,
  653. "flat_hierarchy_product_cat_str": {
  654. "doc_count": 3297,
  655. "flat_hierarchy_product_cat_str": {
  656. "doc_count_error_upper_bound": 0,
  657. "sum_other_doc_count": 2756,
  658. "buckets": [
  659. {
  660. "key": "Fashion",
  661. "doc_count": 3297
  662. },
  663. {
  664. "key": "Fashion->Men",
  665. "doc_count": 1311
  666. },
  667. {
  668. "key": "Fashion->Women",
  669. "doc_count": 1202
  670. },
  671. {
  672. "key": "Fashion->Women->Women Clothing",
  673. "doc_count": 687
  674. },
  675. {
  676. "key": "Fashion->Men->Eyewear",
  677. "doc_count": 622
  678. },
  679. {
  680. "key": "Fashion->Boys",
  681. "doc_count": 554
  682. },
  683. {
  684. "key": "Fashion->Girls",
  685. "doc_count": 551
  686. },
  687. {
  688. "key": "Fashion->Men->Men Clothing",
  689. "doc_count": 499
  690. },
  691. {
  692. "key": "Fashion->Girls->Girls Clothing",
  693. "doc_count": 445
  694. },
  695. {
  696. "key": "Fashion->Boys->Boys Clothing",
  697. "doc_count": 435
  698. },
  699. {
  700. "key": "Fashion->Men->Eyewear->Sunglasses",
  701. "doc_count": 398
  702. },
  703. {
  704. "key": "Fashion->Boys->Boys Clothing->Shirts",
  705. "doc_count": 337
  706. },
  707. {
  708. "key": "Fashion->Girls->Girls Clothing->Shirts & Blouses",
  709. "doc_count": 306
  710. },
  711. {
  712. "key": "Fashion->Women->Women Clothing->Wedding Dress",
  713. "doc_count": 245
  714. },
  715. {
  716. "key": "Fashion->Men->Eyewear->Eyeglasses",
  717. "doc_count": 213
  718. },
  719. {
  720. "key": "Fashion->Women->Eyewear",
  721. "doc_count": 196
  722. },
  723. {
  724. "key": "Fashion->Women->Women Bags",
  725. "doc_count": 188
  726. },
  727. {
  728. "key": "Fashion->Women->Women Clothing->Dresses",
  729. "doc_count": 161
  730. },
  731. {
  732. "key": "Fashion->Luggage & Travel Gear",
  733. "doc_count": 153
  734. },
  735. {
  736. "key": "Fashion->Men->Men Clothing->Shirts",
  737. "doc_count": 143
  738. }
  739. ]
  740. }
  741. }
  742. },
  743. "pa_color_str": {
  744. "doc_count": 3297,
  745. "pa_color_str": {
  746. "doc_count": 3297,
  747. "pa_color_str": {
  748. "doc_count_error_upper_bound": 0,
  749. "sum_other_doc_count": 743,
  750. "buckets": [
  751. {
  752. "key": "Black",
  753. "doc_count": 264
  754. },
  755. {
  756. "key": "White",
  757. "doc_count": 224
  758. },
  759. {
  760. "key": "Blue",
  761. "doc_count": 110
  762. },
  763. {
  764. "key": "Clear\/Havana",
  765. "doc_count": 88
  766. },
  767. {
  768. "key": "Pink",
  769. "doc_count": 60
  770. },
  771. {
  772. "key": "Clear\/Black",
  773. "doc_count": 59
  774. },
  775. {
  776. "key": "Red",
  777. "doc_count": 59
  778. },
  779. {
  780. "key": "Brown",
  781. "doc_count": 55
  782. },
  783. {
  784. "key": "Green",
  785. "doc_count": 55
  786. },
  787. {
  788. "key": "Grey",
  789. "doc_count": 47
  790. },
  791. {
  792. "key": "Grey\/Black",
  793. "doc_count": 33
  794. },
  795. {
  796. "key": "Ivory",
  797. "doc_count": 30
  798. },
  799. {
  800. "key": "Navy Blue",
  801. "doc_count": 29
  802. },
  803. {
  804. "key": "Brown\/Gold",
  805. "doc_count": 27
  806. },
  807. {
  808. "key": "Yellow",
  809. "doc_count": 26
  810. },
  811. {
  812. "key": "Purple",
  813. "doc_count": 25
  814. },
  815. {
  816. "key": "Beige",
  817. "doc_count": 23
  818. },
  819. {
  820. "key": "Brown\/Havana",
  821. "doc_count": 23
  822. },
  823. {
  824. "key": "Gray\/Black",
  825. "doc_count": 22
  826. },
  827. {
  828. "key": "Multicolor",
  829. "doc_count": 21
  830. }
  831. ]
  832. }
  833. }
  834. }
  835. }
  836. }
  837.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!