SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002687s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057569s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14793997 LIMIT 5 [ RunTime:0.028829s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14793997 ORDER BY `minOrder` ASC [ RunTime:0.021361s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14793997 ORDER BY `unit` DESC [ RunTime:0.019474s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14793997 LIMIT 2 [ RunTime:0.004536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14793997 ORDER BY `minOrder` ASC [ RunTime:0.018092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11397269 LIMIT 5 [ RunTime:0.009958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11397269 ORDER BY `minOrder` ASC [ RunTime:0.032929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11397269 ORDER BY `unit` DESC [ RunTime:0.022975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11397269 LIMIT 2 [ RunTime:0.033968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11397269 ORDER BY `minOrder` ASC [ RunTime:0.012228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344860 LIMIT 5 [ RunTime:0.030432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344860 ORDER BY `minOrder` ASC [ RunTime:0.020026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13344860 ORDER BY `unit` DESC [ RunTime:0.010679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13344860 LIMIT 2 [ RunTime:0.007930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344860 ORDER BY `minOrder` ASC [ RunTime:0.014574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471008 LIMIT 5 [ RunTime:0.013405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471008 ORDER BY `minOrder` ASC [ RunTime:0.013990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13471008 ORDER BY `unit` DESC [ RunTime:0.016311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13471008 LIMIT 2 [ RunTime:0.016872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471008 ORDER BY `minOrder` ASC [ RunTime:0.010976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387628 LIMIT 5 [ RunTime:0.025740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387628 ORDER BY `minOrder` ASC [ RunTime:0.049696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387628 ORDER BY `unit` DESC [ RunTime:0.030365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387628 LIMIT 2 [ RunTime:0.063607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387628 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
select * from pdf where partno='5193C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.027109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517021 LIMIT 5 [ RunTime:0.028694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517021 ORDER BY `minOrder` ASC [ RunTime:0.028632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13517021 ORDER BY `unit` DESC [ RunTime:0.023136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13517021 LIMIT 2 [ RunTime:0.009220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517021 ORDER BY `minOrder` ASC [ RunTime:0.010227s ]
select * from pdf where partno='5193C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.036331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17486326 LIMIT 5 [ RunTime:0.024171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17486326 ORDER BY `minOrder` ASC [ RunTime:0.008687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17486326 ORDER BY `unit` DESC [ RunTime:0.008809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17486326 LIMIT 2 [ RunTime:0.007659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17486326 ORDER BY `minOrder` ASC [ RunTime:0.001646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377633 LIMIT 5 [ RunTime:0.011738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377633 ORDER BY `minOrder` ASC [ RunTime:0.014160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377633 ORDER BY `unit` DESC [ RunTime:0.008267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377633 LIMIT 2 [ RunTime:0.010674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377633 ORDER BY `minOrder` ASC [ RunTime:0.012289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377632 LIMIT 5 [ RunTime:0.006531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377632 ORDER BY `minOrder` ASC [ RunTime:0.006067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377632 ORDER BY `unit` DESC [ RunTime:0.013470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377632 LIMIT 2 [ RunTime:0.015215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377632 ORDER BY `minOrder` ASC [ RunTime:0.018015s ]
select * from pdf where partno='5193C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517026 LIMIT 5 [ RunTime:0.013396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517026 ORDER BY `minOrder` ASC [ RunTime:0.022377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13517026 ORDER BY `unit` DESC [ RunTime:0.034935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13517026 LIMIT 2 [ RunTime:0.023209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517026 ORDER BY `minOrder` ASC [ RunTime:0.001958s ]
select * from pdf where partno='5193C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500735 LIMIT 5 [ RunTime:0.014057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500735 ORDER BY `minOrder` ASC [ RunTime:0.042407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500735 ORDER BY `unit` DESC [ RunTime:0.019807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500735 LIMIT 2 [ RunTime:0.027313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500735 ORDER BY `minOrder` ASC [ RunTime:0.033157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500721 LIMIT 5 [ RunTime:0.023200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500721 ORDER BY `minOrder` ASC [ RunTime:0.005322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500721 ORDER BY `unit` DESC [ RunTime:0.007431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500721 LIMIT 2 [ RunTime:0.001971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500721 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500705 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500705 ORDER BY `minOrder` ASC [ RunTime:0.001006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500705 ORDER BY `unit` DESC [ RunTime:0.007061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500705 LIMIT 2 [ RunTime:0.004537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500705 ORDER BY `minOrder` ASC [ RunTime:0.004502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500695 LIMIT 5 [ RunTime:0.007402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500695 ORDER BY `minOrder` ASC [ RunTime:0.001633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500695 ORDER BY `unit` DESC [ RunTime:0.002548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500695 LIMIT 2 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500695 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500693 LIMIT 5 [ RunTime:0.002826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500693 ORDER BY `minOrder` ASC [ RunTime:0.010495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500693 ORDER BY `unit` DESC [ RunTime:0.004526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500693 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500693 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500663 LIMIT 5 [ RunTime:0.000867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500663 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500663 ORDER BY `unit` DESC [ RunTime:0.002163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500663 LIMIT 2 [ RunTime:0.001305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500663 ORDER BY `minOrder` ASC [ RunTime:0.001830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500661 LIMIT 5 [ RunTime:0.015021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500661 ORDER BY `minOrder` ASC [ RunTime:0.002936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500661 ORDER BY `unit` DESC [ RunTime:0.007327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500661 LIMIT 2 [ RunTime:0.003266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500661 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500658 LIMIT 5 [ RunTime:0.018004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500658 ORDER BY `minOrder` ASC [ RunTime:0.030542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500658 ORDER BY `unit` DESC [ RunTime:0.013313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500658 LIMIT 2 [ RunTime:0.019474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500658 ORDER BY `minOrder` ASC [ RunTime:0.002891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500643 LIMIT 5 [ RunTime:0.009023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500643 ORDER BY `minOrder` ASC [ RunTime:0.024753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500643 ORDER BY `unit` DESC [ RunTime:0.001453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500643 LIMIT 2 [ RunTime:0.009905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500643 ORDER BY `minOrder` ASC [ RunTime:0.011923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500632 LIMIT 5 [ RunTime:0.006283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500632 ORDER BY `minOrder` ASC [ RunTime:0.001065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500632 ORDER BY `unit` DESC [ RunTime:0.005672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500632 LIMIT 2 [ RunTime:0.013009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500632 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263363 LIMIT 5 [ RunTime:0.002581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263363 ORDER BY `minOrder` ASC [ RunTime:0.024583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32263363 ORDER BY `unit` DESC [ RunTime:0.015395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32263363 LIMIT 2 [ RunTime:0.007101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263363 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='51939-030lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.012304s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-030lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.009991s ]
SELECT `id` FROM `stock` WHERE `id` <> 32263363 AND `partno` = '51939-030lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.025702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096037 LIMIT 5 [ RunTime:0.012392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096037 ORDER BY `minOrder` ASC [ RunTime:0.018575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096037 ORDER BY `unit` DESC [ RunTime:0.017227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096037 LIMIT 2 [ RunTime:0.006351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096037 ORDER BY `minOrder` ASC [ RunTime:0.001740s ]
select * from pdf where partno='5193' and brandshort='adafruit' limit 1 [ RunTime:0.004521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.047671s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63503945 LIMIT 5 [ RunTime:0.004418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503945 ORDER BY `minOrder` ASC [ RunTime:0.058891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63503945 ORDER BY `unit` DESC [ RunTime:0.019303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63503945 LIMIT 2 [ RunTime:0.019568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503945 ORDER BY `minOrder` ASC [ RunTime:0.035684s ]
select * from pdf where partno='5193TR' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.024947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193TR' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.054907s ]
SELECT `id` FROM `stock` WHERE `id` <> 63503945 AND `partno` = '5193TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.023399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14793997 [ RunTime:0.044147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943059 LIMIT 5 [ RunTime:0.051030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943059 ORDER BY `minOrder` ASC [ RunTime:0.065498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943059 ORDER BY `unit` DESC [ RunTime:0.034149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943059 LIMIT 2 [ RunTime:0.065502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943059 ORDER BY `minOrder` ASC [ RunTime:0.043666s ]
select * from pdf where partno='51939-357LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.092519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-357LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.094481s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943059 AND `partno` = '51939-357LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.141123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489029 [ RunTime:0.079656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943060 LIMIT 5 [ RunTime:0.032025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943060 ORDER BY `minOrder` ASC [ RunTime:0.044985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943060 ORDER BY `unit` DESC [ RunTime:0.045109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943060 LIMIT 2 [ RunTime:0.079541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943060 ORDER BY `minOrder` ASC [ RunTime:0.021142s ]
select * from pdf where partno='51939-701LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.041230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-701LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.032819s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943060 AND `partno` = '51939-701LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.053231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489030 [ RunTime:0.003592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943094 LIMIT 5 [ RunTime:0.030007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943094 ORDER BY `minOrder` ASC [ RunTime:0.043934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943094 ORDER BY `unit` DESC [ RunTime:0.013070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943094 LIMIT 2 [ RunTime:0.014858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943094 ORDER BY `minOrder` ASC [ RunTime:0.021524s ]
select * from pdf where partno='51939-831NSPLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.017681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-831NSPLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.012360s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943094 AND `partno` = '51939-831NSPLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.039577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489037 [ RunTime:0.016621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60942444 LIMIT 5 [ RunTime:0.013785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942444 ORDER BY `minOrder` ASC [ RunTime:0.024543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60942444 ORDER BY `unit` DESC [ RunTime:0.004922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60942444 LIMIT 2 [ RunTime:0.016730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942444 ORDER BY `minOrder` ASC [ RunTime:0.003032s ]
select * from pdf where partno='51939-667LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.005837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-667LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006693s ]
SELECT `id` FROM `stock` WHERE `id` <> 60942444 AND `partno` = '51939-667LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11397269 [ RunTime:0.011828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64574262 LIMIT 5 [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574262 ORDER BY `minOrder` ASC [ RunTime:0.006595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64574262 ORDER BY `unit` DESC [ RunTime:0.003226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64574262 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574262 ORDER BY `minOrder` ASC [ RunTime:0.002016s ]
select * from pdf where partno='5193CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.009906s ]
SELECT `id` FROM `stock` WHERE `id` <> 64574262 AND `partno` = '5193CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344860 [ RunTime:0.000922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943150 LIMIT 5 [ RunTime:0.001590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943150 ORDER BY `minOrder` ASC [ RunTime:0.003576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943150 ORDER BY `unit` DESC [ RunTime:0.002905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943150 LIMIT 2 [ RunTime:0.001195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943150 ORDER BY `minOrder` ASC [ RunTime:0.002264s ]
select * from pdf where partno='51939-285LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-285LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.011752s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943150 AND `partno` = '51939-285LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.011893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489379 [ RunTime:0.002734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943072 LIMIT 5 [ RunTime:0.005429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943072 ORDER BY `minOrder` ASC [ RunTime:0.013861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943072 ORDER BY `unit` DESC [ RunTime:0.008557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943072 LIMIT 2 [ RunTime:0.013585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943072 ORDER BY `minOrder` ASC [ RunTime:0.003744s ]
select * from pdf where partno='51939-768LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-768LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002620s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943072 AND `partno` = '51939-768LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.013907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943242 LIMIT 5 [ RunTime:0.001940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943242 ORDER BY `minOrder` ASC [ RunTime:0.007515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943242 ORDER BY `unit` DESC [ RunTime:0.009724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943242 LIMIT 2 [ RunTime:0.002356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943242 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
select * from pdf where partno='51939-726LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-726LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002576s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943242 AND `partno` = '51939-726LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489712 [ RunTime:0.002126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943177 LIMIT 5 [ RunTime:0.001264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943177 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943177 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943177 LIMIT 2 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943177 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='51939-1039LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-1039LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003499s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943177 AND `partno` = '51939-1039LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.005079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489413 [ RunTime:0.003638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943360 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943360 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943360 ORDER BY `unit` DESC [ RunTime:0.015739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943360 LIMIT 2 [ RunTime:0.005330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943360 ORDER BY `minOrder` ASC [ RunTime:0.005088s ]
select * from pdf where partno='51939-472LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-472LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000860s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943360 AND `partno` = '51939-472LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12490018 [ RunTime:0.001057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58297809 LIMIT 5 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297809 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58297809 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58297809 LIMIT 2 [ RunTime:0.010593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297809 ORDER BY `minOrder` ASC [ RunTime:0.023000s ]
select * from pdf where partno='5193' and brandshort='Pololu' limit 1 [ RunTime:0.006998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.004012s ]
SELECT `id` FROM `stock` WHERE `id` <> 58297809 AND `partno` = '5193' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.008373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471008 [ RunTime:0.002140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944204 LIMIT 5 [ RunTime:0.003288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944204 ORDER BY `minOrder` ASC [ RunTime:0.007575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944204 ORDER BY `unit` DESC [ RunTime:0.004702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944204 LIMIT 2 [ RunTime:0.001853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944204 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='51939-030LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.030483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-030LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002414s ]
SELECT `id` FROM `stock` WHERE `id` <> 60944204 AND `partno` = '51939-030LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.009778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944384 LIMIT 5 [ RunTime:0.019248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944384 ORDER BY `minOrder` ASC [ RunTime:0.020095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944384 ORDER BY `unit` DESC [ RunTime:0.012742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944384 LIMIT 2 [ RunTime:0.009165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944384 ORDER BY `minOrder` ASC [ RunTime:0.003833s ]
select * from pdf where partno='51939-178LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-178LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.016545s ]
SELECT `id` FROM `stock` WHERE `id` <> 60944384 AND `partno` = '51939-178LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11392916 [ RunTime:0.015975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944401 LIMIT 5 [ RunTime:0.007008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944401 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944401 ORDER BY `unit` DESC [ RunTime:0.002126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944401 LIMIT 2 [ RunTime:0.008674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944401 ORDER BY `minOrder` ASC [ RunTime:0.006181s ]
select * from pdf where partno='51939-152LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.011604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51939-152LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.015198s ]
SELECT `id` FROM `stock` WHERE `id` <> 60944401 AND `partno` = '51939-152LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11398305 [ RunTime:0.008352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62998274 LIMIT 5 [ RunTime:0.006647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998274 ORDER BY `minOrder` ASC [ RunTime:0.020003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62998274 ORDER BY `unit` DESC [ RunTime:0.015611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62998274 LIMIT 2 [ RunTime:0.006190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998274 ORDER BY `minOrder` ASC [ RunTime:0.001684s ]
select * from pdf where partno='5193C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001228s ]
SELECT `id` FROM `stock` WHERE `id` <> 62998274 AND `partno` = '5193C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.004122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387628 [ RunTime:0.002703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001126 LIMIT 5 [ RunTime:0.001990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001126 ORDER BY `minOrder` ASC [ RunTime:0.008747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001126 ORDER BY `unit` DESC [ RunTime:0.006838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001126 LIMIT 2 [ RunTime:0.010224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001126 ORDER BY `minOrder` ASC [ RunTime:0.002815s ]
select * from pdf where partno='5193C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001613s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001126 AND `partno` = '5193C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517021 [ RunTime:0.016114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000245 LIMIT 5 [ RunTime:0.009170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000245 ORDER BY `minOrder` ASC [ RunTime:0.016920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000245 ORDER BY `unit` DESC [ RunTime:0.001943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000245 LIMIT 2 [ RunTime:0.008160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000245 ORDER BY `minOrder` ASC [ RunTime:0.001950s ]
select * from pdf where partno='5193C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003271s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000245 AND `partno` = '5193C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.005444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517026 [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63020085 LIMIT 5 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63020085 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63020085 ORDER BY `unit` DESC [ RunTime:0.010157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63020085 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63020085 ORDER BY `minOrder` ASC [ RunTime:0.007049s ]
select * from pdf where partno='5193C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193C SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.004870s ]
SELECT `id` FROM `stock` WHERE `id` <> 63020085 AND `partno` = '5193C SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.013761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377633 [ RunTime:0.008301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63019949 LIMIT 5 [ RunTime:0.003579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019949 ORDER BY `minOrder` ASC [ RunTime:0.008557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63019949 ORDER BY `unit` DESC [ RunTime:0.016640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63019949 LIMIT 2 [ RunTime:0.005284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019949 ORDER BY `minOrder` ASC [ RunTime:0.005071s ]
select * from pdf where partno='5193C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5193C BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.010026s ]
SELECT `id` FROM `stock` WHERE `id` <> 63019949 AND `partno` = '5193C BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377632 [ RunTime:0.010726s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001863s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008723s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009875s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010388s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010835s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014785s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007724s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5193%' OR `brand` LIKE '5193%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007318s ]