SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001328s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007127s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047517 LIMIT 5 [ RunTime:0.009929s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047517 ORDER BY `minOrder` ASC [ RunTime:0.010162s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12047517 ORDER BY `unit` DESC [ RunTime:0.013535s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12047517 LIMIT 2 [ RunTime:0.007518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047517 ORDER BY `minOrder` ASC [ RunTime:0.003121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17513132 LIMIT 5 [ RunTime:0.007364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17513132 ORDER BY `minOrder` ASC [ RunTime:0.012184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17513132 ORDER BY `unit` DESC [ RunTime:0.036805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17513132 LIMIT 2 [ RunTime:0.022765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17513132 ORDER BY `minOrder` ASC [ RunTime:0.010021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842969 LIMIT 5 [ RunTime:0.011503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842969 ORDER BY `minOrder` ASC [ RunTime:0.020197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842969 ORDER BY `unit` DESC [ RunTime:0.079282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842969 LIMIT 2 [ RunTime:0.025885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842969 ORDER BY `minOrder` ASC [ RunTime:0.007427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842968 LIMIT 5 [ RunTime:0.026534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842968 ORDER BY `minOrder` ASC [ RunTime:0.030686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842968 ORDER BY `unit` DESC [ RunTime:0.044714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842968 LIMIT 2 [ RunTime:0.037901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842968 ORDER BY `minOrder` ASC [ RunTime:0.007093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842925 LIMIT 5 [ RunTime:0.015623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842925 ORDER BY `minOrder` ASC [ RunTime:0.042731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842925 ORDER BY `unit` DESC [ RunTime:0.019128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842925 LIMIT 2 [ RunTime:0.022185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842925 ORDER BY `minOrder` ASC [ RunTime:0.027949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842895 LIMIT 5 [ RunTime:0.030959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842895 ORDER BY `minOrder` ASC [ RunTime:0.013758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842895 ORDER BY `unit` DESC [ RunTime:0.026717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842895 LIMIT 2 [ RunTime:0.043074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842895 ORDER BY `minOrder` ASC [ RunTime:0.023749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842894 LIMIT 5 [ RunTime:0.039558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842894 ORDER BY `minOrder` ASC [ RunTime:0.048982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842894 ORDER BY `unit` DESC [ RunTime:0.013902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842894 LIMIT 2 [ RunTime:0.061792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842894 ORDER BY `minOrder` ASC [ RunTime:0.046804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842861 LIMIT 5 [ RunTime:0.037621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842861 ORDER BY `minOrder` ASC [ RunTime:0.053683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842861 ORDER BY `unit` DESC [ RunTime:0.033624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842861 LIMIT 2 [ RunTime:0.035041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842861 ORDER BY `minOrder` ASC [ RunTime:0.017030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842860 LIMIT 5 [ RunTime:0.008005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842860 ORDER BY `minOrder` ASC [ RunTime:0.023346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842860 ORDER BY `unit` DESC [ RunTime:0.011952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842860 LIMIT 2 [ RunTime:0.037382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842860 ORDER BY `minOrder` ASC [ RunTime:0.026102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842845 LIMIT 5 [ RunTime:0.035496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842845 ORDER BY `minOrder` ASC [ RunTime:0.027897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842845 ORDER BY `unit` DESC [ RunTime:0.006351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842845 LIMIT 2 [ RunTime:0.019418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842845 ORDER BY `minOrder` ASC [ RunTime:0.011055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842843 LIMIT 5 [ RunTime:0.041426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842843 ORDER BY `minOrder` ASC [ RunTime:0.022639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842843 ORDER BY `unit` DESC [ RunTime:0.007214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842843 LIMIT 2 [ RunTime:0.012847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842843 ORDER BY `minOrder` ASC [ RunTime:0.006488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842841 LIMIT 5 [ RunTime:0.028604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842841 ORDER BY `minOrder` ASC [ RunTime:0.017761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842841 ORDER BY `unit` DESC [ RunTime:0.040664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842841 LIMIT 2 [ RunTime:0.008509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842841 ORDER BY `minOrder` ASC [ RunTime:0.018712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842837 LIMIT 5 [ RunTime:0.025209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842837 ORDER BY `minOrder` ASC [ RunTime:0.020386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842837 ORDER BY `unit` DESC [ RunTime:0.034428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842837 LIMIT 2 [ RunTime:0.012640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842837 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842782 LIMIT 5 [ RunTime:0.009726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842782 ORDER BY `minOrder` ASC [ RunTime:0.022186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842782 ORDER BY `unit` DESC [ RunTime:0.010928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842782 LIMIT 2 [ RunTime:0.009775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842782 ORDER BY `minOrder` ASC [ RunTime:0.003076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17023042 LIMIT 5 [ RunTime:0.030575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17023042 ORDER BY `minOrder` ASC [ RunTime:0.018537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17023042 ORDER BY `unit` DESC [ RunTime:0.024226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17023042 LIMIT 2 [ RunTime:0.012316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17023042 ORDER BY `minOrder` ASC [ RunTime:0.003638s ]
select * from pdf where partno='96063009' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.033998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431500 LIMIT 5 [ RunTime:0.052132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431500 ORDER BY `minOrder` ASC [ RunTime:0.011252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431500 ORDER BY `unit` DESC [ RunTime:0.037117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431500 LIMIT 2 [ RunTime:0.035957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431500 ORDER BY `minOrder` ASC [ RunTime:0.007650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430639 LIMIT 5 [ RunTime:0.014123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430639 ORDER BY `minOrder` ASC [ RunTime:0.042810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430639 ORDER BY `unit` DESC [ RunTime:0.040452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430639 LIMIT 2 [ RunTime:0.026190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430639 ORDER BY `minOrder` ASC [ RunTime:0.019369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430638 LIMIT 5 [ RunTime:0.024177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430638 ORDER BY `minOrder` ASC [ RunTime:0.012329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430638 ORDER BY `unit` DESC [ RunTime:0.036014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430638 LIMIT 2 [ RunTime:0.005651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430638 ORDER BY `minOrder` ASC [ RunTime:0.010714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430496 LIMIT 5 [ RunTime:0.024885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430496 ORDER BY `minOrder` ASC [ RunTime:0.021872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430496 ORDER BY `unit` DESC [ RunTime:0.011409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430496 LIMIT 2 [ RunTime:0.015723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430496 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430495 LIMIT 5 [ RunTime:0.007910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430495 ORDER BY `minOrder` ASC [ RunTime:0.017823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430495 ORDER BY `unit` DESC [ RunTime:0.036475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430495 LIMIT 2 [ RunTime:0.040840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430495 ORDER BY `minOrder` ASC [ RunTime:0.025237s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021920s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63372518 LIMIT 5 [ RunTime:0.050934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63372518 ORDER BY `minOrder` ASC [ RunTime:0.010792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63372518 ORDER BY `unit` DESC [ RunTime:0.021577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63372518 LIMIT 2 [ RunTime:0.030404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63372518 ORDER BY `minOrder` ASC [ RunTime:0.018698s ]
select * from pdf where partno='9606' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.060747s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9606' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.060362s ]
SELECT `id` FROM `stock` WHERE `id` <> 63372518 AND `partno` = '9606' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.037974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047517 [ RunTime:0.042273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63524368 LIMIT 5 [ RunTime:0.023651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524368 ORDER BY `minOrder` ASC [ RunTime:0.064874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63524368 ORDER BY `unit` DESC [ RunTime:0.023265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63524368 LIMIT 2 [ RunTime:0.056603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524368 ORDER BY `minOrder` ASC [ RunTime:0.008130s ]
select * from pdf where partno='9606' and brandshort='Triplett' limit 1 [ RunTime:0.045234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9606' OR `brand` LIKE 'Triplett%' ) ) LIMIT 1 [ RunTime:0.017523s ]
SELECT `id` FROM `stock` WHERE `id` <> 63524368 AND `partno` = '9606' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%triplett%' ) [ RunTime:0.046790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17513132 [ RunTime:0.030797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64506806 LIMIT 5 [ RunTime:0.003161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64506806 ORDER BY `minOrder` ASC [ RunTime:0.021323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64506806 ORDER BY `unit` DESC [ RunTime:0.033851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64506806 LIMIT 2 [ RunTime:0.009732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64506806 ORDER BY `minOrder` ASC [ RunTime:0.024153s ]
select * from pdf where partno='96060' and brandshort='Brady Corporation' limit 1 [ RunTime:0.053167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96060' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027038s ]
SELECT `id` FROM `stock` WHERE `id` <> 64506806 AND `partno` = '96060' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.054416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354592 [ RunTime:0.037267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64506401 LIMIT 5 [ RunTime:0.060569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64506401 ORDER BY `minOrder` ASC [ RunTime:0.044986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64506401 ORDER BY `unit` DESC [ RunTime:0.011598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64506401 LIMIT 2 [ RunTime:0.040791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64506401 ORDER BY `minOrder` ASC [ RunTime:0.032405s ]
select * from pdf where partno='96061' and brandshort='Brady Corporation' limit 1 [ RunTime:0.042543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96061' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027464s ]
SELECT `id` FROM `stock` WHERE `id` <> 64506401 AND `partno` = '96061' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354456 [ RunTime:0.017173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64505762 LIMIT 5 [ RunTime:0.012907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64505762 ORDER BY `minOrder` ASC [ RunTime:0.031133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64505762 ORDER BY `unit` DESC [ RunTime:0.048447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64505762 LIMIT 2 [ RunTime:0.021805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64505762 ORDER BY `minOrder` ASC [ RunTime:0.024372s ]
select * from pdf where partno='96062' and brandshort='Brady Corporation' limit 1 [ RunTime:0.032240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96062' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.029248s ]
SELECT `id` FROM `stock` WHERE `id` <> 64505762 AND `partno` = '96062' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.031076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13479275 [ RunTime:0.031526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64447807 LIMIT 5 [ RunTime:0.030687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64447807 ORDER BY `minOrder` ASC [ RunTime:0.031598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64447807 ORDER BY `unit` DESC [ RunTime:0.018265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64447807 LIMIT 2 [ RunTime:0.024840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64447807 ORDER BY `minOrder` ASC [ RunTime:0.003380s ]
select * from pdf where partno='96063009' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.007056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96063009' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.025602s ]
SELECT `id` FROM `stock` WHERE `id` <> 64447807 AND `partno` = '96063009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.040644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17023042 [ RunTime:0.040789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64447713 LIMIT 5 [ RunTime:0.026590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64447713 ORDER BY `minOrder` ASC [ RunTime:0.043322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64447713 ORDER BY `unit` DESC [ RunTime:0.018002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64447713 LIMIT 2 [ RunTime:0.004028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64447713 ORDER BY `minOrder` ASC [ RunTime:0.010075s ]
select * from pdf where partno='96063008' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.038928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96063008' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.030840s ]
SELECT `id` FROM `stock` WHERE `id` <> 64447713 AND `partno` = '96063008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.030680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238037 [ RunTime:0.010335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445169 LIMIT 5 [ RunTime:0.024063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445169 ORDER BY `minOrder` ASC [ RunTime:0.007253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445169 ORDER BY `unit` DESC [ RunTime:0.017270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445169 LIMIT 2 [ RunTime:0.032594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445169 ORDER BY `minOrder` ASC [ RunTime:0.002084s ]
select * from pdf where partno='96069303' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.032701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96069303' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.025713s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445169 AND `partno` = '96069303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.045922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842969 [ RunTime:0.029192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445168 LIMIT 5 [ RunTime:0.005697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445168 ORDER BY `minOrder` ASC [ RunTime:0.062095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445168 ORDER BY `unit` DESC [ RunTime:0.056787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445168 LIMIT 2 [ RunTime:0.028574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445168 ORDER BY `minOrder` ASC [ RunTime:0.018896s ]
select * from pdf where partno='96069401' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.042522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96069401' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.042850s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445168 AND `partno` = '96069401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.031861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842968 [ RunTime:0.007697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445115 LIMIT 5 [ RunTime:0.045698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445115 ORDER BY `minOrder` ASC [ RunTime:0.035522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445115 ORDER BY `unit` DESC [ RunTime:0.012124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445115 LIMIT 2 [ RunTime:0.019557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445115 ORDER BY `minOrder` ASC [ RunTime:0.025070s ]
select * from pdf where partno='96069803' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.012668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96069803' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.006072s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445115 AND `partno` = '96069803' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.025360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842925 [ RunTime:0.055052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445109 LIMIT 5 [ RunTime:0.049724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445109 ORDER BY `minOrder` ASC [ RunTime:0.030152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445109 ORDER BY `unit` DESC [ RunTime:0.052066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445109 LIMIT 2 [ RunTime:0.016902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445109 ORDER BY `minOrder` ASC [ RunTime:0.016842s ]
select * from pdf where partno='96069801' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.021664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96069801' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.008463s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445109 AND `partno` = '96069801' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.032424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842837 [ RunTime:0.005865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445077 LIMIT 5 [ RunTime:0.005555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445077 ORDER BY `minOrder` ASC [ RunTime:0.018334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445077 ORDER BY `unit` DESC [ RunTime:0.002174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445077 LIMIT 2 [ RunTime:0.021338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445077 ORDER BY `minOrder` ASC [ RunTime:0.002677s ]
select * from pdf where partno='96063003' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.010463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96063003' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.007814s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445077 AND `partno` = '96063003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.001129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842895 [ RunTime:0.001612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445076 LIMIT 5 [ RunTime:0.005813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445076 ORDER BY `minOrder` ASC [ RunTime:0.005540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445076 ORDER BY `unit` DESC [ RunTime:0.009892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445076 LIMIT 2 [ RunTime:0.021541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445076 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
select * from pdf where partno='96063007' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.018327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96063007' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.004215s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445076 AND `partno` = '96063007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.011968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842894 [ RunTime:0.016342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445058 LIMIT 5 [ RunTime:0.009008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445058 ORDER BY `minOrder` ASC [ RunTime:0.028430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445058 ORDER BY `unit` DESC [ RunTime:0.014643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445058 LIMIT 2 [ RunTime:0.012222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445058 ORDER BY `minOrder` ASC [ RunTime:0.008584s ]
select * from pdf where partno='96063006' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.002901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96063006' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.006177s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445058 AND `partno` = '96063006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.013426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842861 [ RunTime:0.000644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445057 LIMIT 5 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445057 ORDER BY `minOrder` ASC [ RunTime:0.008981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445057 ORDER BY `unit` DESC [ RunTime:0.018485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445057 LIMIT 2 [ RunTime:0.003193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445057 ORDER BY `minOrder` ASC [ RunTime:0.010528s ]
select * from pdf where partno='96063002' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.014677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96063002' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.014366s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445057 AND `partno` = '96063002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.008516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842860 [ RunTime:0.009107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445045 LIMIT 5 [ RunTime:0.005332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445045 ORDER BY `minOrder` ASC [ RunTime:0.017584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445045 ORDER BY `unit` DESC [ RunTime:0.039501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445045 LIMIT 2 [ RunTime:0.032628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445045 ORDER BY `minOrder` ASC [ RunTime:0.003596s ]
select * from pdf where partno='96069804' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.007335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96069804' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.003794s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445045 AND `partno` = '96069804' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.032954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842845 [ RunTime:0.030766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445042 LIMIT 5 [ RunTime:0.028698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445042 ORDER BY `minOrder` ASC [ RunTime:0.012793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445042 ORDER BY `unit` DESC [ RunTime:0.012334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445042 LIMIT 2 [ RunTime:0.012758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445042 ORDER BY `minOrder` ASC [ RunTime:0.000814s ]
select * from pdf where partno='96069805' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.002504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96069805' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.016940s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445042 AND `partno` = '96069805' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.016848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842843 [ RunTime:0.037062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445041 LIMIT 5 [ RunTime:0.013025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445041 ORDER BY `minOrder` ASC [ RunTime:0.026468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445041 ORDER BY `unit` DESC [ RunTime:0.024447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445041 LIMIT 2 [ RunTime:0.013915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445041 ORDER BY `minOrder` ASC [ RunTime:0.007658s ]
select * from pdf where partno='96063001' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.011049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96063001' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.011643s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445041 AND `partno` = '96063001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842841 [ RunTime:0.000696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445040 LIMIT 5 [ RunTime:0.002181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445040 ORDER BY `minOrder` ASC [ RunTime:0.004589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445040 ORDER BY `unit` DESC [ RunTime:0.021219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445040 LIMIT 2 [ RunTime:0.029248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445040 ORDER BY `minOrder` ASC [ RunTime:0.007804s ]
select * from pdf where partno='96063005' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.018600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96063005' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.014939s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445040 AND `partno` = '96063005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.017419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237566 [ RunTime:0.008820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445028 LIMIT 5 [ RunTime:0.011571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445028 ORDER BY `minOrder` ASC [ RunTime:0.022713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445028 ORDER BY `unit` DESC [ RunTime:0.010620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445028 LIMIT 2 [ RunTime:0.029694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445028 ORDER BY `minOrder` ASC [ RunTime:0.007087s ]
select * from pdf where partno='96069802' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.015756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96069802' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.012203s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445028 AND `partno` = '96069802' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.022524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14185790 [ RunTime:0.011124s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006637s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036443s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019258s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028895s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042290s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020547s ]
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 '9606%' OR `brand` LIKE '9606%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046629s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9606%' OR `brand` LIKE '9606%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.039093s ]