SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001639s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=10596&search=1' [ RunTime:0.002654s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002423s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000585s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002428s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002083s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002291s ]
SELECT * FROM `stock_search` WHERE `partno` = '10596' LIMIT 1 [ RunTime:0.009143s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 17:33:19' WHERE `partno` = '10596' [ RunTime:0.008923s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003839s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019127s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11676939 LIMIT 5 [ RunTime:0.004044s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11676939 ORDER BY `minOrder` ASC [ RunTime:0.004474s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11676939 ORDER BY `unit` DESC [ RunTime:0.002805s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11676939 LIMIT 2 [ RunTime:0.003613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11676939 ORDER BY `minOrder` ASC [ RunTime:0.011009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606409 LIMIT 5 [ RunTime:0.009753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606409 ORDER BY `minOrder` ASC [ RunTime:0.011377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606409 ORDER BY `unit` DESC [ RunTime:0.001536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606409 LIMIT 2 [ RunTime:0.008930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606409 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606261 LIMIT 5 [ RunTime:0.000988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606261 ORDER BY `minOrder` ASC [ RunTime:0.003085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606261 ORDER BY `unit` DESC [ RunTime:0.005466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606261 LIMIT 2 [ RunTime:0.001562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606261 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19620853 LIMIT 5 [ RunTime:0.003171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19620853 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19620853 ORDER BY `unit` DESC [ RunTime:0.006483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19620853 LIMIT 2 [ RunTime:0.002299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19620853 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11676959 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11676959 ORDER BY `minOrder` ASC [ RunTime:0.002043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11676959 ORDER BY `unit` DESC [ RunTime:0.007242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11676959 LIMIT 2 [ RunTime:0.007918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11676959 ORDER BY `minOrder` ASC [ RunTime:0.005971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14689216 LIMIT 5 [ RunTime:0.008712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14689216 ORDER BY `minOrder` ASC [ RunTime:0.005717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14689216 ORDER BY `unit` DESC [ RunTime:0.008755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14689216 LIMIT 2 [ RunTime:0.011580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14689216 ORDER BY `minOrder` ASC [ RunTime:0.002205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13799512 LIMIT 5 [ RunTime:0.005695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13799512 ORDER BY `minOrder` ASC [ RunTime:0.010937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13799512 ORDER BY `unit` DESC [ RunTime:0.001789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13799512 LIMIT 2 [ RunTime:0.004941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13799512 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671808 LIMIT 5 [ RunTime:0.009141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671808 ORDER BY `minOrder` ASC [ RunTime:0.010493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14671808 ORDER BY `unit` DESC [ RunTime:0.004609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14671808 LIMIT 2 [ RunTime:0.009543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671808 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190501 LIMIT 5 [ RunTime:0.002643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190501 ORDER BY `minOrder` ASC [ RunTime:0.007461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190501 ORDER BY `unit` DESC [ RunTime:0.000769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190501 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190501 ORDER BY `minOrder` ASC [ RunTime:0.010307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200687 LIMIT 5 [ RunTime:0.006724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200687 ORDER BY `minOrder` ASC [ RunTime:0.009437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200687 ORDER BY `unit` DESC [ RunTime:0.001762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200687 LIMIT 2 [ RunTime:0.004126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200687 ORDER BY `minOrder` ASC [ RunTime:0.002201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655851 LIMIT 5 [ RunTime:0.006831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655851 ORDER BY `minOrder` ASC [ RunTime:0.005937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19655851 ORDER BY `unit` DESC [ RunTime:0.005794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19655851 LIMIT 2 [ RunTime:0.008766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655851 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606082 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606082 ORDER BY `minOrder` ASC [ RunTime:0.003207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606082 ORDER BY `unit` DESC [ RunTime:0.008988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606082 LIMIT 2 [ RunTime:0.011102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606082 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19094841 LIMIT 5 [ RunTime:0.002097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19094841 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19094841 ORDER BY `unit` DESC [ RunTime:0.006927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19094841 LIMIT 2 [ RunTime:0.004253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19094841 ORDER BY `minOrder` ASC [ RunTime:0.004284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980960 LIMIT 5 [ RunTime:0.002740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980960 ORDER BY `minOrder` ASC [ RunTime:0.005903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980960 ORDER BY `unit` DESC [ RunTime:0.000803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980960 LIMIT 2 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980960 ORDER BY `minOrder` ASC [ RunTime:0.002663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980575 LIMIT 5 [ RunTime:0.001321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980575 ORDER BY `minOrder` ASC [ RunTime:0.017607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980575 ORDER BY `unit` DESC [ RunTime:0.007928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980575 LIMIT 2 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980575 ORDER BY `minOrder` ASC [ RunTime:0.002495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980040 LIMIT 5 [ RunTime:0.002284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980040 ORDER BY `minOrder` ASC [ RunTime:0.004293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980040 ORDER BY `unit` DESC [ RunTime:0.010421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980040 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980040 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979981 LIMIT 5 [ RunTime:0.002212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979981 ORDER BY `minOrder` ASC [ RunTime:0.018936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979981 ORDER BY `unit` DESC [ RunTime:0.017143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979981 LIMIT 2 [ RunTime:0.002820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979981 ORDER BY `minOrder` ASC [ RunTime:0.004034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781912 LIMIT 5 [ RunTime:0.004928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781912 ORDER BY `minOrder` ASC [ RunTime:0.002177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781912 ORDER BY `unit` DESC [ RunTime:0.003641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781912 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781912 ORDER BY `minOrder` ASC [ RunTime:0.002233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780771 LIMIT 5 [ RunTime:0.003119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780771 ORDER BY `minOrder` ASC [ RunTime:0.007076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780771 ORDER BY `unit` DESC [ RunTime:0.018223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780771 LIMIT 2 [ RunTime:0.002086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780771 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775847 LIMIT 5 [ RunTime:0.005034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775847 ORDER BY `minOrder` ASC [ RunTime:0.000736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775847 ORDER BY `unit` DESC [ RunTime:0.016711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775847 LIMIT 2 [ RunTime:0.011888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775847 ORDER BY `minOrder` ASC [ RunTime:0.007057s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003360s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558572 LIMIT 5 [ RunTime:0.006214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558572 ORDER BY `minOrder` ASC [ RunTime:0.005430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558572 ORDER BY `unit` DESC [ RunTime:0.000982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558572 LIMIT 2 [ RunTime:0.004087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558572 ORDER BY `minOrder` ASC [ RunTime:0.012383s ]
select * from pdf where partno='10596CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.008839s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10596CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.005607s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558572 AND `partno` = '10596CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.010143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61911115 LIMIT 5 [ RunTime:0.017771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911115 ORDER BY `minOrder` ASC [ RunTime:0.008205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61911115 ORDER BY `unit` DESC [ RunTime:0.014309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61911115 LIMIT 2 [ RunTime:0.018302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911115 ORDER BY `minOrder` ASC [ RunTime:0.010309s ]
select * from pdf where partno='1059691-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.027943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059691-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.014249s ]
SELECT `id` FROM `stock` WHERE `id` <> 61911115 AND `partno` = '1059691-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.008444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11676959 [ RunTime:0.012926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61910638 LIMIT 5 [ RunTime:0.018630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910638 ORDER BY `minOrder` ASC [ RunTime:0.015888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61910638 ORDER BY `unit` DESC [ RunTime:0.004768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61910638 LIMIT 2 [ RunTime:0.005559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910638 ORDER BY `minOrder` ASC [ RunTime:0.003222s ]
select * from pdf where partno='1059684-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.005789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059684-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.002799s ]
SELECT `id` FROM `stock` WHERE `id` <> 61910638 AND `partno` = '1059684-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.004255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11676939 [ RunTime:0.020046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480981 LIMIT 5 [ RunTime:0.004533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480981 ORDER BY `minOrder` ASC [ RunTime:0.008544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480981 ORDER BY `unit` DESC [ RunTime:0.005168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480981 LIMIT 2 [ RunTime:0.001262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480981 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='1059600000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059600000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011017s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480981 AND `partno` = '1059600000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19620853 [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60489942 LIMIT 5 [ RunTime:0.012131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60489942 ORDER BY `minOrder` ASC [ RunTime:0.003461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60489942 ORDER BY `unit` DESC [ RunTime:0.008608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60489942 LIMIT 2 [ RunTime:0.006861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60489942 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
select * from pdf where partno='1059630000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059630000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003996s ]
SELECT `id` FROM `stock` WHERE `id` <> 60489942 AND `partno` = '1059630000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606082 [ RunTime:0.000730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61915342 LIMIT 5 [ RunTime:0.002167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915342 ORDER BY `minOrder` ASC [ RunTime:0.001038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61915342 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61915342 LIMIT 2 [ RunTime:0.002784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915342 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='1059669-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059669-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001053s ]
SELECT `id` FROM `stock` WHERE `id` <> 61915342 AND `partno` = '1059669-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60489712 LIMIT 5 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60489712 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60489712 ORDER BY `unit` DESC [ RunTime:0.005719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60489712 LIMIT 2 [ RunTime:0.002250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60489712 ORDER BY `minOrder` ASC [ RunTime:0.007399s ]
select * from pdf where partno='1059610000' and brandshort='Weidmüller' limit 1 [ RunTime:0.009113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059610000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.027075s ]
SELECT `id` FROM `stock` WHERE `id` <> 60489712 AND `partno` = '1059610000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606261 [ RunTime:0.003241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60629922 LIMIT 5 [ RunTime:0.001017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629922 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60629922 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60629922 LIMIT 2 [ RunTime:0.003426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629922 ORDER BY `minOrder` ASC [ RunTime:0.002932s ]
select * from pdf where partno='1059660000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059660000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003859s ]
SELECT `id` FROM `stock` WHERE `id` <> 60629922 AND `partno` = '1059660000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62136375 LIMIT 5 [ RunTime:0.008244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62136375 ORDER BY `minOrder` ASC [ RunTime:0.004628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62136375 ORDER BY `unit` DESC [ RunTime:0.000752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62136375 LIMIT 2 [ RunTime:0.002032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62136375 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='1059650150' and brandshort='Weidmüller' limit 1 [ RunTime:0.001229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059650150' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001395s ]
SELECT `id` FROM `stock` WHERE `id` <> 62136375 AND `partno` = '1059650150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671808 [ RunTime:0.006276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62134128 LIMIT 5 [ RunTime:0.004612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134128 ORDER BY `minOrder` ASC [ RunTime:0.002447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62134128 ORDER BY `unit` DESC [ RunTime:0.000661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62134128 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134128 ORDER BY `minOrder` ASC [ RunTime:0.001273s ]
select * from pdf where partno='1059651000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059651000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001387s ]
SELECT `id` FROM `stock` WHERE `id` <> 62134128 AND `partno` = '1059651000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14689216 [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335275 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335275 ORDER BY `minOrder` ASC [ RunTime:0.002419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335275 ORDER BY `unit` DESC [ RunTime:0.002253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335275 LIMIT 2 [ RunTime:0.001316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335275 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='1059645' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059645' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000734s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335275 AND `partno` = '1059645' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190501 [ RunTime:0.003843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335267 LIMIT 5 [ RunTime:0.001551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335267 ORDER BY `minOrder` ASC [ RunTime:0.005862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335267 ORDER BY `unit` DESC [ RunTime:0.000692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335267 LIMIT 2 [ RunTime:0.002616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335267 ORDER BY `minOrder` ASC [ RunTime:0.004290s ]
select * from pdf where partno='1059644' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059644' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001865s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335267 AND `partno` = '1059644' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200687 [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336989 LIMIT 5 [ RunTime:0.003286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336989 ORDER BY `minOrder` ASC [ RunTime:0.002801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336989 ORDER BY `unit` DESC [ RunTime:0.002326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336989 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336989 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='1059632' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059632' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000761s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336989 AND `partno` = '1059632' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336988 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336988 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336988 ORDER BY `unit` DESC [ RunTime:0.003825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336988 LIMIT 2 [ RunTime:0.008440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336988 ORDER BY `minOrder` ASC [ RunTime:0.005745s ]
select * from pdf where partno='1059631' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059631' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005650s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336988 AND `partno` = '1059631' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807359 LIMIT 5 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807359 ORDER BY `minOrder` ASC [ RunTime:0.001185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807359 ORDER BY `unit` DESC [ RunTime:0.009647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807359 LIMIT 2 [ RunTime:0.013895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807359 ORDER BY `minOrder` ASC [ RunTime:0.008525s ]
select * from pdf where partno='1059643' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059643' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001572s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807359 AND `partno` = '1059643' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011270 [ RunTime:0.002330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806515 LIMIT 5 [ RunTime:0.013371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806515 ORDER BY `minOrder` ASC [ RunTime:0.005598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806515 ORDER BY `unit` DESC [ RunTime:0.001093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806515 LIMIT 2 [ RunTime:0.001441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806515 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='1059670' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059670' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009108s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806515 AND `partno` = '1059670' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774420 [ RunTime:0.014499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805359 LIMIT 5 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805359 ORDER BY `minOrder` ASC [ RunTime:0.001123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805359 ORDER BY `unit` DESC [ RunTime:0.003010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805359 LIMIT 2 [ RunTime:0.003495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805359 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='1059635' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059635' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002709s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805359 AND `partno` = '1059635' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773781 [ RunTime:0.008855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805201 LIMIT 5 [ RunTime:0.004760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805201 ORDER BY `minOrder` ASC [ RunTime:0.002486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805201 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805201 LIMIT 2 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805201 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='1059627' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059627' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002406s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805201 AND `partno` = '1059627' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773706 [ RunTime:0.007309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805099 LIMIT 5 [ RunTime:0.001226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805099 ORDER BY `minOrder` ASC [ RunTime:0.002541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805099 ORDER BY `unit` DESC [ RunTime:0.003172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805099 LIMIT 2 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805099 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='1059681' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059681' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010460s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805099 AND `partno` = '1059681' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223619 [ RunTime:0.010857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804917 LIMIT 5 [ RunTime:0.006894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804917 ORDER BY `minOrder` ASC [ RunTime:0.001195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804917 ORDER BY `unit` DESC [ RunTime:0.003283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804917 LIMIT 2 [ RunTime:0.004022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804917 ORDER BY `minOrder` ASC [ RunTime:0.002076s ]
select * from pdf where partno='1059625' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059625' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001090s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804917 AND `partno` = '1059625' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266241 [ RunTime:0.000776s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004943s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005941s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016770s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001809s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001079s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003825s ]
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 '10596%' OR `brand` LIKE '10596%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011697s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10596%' OR `brand` LIKE '10596%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002918s ]