SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002526s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.118946s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.028006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298628 LIMIT 5 [ RunTime:0.049196s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298628 ORDER BY `minOrder` ASC [ RunTime:0.083555s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298628 ORDER BY `unit` DESC [ RunTime:0.019428s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298628 LIMIT 2 [ RunTime:0.002510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298628 ORDER BY `minOrder` ASC [ RunTime:0.006568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14237364 LIMIT 5 [ RunTime:0.027488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14237364 ORDER BY `minOrder` ASC [ RunTime:0.120065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14237364 ORDER BY `unit` DESC [ RunTime:0.051411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14237364 LIMIT 2 [ RunTime:0.084242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14237364 ORDER BY `minOrder` ASC [ RunTime:0.068849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15329493 LIMIT 5 [ RunTime:0.068862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15329493 ORDER BY `minOrder` ASC [ RunTime:0.096991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15329493 ORDER BY `unit` DESC [ RunTime:0.075894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15329493 LIMIT 2 [ RunTime:0.088645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15329493 ORDER BY `minOrder` ASC [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18993712 LIMIT 5 [ RunTime:0.081199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18993712 ORDER BY `minOrder` ASC [ RunTime:0.027422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18993712 ORDER BY `unit` DESC [ RunTime:0.005122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18993712 LIMIT 2 [ RunTime:0.063055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18993712 ORDER BY `minOrder` ASC [ RunTime:0.006647s ]
select * from pdf where partno='4070' and brandshort='Davies Molding, LLC' limit 1 [ RunTime:0.001252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344516 LIMIT 5 [ RunTime:0.012475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344516 ORDER BY `minOrder` ASC [ RunTime:0.030538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13344516 ORDER BY `unit` DESC [ RunTime:0.047458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13344516 LIMIT 2 [ RunTime:0.064789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344516 ORDER BY `minOrder` ASC [ RunTime:0.037997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18902276 LIMIT 5 [ RunTime:0.065755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18902276 ORDER BY `minOrder` ASC [ RunTime:0.052437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18902276 ORDER BY `unit` DESC [ RunTime:0.044244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18902276 LIMIT 2 [ RunTime:0.073114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18902276 ORDER BY `minOrder` ASC [ RunTime:0.021966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18903110 LIMIT 5 [ RunTime:0.037981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903110 ORDER BY `minOrder` ASC [ RunTime:0.002272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18903110 ORDER BY `unit` DESC [ RunTime:0.025948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18903110 LIMIT 2 [ RunTime:0.046539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903110 ORDER BY `minOrder` ASC [ RunTime:0.015478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19267006 LIMIT 5 [ RunTime:0.044361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19267006 ORDER BY `minOrder` ASC [ RunTime:0.103283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19267006 ORDER BY `unit` DESC [ RunTime:0.026199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19267006 LIMIT 2 [ RunTime:0.026032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19267006 ORDER BY `minOrder` ASC [ RunTime:0.013068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18901060 LIMIT 5 [ RunTime:0.035214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18901060 ORDER BY `minOrder` ASC [ RunTime:0.097403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18901060 ORDER BY `unit` DESC [ RunTime:0.028715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18901060 LIMIT 2 [ RunTime:0.014021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18901060 ORDER BY `minOrder` ASC [ RunTime:0.023122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18620307 LIMIT 5 [ RunTime:0.057797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18620307 ORDER BY `minOrder` ASC [ RunTime:0.083954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18620307 ORDER BY `unit` DESC [ RunTime:0.125918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18620307 LIMIT 2 [ RunTime:0.043481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18620307 ORDER BY `minOrder` ASC [ RunTime:0.038903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17851952 LIMIT 5 [ RunTime:0.079189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17851952 ORDER BY `minOrder` ASC [ RunTime:0.111760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17851952 ORDER BY `unit` DESC [ RunTime:0.029741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17851952 LIMIT 2 [ RunTime:0.033641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17851952 ORDER BY `minOrder` ASC [ RunTime:0.031987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850767 LIMIT 5 [ RunTime:0.105933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850767 ORDER BY `minOrder` ASC [ RunTime:0.049058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850767 ORDER BY `unit` DESC [ RunTime:0.024987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850767 LIMIT 2 [ RunTime:0.043470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850767 ORDER BY `minOrder` ASC [ RunTime:0.036152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425709 LIMIT 5 [ RunTime:0.026401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425709 ORDER BY `minOrder` ASC [ RunTime:0.025365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425709 ORDER BY `unit` DESC [ RunTime:0.009734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425709 LIMIT 2 [ RunTime:0.027851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425709 ORDER BY `minOrder` ASC [ RunTime:0.014648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424369 LIMIT 5 [ RunTime:0.037376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424369 ORDER BY `minOrder` ASC [ RunTime:0.055254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14424369 ORDER BY `unit` DESC [ RunTime:0.028368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14424369 LIMIT 2 [ RunTime:0.038247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424369 ORDER BY `minOrder` ASC [ RunTime:0.019193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424366 LIMIT 5 [ RunTime:0.058838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424366 ORDER BY `minOrder` ASC [ RunTime:0.073860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14424366 ORDER BY `unit` DESC [ RunTime:0.013697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14424366 LIMIT 2 [ RunTime:0.011896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424366 ORDER BY `minOrder` ASC [ RunTime:0.020387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14046681 LIMIT 5 [ RunTime:0.088152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14046681 ORDER BY `minOrder` ASC [ RunTime:0.043497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14046681 ORDER BY `unit` DESC [ RunTime:0.050011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14046681 LIMIT 2 [ RunTime:0.063561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14046681 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556647 LIMIT 5 [ RunTime:0.015259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556647 ORDER BY `minOrder` ASC [ RunTime:0.074077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556647 ORDER BY `unit` DESC [ RunTime:0.051747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556647 LIMIT 2 [ RunTime:0.029348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556647 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555290 LIMIT 5 [ RunTime:0.006115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555290 ORDER BY `minOrder` ASC [ RunTime:0.015708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555290 ORDER BY `unit` DESC [ RunTime:0.013243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555290 LIMIT 2 [ RunTime:0.024276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555290 ORDER BY `minOrder` ASC [ RunTime:0.033779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550460 LIMIT 5 [ RunTime:0.020003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550460 ORDER BY `minOrder` ASC [ RunTime:0.025577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13550460 ORDER BY `unit` DESC [ RunTime:0.019579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13550460 LIMIT 2 [ RunTime:0.023336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550460 ORDER BY `minOrder` ASC [ RunTime:0.009802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459751 LIMIT 5 [ RunTime:0.008527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459751 ORDER BY `minOrder` ASC [ RunTime:0.007926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459751 ORDER BY `unit` DESC [ RunTime:0.002753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459751 LIMIT 2 [ RunTime:0.006239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459751 ORDER BY `minOrder` ASC [ RunTime:0.010698s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282093 LIMIT 5 [ RunTime:0.027003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282093 ORDER BY `minOrder` ASC [ RunTime:0.024858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282093 ORDER BY `unit` DESC [ RunTime:0.004555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282093 LIMIT 2 [ RunTime:0.021884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282093 ORDER BY `minOrder` ASC [ RunTime:0.001581s ]
select * from pdf where partno='40702' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.022255s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40702' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.036943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32290051 LIMIT 5 [ RunTime:0.045681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290051 ORDER BY `minOrder` ASC [ RunTime:0.008052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32290051 ORDER BY `unit` DESC [ RunTime:0.005044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32290051 LIMIT 2 [ RunTime:0.009837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290051 ORDER BY `minOrder` ASC [ RunTime:0.003295s ]
select * from pdf where partno='40704' and brandshort='vicor' limit 1 [ RunTime:0.013406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40704' OR `brand` LIKE 'vicor%' ) ) LIMIT 1 [ RunTime:0.020607s ]
SELECT `id` FROM `stock` WHERE `id` <> 32290051 AND `partno` = '40704' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor%' ) [ RunTime:0.011683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18620307 [ RunTime:0.021808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283129 LIMIT 5 [ RunTime:0.050717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283129 ORDER BY `minOrder` ASC [ RunTime:0.023378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32283129 ORDER BY `unit` DESC [ RunTime:0.020132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32283129 LIMIT 2 [ RunTime:0.044669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283129 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
select * from pdf where partno='407001-usb' and brandshort='extech' limit 1 [ RunTime:0.001901s ]
select foldpath,foldpath2,filename from pdf_file where id=690344 limit 1 [ RunTime:0.011804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '407001-usb' OR `brand` LIKE 'extech%' ) ) LIMIT 1 [ RunTime:0.008664s ]
SELECT `id` FROM `stock` WHERE `id` <> 32283129 AND `partno` = '407001-usb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%extech%' ) [ RunTime:0.065243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18902276 [ RunTime:0.005075s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53823611 LIMIT 5 [ RunTime:0.028219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53823611 ORDER BY `minOrder` ASC [ RunTime:0.037937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53823611 ORDER BY `unit` DESC [ RunTime:0.034985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53823611 LIMIT 2 [ RunTime:0.010721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53823611 ORDER BY `minOrder` ASC [ RunTime:0.016661s ]
select * from pdf where partno='40702' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40702' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56984346 LIMIT 5 [ RunTime:0.003119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56984346 ORDER BY `minOrder` ASC [ RunTime:0.008565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56984346 ORDER BY `unit` DESC [ RunTime:0.005066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56984346 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56984346 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='4070BDC' and brandshort='National Semiconductor' limit 1 [ RunTime:0.001326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070BDC' OR `brand` LIKE 'National Semiconductor%' ) ) LIMIT 1 [ RunTime:0.005863s ]
SELECT `id` FROM `stock` WHERE `id` <> 56984346 AND `partno` = '4070BDC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%national semiconductor%' ) [ RunTime:0.014650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14237364 [ RunTime:0.008432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53815481 LIMIT 5 [ RunTime:0.002559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53815481 ORDER BY `minOrder` ASC [ RunTime:0.012755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53815481 ORDER BY `unit` DESC [ RunTime:0.012214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53815481 LIMIT 2 [ RunTime:0.014510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53815481 ORDER BY `minOrder` ASC [ RunTime:0.006414s ]
select * from pdf where partno='40705' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.044642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40705' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56984465 LIMIT 5 [ RunTime:0.018559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56984465 ORDER BY `minOrder` ASC [ RunTime:0.009436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56984465 ORDER BY `unit` DESC [ RunTime:0.006685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56984465 LIMIT 2 [ RunTime:0.013335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56984465 ORDER BY `minOrder` ASC [ RunTime:0.012007s ]
select * from pdf where partno='4070BDM' and brandshort='National Semiconductor' limit 1 [ RunTime:0.016468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070BDM' OR `brand` LIKE 'National Semiconductor%' ) ) LIMIT 1 [ RunTime:0.004716s ]
SELECT `id` FROM `stock` WHERE `id` <> 56984465 AND `partno` = '4070BDM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%national semiconductor%' ) [ RunTime:0.046782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15329493 [ RunTime:0.042256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57756080 LIMIT 5 [ RunTime:0.025904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756080 ORDER BY `minOrder` ASC [ RunTime:0.056403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57756080 ORDER BY `unit` DESC [ RunTime:0.023880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57756080 LIMIT 2 [ RunTime:0.056849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756080 ORDER BY `minOrder` ASC [ RunTime:0.071905s ]
select * from pdf where partno='4070CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.077841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.034221s ]
SELECT `id` FROM `stock` WHERE `id` <> 57756080 AND `partno` = '4070CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344516 [ RunTime:0.059294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56639576 LIMIT 5 [ RunTime:0.031788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56639576 ORDER BY `minOrder` ASC [ RunTime:0.009066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56639576 ORDER BY `unit` DESC [ RunTime:0.022890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56639576 LIMIT 2 [ RunTime:0.015369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56639576 ORDER BY `minOrder` ASC [ RunTime:0.011979s ]
select * from pdf where partno='4070' and brandshort='Davies Molding, LLC' limit 1 [ RunTime:0.002418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070' OR `brand` LIKE 'Davies Molding, LLC%' ) ) LIMIT 1 [ RunTime:0.002865s ]
SELECT `id` FROM `stock` WHERE `id` <> 56639576 AND `partno` = '4070' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%davies molding, llc%' ) [ RunTime:0.003866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18993712 [ RunTime:0.012306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56398372 LIMIT 5 [ RunTime:0.054210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56398372 ORDER BY `minOrder` ASC [ RunTime:0.060290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56398372 ORDER BY `unit` DESC [ RunTime:0.019805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56398372 LIMIT 2 [ RunTime:0.011848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56398372 ORDER BY `minOrder` ASC [ RunTime:0.012563s ]
select * from pdf where partno='4070854' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070854' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033971s ]
SELECT `id` FROM `stock` WHERE `id` <> 56398372 AND `partno` = '4070854' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56685020 LIMIT 5 [ RunTime:0.087128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56685020 ORDER BY `minOrder` ASC [ RunTime:0.051404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56685020 ORDER BY `unit` DESC [ RunTime:0.009779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56685020 LIMIT 2 [ RunTime:0.102721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56685020 ORDER BY `minOrder` ASC [ RunTime:0.009820s ]
select * from pdf where partno='407001-USB' and brandshort='FLIR Extech' limit 1 [ RunTime:0.009540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '407001-USB' OR `brand` LIKE 'FLIR Extech%' ) ) LIMIT 1 [ RunTime:0.015402s ]
SELECT `id` FROM `stock` WHERE `id` <> 56685020 AND `partno` = '407001-USB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flir extech%' ) [ RunTime:0.018154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18902276 [ RunTime:0.010274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56685028 LIMIT 5 [ RunTime:0.025237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56685028 ORDER BY `minOrder` ASC [ RunTime:0.018224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56685028 ORDER BY `unit` DESC [ RunTime:0.032080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56685028 LIMIT 2 [ RunTime:0.026467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56685028 ORDER BY `minOrder` ASC [ RunTime:0.016305s ]
select * from pdf where partno='407001-PRO' and brandshort='FLIR Extech' limit 1 [ RunTime:0.017059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '407001-PRO' OR `brand` LIKE 'FLIR Extech%' ) ) LIMIT 1 [ RunTime:0.008953s ]
SELECT `id` FROM `stock` WHERE `id` <> 56685028 AND `partno` = '407001-PRO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flir extech%' ) [ RunTime:0.018091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18903110 [ RunTime:0.025148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58005794 LIMIT 5 [ RunTime:0.002875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58005794 ORDER BY `minOrder` ASC [ RunTime:0.005254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58005794 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58005794 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58005794 ORDER BY `minOrder` ASC [ RunTime:0.002175s ]
select * from pdf where partno='4070-4BK;1' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.000620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070-4BK;1' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.000410s ]
SELECT `id` FROM `stock` WHERE `id` <> 58005794 AND `partno` = '4070-4BK;1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58005392 LIMIT 5 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58005392 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58005392 ORDER BY `unit` DESC [ RunTime:0.000391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58005392 LIMIT 2 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58005392 ORDER BY `minOrder` ASC [ RunTime:0.003900s ]
select * from pdf where partno='4070-6BK-BU' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.000501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070-6BK-BU' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.000553s ]
SELECT `id` FROM `stock` WHERE `id` <> 58005392 AND `partno` = '4070-6BK-BU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.001976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57716141 LIMIT 5 [ RunTime:0.019462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57716141 ORDER BY `minOrder` ASC [ RunTime:0.042004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57716141 ORDER BY `unit` DESC [ RunTime:0.000761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57716141 LIMIT 2 [ RunTime:0.007879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57716141 ORDER BY `minOrder` ASC [ RunTime:0.010735s ]
select * from pdf where partno='40702' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40702' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714495 LIMIT 5 [ RunTime:0.007791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714495 ORDER BY `minOrder` ASC [ RunTime:0.008738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714495 ORDER BY `unit` DESC [ RunTime:0.003639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714495 LIMIT 2 [ RunTime:0.013228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714495 ORDER BY `minOrder` ASC [ RunTime:0.001022s ]
select * from pdf where partno='40706' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40706' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008955s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714495 AND `partno` = '40706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425709 [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57714392 LIMIT 5 [ RunTime:0.002877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714392 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57714392 ORDER BY `unit` DESC [ RunTime:0.012369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57714392 LIMIT 2 [ RunTime:0.043368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57714392 ORDER BY `minOrder` ASC [ RunTime:0.001605s ]
select * from pdf where partno='40708' and brandshort='Brady Corporation' limit 1 [ RunTime:0.021710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40708' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027229s ]
SELECT `id` FROM `stock` WHERE `id` <> 57714392 AND `partno` = '40708' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.032393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556647 [ RunTime:0.037526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57712064 LIMIT 5 [ RunTime:0.008240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712064 ORDER BY `minOrder` ASC [ RunTime:0.007097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57712064 ORDER BY `unit` DESC [ RunTime:0.000647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57712064 LIMIT 2 [ RunTime:0.026646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712064 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
select * from pdf where partno='40705' and brandshort='Brady Corporation' limit 1 [ RunTime:0.056623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40705' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57712059 LIMIT 5 [ RunTime:0.006710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712059 ORDER BY `minOrder` ASC [ RunTime:0.008435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57712059 ORDER BY `unit` DESC [ RunTime:0.004025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57712059 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712059 ORDER BY `minOrder` ASC [ RunTime:0.000798s ]
select * from pdf where partno='40707' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40707' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006665s ]
SELECT `id` FROM `stock` WHERE `id` <> 57712059 AND `partno` = '40707' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424366 [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57712052 LIMIT 5 [ RunTime:0.023843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712052 ORDER BY `minOrder` ASC [ RunTime:0.013864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57712052 ORDER BY `unit` DESC [ RunTime:0.001052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57712052 LIMIT 2 [ RunTime:0.018542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712052 ORDER BY `minOrder` ASC [ RunTime:0.013627s ]
select * from pdf where partno='40709' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40709' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.014922s ]
SELECT `id` FROM `stock` WHERE `id` <> 57712052 AND `partno` = '40709' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.020495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555290 [ RunTime:0.019880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57704054 LIMIT 5 [ RunTime:0.008459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57704054 ORDER BY `minOrder` ASC [ RunTime:0.009672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57704054 ORDER BY `unit` DESC [ RunTime:0.008788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57704054 LIMIT 2 [ RunTime:0.010193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57704054 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='4070-H' and brandshort='Brady Corporation' limit 1 [ RunTime:0.011843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070-H' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001106s ]
SELECT `id` FROM `stock` WHERE `id` <> 57704054 AND `partno` = '4070-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457974 [ RunTime:0.001983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703753 LIMIT 5 [ RunTime:0.006995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703753 ORDER BY `minOrder` ASC [ RunTime:0.007742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703753 ORDER BY `unit` DESC [ RunTime:0.004478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703753 LIMIT 2 [ RunTime:0.029895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703753 ORDER BY `minOrder` ASC [ RunTime:0.014114s ]
select * from pdf where partno='4070-G' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070-G' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016909s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703753 AND `partno` = '4070-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457777 [ RunTime:0.002191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57703541 LIMIT 5 [ RunTime:0.003155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703541 ORDER BY `minOrder` ASC [ RunTime:0.001263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57703541 ORDER BY `unit` DESC [ RunTime:0.010650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57703541 LIMIT 2 [ RunTime:0.014975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57703541 ORDER BY `minOrder` ASC [ RunTime:0.014317s ]
select * from pdf where partno='4070-F' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4070-F' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007458s ]
SELECT `id` FROM `stock` WHERE `id` <> 57703541 AND `partno` = '4070-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.039945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457545 [ RunTime:0.022743s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028347s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024283s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014117s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010429s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020601s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017777s ]
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 '4070%' OR `brand` LIKE '4070%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025378s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4070%' OR `brand` LIKE '4070%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011435s ]