SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002189s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=SMCJ10&search=1' [ RunTime:0.001925s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001941s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000481s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002105s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002123s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002977s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ10' LIMIT 1 [ RunTime:0.000899s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 18:52:48' WHERE `partno` = 'SMCJ10' [ RunTime:0.004709s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001737s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014975s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920230 LIMIT 5 [ RunTime:0.001356s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920230 ORDER BY `minOrder` ASC [ RunTime:0.001990s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920230 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920230 LIMIT 2 [ RunTime:0.002446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920230 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905152 LIMIT 5 [ RunTime:0.005336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905152 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905152 ORDER BY `unit` DESC [ RunTime:0.009319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905152 LIMIT 2 [ RunTime:0.012777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905152 ORDER BY `minOrder` ASC [ RunTime:0.002462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800900 LIMIT 5 [ RunTime:0.003860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800900 ORDER BY `minOrder` ASC [ RunTime:0.002006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800900 ORDER BY `unit` DESC [ RunTime:0.008743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800900 LIMIT 2 [ RunTime:0.002613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800900 ORDER BY `minOrder` ASC [ RunTime:0.003162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919259 LIMIT 5 [ RunTime:0.008081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919259 ORDER BY `minOrder` ASC [ RunTime:0.009564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919259 ORDER BY `unit` DESC [ RunTime:0.000768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919259 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919259 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668082 LIMIT 5 [ RunTime:0.003897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668082 ORDER BY `minOrder` ASC [ RunTime:0.022582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668082 ORDER BY `unit` DESC [ RunTime:0.008208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668082 LIMIT 2 [ RunTime:0.013142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668082 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='SMCJ100CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808322 LIMIT 5 [ RunTime:0.002377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808322 ORDER BY `minOrder` ASC [ RunTime:0.006111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808322 ORDER BY `unit` DESC [ RunTime:0.022197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808322 LIMIT 2 [ RunTime:0.009080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808322 ORDER BY `minOrder` ASC [ RunTime:0.001231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679663 LIMIT 5 [ RunTime:0.004145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679663 ORDER BY `minOrder` ASC [ RunTime:0.032330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679663 ORDER BY `unit` DESC [ RunTime:0.009341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679663 LIMIT 2 [ RunTime:0.004766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679663 ORDER BY `minOrder` ASC [ RunTime:0.011114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911626 LIMIT 5 [ RunTime:0.018843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911626 ORDER BY `minOrder` ASC [ RunTime:0.010084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911626 ORDER BY `unit` DESC [ RunTime:0.003627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911626 LIMIT 2 [ RunTime:0.020778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911626 ORDER BY `minOrder` ASC [ RunTime:0.007164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668806 LIMIT 5 [ RunTime:0.006990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668806 ORDER BY `minOrder` ASC [ RunTime:0.013145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668806 ORDER BY `unit` DESC [ RunTime:0.019518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668806 LIMIT 2 [ RunTime:0.006737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668806 ORDER BY `minOrder` ASC [ RunTime:0.001306s ]
select * from pdf where partno='SMCJ10CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678436 LIMIT 5 [ RunTime:0.015199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678436 ORDER BY `minOrder` ASC [ RunTime:0.000888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678436 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678436 LIMIT 2 [ RunTime:0.015950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678436 ORDER BY `minOrder` ASC [ RunTime:0.008604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910343 LIMIT 5 [ RunTime:0.018193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910343 ORDER BY `minOrder` ASC [ RunTime:0.006132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910343 ORDER BY `unit` DESC [ RunTime:0.002612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910343 LIMIT 2 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910343 ORDER BY `minOrder` ASC [ RunTime:0.014591s ]
select * from pdf where partno='SMCJ10A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920556 LIMIT 5 [ RunTime:0.029340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920556 ORDER BY `minOrder` ASC [ RunTime:0.046627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920556 ORDER BY `unit` DESC [ RunTime:0.015353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920556 LIMIT 2 [ RunTime:0.025826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920556 ORDER BY `minOrder` ASC [ RunTime:0.003087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906771 LIMIT 5 [ RunTime:0.032764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906771 ORDER BY `minOrder` ASC [ RunTime:0.012864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906771 ORDER BY `unit` DESC [ RunTime:0.030863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906771 LIMIT 2 [ RunTime:0.029937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906771 ORDER BY `minOrder` ASC [ RunTime:0.010559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663896 LIMIT 5 [ RunTime:0.019686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663896 ORDER BY `minOrder` ASC [ RunTime:0.039043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663896 ORDER BY `unit` DESC [ RunTime:0.015091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663896 LIMIT 2 [ RunTime:0.023152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663896 ORDER BY `minOrder` ASC [ RunTime:0.005477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661794 LIMIT 5 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661794 ORDER BY `minOrder` ASC [ RunTime:0.004967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661794 ORDER BY `unit` DESC [ RunTime:0.021870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661794 LIMIT 2 [ RunTime:0.002920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661794 ORDER BY `minOrder` ASC [ RunTime:0.001795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804094 LIMIT 5 [ RunTime:0.020158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804094 ORDER BY `minOrder` ASC [ RunTime:0.005364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14804094 ORDER BY `unit` DESC [ RunTime:0.013163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14804094 LIMIT 2 [ RunTime:0.007513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804094 ORDER BY `minOrder` ASC [ RunTime:0.001400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800279 LIMIT 5 [ RunTime:0.011622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800279 ORDER BY `minOrder` ASC [ RunTime:0.005406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800279 ORDER BY `unit` DESC [ RunTime:0.012151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800279 LIMIT 2 [ RunTime:0.006090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800279 ORDER BY `minOrder` ASC [ RunTime:0.007516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905810 LIMIT 5 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905810 ORDER BY `minOrder` ASC [ RunTime:0.009885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905810 ORDER BY `unit` DESC [ RunTime:0.004249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905810 LIMIT 2 [ RunTime:0.002462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905810 ORDER BY `minOrder` ASC [ RunTime:0.001418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905131 LIMIT 5 [ RunTime:0.015154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905131 ORDER BY `minOrder` ASC [ RunTime:0.017297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905131 ORDER BY `unit` DESC [ RunTime:0.010686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905131 LIMIT 2 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905131 ORDER BY `minOrder` ASC [ RunTime:0.010631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932856 LIMIT 5 [ RunTime:0.006226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932856 ORDER BY `minOrder` ASC [ RunTime:0.002514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932856 ORDER BY `unit` DESC [ RunTime:0.006573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932856 LIMIT 2 [ RunTime:0.016109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932856 ORDER BY `minOrder` ASC [ RunTime:0.006923s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141230 LIMIT 5 [ RunTime:0.021338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141230 ORDER BY `minOrder` ASC [ RunTime:0.024870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141230 ORDER BY `unit` DESC [ RunTime:0.003161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141230 LIMIT 2 [ RunTime:0.025322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141230 ORDER BY `minOrder` ASC [ RunTime:0.010496s ]
select * from pdf where partno='smcj100a-q' and brandshort='bourns' limit 1 [ RunTime:0.019605s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj100a-q' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.018175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141071 LIMIT 5 [ RunTime:0.028226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141071 ORDER BY `minOrder` ASC [ RunTime:0.029317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141071 ORDER BY `unit` DESC [ RunTime:0.011448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141071 LIMIT 2 [ RunTime:0.015103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141071 ORDER BY `minOrder` ASC [ RunTime:0.010903s ]
select * from pdf where partno='smcj100a' and brandshort='bourns' limit 1 [ RunTime:0.005056s ]
select foldpath,foldpath2,filename from pdf_file where id=951289 limit 1 [ RunTime:0.007283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj100a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.016129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141524 LIMIT 5 [ RunTime:0.006779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141524 ORDER BY `minOrder` ASC [ RunTime:0.015288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141524 ORDER BY `unit` DESC [ RunTime:0.016893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141524 LIMIT 2 [ RunTime:0.017477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141524 ORDER BY `minOrder` ASC [ RunTime:0.013735s ]
select * from pdf where partno='smcj100a-13-f' and brandshort='diodes incorporated' limit 1 [ RunTime:0.021737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj100a-13-f' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.009205s ]
SELECT `id` FROM `stock` WHERE `id` <> 51141524 AND `partno` = 'smcj100a-13-f' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.008459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679663 [ RunTime:0.011971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141197 LIMIT 5 [ RunTime:0.014639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141197 ORDER BY `minOrder` ASC [ RunTime:0.041660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141197 ORDER BY `unit` DESC [ RunTime:0.028010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141197 LIMIT 2 [ RunTime:0.034484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141197 ORDER BY `minOrder` ASC [ RunTime:0.027516s ]
select * from pdf where partno='smcj10a-13-f' and brandshort='diodes incorporated' limit 1 [ RunTime:0.065463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj10a-13-f' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.034573s ]
SELECT `id` FROM `stock` WHERE `id` <> 51141197 AND `partno` = 'smcj10a-13-f' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.037152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905152 [ RunTime:0.020691s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104860 LIMIT 5 [ RunTime:0.013168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104860 ORDER BY `minOrder` ASC [ RunTime:0.020794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104860 ORDER BY `unit` DESC [ RunTime:0.015042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104860 LIMIT 2 [ RunTime:0.005291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104860 ORDER BY `minOrder` ASC [ RunTime:0.002229s ]
select * from pdf where partno='SMCJ10A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.009937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ10A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.017953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150831 LIMIT 5 [ RunTime:0.006553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150831 ORDER BY `minOrder` ASC [ RunTime:0.018222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150831 ORDER BY `unit` DESC [ RunTime:0.044447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150831 LIMIT 2 [ RunTime:0.025559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150831 ORDER BY `minOrder` ASC [ RunTime:0.023262s ]
select * from pdf where partno='SMCJ100A' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.028030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100A' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.026541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105559 LIMIT 5 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105559 ORDER BY `minOrder` ASC [ RunTime:0.031074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105559 ORDER BY `unit` DESC [ RunTime:0.040002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105559 LIMIT 2 [ RunTime:0.078441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105559 ORDER BY `minOrder` ASC [ RunTime:0.029873s ]
select * from pdf where partno='SMCJ100A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.059271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.020970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105533 LIMIT 5 [ RunTime:0.055774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105533 ORDER BY `minOrder` ASC [ RunTime:0.072893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105533 ORDER BY `unit` DESC [ RunTime:0.061958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105533 LIMIT 2 [ RunTime:0.040852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105533 ORDER BY `minOrder` ASC [ RunTime:0.050534s ]
select * from pdf where partno='SMCJ100CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.025650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.021830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104849 LIMIT 5 [ RunTime:0.023805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104849 ORDER BY `minOrder` ASC [ RunTime:0.025210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104849 ORDER BY `unit` DESC [ RunTime:0.037524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104849 LIMIT 2 [ RunTime:0.049914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104849 ORDER BY `minOrder` ASC [ RunTime:0.009494s ]
select * from pdf where partno='SMCJ100A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.039913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.020044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106183 LIMIT 5 [ RunTime:0.023933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106183 ORDER BY `minOrder` ASC [ RunTime:0.027464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106183 ORDER BY `unit` DESC [ RunTime:0.026664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106183 LIMIT 2 [ RunTime:0.028882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106183 ORDER BY `minOrder` ASC [ RunTime:0.038175s ]
select * from pdf where partno='SMCJ100CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.023855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.017471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42119226 LIMIT 5 [ RunTime:0.024582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119226 ORDER BY `minOrder` ASC [ RunTime:0.027778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42119226 ORDER BY `unit` DESC [ RunTime:0.011179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42119226 LIMIT 2 [ RunTime:0.000921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119226 ORDER BY `minOrder` ASC [ RunTime:0.004501s ]
select * from pdf where partno='SMCJ100A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.012890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.012784s ]
SELECT `id` FROM `stock` WHERE `id` <> 42119226 AND `partno` = 'SMCJ100A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.028995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679663 [ RunTime:0.009687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106214 LIMIT 5 [ RunTime:0.018784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106214 ORDER BY `minOrder` ASC [ RunTime:0.018952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106214 ORDER BY `unit` DESC [ RunTime:0.018142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106214 LIMIT 2 [ RunTime:0.026842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106214 ORDER BY `minOrder` ASC [ RunTime:0.007544s ]
select * from pdf where partno='SMCJ100CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.019665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004154s ]
SELECT `id` FROM `stock` WHERE `id` <> 42106214 AND `partno` = 'SMCJ100CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.018131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678436 [ RunTime:0.008494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118075 LIMIT 5 [ RunTime:0.013469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118075 ORDER BY `minOrder` ASC [ RunTime:0.019759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118075 ORDER BY `unit` DESC [ RunTime:0.026197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118075 LIMIT 2 [ RunTime:0.015318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118075 ORDER BY `minOrder` ASC [ RunTime:0.024116s ]
select * from pdf where partno='SMCJ10CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.014239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ10CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.010241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42119317 LIMIT 5 [ RunTime:0.024140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119317 ORDER BY `minOrder` ASC [ RunTime:0.025547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42119317 ORDER BY `unit` DESC [ RunTime:0.004900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42119317 LIMIT 2 [ RunTime:0.015089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119317 ORDER BY `minOrder` ASC [ RunTime:0.007656s ]
select * from pdf where partno='SMCJ10CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.020638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ10CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.029614s ]
SELECT `id` FROM `stock` WHERE `id` <> 42119317 AND `partno` = 'SMCJ10CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.031669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922888 [ RunTime:0.007281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42096111 LIMIT 5 [ RunTime:0.007619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096111 ORDER BY `minOrder` ASC [ RunTime:0.006428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42096111 ORDER BY `unit` DESC [ RunTime:0.014572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42096111 LIMIT 2 [ RunTime:0.017742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096111 ORDER BY `minOrder` ASC [ RunTime:0.007664s ]
select * from pdf where partno='SMCJ10CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ10CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143025 LIMIT 5 [ RunTime:0.010662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143025 ORDER BY `minOrder` ASC [ RunTime:0.017860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143025 ORDER BY `unit` DESC [ RunTime:0.005611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143025 LIMIT 2 [ RunTime:0.011271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143025 ORDER BY `minOrder` ASC [ RunTime:0.016174s ]
select * from pdf where partno='SMCJ100CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.024064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.015478s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143025 AND `partno` = 'SMCJ100CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.028133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909142 [ RunTime:0.013482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142932 LIMIT 5 [ RunTime:0.033919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142932 ORDER BY `minOrder` ASC [ RunTime:0.023979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142932 ORDER BY `unit` DESC [ RunTime:0.029667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142932 LIMIT 2 [ RunTime:0.008781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142932 ORDER BY `minOrder` ASC [ RunTime:0.010005s ]
select * from pdf where partno='SMCJ100A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.016610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004281s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142932 AND `partno` = 'SMCJ100A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.016983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804656 [ RunTime:0.004159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142623 LIMIT 5 [ RunTime:0.000778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142623 ORDER BY `minOrder` ASC [ RunTime:0.011669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142623 ORDER BY `unit` DESC [ RunTime:0.017269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142623 LIMIT 2 [ RunTime:0.013949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142623 ORDER BY `minOrder` ASC [ RunTime:0.007314s ]
select * from pdf where partno='SMCJ10CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.015921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ10CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.009640s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142623 AND `partno` = 'SMCJ10CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.008131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909120 [ RunTime:0.001051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142542 LIMIT 5 [ RunTime:0.004825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142542 ORDER BY `minOrder` ASC [ RunTime:0.019693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142542 ORDER BY `unit` DESC [ RunTime:0.032213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142542 LIMIT 2 [ RunTime:0.025021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142542 ORDER BY `minOrder` ASC [ RunTime:0.024594s ]
select * from pdf where partno='SMCJ10A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.036051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ10A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.048113s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142542 AND `partno` = 'SMCJ10A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909106 [ RunTime:0.000982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42141828 LIMIT 5 [ RunTime:0.007618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141828 ORDER BY `minOrder` ASC [ RunTime:0.027436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42141828 ORDER BY `unit` DESC [ RunTime:0.015160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42141828 LIMIT 2 [ RunTime:0.009202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141828 ORDER BY `minOrder` ASC [ RunTime:0.005718s ]
select * from pdf where partno='SMCJ10CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.003407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ10CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.002599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42133924 LIMIT 5 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133924 ORDER BY `minOrder` ASC [ RunTime:0.013253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42133924 ORDER BY `unit` DESC [ RunTime:0.027244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42133924 LIMIT 2 [ RunTime:0.013095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133924 ORDER BY `minOrder` ASC [ RunTime:0.009993s ]
select * from pdf where partno='SMCJ100' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.010368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.013719s ]
SELECT `id` FROM `stock` WHERE `id` <> 42133924 AND `partno` = 'SMCJ100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.016776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800279 [ RunTime:0.008698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42131559 LIMIT 5 [ RunTime:0.002426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131559 ORDER BY `minOrder` ASC [ RunTime:0.001209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42131559 ORDER BY `unit` DESC [ RunTime:0.024028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42131559 LIMIT 2 [ RunTime:0.004319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131559 ORDER BY `minOrder` ASC [ RunTime:0.010481s ]
select * from pdf where partno='SMCJ100A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.002131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000969s ]
SELECT `id` FROM `stock` WHERE `id` <> 42131559 AND `partno` = 'SMCJ100A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.001351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932856 [ RunTime:0.012168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42131963 LIMIT 5 [ RunTime:0.001720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131963 ORDER BY `minOrder` ASC [ RunTime:0.015219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42131963 ORDER BY `unit` DESC [ RunTime:0.010220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42131963 LIMIT 2 [ RunTime:0.002279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131963 ORDER BY `minOrder` ASC [ RunTime:0.004151s ]
select * from pdf where partno='SMCJ10' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.004039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ10' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003743s ]
SELECT `id` FROM `stock` WHERE `id` <> 42131963 AND `partno` = 'SMCJ10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661794 [ RunTime:0.013399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128614 LIMIT 5 [ RunTime:0.007211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128614 ORDER BY `minOrder` ASC [ RunTime:0.001106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128614 ORDER BY `unit` DESC [ RunTime:0.001136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128614 LIMIT 2 [ RunTime:0.017253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128614 ORDER BY `minOrder` ASC [ RunTime:0.002209s ]
select * from pdf where partno='SMCJ100A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.004420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ100A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005898s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002539s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019019s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003747s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000922s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034947s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011704s ]
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 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010048s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMCJ10%' OR `brand` LIKE 'SMCJ10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022043s ]