SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001208s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=80326&search=1' [ RunTime:0.004346s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003472s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000742s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003462s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000517s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002413s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002294s ]
SELECT * FROM `stock_search` WHERE `partno` = '80326' LIMIT 1 [ RunTime:0.004048s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 12:36:19' WHERE `partno` = '80326' [ RunTime:0.004139s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003370s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004795s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343770 LIMIT 5 [ RunTime:0.000706s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343770 ORDER BY `minOrder` ASC [ RunTime:0.002742s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343770 ORDER BY `unit` DESC [ RunTime:0.001243s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343770 LIMIT 2 [ RunTime:0.006440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343770 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343961 LIMIT 5 [ RunTime:0.005475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343961 ORDER BY `minOrder` ASC [ RunTime:0.006031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343961 ORDER BY `unit` DESC [ RunTime:0.028894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343961 LIMIT 2 [ RunTime:0.010060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343961 ORDER BY `minOrder` ASC [ RunTime:0.005936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15261932 LIMIT 5 [ RunTime:0.012567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261932 ORDER BY `minOrder` ASC [ RunTime:0.020628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15261932 ORDER BY `unit` DESC [ RunTime:0.013972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15261932 LIMIT 2 [ RunTime:0.006249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261932 ORDER BY `minOrder` ASC [ RunTime:0.006425s ]
select * from pdf where partno='803268' and brandshort='Bergquist' limit 1 [ RunTime:0.005787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044814 LIMIT 5 [ RunTime:0.009937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044814 ORDER BY `minOrder` ASC [ RunTime:0.007899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17044814 ORDER BY `unit` DESC [ RunTime:0.005206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17044814 LIMIT 2 [ RunTime:0.007639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044814 ORDER BY `minOrder` ASC [ RunTime:0.001628s ]
select * from pdf where partno='803266' and brandshort='Bergquist' limit 1 [ RunTime:0.008422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961870 LIMIT 5 [ RunTime:0.009419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961870 ORDER BY `minOrder` ASC [ RunTime:0.008111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18961870 ORDER BY `unit` DESC [ RunTime:0.009013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18961870 LIMIT 2 [ RunTime:0.019262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961870 ORDER BY `minOrder` ASC [ RunTime:0.008473s ]
select * from pdf where partno='803263' and brandshort='Bergquist' limit 1 [ RunTime:0.008193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961869 LIMIT 5 [ RunTime:0.008479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961869 ORDER BY `minOrder` ASC [ RunTime:0.028627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18961869 ORDER BY `unit` DESC [ RunTime:0.016836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18961869 LIMIT 2 [ RunTime:0.029251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961869 ORDER BY `minOrder` ASC [ RunTime:0.003500s ]
select * from pdf where partno='803261' and brandshort='Bergquist' limit 1 [ RunTime:0.010306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044843 LIMIT 5 [ RunTime:0.031051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044843 ORDER BY `minOrder` ASC [ RunTime:0.033481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17044843 ORDER BY `unit` DESC [ RunTime:0.017414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17044843 LIMIT 2 [ RunTime:0.015077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044843 ORDER BY `minOrder` ASC [ RunTime:0.002409s ]
select * from pdf where partno='803269' and brandshort='Bergquist' limit 1 [ RunTime:0.021791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044842 LIMIT 5 [ RunTime:0.016948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044842 ORDER BY `minOrder` ASC [ RunTime:0.019537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17044842 ORDER BY `unit` DESC [ RunTime:0.007402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17044842 LIMIT 2 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044842 ORDER BY `minOrder` ASC [ RunTime:0.000612s ]
select * from pdf where partno='803267' and brandshort='Bergquist' limit 1 [ RunTime:0.006851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14195240 LIMIT 5 [ RunTime:0.009843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14195240 ORDER BY `minOrder` ASC [ RunTime:0.009202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14195240 ORDER BY `unit` DESC [ RunTime:0.003900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14195240 LIMIT 2 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14195240 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='803265' and brandshort='Bergquist' limit 1 [ RunTime:0.001054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14195228 LIMIT 5 [ RunTime:0.011039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14195228 ORDER BY `minOrder` ASC [ RunTime:0.002558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14195228 ORDER BY `unit` DESC [ RunTime:0.007096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14195228 LIMIT 2 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14195228 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='803262' and brandshort='Bergquist' limit 1 [ RunTime:0.000986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12181133 LIMIT 5 [ RunTime:0.006455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12181133 ORDER BY `minOrder` ASC [ RunTime:0.001774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12181133 ORDER BY `unit` DESC [ RunTime:0.007928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12181133 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12181133 ORDER BY `minOrder` ASC [ RunTime:0.002287s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003830s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755140 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755140 ORDER BY `minOrder` ASC [ RunTime:0.010589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755140 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755140 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755140 ORDER BY `minOrder` ASC [ RunTime:0.008115s ]
select * from pdf where partno='80326CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006855s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80326CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.030054s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755140 AND `partno` = '80326CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343770 [ RunTime:0.000828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51272903 LIMIT 5 [ RunTime:0.005612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51272903 ORDER BY `minOrder` ASC [ RunTime:0.010723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51272903 ORDER BY `unit` DESC [ RunTime:0.003731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51272903 LIMIT 2 [ RunTime:0.019326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51272903 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='803268' and brandshort='Bergquist' limit 1 [ RunTime:0.000641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803268' OR `brand` LIKE 'Bergquist%' ) ) LIMIT 1 [ RunTime:0.009044s ]
SELECT `id` FROM `stock` WHERE `id` <> 51272903 AND `partno` = '803268' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bergquist%' ) [ RunTime:0.008097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15261932 [ RunTime:0.001662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57962592 LIMIT 5 [ RunTime:0.007927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57962592 ORDER BY `minOrder` ASC [ RunTime:0.009505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57962592 ORDER BY `unit` DESC [ RunTime:0.000740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57962592 LIMIT 2 [ RunTime:0.000794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57962592 ORDER BY `minOrder` ASC [ RunTime:0.028003s ]
select * from pdf where partno='803266' and brandshort='Amphenol i2s' limit 1 [ RunTime:0.003430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803266' OR `brand` LIKE 'Amphenol i2s%' ) ) LIMIT 1 [ RunTime:0.009089s ]
SELECT `id` FROM `stock` WHERE `id` <> 57962592 AND `partno` = '803266' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol i2s%' ) [ RunTime:0.001350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57962591 LIMIT 5 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57962591 ORDER BY `minOrder` ASC [ RunTime:0.003980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57962591 ORDER BY `unit` DESC [ RunTime:0.004324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57962591 LIMIT 2 [ RunTime:0.005775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57962591 ORDER BY `minOrder` ASC [ RunTime:0.001465s ]
select * from pdf where partno='803265' and brandshort='Amphenol i2s' limit 1 [ RunTime:0.005624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803265' OR `brand` LIKE 'Amphenol i2s%' ) ) LIMIT 1 [ RunTime:0.008299s ]
SELECT `id` FROM `stock` WHERE `id` <> 57962591 AND `partno` = '803265' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol i2s%' ) [ RunTime:0.006328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57962590 LIMIT 5 [ RunTime:0.011804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57962590 ORDER BY `minOrder` ASC [ RunTime:0.001008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57962590 ORDER BY `unit` DESC [ RunTime:0.001557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57962590 LIMIT 2 [ RunTime:0.005886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57962590 ORDER BY `minOrder` ASC [ RunTime:0.011458s ]
select * from pdf where partno='803267' and brandshort='Amphenol i2s' limit 1 [ RunTime:0.012310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803267' OR `brand` LIKE 'Amphenol i2s%' ) ) LIMIT 1 [ RunTime:0.006921s ]
SELECT `id` FROM `stock` WHERE `id` <> 57962590 AND `partno` = '803267' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol i2s%' ) [ RunTime:0.029490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51272900 LIMIT 5 [ RunTime:0.034245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51272900 ORDER BY `minOrder` ASC [ RunTime:0.023049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51272900 ORDER BY `unit` DESC [ RunTime:0.131888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51272900 LIMIT 2 [ RunTime:0.010465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51272900 ORDER BY `minOrder` ASC [ RunTime:0.011477s ]
select * from pdf where partno='803266' and brandshort='Bergquist' limit 1 [ RunTime:0.010013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803266' OR `brand` LIKE 'Bergquist%' ) ) LIMIT 1 [ RunTime:0.028485s ]
SELECT `id` FROM `stock` WHERE `id` <> 51272900 AND `partno` = '803266' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bergquist%' ) [ RunTime:0.009695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044814 [ RunTime:0.040744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57756495 LIMIT 5 [ RunTime:0.013562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756495 ORDER BY `minOrder` ASC [ RunTime:0.042852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57756495 ORDER BY `unit` DESC [ RunTime:0.010201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57756495 LIMIT 2 [ RunTime:0.016783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756495 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
select * from pdf where partno='80326SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.021719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80326SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010277s ]
SELECT `id` FROM `stock` WHERE `id` <> 57756495 AND `partno` = '80326SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343961 [ RunTime:0.019992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51708765 LIMIT 5 [ RunTime:0.011771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51708765 ORDER BY `minOrder` ASC [ RunTime:0.048966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51708765 ORDER BY `unit` DESC [ RunTime:0.014333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51708765 LIMIT 2 [ RunTime:0.032307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51708765 ORDER BY `minOrder` ASC [ RunTime:0.017636s ]
select * from pdf where partno='80326' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.013502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80326' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.009810s ]
SELECT `id` FROM `stock` WHERE `id` <> 51708765 AND `partno` = '80326' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.018458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12181133 [ RunTime:0.016003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51273060 LIMIT 5 [ RunTime:0.026535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51273060 ORDER BY `minOrder` ASC [ RunTime:0.019969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51273060 ORDER BY `unit` DESC [ RunTime:0.030255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51273060 LIMIT 2 [ RunTime:0.033022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51273060 ORDER BY `minOrder` ASC [ RunTime:0.006559s ]
select * from pdf where partno='803269' and brandshort='Bergquist' limit 1 [ RunTime:0.017232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803269' OR `brand` LIKE 'Bergquist%' ) ) LIMIT 1 [ RunTime:0.018187s ]
SELECT `id` FROM `stock` WHERE `id` <> 51273060 AND `partno` = '803269' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bergquist%' ) [ RunTime:0.014881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044843 [ RunTime:0.043847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51273057 LIMIT 5 [ RunTime:0.062109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51273057 ORDER BY `minOrder` ASC [ RunTime:0.033180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51273057 ORDER BY `unit` DESC [ RunTime:0.031357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51273057 LIMIT 2 [ RunTime:0.021525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51273057 ORDER BY `minOrder` ASC [ RunTime:0.018109s ]
select * from pdf where partno='803267' and brandshort='Bergquist' limit 1 [ RunTime:0.022108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803267' OR `brand` LIKE 'Bergquist%' ) ) LIMIT 1 [ RunTime:0.015236s ]
SELECT `id` FROM `stock` WHERE `id` <> 51273057 AND `partno` = '803267' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bergquist%' ) [ RunTime:0.050855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044842 [ RunTime:0.044367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51273056 LIMIT 5 [ RunTime:0.010656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51273056 ORDER BY `minOrder` ASC [ RunTime:0.030416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51273056 ORDER BY `unit` DESC [ RunTime:0.014066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51273056 LIMIT 2 [ RunTime:0.068027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51273056 ORDER BY `minOrder` ASC [ RunTime:0.017891s ]
select * from pdf where partno='803265' and brandshort='Bergquist' limit 1 [ RunTime:0.006073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803265' OR `brand` LIKE 'Bergquist%' ) ) LIMIT 1 [ RunTime:0.030332s ]
SELECT `id` FROM `stock` WHERE `id` <> 51273056 AND `partno` = '803265' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bergquist%' ) [ RunTime:0.025719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14195240 [ RunTime:0.021966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51272943 LIMIT 5 [ RunTime:0.039162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51272943 ORDER BY `minOrder` ASC [ RunTime:0.068088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51272943 ORDER BY `unit` DESC [ RunTime:0.080026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51272943 LIMIT 2 [ RunTime:0.045608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51272943 ORDER BY `minOrder` ASC [ RunTime:0.008299s ]
select * from pdf where partno='803262' and brandshort='Bergquist' limit 1 [ RunTime:0.003477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803262' OR `brand` LIKE 'Bergquist%' ) ) LIMIT 1 [ RunTime:0.023138s ]
SELECT `id` FROM `stock` WHERE `id` <> 51272943 AND `partno` = '803262' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bergquist%' ) [ RunTime:0.020086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14195228 [ RunTime:0.013966s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030982s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037828s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037376s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074568s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043088s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016905s ]
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 '80326%' OR `brand` LIKE '80326%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050345s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '80326%' OR `brand` LIKE '80326%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.032415s ]