SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002039s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022085s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12676118 LIMIT 5 [ RunTime:0.020571s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12676118 ORDER BY `minOrder` ASC [ RunTime:0.040709s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12676118 ORDER BY `unit` DESC [ RunTime:0.048972s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12676118 LIMIT 2 [ RunTime:0.009796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12676118 ORDER BY `minOrder` ASC [ RunTime:0.016604s ]
select * from pdf where partno='CLM-120-02-F-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.048443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11519962 LIMIT 5 [ RunTime:0.018713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11519962 ORDER BY `minOrder` ASC [ RunTime:0.009700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11519962 ORDER BY `unit` DESC [ RunTime:0.002151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11519962 LIMIT 2 [ RunTime:0.025236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11519962 ORDER BY `minOrder` ASC [ RunTime:0.021048s ]
select * from pdf where partno='CLM-120-02-F-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12701499 LIMIT 5 [ RunTime:0.007243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12701499 ORDER BY `minOrder` ASC [ RunTime:0.043354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12701499 ORDER BY `unit` DESC [ RunTime:0.084300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12701499 LIMIT 2 [ RunTime:0.036856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12701499 ORDER BY `minOrder` ASC [ RunTime:0.002846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12700812 LIMIT 5 [ RunTime:0.029049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12700812 ORDER BY `minOrder` ASC [ RunTime:0.021871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12700812 ORDER BY `unit` DESC [ RunTime:0.053626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12700812 LIMIT 2 [ RunTime:0.036888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12700812 ORDER BY `minOrder` ASC [ RunTime:0.035093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12700447 LIMIT 5 [ RunTime:0.014020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12700447 ORDER BY `minOrder` ASC [ RunTime:0.032877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12700447 ORDER BY `unit` DESC [ RunTime:0.024592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12700447 LIMIT 2 [ RunTime:0.024128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12700447 ORDER BY `minOrder` ASC [ RunTime:0.014954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12698338 LIMIT 5 [ RunTime:0.037441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12698338 ORDER BY `minOrder` ASC [ RunTime:0.021429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12698338 ORDER BY `unit` DESC [ RunTime:0.020369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12698338 LIMIT 2 [ RunTime:0.033506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12698338 ORDER BY `minOrder` ASC [ RunTime:0.008251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12690379 LIMIT 5 [ RunTime:0.005406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12690379 ORDER BY `minOrder` ASC [ RunTime:0.016075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12690379 ORDER BY `unit` DESC [ RunTime:0.005229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12690379 LIMIT 2 [ RunTime:0.007815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12690379 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12687550 LIMIT 5 [ RunTime:0.010717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12687550 ORDER BY `minOrder` ASC [ RunTime:0.003061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12687550 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12687550 LIMIT 2 [ RunTime:0.004044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12687550 ORDER BY `minOrder` ASC [ RunTime:0.012104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12664104 LIMIT 5 [ RunTime:0.015711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664104 ORDER BY `minOrder` ASC [ RunTime:0.006064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12664104 ORDER BY `unit` DESC [ RunTime:0.006159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12664104 LIMIT 2 [ RunTime:0.017115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664104 ORDER BY `minOrder` ASC [ RunTime:0.001656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663843 LIMIT 5 [ RunTime:0.009669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663843 ORDER BY `minOrder` ASC [ RunTime:0.012298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12663843 ORDER BY `unit` DESC [ RunTime:0.006792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12663843 LIMIT 2 [ RunTime:0.005930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663843 ORDER BY `minOrder` ASC [ RunTime:0.001773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646328 LIMIT 5 [ RunTime:0.001428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646328 ORDER BY `minOrder` ASC [ RunTime:0.003080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12646328 ORDER BY `unit` DESC [ RunTime:0.012102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12646328 LIMIT 2 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646328 ORDER BY `minOrder` ASC [ RunTime:0.008125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11544285 LIMIT 5 [ RunTime:0.005835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11544285 ORDER BY `minOrder` ASC [ RunTime:0.009578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11544285 ORDER BY `unit` DESC [ RunTime:0.002074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11544285 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11544285 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11543666 LIMIT 5 [ RunTime:0.001334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11543666 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11543666 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11543666 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11543666 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538436 LIMIT 5 [ RunTime:0.001045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11538436 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11538436 ORDER BY `unit` DESC [ RunTime:0.003265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11538436 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11538436 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11536181 LIMIT 5 [ RunTime:0.001093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11536181 ORDER BY `minOrder` ASC [ RunTime:0.009944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11536181 ORDER BY `unit` DESC [ RunTime:0.006709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11536181 LIMIT 2 [ RunTime:0.002026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11536181 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534614 LIMIT 5 [ RunTime:0.005564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534614 ORDER BY `minOrder` ASC [ RunTime:0.002813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11534614 ORDER BY `unit` DESC [ RunTime:0.000554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11534614 LIMIT 2 [ RunTime:0.003537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534614 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534029 LIMIT 5 [ RunTime:0.001041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534029 ORDER BY `minOrder` ASC [ RunTime:0.003722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11534029 ORDER BY `unit` DESC [ RunTime:0.002230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11534029 LIMIT 2 [ RunTime:0.001301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534029 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523995 LIMIT 5 [ RunTime:0.001559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523995 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11523995 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11523995 LIMIT 2 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523995 ORDER BY `minOrder` ASC [ RunTime:0.002082s ]
select * from pdf where partno='CLM-120-02-F-D-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11516956 LIMIT 5 [ RunTime:0.001537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11516956 ORDER BY `minOrder` ASC [ RunTime:0.002559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11516956 ORDER BY `unit` DESC [ RunTime:0.002549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11516956 LIMIT 2 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11516956 ORDER BY `minOrder` ASC [ RunTime:0.003165s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001269s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750769 LIMIT 5 [ RunTime:0.011439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750769 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750769 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750769 LIMIT 2 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750769 ORDER BY `minOrder` ASC [ RunTime:0.011039s ]
select * from pdf where partno='CLM-120-02-F-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 59750769 AND `partno` = 'CLM-120-02-F-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11519962 [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753243 LIMIT 5 [ RunTime:0.000914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753243 ORDER BY `minOrder` ASC [ RunTime:0.001769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753243 ORDER BY `unit` DESC [ RunTime:0.006969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753243 LIMIT 2 [ RunTime:0.015245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753243 ORDER BY `minOrder` ASC [ RunTime:0.007425s ]
select * from pdf where partno='CLM-120-02-F-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001764s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753243 AND `partno` = 'CLM-120-02-F-D-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12676118 [ RunTime:0.000589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59878523 LIMIT 5 [ RunTime:0.004445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878523 ORDER BY `minOrder` ASC [ RunTime:0.004152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59878523 ORDER BY `unit` DESC [ RunTime:0.000494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59878523 LIMIT 2 [ RunTime:0.004944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878523 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='CLM-120-02-F-D-BE-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006420s ]
SELECT `id` FROM `stock` WHERE `id` <> 59878523 AND `partno` = 'CLM-120-02-F-D-BE-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59878522 LIMIT 5 [ RunTime:0.007024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878522 ORDER BY `minOrder` ASC [ RunTime:0.006282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59878522 ORDER BY `unit` DESC [ RunTime:0.004960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59878522 LIMIT 2 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878522 ORDER BY `minOrder` ASC [ RunTime:0.003443s ]
select * from pdf where partno='CLM-120-02-F-D-BE-A-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-A-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018604s ]
SELECT `id` FROM `stock` WHERE `id` <> 59878522 AND `partno` = 'CLM-120-02-F-D-BE-A-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59878147 LIMIT 5 [ RunTime:0.002912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878147 ORDER BY `minOrder` ASC [ RunTime:0.000960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59878147 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59878147 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878147 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='CLM-120-02-F-D-BE-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011813s ]
SELECT `id` FROM `stock` WHERE `id` <> 59878147 AND `partno` = 'CLM-120-02-F-D-BE-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59877614 LIMIT 5 [ RunTime:0.001388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877614 ORDER BY `minOrder` ASC [ RunTime:0.003563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59877614 ORDER BY `unit` DESC [ RunTime:0.006999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59877614 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877614 ORDER BY `minOrder` ASC [ RunTime:0.004961s ]
select * from pdf where partno='CLM-120-02-F-D-BE-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004435s ]
SELECT `id` FROM `stock` WHERE `id` <> 59877614 AND `partno` = 'CLM-120-02-F-D-BE-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59877092 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877092 ORDER BY `minOrder` ASC [ RunTime:0.007905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59877092 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59877092 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877092 ORDER BY `minOrder` ASC [ RunTime:0.001277s ]
select * from pdf where partno='CLM-120-02-F-D-BE-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000992s ]
SELECT `id` FROM `stock` WHERE `id` <> 59877092 AND `partno` = 'CLM-120-02-F-D-BE-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59876908 LIMIT 5 [ RunTime:0.011958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59876908 ORDER BY `minOrder` ASC [ RunTime:0.008865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59876908 ORDER BY `unit` DESC [ RunTime:0.009832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59876908 LIMIT 2 [ RunTime:0.015290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59876908 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='CLM-120-02-F-D-BE-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022969s ]
SELECT `id` FROM `stock` WHERE `id` <> 59876908 AND `partno` = 'CLM-120-02-F-D-BE-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59876130 LIMIT 5 [ RunTime:0.004374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59876130 ORDER BY `minOrder` ASC [ RunTime:0.005023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59876130 ORDER BY `unit` DESC [ RunTime:0.004412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59876130 LIMIT 2 [ RunTime:0.007377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59876130 ORDER BY `minOrder` ASC [ RunTime:0.026723s ]
select * from pdf where partno='CLM-120-02-F-D-BE-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026112s ]
SELECT `id` FROM `stock` WHERE `id` <> 59876130 AND `partno` = 'CLM-120-02-F-D-BE-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59876016 LIMIT 5 [ RunTime:0.003723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59876016 ORDER BY `minOrder` ASC [ RunTime:0.010995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59876016 ORDER BY `unit` DESC [ RunTime:0.003739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59876016 LIMIT 2 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59876016 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='CLM-120-02-F-D-A-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-A-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005069s ]
SELECT `id` FROM `stock` WHERE `id` <> 59876016 AND `partno` = 'CLM-120-02-F-D-A-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59873099 LIMIT 5 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59873099 ORDER BY `minOrder` ASC [ RunTime:0.006544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59873099 ORDER BY `unit` DESC [ RunTime:0.011263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59873099 LIMIT 2 [ RunTime:0.015337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59873099 ORDER BY `minOrder` ASC [ RunTime:0.009962s ]
select * from pdf where partno='CLM-120-02-F-D-BE-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002808s ]
SELECT `id` FROM `stock` WHERE `id` <> 59873099 AND `partno` = 'CLM-120-02-F-D-BE-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646328 [ RunTime:0.014755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59855972 LIMIT 5 [ RunTime:0.014024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59855972 ORDER BY `minOrder` ASC [ RunTime:0.020462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59855972 ORDER BY `unit` DESC [ RunTime:0.017644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59855972 LIMIT 2 [ RunTime:0.003011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59855972 ORDER BY `minOrder` ASC [ RunTime:0.013027s ]
select * from pdf where partno='CLM-120-02-F-D-PA-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-PA-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013386s ]
SELECT `id` FROM `stock` WHERE `id` <> 59855972 AND `partno` = 'CLM-120-02-F-D-PA-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59850564 LIMIT 5 [ RunTime:0.011665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59850564 ORDER BY `minOrder` ASC [ RunTime:0.034407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59850564 ORDER BY `unit` DESC [ RunTime:0.005940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59850564 LIMIT 2 [ RunTime:0.016565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59850564 ORDER BY `minOrder` ASC [ RunTime:0.021920s ]
select * from pdf where partno='CLM-120-02-F-D-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.024495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021641s ]
SELECT `id` FROM `stock` WHERE `id` <> 59850564 AND `partno` = 'CLM-120-02-F-D-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59850054 LIMIT 5 [ RunTime:0.009436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59850054 ORDER BY `minOrder` ASC [ RunTime:0.005376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59850054 ORDER BY `unit` DESC [ RunTime:0.006080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59850054 LIMIT 2 [ RunTime:0.014944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59850054 ORDER BY `minOrder` ASC [ RunTime:0.005397s ]
select * from pdf where partno='CLM-120-02-F-D-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015473s ]
SELECT `id` FROM `stock` WHERE `id` <> 59850054 AND `partno` = 'CLM-120-02-F-D-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59847977 LIMIT 5 [ RunTime:0.025048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59847977 ORDER BY `minOrder` ASC [ RunTime:0.015067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59847977 ORDER BY `unit` DESC [ RunTime:0.010868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59847977 LIMIT 2 [ RunTime:0.003266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59847977 ORDER BY `minOrder` ASC [ RunTime:0.002021s ]
select * from pdf where partno='CLM-120-02-F-D-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010481s ]
SELECT `id` FROM `stock` WHERE `id` <> 59847977 AND `partno` = 'CLM-120-02-F-D-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59843105 LIMIT 5 [ RunTime:0.043067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59843105 ORDER BY `minOrder` ASC [ RunTime:0.013462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59843105 ORDER BY `unit` DESC [ RunTime:0.018162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59843105 LIMIT 2 [ RunTime:0.009377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59843105 ORDER BY `minOrder` ASC [ RunTime:0.007070s ]
select * from pdf where partno='CLM-120-02-F-D-BE-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012009s ]
SELECT `id` FROM `stock` WHERE `id` <> 59843105 AND `partno` = 'CLM-120-02-F-D-BE-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59841528 LIMIT 5 [ RunTime:0.013897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59841528 ORDER BY `minOrder` ASC [ RunTime:0.028159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59841528 ORDER BY `unit` DESC [ RunTime:0.017540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59841528 LIMIT 2 [ RunTime:0.045635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59841528 ORDER BY `minOrder` ASC [ RunTime:0.011049s ]
select * from pdf where partno='CLM-120-02-F-D-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.031641s ]
SELECT `id` FROM `stock` WHERE `id` <> 59841528 AND `partno` = 'CLM-120-02-F-D-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59840662 LIMIT 5 [ RunTime:0.003780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840662 ORDER BY `minOrder` ASC [ RunTime:0.020623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59840662 ORDER BY `unit` DESC [ RunTime:0.029442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59840662 LIMIT 2 [ RunTime:0.013574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840662 ORDER BY `minOrder` ASC [ RunTime:0.030072s ]
select * from pdf where partno='CLM-120-02-F-D-BE-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025478s ]
SELECT `id` FROM `stock` WHERE `id` <> 59840662 AND `partno` = 'CLM-120-02-F-D-BE-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59839626 LIMIT 5 [ RunTime:0.023184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59839626 ORDER BY `minOrder` ASC [ RunTime:0.026380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59839626 ORDER BY `unit` DESC [ RunTime:0.010880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59839626 LIMIT 2 [ RunTime:0.012560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59839626 ORDER BY `minOrder` ASC [ RunTime:0.009684s ]
select * from pdf where partno='CLM-120-02-F-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008776s ]
SELECT `id` FROM `stock` WHERE `id` <> 59839626 AND `partno` = 'CLM-120-02-F-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11544285 [ RunTime:0.006817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59839258 LIMIT 5 [ RunTime:0.011155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59839258 ORDER BY `minOrder` ASC [ RunTime:0.038527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59839258 ORDER BY `unit` DESC [ RunTime:0.035078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59839258 LIMIT 2 [ RunTime:0.007574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59839258 ORDER BY `minOrder` ASC [ RunTime:0.002087s ]
select * from pdf where partno='CLM-120-02-F-D-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-120-02-F-D-BE-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030923s ]
SELECT `id` FROM `stock` WHERE `id` <> 59839258 AND `partno` = 'CLM-120-02-F-D-BE-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12701499 [ RunTime:0.019032s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010228s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021299s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010605s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042613s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038568s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019148s ]
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 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019637s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CLM-120-02-F-D%' OR `brand` LIKE 'CLM-120-02-F-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024209s ]