SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001203s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047560s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481159 LIMIT 5 [ RunTime:0.038880s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481159 ORDER BY `minOrder` ASC [ RunTime:0.056181s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481159 ORDER BY `unit` DESC [ RunTime:0.010574s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.022188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481159 LIMIT 2 [ RunTime:0.045900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481159 ORDER BY `minOrder` ASC [ RunTime:0.059268s ]
select * from pdf where partno='54025-2022' and brandshort='CNC Tech' limit 1 [ RunTime:0.040641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15493786 LIMIT 5 [ RunTime:0.051253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15493786 ORDER BY `minOrder` ASC [ RunTime:0.085746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15493786 ORDER BY `unit` DESC [ RunTime:0.017517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15493786 LIMIT 2 [ RunTime:0.027480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15493786 ORDER BY `minOrder` ASC [ RunTime:0.041055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481151 LIMIT 5 [ RunTime:0.047594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481151 ORDER BY `minOrder` ASC [ RunTime:0.084532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481151 ORDER BY `unit` DESC [ RunTime:0.100729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481151 LIMIT 2 [ RunTime:0.055387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481151 ORDER BY `minOrder` ASC [ RunTime:0.032448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16215662 LIMIT 5 [ RunTime:0.070004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16215662 ORDER BY `minOrder` ASC [ RunTime:0.067002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16215662 ORDER BY `unit` DESC [ RunTime:0.042230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16215662 LIMIT 2 [ RunTime:0.030105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16215662 ORDER BY `minOrder` ASC [ RunTime:0.009778s ]
select * from pdf where partno='54025-06-0100-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.041909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850591 LIMIT 5 [ RunTime:0.044937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850591 ORDER BY `minOrder` ASC [ RunTime:0.036623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19850591 ORDER BY `unit` DESC [ RunTime:0.032055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19850591 LIMIT 2 [ RunTime:0.029295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850591 ORDER BY `minOrder` ASC [ RunTime:0.016397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16217766 LIMIT 5 [ RunTime:0.037553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16217766 ORDER BY `minOrder` ASC [ RunTime:0.015728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16217766 ORDER BY `unit` DESC [ RunTime:0.033513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16217766 LIMIT 2 [ RunTime:0.028884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16217766 ORDER BY `minOrder` ASC [ RunTime:0.037350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19815121 LIMIT 5 [ RunTime:0.035565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19815121 ORDER BY `minOrder` ASC [ RunTime:0.047229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19815121 ORDER BY `unit` DESC [ RunTime:0.049671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19815121 LIMIT 2 [ RunTime:0.036371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19815121 ORDER BY `minOrder` ASC [ RunTime:0.015509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19816484 LIMIT 5 [ RunTime:0.012624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816484 ORDER BY `minOrder` ASC [ RunTime:0.014608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19816484 ORDER BY `unit` DESC [ RunTime:0.022495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19816484 LIMIT 2 [ RunTime:0.052856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816484 ORDER BY `minOrder` ASC [ RunTime:0.023067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629219 LIMIT 5 [ RunTime:0.027973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629219 ORDER BY `minOrder` ASC [ RunTime:0.029400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629219 ORDER BY `unit` DESC [ RunTime:0.039244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629219 LIMIT 2 [ RunTime:0.032730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629219 ORDER BY `minOrder` ASC [ RunTime:0.005099s ]
select * from pdf where partno='54025-06' and brandshort='CNC Tech' limit 1 [ RunTime:0.032985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630523 LIMIT 5 [ RunTime:0.090992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630523 ORDER BY `minOrder` ASC [ RunTime:0.048029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630523 ORDER BY `unit` DESC [ RunTime:0.025470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630523 LIMIT 2 [ RunTime:0.029583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630523 ORDER BY `minOrder` ASC [ RunTime:0.013049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486280 LIMIT 5 [ RunTime:0.039510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486280 ORDER BY `minOrder` ASC [ RunTime:0.033288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11486280 ORDER BY `unit` DESC [ RunTime:0.036007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11486280 LIMIT 2 [ RunTime:0.010136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486280 ORDER BY `minOrder` ASC [ RunTime:0.011979s ]
select * from pdf where partno='54025-08' and brandshort='CNC Tech' limit 1 [ RunTime:0.009544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851899 LIMIT 5 [ RunTime:0.005010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851899 ORDER BY `minOrder` ASC [ RunTime:0.029389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851899 ORDER BY `unit` DESC [ RunTime:0.021516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851899 LIMIT 2 [ RunTime:0.017899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851899 ORDER BY `minOrder` ASC [ RunTime:0.001419s ]
select * from pdf where partno='54025-08-0100-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.017819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11927045 LIMIT 5 [ RunTime:0.032740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927045 ORDER BY `minOrder` ASC [ RunTime:0.004239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11927045 ORDER BY `unit` DESC [ RunTime:0.013315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11927045 LIMIT 2 [ RunTime:0.016669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927045 ORDER BY `minOrder` ASC [ RunTime:0.003161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19818093 LIMIT 5 [ RunTime:0.005491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19818093 ORDER BY `minOrder` ASC [ RunTime:0.034445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19818093 ORDER BY `unit` DESC [ RunTime:0.017819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19818093 LIMIT 2 [ RunTime:0.014293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19818093 ORDER BY `minOrder` ASC [ RunTime:0.000651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12386411 LIMIT 5 [ RunTime:0.021440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12386411 ORDER BY `minOrder` ASC [ RunTime:0.000747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12386411 ORDER BY `unit` DESC [ RunTime:0.002491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12386411 LIMIT 2 [ RunTime:0.007850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12386411 ORDER BY `minOrder` ASC [ RunTime:0.019703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379610 LIMIT 5 [ RunTime:0.016862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379610 ORDER BY `minOrder` ASC [ RunTime:0.004480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14379610 ORDER BY `unit` DESC [ RunTime:0.003274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14379610 LIMIT 2 [ RunTime:0.001387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379610 ORDER BY `minOrder` ASC [ RunTime:0.007244s ]
select * from pdf where partno='5402FE 008500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.006788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187273 LIMIT 5 [ RunTime:0.013925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187273 ORDER BY `minOrder` ASC [ RunTime:0.007631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187273 ORDER BY `unit` DESC [ RunTime:0.004050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187273 LIMIT 2 [ RunTime:0.005673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187273 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494481 LIMIT 5 [ RunTime:0.018906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494481 ORDER BY `minOrder` ASC [ RunTime:0.001601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13494481 ORDER BY `unit` DESC [ RunTime:0.007730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13494481 LIMIT 2 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494481 ORDER BY `minOrder` ASC [ RunTime:0.005515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12064188 LIMIT 5 [ RunTime:0.020783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12064188 ORDER BY `minOrder` ASC [ RunTime:0.007678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12064188 ORDER BY `unit` DESC [ RunTime:0.004290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12064188 LIMIT 2 [ RunTime:0.012768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12064188 ORDER BY `minOrder` ASC [ RunTime:0.014292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385164 LIMIT 5 [ RunTime:0.020529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385164 ORDER BY `minOrder` ASC [ RunTime:0.039314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385164 ORDER BY `unit` DESC [ RunTime:0.021397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385164 LIMIT 2 [ RunTime:0.015531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385164 ORDER BY `minOrder` ASC [ RunTime:0.012789s ]
select * from pdf where partno='5402FE 008U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.010934s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095144 LIMIT 5 [ RunTime:0.013892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095144 ORDER BY `minOrder` ASC [ RunTime:0.031330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095144 ORDER BY `unit` DESC [ RunTime:0.020097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095144 LIMIT 2 [ RunTime:0.004453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095144 ORDER BY `minOrder` ASC [ RunTime:0.019981s ]
select * from pdf where partno='5402' and brandshort='scs' limit 1 [ RunTime:0.026650s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402' OR `brand` LIKE 'scs%' ) ) LIMIT 1 [ RunTime:0.012915s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095144 AND `partno` = '5402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.018603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12386411 [ RunTime:0.026316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137390 LIMIT 5 [ RunTime:0.027864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137390 ORDER BY `minOrder` ASC [ RunTime:0.018296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137390 ORDER BY `unit` DESC [ RunTime:0.011966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137390 LIMIT 2 [ RunTime:0.027176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137390 ORDER BY `minOrder` ASC [ RunTime:0.005196s ]
select * from pdf where partno='5402fe 008500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.021863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402fe 008500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.012958s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137390 AND `partno` = '5402fe 008500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.019914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137777 LIMIT 5 [ RunTime:0.017405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137777 ORDER BY `minOrder` ASC [ RunTime:0.058524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137777 ORDER BY `unit` DESC [ RunTime:0.018858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137777 LIMIT 2 [ RunTime:0.049241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137777 ORDER BY `minOrder` ASC [ RunTime:0.030833s ]
select * from pdf where partno='5402ue 008u1000' and brandshort='belden wire & cable' limit 1 [ RunTime:0.048862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402ue 008u1000' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.015153s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137777 AND `partno` = '5402ue 008u1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.102220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137034 LIMIT 5 [ RunTime:0.012190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137034 ORDER BY `minOrder` ASC [ RunTime:0.037434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137034 ORDER BY `unit` DESC [ RunTime:0.007930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137034 LIMIT 2 [ RunTime:0.026290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137034 ORDER BY `minOrder` ASC [ RunTime:0.035788s ]
select * from pdf where partno='5402fe 008u500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.033838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402fe 008u500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.027992s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137034 AND `partno` = '5402fe 008u500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.028851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137391 LIMIT 5 [ RunTime:0.029400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137391 ORDER BY `minOrder` ASC [ RunTime:0.035076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137391 ORDER BY `unit` DESC [ RunTime:0.061311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137391 LIMIT 2 [ RunTime:0.026693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137391 ORDER BY `minOrder` ASC [ RunTime:0.059940s ]
select * from pdf where partno='5402fe 008u1000' and brandshort='belden wire & cable' limit 1 [ RunTime:0.046873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402fe 008u1000' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.042082s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137391 AND `partno` = '5402fe 008u1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.034397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32308821 LIMIT 5 [ RunTime:0.037376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32308821 ORDER BY `minOrder` ASC [ RunTime:0.019394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32308821 ORDER BY `unit` DESC [ RunTime:0.029561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32308821 LIMIT 2 [ RunTime:0.026478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32308821 ORDER BY `minOrder` ASC [ RunTime:0.017700s ]
select * from pdf where partno='5402-rmg4-glb' and brandshort='digi' limit 1 [ RunTime:0.016974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402-rmg4-glb' OR `brand` LIKE 'digi%' ) ) LIMIT 1 [ RunTime:0.022195s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60345086 LIMIT 5 [ RunTime:0.005289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345086 ORDER BY `minOrder` ASC [ RunTime:0.010529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60345086 ORDER BY `unit` DESC [ RunTime:0.019685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60345086 LIMIT 2 [ RunTime:0.002649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345086 ORDER BY `minOrder` ASC [ RunTime:0.013478s ]
select * from pdf where partno='54025-2022' and brandshort='CNC Tech' limit 1 [ RunTime:0.002579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-2022' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.009697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62996673 LIMIT 5 [ RunTime:0.008964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62996673 ORDER BY `minOrder` ASC [ RunTime:0.014752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62996673 ORDER BY `unit` DESC [ RunTime:0.001639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62996673 LIMIT 2 [ RunTime:0.002996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62996673 ORDER BY `minOrder` ASC [ RunTime:0.005985s ]
select * from pdf where partno='5402UE 008U1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402UE 008U1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.007275s ]
SELECT `id` FROM `stock` WHERE `id` <> 62996673 AND `partno` = '5402UE 008U1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.009731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494481 [ RunTime:0.005373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60345091 LIMIT 5 [ RunTime:0.005350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345091 ORDER BY `minOrder` ASC [ RunTime:0.016846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60345091 ORDER BY `unit` DESC [ RunTime:0.011068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60345091 LIMIT 2 [ RunTime:0.018011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345091 ORDER BY `minOrder` ASC [ RunTime:0.003331s ]
select * from pdf where partno='54025-2426' and brandshort='CNC Tech' limit 1 [ RunTime:0.001236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-2426' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.004048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448357 LIMIT 5 [ RunTime:0.005012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448357 ORDER BY `minOrder` ASC [ RunTime:0.018711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448357 ORDER BY `unit` DESC [ RunTime:0.003480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448357 LIMIT 2 [ RunTime:0.003178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448357 ORDER BY `minOrder` ASC [ RunTime:0.002891s ]
select * from pdf where partno='54025-08-0100-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.001782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-08-0100-01' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.021235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63490219 LIMIT 5 [ RunTime:0.010260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63490219 ORDER BY `minOrder` ASC [ RunTime:0.005587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63490219 ORDER BY `unit` DESC [ RunTime:0.010237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63490219 LIMIT 2 [ RunTime:0.015145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63490219 ORDER BY `minOrder` ASC [ RunTime:0.001706s ]
select * from pdf where partno='5402' and brandshort='SCS' limit 1 [ RunTime:0.001147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402' OR `brand` LIKE 'SCS%' ) ) LIMIT 1 [ RunTime:0.013557s ]
SELECT `id` FROM `stock` WHERE `id` <> 63490219 AND `partno` = '5402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.002007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12386411 [ RunTime:0.005910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938597 LIMIT 5 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938597 ORDER BY `minOrder` ASC [ RunTime:0.002328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938597 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938597 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938597 ORDER BY `minOrder` ASC [ RunTime:0.004913s ]
select * from pdf where partno='54025-04' and brandshort='CNC Tech' limit 1 [ RunTime:0.001100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-04' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.005799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997080 LIMIT 5 [ RunTime:0.001960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997080 ORDER BY `minOrder` ASC [ RunTime:0.006133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997080 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997080 LIMIT 2 [ RunTime:0.001193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997080 ORDER BY `minOrder` ASC [ RunTime:0.000988s ]
select * from pdf where partno='5402FE 008500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402FE 008500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000746s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997080 AND `partno` = '5402FE 008500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.002885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379610 [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60974460 LIMIT 5 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60974460 ORDER BY `minOrder` ASC [ RunTime:0.008060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60974460 ORDER BY `unit` DESC [ RunTime:0.006452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60974460 LIMIT 2 [ RunTime:0.004883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60974460 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
select * from pdf where partno='54020-32030LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54020-32030LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.011733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442477 LIMIT 5 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442477 ORDER BY `minOrder` ASC [ RunTime:0.008432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442477 ORDER BY `unit` DESC [ RunTime:0.005597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442477 LIMIT 2 [ RunTime:0.007402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442477 ORDER BY `minOrder` ASC [ RunTime:0.001775s ]
select * from pdf where partno='54025-04-0200-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.004340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-04-0200-01' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.006922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442415 LIMIT 5 [ RunTime:0.010988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442415 ORDER BY `minOrder` ASC [ RunTime:0.009923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442415 ORDER BY `unit` DESC [ RunTime:0.001685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442415 LIMIT 2 [ RunTime:0.004808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442415 ORDER BY `minOrder` ASC [ RunTime:0.018404s ]
select * from pdf where partno='54025-04-0100-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.017350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-04-0100-01' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.009986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63007381 LIMIT 5 [ RunTime:0.009816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007381 ORDER BY `minOrder` ASC [ RunTime:0.008143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63007381 ORDER BY `unit` DESC [ RunTime:0.013629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63007381 LIMIT 2 [ RunTime:0.014239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007381 ORDER BY `minOrder` ASC [ RunTime:0.003814s ]
select * from pdf where partno='5402FE 008U1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.009406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402FE 008U1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.008945s ]
SELECT `id` FROM `stock` WHERE `id` <> 63007381 AND `partno` = '5402FE 008U1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.001362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495501 [ RunTime:0.020412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59542206 LIMIT 5 [ RunTime:0.009746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542206 ORDER BY `minOrder` ASC [ RunTime:0.007730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59542206 ORDER BY `unit` DESC [ RunTime:0.007222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59542206 LIMIT 2 [ RunTime:0.020596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542206 ORDER BY `minOrder` ASC [ RunTime:0.014030s ]
select * from pdf where partno='54025-06-0200-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.014196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-06-0200-01' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.029872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59949884 LIMIT 5 [ RunTime:0.013944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59949884 ORDER BY `minOrder` ASC [ RunTime:0.025788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59949884 ORDER BY `unit` DESC [ RunTime:0.048066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59949884 LIMIT 2 [ RunTime:0.009738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59949884 ORDER BY `minOrder` ASC [ RunTime:0.010612s ]
select * from pdf where partno='54025-06' and brandshort='CNC Tech' limit 1 [ RunTime:0.007311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-06' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.005815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62996881 LIMIT 5 [ RunTime:0.019465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62996881 ORDER BY `minOrder` ASC [ RunTime:0.026826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62996881 ORDER BY `unit` DESC [ RunTime:0.014712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62996881 LIMIT 2 [ RunTime:0.009789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62996881 ORDER BY `minOrder` ASC [ RunTime:0.001358s ]
select * from pdf where partno='5402FE 008U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402FE 008U500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.011261s ]
SELECT `id` FROM `stock` WHERE `id` <> 62996881 AND `partno` = '5402FE 008U500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.007950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385164 [ RunTime:0.013212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59949917 LIMIT 5 [ RunTime:0.011043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59949917 ORDER BY `minOrder` ASC [ RunTime:0.010721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59949917 ORDER BY `unit` DESC [ RunTime:0.005085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59949917 LIMIT 2 [ RunTime:0.003166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59949917 ORDER BY `minOrder` ASC [ RunTime:0.001673s ]
select * from pdf where partno='54025-10' and brandshort='CNC Tech' limit 1 [ RunTime:0.009274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025-10' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.005028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64413322 LIMIT 5 [ RunTime:0.012015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64413322 ORDER BY `minOrder` ASC [ RunTime:0.009383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64413322 ORDER BY `unit` DESC [ RunTime:0.014409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64413322 LIMIT 2 [ RunTime:0.009610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64413322 ORDER BY `minOrder` ASC [ RunTime:0.004758s ]
select * from pdf where partno='5402' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.006960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.017395s ]
SELECT `id` FROM `stock` WHERE `id` <> 64413322 AND `partno` = '5402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.031638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373960 [ RunTime:0.006990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64575860 LIMIT 5 [ RunTime:0.005005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64575860 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64575860 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64575860 LIMIT 2 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64575860 ORDER BY `minOrder` ASC [ RunTime:0.005326s ]
select * from pdf where partno='5402CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004493s ]
SELECT `id` FROM `stock` WHERE `id` <> 64575860 AND `partno` = '5402CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12064188 [ RunTime:0.005404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58041237 LIMIT 5 [ RunTime:0.003039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041237 ORDER BY `minOrder` ASC [ RunTime:0.001312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58041237 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58041237 LIMIT 2 [ RunTime:0.001391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041237 ORDER BY `minOrder` ASC [ RunTime:0.001608s ]
select * from pdf where partno='5402' and brandshort='Knowles Johanson Manufacturing' limit 1 [ RunTime:0.004293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402' OR `brand` LIKE 'Knowles Johanson Manufacturing%' ) ) LIMIT 1 [ RunTime:0.001516s ]
SELECT `id` FROM `stock` WHERE `id` <> 58041237 AND `partno` = '5402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles johanson manufacturing%' ) [ RunTime:0.000945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17758172 [ RunTime:0.002997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000838 LIMIT 5 [ RunTime:0.031257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000838 ORDER BY `minOrder` ASC [ RunTime:0.003095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000838 ORDER BY `unit` DESC [ RunTime:0.018209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000838 LIMIT 2 [ RunTime:0.019614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000838 ORDER BY `minOrder` ASC [ RunTime:0.006924s ]
select * from pdf where partno='5402 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5402 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002480s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000838 AND `partno` = '5402 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514887 [ RunTime:0.008054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58581934 LIMIT 5 [ RunTime:0.040064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58581934 ORDER BY `minOrder` ASC [ RunTime:0.013962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58581934 ORDER BY `unit` DESC [ RunTime:0.013666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58581934 LIMIT 2 [ RunTime:0.009417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58581934 ORDER BY `minOrder` ASC [ RunTime:0.013271s ]
select * from pdf where partno='54025' and brandshort='Wiha' limit 1 [ RunTime:0.018411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54025' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.015833s ]
SELECT `id` FROM `stock` WHERE `id` <> 58581934 AND `partno` = '54025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.008416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11182917 [ RunTime:0.032399s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030617s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012483s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019770s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006023s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012290s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014339s ]
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 '5402%' OR `brand` LIKE '5402%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014982s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5402%' OR `brand` LIKE '5402%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023591s ]