SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002406s ]
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=1010&search=1' [ RunTime:0.002978s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002314s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001915s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003117s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.003758s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001619s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002836s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001127s ]
SELECT * FROM `stock_search` WHERE `partno` = '1010' LIMIT 1 [ RunTime:0.003945s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-13 15:27:57' WHERE `partno` = '1010' [ RunTime:0.002325s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001464s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.139665s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932111 LIMIT 5 [ RunTime:0.011853s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932111 ORDER BY `minOrder` ASC [ RunTime:0.007667s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932111 ORDER BY `unit` DESC [ RunTime:0.016776s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932111 LIMIT 2 [ RunTime:0.004353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932111 ORDER BY `minOrder` ASC [ RunTime:0.014566s ]
select * from pdf where partno='10103593-0001LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.031449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13261375 LIMIT 5 [ RunTime:0.019116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13261375 ORDER BY `minOrder` ASC [ RunTime:0.008083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13261375 ORDER BY `unit` DESC [ RunTime:0.031280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13261375 LIMIT 2 [ RunTime:0.021780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13261375 ORDER BY `minOrder` ASC [ RunTime:0.008379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932103 LIMIT 5 [ RunTime:0.020187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932103 ORDER BY `minOrder` ASC [ RunTime:0.061219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932103 ORDER BY `unit` DESC [ RunTime:0.030665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932103 LIMIT 2 [ RunTime:0.017536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932103 ORDER BY `minOrder` ASC [ RunTime:0.019436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934270 LIMIT 5 [ RunTime:0.062959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934270 ORDER BY `minOrder` ASC [ RunTime:0.013778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934270 ORDER BY `unit` DESC [ RunTime:0.034250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934270 LIMIT 2 [ RunTime:0.014578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934270 ORDER BY `minOrder` ASC [ RunTime:0.006225s ]
select * from pdf where partno='10103592-0001LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.023938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932113 LIMIT 5 [ RunTime:0.021419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932113 ORDER BY `minOrder` ASC [ RunTime:0.016430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932113 ORDER BY `unit` DESC [ RunTime:0.018923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932113 LIMIT 2 [ RunTime:0.019851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932113 ORDER BY `minOrder` ASC [ RunTime:0.003028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934276 LIMIT 5 [ RunTime:0.002198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934276 ORDER BY `minOrder` ASC [ RunTime:0.001388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934276 ORDER BY `unit` DESC [ RunTime:0.009005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934276 LIMIT 2 [ RunTime:0.010452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934276 ORDER BY `minOrder` ASC [ RunTime:0.005358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484072 LIMIT 5 [ RunTime:0.011619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484072 ORDER BY `minOrder` ASC [ RunTime:0.007457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484072 ORDER BY `unit` DESC [ RunTime:0.012317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484072 LIMIT 2 [ RunTime:0.003072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484072 ORDER BY `minOrder` ASC [ RunTime:0.002964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6063 LIMIT 5 [ RunTime:0.024097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6063 ORDER BY `minOrder` ASC [ RunTime:0.015701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6063 ORDER BY `unit` DESC [ RunTime:0.009447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6063 LIMIT 2 [ RunTime:0.013811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6063 ORDER BY `minOrder` ASC [ RunTime:0.008909s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10103594-0001LF' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.009968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273981 LIMIT 5 [ RunTime:0.029902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273981 ORDER BY `minOrder` ASC [ RunTime:0.016274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14273981 ORDER BY `unit` DESC [ RunTime:0.021728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14273981 LIMIT 2 [ RunTime:0.002952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273981 ORDER BY `minOrder` ASC [ RunTime:0.002906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509323 LIMIT 5 [ RunTime:0.006384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509323 ORDER BY `minOrder` ASC [ RunTime:0.016778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509323 ORDER BY `unit` DESC [ RunTime:0.011007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509323 LIMIT 2 [ RunTime:0.010008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509323 ORDER BY `minOrder` ASC [ RunTime:0.003605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12614182 LIMIT 5 [ RunTime:0.017492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12614182 ORDER BY `minOrder` ASC [ RunTime:0.014791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12614182 ORDER BY `unit` DESC [ RunTime:0.014258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12614182 LIMIT 2 [ RunTime:0.005510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12614182 ORDER BY `minOrder` ASC [ RunTime:0.003690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047262 LIMIT 5 [ RunTime:0.001389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047262 ORDER BY `minOrder` ASC [ RunTime:0.000924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12047262 ORDER BY `unit` DESC [ RunTime:0.006680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12047262 LIMIT 2 [ RunTime:0.033965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047262 ORDER BY `minOrder` ASC [ RunTime:0.001766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12788959 LIMIT 5 [ RunTime:0.021692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12788959 ORDER BY `minOrder` ASC [ RunTime:0.021549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12788959 ORDER BY `unit` DESC [ RunTime:0.000822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12788959 LIMIT 2 [ RunTime:0.017412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12788959 ORDER BY `minOrder` ASC [ RunTime:0.009987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11607676 LIMIT 5 [ RunTime:0.010548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11607676 ORDER BY `minOrder` ASC [ RunTime:0.003148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11607676 ORDER BY `unit` DESC [ RunTime:0.021340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11607676 LIMIT 2 [ RunTime:0.002050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11607676 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782174 LIMIT 5 [ RunTime:0.007393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782174 ORDER BY `minOrder` ASC [ RunTime:0.009527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782174 ORDER BY `unit` DESC [ RunTime:0.004300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782174 LIMIT 2 [ RunTime:0.014780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782174 ORDER BY `minOrder` ASC [ RunTime:0.004106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262262 LIMIT 5 [ RunTime:0.023644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13262262 ORDER BY `minOrder` ASC [ RunTime:0.046547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13262262 ORDER BY `unit` DESC [ RunTime:0.051787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13262262 LIMIT 2 [ RunTime:0.036763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13262262 ORDER BY `minOrder` ASC [ RunTime:0.015816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609533 LIMIT 5 [ RunTime:0.023669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609533 ORDER BY `minOrder` ASC [ RunTime:0.014848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11609533 ORDER BY `unit` DESC [ RunTime:0.011791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11609533 LIMIT 2 [ RunTime:0.012956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609533 ORDER BY `minOrder` ASC [ RunTime:0.004809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12788974 LIMIT 5 [ RunTime:0.013038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12788974 ORDER BY `minOrder` ASC [ RunTime:0.015581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12788974 ORDER BY `unit` DESC [ RunTime:0.016573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12788974 LIMIT 2 [ RunTime:0.019192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12788974 ORDER BY `minOrder` ASC [ RunTime:0.009903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11410073 LIMIT 5 [ RunTime:0.008508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11410073 ORDER BY `minOrder` ASC [ RunTime:0.016027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11410073 ORDER BY `unit` DESC [ RunTime:0.011909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11410073 LIMIT 2 [ RunTime:0.034722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11410073 ORDER BY `minOrder` ASC [ RunTime:0.014522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446954 LIMIT 5 [ RunTime:0.021676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446954 ORDER BY `minOrder` ASC [ RunTime:0.012695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446954 ORDER BY `unit` DESC [ RunTime:0.024717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446954 LIMIT 2 [ RunTime:0.013108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446954 ORDER BY `minOrder` ASC [ RunTime:0.010935s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264101 LIMIT 5 [ RunTime:0.014145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264101 ORDER BY `minOrder` ASC [ RunTime:0.023353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264101 ORDER BY `unit` DESC [ RunTime:0.049606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264101 LIMIT 2 [ RunTime:0.054027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264101 ORDER BY `minOrder` ASC [ RunTime:0.016948s ]
select * from pdf where partno='1010027182' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.057556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010027182' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.034006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257875 LIMIT 5 [ RunTime:0.010488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257875 ORDER BY `minOrder` ASC [ RunTime:0.018294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257875 ORDER BY `unit` DESC [ RunTime:0.040935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257875 LIMIT 2 [ RunTime:0.034656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257875 ORDER BY `minOrder` ASC [ RunTime:0.025491s ]
select * from pdf where partno='10103594-0001lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.026475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10103594-0001lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.012991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283964 LIMIT 5 [ RunTime:0.048827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283964 ORDER BY `minOrder` ASC [ RunTime:0.040319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32283964 ORDER BY `unit` DESC [ RunTime:0.085198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32283964 LIMIT 2 [ RunTime:0.051213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283964 ORDER BY `minOrder` ASC [ RunTime:0.020022s ]
select * from pdf where partno='101050-003' and brandshort='smiths interconnect / idi' limit 1 [ RunTime:0.052046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '101050-003' OR `brand` LIKE 'smiths interconnect / idi%' ) ) LIMIT 1 [ RunTime:0.024762s ]
SELECT `id` FROM `stock` WHERE `id` <> 32283964 AND `partno` = '101050-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smiths interconnect / idi%' ) [ RunTime:0.040457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277993 [ RunTime:0.028156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277993 LIMIT 5 [ RunTime:0.034324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277993 ORDER BY `minOrder` ASC [ RunTime:0.033434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277993 ORDER BY `unit` DESC [ RunTime:0.019379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277993 LIMIT 2 [ RunTime:0.050516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277993 ORDER BY `minOrder` ASC [ RunTime:0.052419s ]
select * from pdf where partno='101050-003' and brandshort='smiths interconnect / idi' limit 1 [ RunTime:0.020515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '101050-003' OR `brand` LIKE 'smiths interconnect / idi%' ) ) LIMIT 1 [ RunTime:0.034972s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277993 AND `partno` = '101050-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smiths interconnect / idi%' ) [ RunTime:0.026921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283964 [ RunTime:0.032265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264014 LIMIT 5 [ RunTime:0.027349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264014 ORDER BY `minOrder` ASC [ RunTime:0.046954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264014 ORDER BY `unit` DESC [ RunTime:0.032522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264014 LIMIT 2 [ RunTime:0.027668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264014 ORDER BY `minOrder` ASC [ RunTime:0.024018s ]
select * from pdf where partno='1010170469#2a' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.012039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010170469#2a' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.023337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268054 LIMIT 5 [ RunTime:0.024230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268054 ORDER BY `minOrder` ASC [ RunTime:0.031951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268054 ORDER BY `unit` DESC [ RunTime:0.028657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268054 LIMIT 2 [ RunTime:0.029748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268054 ORDER BY `minOrder` ASC [ RunTime:0.018235s ]
select * from pdf where partno='1010-070-0606' and brandshort='te connectivity / deutsch' limit 1 [ RunTime:0.020926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-070-0606' OR `brand` LIKE 'te connectivity / deutsch%' ) ) LIMIT 1 [ RunTime:0.036054s ]
SELECT `id` FROM `stock` WHERE `id` <> 32268054 AND `partno` = '1010-070-0606' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / deutsch%' ) [ RunTime:0.017554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264144 LIMIT 5 [ RunTime:0.010580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264144 ORDER BY `minOrder` ASC [ RunTime:0.025003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264144 ORDER BY `unit` DESC [ RunTime:0.008278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264144 LIMIT 2 [ RunTime:0.015569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264144 ORDER BY `minOrder` ASC [ RunTime:0.024437s ]
select * from pdf where partno='10102166a812a' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.030413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10102166a812a' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.017863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268305 LIMIT 5 [ RunTime:0.012581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268305 ORDER BY `minOrder` ASC [ RunTime:0.003137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268305 ORDER BY `unit` DESC [ RunTime:0.027187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268305 LIMIT 2 [ RunTime:0.004676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268305 ORDER BY `minOrder` ASC [ RunTime:0.006533s ]
select * from pdf where partno='1010-007-0806' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.002542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-007-0806' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.023155s ]
SELECT `id` FROM `stock` WHERE `id` <> 32268305 AND `partno` = '1010-007-0806' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.029860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267511 LIMIT 5 [ RunTime:0.015778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267511 ORDER BY `minOrder` ASC [ RunTime:0.007352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267511 ORDER BY `unit` DESC [ RunTime:0.035076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267511 LIMIT 2 [ RunTime:0.014020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267511 ORDER BY `minOrder` ASC [ RunTime:0.013881s ]
select * from pdf where partno='1010-017-0606' and brandshort='te connectivity / deutsch' limit 1 [ RunTime:0.024576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-017-0606' OR `brand` LIKE 'te connectivity / deutsch%' ) ) LIMIT 1 [ RunTime:0.043232s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267511 AND `partno` = '1010-017-0606' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / deutsch%' ) [ RunTime:0.051290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264482 LIMIT 5 [ RunTime:0.025071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264482 ORDER BY `minOrder` ASC [ RunTime:0.022276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264482 ORDER BY `unit` DESC [ RunTime:0.037919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264482 LIMIT 2 [ RunTime:0.062366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264482 ORDER BY `minOrder` ASC [ RunTime:0.033552s ]
select * from pdf where partno='1010030682' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.030053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010030682' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.046832s ]
SELECT `id` FROM `stock` WHERE `id` <> 32264482 AND `partno` = '1010030682' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.056778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257877 LIMIT 5 [ RunTime:0.031582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257877 ORDER BY `minOrder` ASC [ RunTime:0.015481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257877 ORDER BY `unit` DESC [ RunTime:0.035049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257877 LIMIT 2 [ RunTime:0.035878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257877 ORDER BY `minOrder` ASC [ RunTime:0.013327s ]
select * from pdf where partno='10104111-0001lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.038309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10104111-0001lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.001663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267510 LIMIT 5 [ RunTime:0.016506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267510 ORDER BY `minOrder` ASC [ RunTime:0.030771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267510 ORDER BY `unit` DESC [ RunTime:0.024489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267510 LIMIT 2 [ RunTime:0.011181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267510 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
select * from pdf where partno='1010-016-0406' and brandshort='te connectivity / deutsch' limit 1 [ RunTime:0.017484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-016-0406' OR `brand` LIKE 'te connectivity / deutsch%' ) ) LIMIT 1 [ RunTime:0.011512s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267510 AND `partno` = '1010-016-0406' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / deutsch%' ) [ RunTime:0.033539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257873 LIMIT 5 [ RunTime:0.020007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257873 ORDER BY `minOrder` ASC [ RunTime:0.022802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257873 ORDER BY `unit` DESC [ RunTime:0.056382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257873 LIMIT 2 [ RunTime:0.048787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257873 ORDER BY `minOrder` ASC [ RunTime:0.016102s ]
select * from pdf where partno='10103592-0001lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.046692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10103592-0001lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.035962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257874 LIMIT 5 [ RunTime:0.015973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257874 ORDER BY `minOrder` ASC [ RunTime:0.012202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257874 ORDER BY `unit` DESC [ RunTime:0.013885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257874 LIMIT 2 [ RunTime:0.024541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257874 ORDER BY `minOrder` ASC [ RunTime:0.006864s ]
select * from pdf where partno='10103593-0001lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.013730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10103593-0001lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.015589s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257874 AND `partno` = '10103593-0001lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.064794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268005 LIMIT 5 [ RunTime:0.011466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268005 ORDER BY `minOrder` ASC [ RunTime:0.033417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268005 ORDER BY `unit` DESC [ RunTime:0.025612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268005 LIMIT 2 [ RunTime:0.028733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268005 ORDER BY `minOrder` ASC [ RunTime:0.005033s ]
select * from pdf where partno='1010-079-0206' and brandshort='te connectivity / deutsch' limit 1 [ RunTime:0.004553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-079-0206' OR `brand` LIKE 'te connectivity / deutsch%' ) ) LIMIT 1 [ RunTime:0.009839s ]
SELECT `id` FROM `stock` WHERE `id` <> 32268005 AND `partno` = '1010-079-0206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / deutsch%' ) [ RunTime:0.020587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257876 LIMIT 5 [ RunTime:0.008681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257876 ORDER BY `minOrder` ASC [ RunTime:0.004520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257876 ORDER BY `unit` DESC [ RunTime:0.018166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257876 LIMIT 2 [ RunTime:0.004695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257876 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
select * from pdf where partno='10104110-0001lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.011023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10104110-0001lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.013112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267326 LIMIT 5 [ RunTime:0.018851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267326 ORDER BY `minOrder` ASC [ RunTime:0.010671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267326 ORDER BY `unit` DESC [ RunTime:0.002149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267326 LIMIT 2 [ RunTime:0.001260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267326 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='1010-063-0806' and brandshort='te connectivity / deutsch' limit 1 [ RunTime:0.004350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-063-0806' OR `brand` LIKE 'te connectivity / deutsch%' ) ) LIMIT 1 [ RunTime:0.004172s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267326 AND `partno` = '1010-063-0806' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / deutsch%' ) [ RunTime:0.017612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268462 LIMIT 5 [ RunTime:0.003769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268462 ORDER BY `minOrder` ASC [ RunTime:0.019023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268462 ORDER BY `unit` DESC [ RunTime:0.000836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268462 LIMIT 2 [ RunTime:0.000587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268462 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
select * from pdf where partno='10106813-021112lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.002565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10106813-021112lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.004806s ]
SELECT `id` FROM `stock` WHERE `id` <> 32268462 AND `partno` = '10106813-021112lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.018683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268617 LIMIT 5 [ RunTime:0.008236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268617 ORDER BY `minOrder` ASC [ RunTime:0.003318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268617 ORDER BY `unit` DESC [ RunTime:0.007818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268617 LIMIT 2 [ RunTime:0.001493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268617 ORDER BY `minOrder` ASC [ RunTime:0.008952s ]
select * from pdf where partno='10106813-033112lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.010424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10106813-033112lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.004424s ]
SELECT `id` FROM `stock` WHERE `id` <> 32268617 AND `partno` = '10106813-033112lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.017042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268893 LIMIT 5 [ RunTime:0.029645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268893 ORDER BY `minOrder` ASC [ RunTime:0.034054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268893 ORDER BY `unit` DESC [ RunTime:0.002709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268893 LIMIT 2 [ RunTime:0.016643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268893 ORDER BY `minOrder` ASC [ RunTime:0.006269s ]
select * from pdf where partno='10106813-031112lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.010818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10106813-031112lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.013806s ]
SELECT `id` FROM `stock` WHERE `id` <> 32268893 AND `partno` = '10106813-031112lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.037083s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.097897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64416087 LIMIT 5 [ RunTime:0.039445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64416087 ORDER BY `minOrder` ASC [ RunTime:0.017520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64416087 ORDER BY `unit` DESC [ RunTime:0.018950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64416087 LIMIT 2 [ RunTime:0.008813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64416087 ORDER BY `minOrder` ASC [ RunTime:0.003010s ]
select * from pdf where partno='10104320-009RLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.013149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10104320-009RLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.009230s ]
SELECT `id` FROM `stock` WHERE `id` <> 64416087 AND `partno` = '10104320-009RLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.012325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262262 [ RunTime:0.010761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394034 LIMIT 5 [ RunTime:0.013182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394034 ORDER BY `minOrder` ASC [ RunTime:0.038034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394034 ORDER BY `unit` DESC [ RunTime:0.058652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394034 LIMIT 2 [ RunTime:0.031908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394034 ORDER BY `minOrder` ASC [ RunTime:0.010683s ]
select * from pdf where partno='10103593-0001LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.036336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10103593-0001LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.022290s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394034 AND `partno` = '10103593-0001LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.019813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932111 [ RunTime:0.016933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361383 LIMIT 5 [ RunTime:0.028115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361383 ORDER BY `minOrder` ASC [ RunTime:0.032626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361383 ORDER BY `unit` DESC [ RunTime:0.021831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361383 LIMIT 2 [ RunTime:0.012934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361383 ORDER BY `minOrder` ASC [ RunTime:0.000889s ]
select * from pdf where partno='1010-009-0206' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-009-0206' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002966s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361383 AND `partno` = '1010-009-0206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.010845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484708 [ RunTime:0.011877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409344 LIMIT 5 [ RunTime:0.008919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409344 ORDER BY `minOrder` ASC [ RunTime:0.003233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409344 ORDER BY `unit` DESC [ RunTime:0.006528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409344 LIMIT 2 [ RunTime:0.003758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409344 ORDER BY `minOrder` ASC [ RunTime:0.001242s ]
select * from pdf where partno='101050' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.006510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '101050' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.015489s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409344 AND `partno` = '101050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.006969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60363077 LIMIT 5 [ RunTime:0.014074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363077 ORDER BY `minOrder` ASC [ RunTime:0.006970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60363077 ORDER BY `unit` DESC [ RunTime:0.014712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60363077 LIMIT 2 [ RunTime:0.011397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363077 ORDER BY `minOrder` ASC [ RunTime:0.003055s ]
select * from pdf where partno='1010-016-0406' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.003023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-016-0406' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.001765s ]
SELECT `id` FROM `stock` WHERE `id` <> 60363077 AND `partno` = '1010-016-0406' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.005179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613338 [ RunTime:0.004394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361595 LIMIT 5 [ RunTime:0.007225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361595 ORDER BY `minOrder` ASC [ RunTime:0.006152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361595 ORDER BY `unit` DESC [ RunTime:0.015625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361595 LIMIT 2 [ RunTime:0.013022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361595 ORDER BY `minOrder` ASC [ RunTime:0.001541s ]
select * from pdf where partno='1010-017-0606' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.009163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-017-0606' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.003945s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361595 AND `partno` = '1010-017-0606' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.012470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12614704 [ RunTime:0.010105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361389 LIMIT 5 [ RunTime:0.030055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361389 ORDER BY `minOrder` ASC [ RunTime:0.019307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361389 ORDER BY `unit` DESC [ RunTime:0.001418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361389 LIMIT 2 [ RunTime:0.004633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361389 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='1010-002-0306' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.003145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-002-0306' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002773s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361389 AND `partno` = '1010-002-0306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.001142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58735572 LIMIT 5 [ RunTime:0.007973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58735572 ORDER BY `minOrder` ASC [ RunTime:0.008044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58735572 ORDER BY `unit` DESC [ RunTime:0.011645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58735572 LIMIT 2 [ RunTime:0.015830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58735572 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
select * from pdf where partno='10108777-10030RLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10108777-10030RLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003711s ]
SELECT `id` FROM `stock` WHERE `id` <> 58735572 AND `partno` = '10108777-10030RLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14249092 [ RunTime:0.003055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393560 LIMIT 5 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393560 ORDER BY `minOrder` ASC [ RunTime:0.001061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393560 ORDER BY `unit` DESC [ RunTime:0.004680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393560 LIMIT 2 [ RunTime:0.011484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393560 ORDER BY `minOrder` ASC [ RunTime:0.008092s ]
select * from pdf where partno='10104111-0001LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.014237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10104111-0001LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361596 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361596 ORDER BY `minOrder` ASC [ RunTime:0.010855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361596 ORDER BY `unit` DESC [ RunTime:0.008163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361596 LIMIT 2 [ RunTime:0.017907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361596 ORDER BY `minOrder` ASC [ RunTime:0.010556s ]
select * from pdf where partno='1010-007-0806' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.003575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-007-0806' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.005594s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361596 AND `partno` = '1010-007-0806' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.026437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484854 [ RunTime:0.006818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64415937 LIMIT 5 [ RunTime:0.004539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64415937 ORDER BY `minOrder` ASC [ RunTime:0.023114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64415937 ORDER BY `unit` DESC [ RunTime:0.030555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64415937 LIMIT 2 [ RunTime:0.008310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64415937 ORDER BY `minOrder` ASC [ RunTime:0.013901s ]
select * from pdf where partno='10104321-009RLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10104321-009RLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004198s ]
SELECT `id` FROM `stock` WHERE `id` <> 64415937 AND `partno` = '10104321-009RLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.018432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60363088 LIMIT 5 [ RunTime:0.009536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363088 ORDER BY `minOrder` ASC [ RunTime:0.019466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60363088 ORDER BY `unit` DESC [ RunTime:0.005006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60363088 LIMIT 2 [ RunTime:0.015849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363088 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='1010-063-0806' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-063-0806' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002772s ]
SELECT `id` FROM `stock` WHERE `id` <> 60363088 AND `partno` = '1010-063-0806' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.010154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484876 [ RunTime:0.005673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60363089 LIMIT 5 [ RunTime:0.025899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363089 ORDER BY `minOrder` ASC [ RunTime:0.016381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60363089 ORDER BY `unit` DESC [ RunTime:0.006403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60363089 LIMIT 2 [ RunTime:0.003787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363089 ORDER BY `minOrder` ASC [ RunTime:0.001513s ]
select * from pdf where partno='1010-058-1206' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-058-1206' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.017201s ]
SELECT `id` FROM `stock` WHERE `id` <> 60363089 AND `partno` = '1010-058-1206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.000701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484877 [ RunTime:0.008401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60992088 LIMIT 5 [ RunTime:0.006596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60992088 ORDER BY `minOrder` ASC [ RunTime:0.001384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60992088 ORDER BY `unit` DESC [ RunTime:0.001340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60992088 LIMIT 2 [ RunTime:0.007900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60992088 ORDER BY `minOrder` ASC [ RunTime:0.005806s ]
select * from pdf where partno='1010170469#2A' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.002156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010170469#2A' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60468120 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60468120 ORDER BY `minOrder` ASC [ RunTime:0.003260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60468120 ORDER BY `unit` DESC [ RunTime:0.002586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60468120 LIMIT 2 [ RunTime:0.011096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60468120 ORDER BY `minOrder` ASC [ RunTime:0.005778s ]
select * from pdf where partno='1010000000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010000000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.033947s ]
SELECT `id` FROM `stock` WHERE `id` <> 60468120 AND `partno` = '1010000000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446954 [ RunTime:0.002123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64415678 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64415678 ORDER BY `minOrder` ASC [ RunTime:0.012374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64415678 ORDER BY `unit` DESC [ RunTime:0.017666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64415678 LIMIT 2 [ RunTime:0.001727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64415678 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
select * from pdf where partno='10104319-009RLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.013918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10104319-009RLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006596s ]
SELECT `id` FROM `stock` WHERE `id` <> 64415678 AND `partno` = '10104319-009RLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13261375 [ RunTime:0.005088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355293 LIMIT 5 [ RunTime:0.006220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355293 ORDER BY `minOrder` ASC [ RunTime:0.039273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355293 ORDER BY `unit` DESC [ RunTime:0.012164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355293 LIMIT 2 [ RunTime:0.001974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355293 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
select * from pdf where partno='10106813-071112LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10106813-071112LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000914s ]
SELECT `id` FROM `stock` WHERE `id` <> 59355293 AND `partno` = '10106813-071112LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.010392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791598 [ RunTime:0.011306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361607 LIMIT 5 [ RunTime:0.002585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361607 ORDER BY `minOrder` ASC [ RunTime:0.019510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361607 ORDER BY `unit` DESC [ RunTime:0.003691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361607 LIMIT 2 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361607 ORDER BY `minOrder` ASC [ RunTime:0.002260s ]
select * from pdf where partno='1010-020-1206' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.012039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-020-1206' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.005702s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361607 AND `partno` = '1010-020-1206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.004610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484072 [ RunTime:0.012349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104949 LIMIT 5 [ RunTime:0.008289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104949 ORDER BY `minOrder` ASC [ RunTime:0.023623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104949 ORDER BY `unit` DESC [ RunTime:0.003034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104949 LIMIT 2 [ RunTime:0.001656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104949 ORDER BY `minOrder` ASC [ RunTime:0.001808s ]
select * from pdf where partno='1010-1' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.012807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1010-1' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.019673s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104949 AND `partno` = '1010-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.005648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273981 [ RunTime:0.003187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60992079 LIMIT 5 [ RunTime:0.012737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60992079 ORDER BY `minOrder` ASC [ RunTime:0.011165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60992079 ORDER BY `unit` DESC [ RunTime:0.029246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60992079 LIMIT 2 [ RunTime:0.020134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60992079 ORDER BY `minOrder` ASC [ RunTime:0.002634s ]
select * from pdf where partno='10102166A812A' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.003624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10102166A812A' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.000518s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003304s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011543s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002564s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008033s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012195s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001449s ]
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 '1010%' OR `brand` LIKE '1010%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009285s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1010%' OR `brand` LIKE '1010%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024970s ]