SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001506 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001506 [ RunTime:0.002413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467981,721291,606325,394736,556222,388964,654870,744711,364839,514981,749324,205592,33283,251526,842146,861799,1024179,873176,900245,114091,798648,625939,703390,773075,398685,163248,943114,269534,703318,118477,532314,907829,894654,407071,281086,337246,591173,774004,477276,847396,648975,279149,526099,942918,85929,581068,845429,751172,267973,717406,81841,365980,199381,606136,1042527,706165,95456,629189,681113,596287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]