SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003109s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.222' , `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=SMD32&search=1' [ RunTime:0.002937s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002640s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002569s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.222' ) [ RunTime:0.002459s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002245s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001636s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002135s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMD32' LIMIT 1 [ RunTime:0.036850s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-31 01:24:30' WHERE `partno` = 'SMD32' [ RunTime:0.011825s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001380s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018597s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15267696 LIMIT 5 [ RunTime:0.020510s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15267696 ORDER BY `minOrder` ASC [ RunTime:0.029955s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15267696 ORDER BY `unit` DESC [ RunTime:0.016566s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15267696 LIMIT 2 [ RunTime:0.048943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15267696 ORDER BY `minOrder` ASC [ RunTime:0.028957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18987503 LIMIT 5 [ RunTime:0.009931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18987503 ORDER BY `minOrder` ASC [ RunTime:0.024080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18987503 ORDER BY `unit` DESC [ RunTime:0.022176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18987503 LIMIT 2 [ RunTime:0.032110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18987503 ORDER BY `minOrder` ASC [ RunTime:0.035398s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51099332 LIMIT 5 [ RunTime:0.043258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51099332 ORDER BY `minOrder` ASC [ RunTime:0.045828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51099332 ORDER BY `unit` DESC [ RunTime:0.022094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51099332 LIMIT 2 [ RunTime:0.018181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51099332 ORDER BY `minOrder` ASC [ RunTime:0.011788s ]
select * from pdf where partno='smd32nl' and brandshort='chip quik' limit 1 [ RunTime:0.068009s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smd32nl' OR `brand` LIKE 'chip quik%' ) ) LIMIT 1 [ RunTime:0.016668s ]
SELECT `id` FROM `stock` WHERE `id` <> 51099332 AND `partno` = 'smd32nl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%chip quik%' ) [ RunTime:0.055560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15267696 [ RunTime:0.008361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51099519 LIMIT 5 [ RunTime:0.025252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51099519 ORDER BY `minOrder` ASC [ RunTime:0.034220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51099519 ORDER BY `unit` DESC [ RunTime:0.003400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51099519 LIMIT 2 [ RunTime:0.016640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51099519 ORDER BY `minOrder` ASC [ RunTime:0.010780s ]
select * from pdf where partno='smd32' and brandshort='chip quik' limit 1 [ RunTime:0.022156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smd32' OR `brand` LIKE 'chip quik%' ) ) LIMIT 1 [ RunTime:0.021653s ]
SELECT `id` FROM `stock` WHERE `id` <> 51099519 AND `partno` = 'smd32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%chip quik%' ) [ RunTime:0.009597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18987503 [ RunTime:0.020790s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58588140 LIMIT 5 [ RunTime:0.009130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58588140 ORDER BY `minOrder` ASC [ RunTime:0.022137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58588140 ORDER BY `unit` DESC [ RunTime:0.008452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58588140 LIMIT 2 [ RunTime:0.006728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58588140 ORDER BY `minOrder` ASC [ RunTime:0.003680s ]
select * from pdf where partno='SMD32NL' and brandshort='Chip Quik Inc.' limit 1 [ RunTime:0.019805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD32NL' OR `brand` LIKE 'Chip Quik Inc.%' ) ) LIMIT 1 [ RunTime:0.005319s ]
SELECT `id` FROM `stock` WHERE `id` <> 58588140 AND `partno` = 'SMD32NL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%chip quik inc.%' ) [ RunTime:0.000942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15267696 [ RunTime:0.002367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58588201 LIMIT 5 [ RunTime:0.049748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58588201 ORDER BY `minOrder` ASC [ RunTime:0.014477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58588201 ORDER BY `unit` DESC [ RunTime:0.017851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58588201 LIMIT 2 [ RunTime:0.018160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58588201 ORDER BY `minOrder` ASC [ RunTime:0.028747s ]
select * from pdf where partno='SMD32' and brandshort='Chip Quik Inc.' limit 1 [ RunTime:0.007801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD32' OR `brand` LIKE 'Chip Quik Inc.%' ) ) LIMIT 1 [ RunTime:0.009656s ]
SELECT `id` FROM `stock` WHERE `id` <> 58588201 AND `partno` = 'SMD32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%chip quik inc.%' ) [ RunTime:0.035057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18987503 [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44102445 LIMIT 5 [ RunTime:0.014258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44102445 ORDER BY `minOrder` ASC [ RunTime:0.029579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44102445 ORDER BY `unit` DESC [ RunTime:0.012739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44102445 LIMIT 2 [ RunTime:0.022187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44102445 ORDER BY `minOrder` ASC [ RunTime:0.025113s ]
select * from pdf where partno='SMD320PLQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD320PLQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.013916s ]
SELECT `id` FROM `stock` WHERE `id` <> 44102445 AND `partno` = 'SMD320PLQ-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.011346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44101772 LIMIT 5 [ RunTime:0.011703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44101772 ORDER BY `minOrder` ASC [ RunTime:0.035362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44101772 ORDER BY `unit` DESC [ RunTime:0.024212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44101772 LIMIT 2 [ RunTime:0.019160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44101772 ORDER BY `minOrder` ASC [ RunTime:0.027227s ]
select * from pdf where partno='SMD320HL-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.003569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD320HL-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.008146s ]
SELECT `id` FROM `stock` WHERE `id` <> 44101772 AND `partno` = 'SMD320HL-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.032626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44101771 LIMIT 5 [ RunTime:0.026652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44101771 ORDER BY `minOrder` ASC [ RunTime:0.014608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44101771 ORDER BY `unit` DESC [ RunTime:0.010909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44101771 LIMIT 2 [ RunTime:0.038226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44101771 ORDER BY `minOrder` ASC [ RunTime:0.016944s ]
select * from pdf where partno='SMD320PL-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.018589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD320PL-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.032336s ]
SELECT `id` FROM `stock` WHERE `id` <> 44101771 AND `partno` = 'SMD320PL-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.035089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44101282 LIMIT 5 [ RunTime:0.036858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44101282 ORDER BY `minOrder` ASC [ RunTime:0.033454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44101282 ORDER BY `unit` DESC [ RunTime:0.036222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44101282 LIMIT 2 [ RunTime:0.012889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44101282 ORDER BY `minOrder` ASC [ RunTime:0.027985s ]
select * from pdf where partno='SMD32PL-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.007505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD32PL-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.034254s ]
SELECT `id` FROM `stock` WHERE `id` <> 44101282 AND `partno` = 'SMD32PL-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.044738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44100357 LIMIT 5 [ RunTime:0.107145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100357 ORDER BY `minOrder` ASC [ RunTime:0.034168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44100357 ORDER BY `unit` DESC [ RunTime:0.020239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44100357 LIMIT 2 [ RunTime:0.077371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100357 ORDER BY `minOrder` ASC [ RunTime:0.042000s ]
select * from pdf where partno='SMD320HE1-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.038619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD320HE1-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.065531s ]
SELECT `id` FROM `stock` WHERE `id` <> 44100357 AND `partno` = 'SMD320HE1-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.034817s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038054s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027086s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040373s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062462s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029361s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043714s ]
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 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.122475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021964 LIMIT 5 [ RunTime:0.051975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021964 ORDER BY `minOrder` ASC [ RunTime:0.078699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021964 ORDER BY `unit` DESC [ RunTime:0.040975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021964 LIMIT 2 [ RunTime:0.080893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021964 ORDER BY `minOrder` ASC [ RunTime:0.015020s ]
select * from pdf where partno='SMD3225-090N' and brandshort='RUILON' limit 1 [ RunTime:0.042652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-090N' OR `brand` LIKE 'RUILON(瑞隆源)%' ) ) LIMIT 1 [ RunTime:0.045573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58022402 LIMIT 5 [ RunTime:0.042015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022402 ORDER BY `minOrder` ASC [ RunTime:0.063115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58022402 ORDER BY `unit` DESC [ RunTime:0.040793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58022402 LIMIT 2 [ RunTime:0.034713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022402 ORDER BY `minOrder` ASC [ RunTime:0.046204s ]
select * from pdf where partno='SMD3216-090N' and brandshort='DOWO' limit 1 [ RunTime:0.041986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3216-090N' OR `brand` LIKE 'DOWO(东沃)%' ) ) LIMIT 1 [ RunTime:0.039756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021675 LIMIT 5 [ RunTime:0.013550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021675 ORDER BY `minOrder` ASC [ RunTime:0.042051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021675 ORDER BY `unit` DESC [ RunTime:0.024911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021675 LIMIT 2 [ RunTime:0.027550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021675 ORDER BY `minOrder` ASC [ RunTime:0.023397s ]
select * from pdf where partno='SMD3216-300N' and brandshort='R+O' limit 1 [ RunTime:0.029899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3216-300N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.068793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021643 LIMIT 5 [ RunTime:0.034188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021643 ORDER BY `minOrder` ASC [ RunTime:0.035776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021643 ORDER BY `unit` DESC [ RunTime:0.012515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021643 LIMIT 2 [ RunTime:0.029016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021643 ORDER BY `minOrder` ASC [ RunTime:0.008184s ]
select * from pdf where partno='SMD3225-090N' and brandshort='R+O' limit 1 [ RunTime:0.061254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-090N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.020009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58022196 LIMIT 5 [ RunTime:0.043183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022196 ORDER BY `minOrder` ASC [ RunTime:0.013016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58022196 ORDER BY `unit` DESC [ RunTime:0.045900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58022196 LIMIT 2 [ RunTime:0.030486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022196 ORDER BY `minOrder` ASC [ RunTime:0.008298s ]
select * from pdf where partno='SMD3216-090N' and brandshort='RUILON' limit 1 [ RunTime:0.035927s ]
select foldpath,foldpath2,filename from pdf_file where id=1991499 limit 1 [ RunTime:0.021535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3216-090N' OR `brand` LIKE 'RUILON(瑞隆源)%' ) ) LIMIT 1 [ RunTime:0.020603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021676 LIMIT 5 [ RunTime:0.020014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021676 ORDER BY `minOrder` ASC [ RunTime:0.024775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021676 ORDER BY `unit` DESC [ RunTime:0.042451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021676 LIMIT 2 [ RunTime:0.026712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021676 ORDER BY `minOrder` ASC [ RunTime:0.009039s ]
select * from pdf where partno='SMD3216-150N' and brandshort='R+O' limit 1 [ RunTime:0.023529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3216-150N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.033187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44122718 LIMIT 5 [ RunTime:0.061834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44122718 ORDER BY `minOrder` ASC [ RunTime:0.055470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44122718 ORDER BY `unit` DESC [ RunTime:0.027175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44122718 LIMIT 2 [ RunTime:0.007966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44122718 ORDER BY `minOrder` ASC [ RunTime:0.038040s ]
select * from pdf where partno='SMD3225-075N' and brandshort='R+O' limit 1 [ RunTime:0.030544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-075N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.018121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021680 LIMIT 5 [ RunTime:0.023026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021680 ORDER BY `minOrder` ASC [ RunTime:0.021578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021680 ORDER BY `unit` DESC [ RunTime:0.034292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021680 LIMIT 2 [ RunTime:0.032513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021680 ORDER BY `minOrder` ASC [ RunTime:0.007154s ]
select * from pdf where partno='SMD3216-090N' and brandshort='R+O' limit 1 [ RunTime:0.070513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3216-090N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.015820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58022201 LIMIT 5 [ RunTime:0.043144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022201 ORDER BY `minOrder` ASC [ RunTime:0.026512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58022201 ORDER BY `unit` DESC [ RunTime:0.081749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58022201 LIMIT 2 [ RunTime:0.053174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022201 ORDER BY `minOrder` ASC [ RunTime:0.008074s ]
select * from pdf where partno='SMD3225-400N' and brandshort='R+O' limit 1 [ RunTime:0.029757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-400N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.042771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58021967 LIMIT 5 [ RunTime:0.005953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021967 ORDER BY `minOrder` ASC [ RunTime:0.032588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58021967 ORDER BY `unit` DESC [ RunTime:0.022597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58021967 LIMIT 2 [ RunTime:0.022832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58021967 ORDER BY `minOrder` ASC [ RunTime:0.045440s ]
select * from pdf where partno='SMD3225-470N' and brandshort='R+O' limit 1 [ RunTime:0.069672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-470N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.023954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58022550 LIMIT 5 [ RunTime:0.041659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022550 ORDER BY `minOrder` ASC [ RunTime:0.028658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58022550 ORDER BY `unit` DESC [ RunTime:0.038688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58022550 LIMIT 2 [ RunTime:0.044353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022550 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
select * from pdf where partno='SMD3225-200N' and brandshort='R+O' limit 1 [ RunTime:0.039341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-200N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.028844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32118092 LIMIT 5 [ RunTime:0.150476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32118092 ORDER BY `minOrder` ASC [ RunTime:0.126771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32118092 ORDER BY `unit` DESC [ RunTime:0.072022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32118092 LIMIT 2 [ RunTime:0.050592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32118092 ORDER BY `minOrder` ASC [ RunTime:0.029893s ]
select * from pdf where partno='SMD3225-075N' and brandshort='R+O' limit 1 [ RunTime:0.029916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-075N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.064937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58022707 LIMIT 5 [ RunTime:0.076851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022707 ORDER BY `minOrder` ASC [ RunTime:0.085377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58022707 ORDER BY `unit` DESC [ RunTime:0.072010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58022707 LIMIT 2 [ RunTime:0.186361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022707 ORDER BY `minOrder` ASC [ RunTime:0.083669s ]
select * from pdf where partno='SMD3216-470N' and brandshort='R+O' limit 1 [ RunTime:0.074723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3216-470N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.046962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58022847 LIMIT 5 [ RunTime:0.103296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022847 ORDER BY `minOrder` ASC [ RunTime:0.077663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58022847 ORDER BY `unit` DESC [ RunTime:0.042555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58022847 LIMIT 2 [ RunTime:0.092030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022847 ORDER BY `minOrder` ASC [ RunTime:0.059818s ]
select * from pdf where partno='SMD3225-800N' and brandshort='R+O' limit 1 [ RunTime:0.064942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-800N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.105463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32133979 LIMIT 5 [ RunTime:0.108573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32133979 ORDER BY `minOrder` ASC [ RunTime:0.108884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32133979 ORDER BY `unit` DESC [ RunTime:0.079200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32133979 LIMIT 2 [ RunTime:0.142716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32133979 ORDER BY `minOrder` ASC [ RunTime:0.082573s ]
select * from pdf where partno='SMD3225-075N' and brandshort='R+O' limit 1 [ RunTime:0.030072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-075N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.042076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58022864 LIMIT 5 [ RunTime:0.062993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022864 ORDER BY `minOrder` ASC [ RunTime:0.091270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58022864 ORDER BY `unit` DESC [ RunTime:0.033851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58022864 LIMIT 2 [ RunTime:0.069005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58022864 ORDER BY `minOrder` ASC [ RunTime:0.062120s ]
select * from pdf where partno='SMD3225-300N' and brandshort='R+O' limit 1 [ RunTime:0.051226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMD3225-300N' OR `brand` LIKE 'R+O(宏嘉诚)%' ) ) LIMIT 1 [ RunTime:0.043698s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMD32%' OR `brand` LIKE 'SMD32%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.042507s ]