SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106289 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106289 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336658,47421,495960,754654,90974,123041,1045435,1008415,250857,321797,540788,129488,762649,275910,753907,765417,1005220,867898,884264,613947,801148,825287,216564,655088,101704,65888,774759,75255,614457,365007,540014,575701,768568,159303,55288,624085,385279,1016162,167297,512425,614201,903745,962261,571520,159095,281807,933961,145788,424028,368254,791600,223974,520306,223503,130717,243983,662179,345764,197464,251574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]