SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002219s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=15541&search=1' [ RunTime:0.004105s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002829s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004409s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002925s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002334s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002523s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008150s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001410s ]
SELECT * FROM `stock_search` WHERE `partno` = '15541' LIMIT 1 [ RunTime:0.029813s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-19 19:47:22' WHERE `partno` = '15541' [ RunTime:0.005650s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001477s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026174s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377284 LIMIT 5 [ RunTime:0.026094s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377284 ORDER BY `minOrder` ASC [ RunTime:0.023870s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377284 ORDER BY `unit` DESC [ RunTime:0.020841s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377284 LIMIT 2 [ RunTime:0.010098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377284 ORDER BY `minOrder` ASC [ RunTime:0.021022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515892 LIMIT 5 [ RunTime:0.007842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515892 ORDER BY `minOrder` ASC [ RunTime:0.007899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13515892 ORDER BY `unit` DESC [ RunTime:0.016049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13515892 LIMIT 2 [ RunTime:0.004770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515892 ORDER BY `minOrder` ASC [ RunTime:0.012851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515339 LIMIT 5 [ RunTime:0.001963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515339 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13515339 ORDER BY `unit` DESC [ RunTime:0.003762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13515339 LIMIT 2 [ RunTime:0.011052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515339 ORDER BY `minOrder` ASC [ RunTime:0.002168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515537 LIMIT 5 [ RunTime:0.013483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515537 ORDER BY `minOrder` ASC [ RunTime:0.005579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13515537 ORDER BY `unit` DESC [ RunTime:0.008602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13515537 LIMIT 2 [ RunTime:0.005363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515537 ORDER BY `minOrder` ASC [ RunTime:0.000858s ]
select * from pdf where partno='1554115001' and brandshort='Molex' limit 1 [ RunTime:0.024138s ]
select foldpath,foldpath2,filename from pdf_file where id=1514857 limit 1 [ RunTime:0.003441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13502542 LIMIT 5 [ RunTime:0.010996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13502542 ORDER BY `minOrder` ASC [ RunTime:0.010034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13502542 ORDER BY `unit` DESC [ RunTime:0.010753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13502542 LIMIT 2 [ RunTime:0.002726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13502542 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='1554115001' and brandshort='Molex' limit 1 [ RunTime:0.000446s ]
select foldpath,foldpath2,filename from pdf_file where id=1514857 limit 1 [ RunTime:0.002879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702915 LIMIT 5 [ RunTime:0.001562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702915 ORDER BY `minOrder` ASC [ RunTime:0.005296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702915 ORDER BY `unit` DESC [ RunTime:0.002624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702915 LIMIT 2 [ RunTime:0.005131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702915 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382035 LIMIT 5 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382035 ORDER BY `minOrder` ASC [ RunTime:0.002220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382035 ORDER BY `unit` DESC [ RunTime:0.003004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382035 LIMIT 2 [ RunTime:0.002767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382035 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389211 LIMIT 5 [ RunTime:0.004793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389211 ORDER BY `minOrder` ASC [ RunTime:0.003180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389211 ORDER BY `unit` DESC [ RunTime:0.000799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389211 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389211 ORDER BY `minOrder` ASC [ RunTime:0.006106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389283 LIMIT 5 [ RunTime:0.007104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389283 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389283 ORDER BY `unit` DESC [ RunTime:0.002215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389283 LIMIT 2 [ RunTime:0.005806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389283 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16409942 LIMIT 5 [ RunTime:0.003716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16409942 ORDER BY `minOrder` ASC [ RunTime:0.008160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16409942 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16409942 LIMIT 2 [ RunTime:0.002350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16409942 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='1554115001' and brandshort='Molex' limit 1 [ RunTime:0.003783s ]
select foldpath,foldpath2,filename from pdf_file where id=1514857 limit 1 [ RunTime:0.002594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14383796 LIMIT 5 [ RunTime:0.016207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14383796 ORDER BY `minOrder` ASC [ RunTime:0.014249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14383796 ORDER BY `unit` DESC [ RunTime:0.023331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14383796 LIMIT 2 [ RunTime:0.006026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14383796 ORDER BY `minOrder` ASC [ RunTime:0.016694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13510914 LIMIT 5 [ RunTime:0.003943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13510914 ORDER BY `minOrder` ASC [ RunTime:0.001617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13510914 ORDER BY `unit` DESC [ RunTime:0.002694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13510914 LIMIT 2 [ RunTime:0.020785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13510914 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='1554115001' and brandshort='Molex' limit 1 [ RunTime:0.000340s ]
select foldpath,foldpath2,filename from pdf_file where id=1514857 limit 1 [ RunTime:0.000241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649127 LIMIT 5 [ RunTime:0.002291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649127 ORDER BY `minOrder` ASC [ RunTime:0.004554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649127 ORDER BY `unit` DESC [ RunTime:0.012735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649127 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649127 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648993 LIMIT 5 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648993 ORDER BY `minOrder` ASC [ RunTime:0.001154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19648993 ORDER BY `unit` DESC [ RunTime:0.004961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19648993 LIMIT 2 [ RunTime:0.003689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648993 ORDER BY `minOrder` ASC [ RunTime:0.003464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143857 LIMIT 5 [ RunTime:0.008863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143857 ORDER BY `minOrder` ASC [ RunTime:0.002272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17143857 ORDER BY `unit` DESC [ RunTime:0.002635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17143857 LIMIT 2 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143857 ORDER BY `minOrder` ASC [ RunTime:0.002704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412521 LIMIT 5 [ RunTime:0.013766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412521 ORDER BY `minOrder` ASC [ RunTime:0.001178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412521 ORDER BY `unit` DESC [ RunTime:0.008086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412521 LIMIT 2 [ RunTime:0.008937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412521 ORDER BY `minOrder` ASC [ RunTime:0.007774s ]
select * from pdf where partno='1554116001' and brandshort='Molex' limit 1 [ RunTime:0.015393s ]
select foldpath,foldpath2,filename from pdf_file where id=1789331 limit 1 [ RunTime:0.011864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412314 LIMIT 5 [ RunTime:0.013662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412314 ORDER BY `minOrder` ASC [ RunTime:0.009196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412314 ORDER BY `unit` DESC [ RunTime:0.005201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412314 LIMIT 2 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412314 ORDER BY `minOrder` ASC [ RunTime:0.004319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412313 LIMIT 5 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412313 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412313 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412313 LIMIT 2 [ RunTime:0.002354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412313 ORDER BY `minOrder` ASC [ RunTime:0.005200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412312 LIMIT 5 [ RunTime:0.006454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412312 ORDER BY `minOrder` ASC [ RunTime:0.021539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412312 ORDER BY `unit` DESC [ RunTime:0.008724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412312 LIMIT 2 [ RunTime:0.005321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412312 ORDER BY `minOrder` ASC [ RunTime:0.008686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412311 LIMIT 5 [ RunTime:0.004842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412311 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412311 ORDER BY `unit` DESC [ RunTime:0.011387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412311 LIMIT 2 [ RunTime:0.006831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412311 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138053 LIMIT 5 [ RunTime:0.015433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138053 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138053 ORDER BY `unit` DESC [ RunTime:0.000856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138053 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138053 ORDER BY `minOrder` ASC [ RunTime:0.001546s ]
select * from pdf where partno='155411-1004' and brandshort='molex / flamar' limit 1 [ RunTime:0.006948s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '155411-1004' OR `brand` LIKE 'molex / flamar%' ) ) LIMIT 1 [ RunTime:0.000921s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138053 AND `partno` = '155411-1004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%molex / flamar%' ) [ RunTime:0.004709s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59350715 LIMIT 5 [ RunTime:0.001205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350715 ORDER BY `minOrder` ASC [ RunTime:0.002034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59350715 ORDER BY `unit` DESC [ RunTime:0.000570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59350715 LIMIT 2 [ RunTime:0.007307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350715 ORDER BY `minOrder` ASC [ RunTime:0.018417s ]
select * from pdf where partno='15541' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.003899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15541' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.004742s ]
SELECT `id` FROM `stock` WHERE `id` <> 59350715 AND `partno` = '15541' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.011285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540783 LIMIT 5 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540783 ORDER BY `minOrder` ASC [ RunTime:0.009502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540783 ORDER BY `unit` DESC [ RunTime:0.000530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540783 LIMIT 2 [ RunTime:0.002979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540783 ORDER BY `minOrder` ASC [ RunTime:0.007472s ]
select * from pdf where partno='1554155' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554155' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61150866 LIMIT 5 [ RunTime:0.013962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61150866 ORDER BY `minOrder` ASC [ RunTime:0.009875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61150866 ORDER BY `unit` DESC [ RunTime:0.000773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61150866 LIMIT 2 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61150866 ORDER BY `minOrder` ASC [ RunTime:0.002690s ]
select * from pdf where partno='1554151' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554151' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518003 LIMIT 5 [ RunTime:0.005347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518003 ORDER BY `minOrder` ASC [ RunTime:0.018253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518003 ORDER BY `unit` DESC [ RunTime:0.000725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518003 LIMIT 2 [ RunTime:0.000948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518003 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
select * from pdf where partno='15541' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15541' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007268s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518003 AND `partno` = '15541' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526245 [ RunTime:0.006891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63037602 LIMIT 5 [ RunTime:0.022625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63037602 ORDER BY `minOrder` ASC [ RunTime:0.017041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63037602 ORDER BY `unit` DESC [ RunTime:0.020812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63037602 LIMIT 2 [ RunTime:0.008991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63037602 ORDER BY `minOrder` ASC [ RunTime:0.001050s ]
select * from pdf where partno='1554111004' and brandshort='Molex' limit 1 [ RunTime:0.001774s ]
select foldpath,foldpath2,filename from pdf_file where id=1629137 limit 1 [ RunTime:0.001958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554111004' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63034981 LIMIT 5 [ RunTime:0.011004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63034981 ORDER BY `minOrder` ASC [ RunTime:0.010410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63034981 ORDER BY `unit` DESC [ RunTime:0.013349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63034981 LIMIT 2 [ RunTime:0.025307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63034981 ORDER BY `minOrder` ASC [ RunTime:0.004855s ]
select * from pdf where partno='1554115001' and brandshort='Molex' limit 1 [ RunTime:0.006537s ]
select foldpath,foldpath2,filename from pdf_file where id=1514857 limit 1 [ RunTime:0.002863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554115001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63034837 LIMIT 5 [ RunTime:0.006191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63034837 ORDER BY `minOrder` ASC [ RunTime:0.002417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63034837 ORDER BY `unit` DESC [ RunTime:0.017544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63034837 LIMIT 2 [ RunTime:0.015939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63034837 ORDER BY `minOrder` ASC [ RunTime:0.008859s ]
select * from pdf where partno='1554116001' and brandshort='Molex' limit 1 [ RunTime:0.000407s ]
select foldpath,foldpath2,filename from pdf_file where id=1789331 limit 1 [ RunTime:0.005328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554116001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021561 LIMIT 5 [ RunTime:0.007288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021561 ORDER BY `minOrder` ASC [ RunTime:0.000871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021561 ORDER BY `unit` DESC [ RunTime:0.003894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021561 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021561 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='1554115002' and brandshort='Molex' limit 1 [ RunTime:0.000682s ]
select foldpath,foldpath2,filename from pdf_file where id=1514857 limit 1 [ RunTime:0.000687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554115002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021250 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021250 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021250 ORDER BY `unit` DESC [ RunTime:0.004766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021250 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021250 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
select * from pdf where partno='1554116002' and brandshort='Molex' limit 1 [ RunTime:0.000731s ]
select foldpath,foldpath2,filename from pdf_file where id=1789331 limit 1 [ RunTime:0.000781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554116002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021187 LIMIT 5 [ RunTime:0.001451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021187 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021187 ORDER BY `unit` DESC [ RunTime:0.006694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021187 LIMIT 2 [ RunTime:0.001738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021187 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='1554116003' and brandshort='Molex' limit 1 [ RunTime:0.001368s ]
select foldpath,foldpath2,filename from pdf_file where id=1789331 limit 1 [ RunTime:0.000891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554116003' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021186 LIMIT 5 [ RunTime:0.002224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021186 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021186 ORDER BY `unit` DESC [ RunTime:0.005386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021186 LIMIT 2 [ RunTime:0.001494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021186 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='1554111006' and brandshort='Molex' limit 1 [ RunTime:0.000643s ]
select foldpath,foldpath2,filename from pdf_file where id=1629137 limit 1 [ RunTime:0.000944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554111006' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021185 LIMIT 5 [ RunTime:0.003191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021185 ORDER BY `minOrder` ASC [ RunTime:0.002918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021185 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021185 LIMIT 2 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021185 ORDER BY `minOrder` ASC [ RunTime:0.001525s ]
select * from pdf where partno='1554111005' and brandshort='Molex' limit 1 [ RunTime:0.000718s ]
select foldpath,foldpath2,filename from pdf_file where id=1629137 limit 1 [ RunTime:0.003441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554111005' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.009001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63019957 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019957 ORDER BY `minOrder` ASC [ RunTime:0.000920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63019957 ORDER BY `unit` DESC [ RunTime:0.002455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63019957 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019957 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='1554115003' and brandshort='Molex' limit 1 [ RunTime:0.000674s ]
select foldpath,foldpath2,filename from pdf_file where id=1514857 limit 1 [ RunTime:0.001110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554115003' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60546379 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60546379 ORDER BY `minOrder` ASC [ RunTime:0.001530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60546379 ORDER BY `unit` DESC [ RunTime:0.002849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60546379 LIMIT 2 [ RunTime:0.003068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60546379 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
select * from pdf where partno='1554110000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554110000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001054s ]
SELECT `id` FROM `stock` WHERE `id` <> 60546379 AND `partno` = '1554110000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649127 [ RunTime:0.006458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60546167 LIMIT 5 [ RunTime:0.000953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60546167 ORDER BY `minOrder` ASC [ RunTime:0.001997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60546167 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60546167 LIMIT 2 [ RunTime:0.002848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60546167 ORDER BY `minOrder` ASC [ RunTime:0.005687s ]
select * from pdf where partno='1554160000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554160000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008437s ]
SELECT `id` FROM `stock` WHERE `id` <> 60546167 AND `partno` = '1554160000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648993 [ RunTime:0.004300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59998586 LIMIT 5 [ RunTime:0.014398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59998586 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59998586 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59998586 LIMIT 2 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59998586 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
select * from pdf where partno='1554108' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554108' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59787003 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59787003 ORDER BY `minOrder` ASC [ RunTime:0.009866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59787003 ORDER BY `unit` DESC [ RunTime:0.002132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59787003 LIMIT 2 [ RunTime:0.008517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59787003 ORDER BY `minOrder` ASC [ RunTime:0.002403s ]
select * from pdf where partno='1554199-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554199-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011461s ]
SELECT `id` FROM `stock` WHERE `id` <> 59787003 AND `partno` = '1554199-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11525037 [ RunTime:0.019418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43773352 LIMIT 5 [ RunTime:0.004704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773352 ORDER BY `minOrder` ASC [ RunTime:0.002444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43773352 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43773352 LIMIT 2 [ RunTime:0.005044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773352 ORDER BY `minOrder` ASC [ RunTime:0.002889s ]
select * from pdf where partno='15541.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.012059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15541.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.007137s ]
SELECT `id` FROM `stock` WHERE `id` <> 43773352 AND `partno` = '15541.2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.004057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143857 [ RunTime:0.003391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32345748 LIMIT 5 [ RunTime:0.016608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32345748 ORDER BY `minOrder` ASC [ RunTime:0.014745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32345748 ORDER BY `unit` DESC [ RunTime:0.021010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32345748 LIMIT 2 [ RunTime:0.019697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32345748 ORDER BY `minOrder` ASC [ RunTime:0.015780s ]
select * from pdf where partno='1554116' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554116' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012156s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014897s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017070s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007806s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013178s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011041s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018507s ]
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 '15541%' OR `brand` LIKE '15541%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029379s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15541%' OR `brand` LIKE '15541%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.035894s ]