SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454218 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454218 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191896,397092,625003,274454,677910,999362,139839,906735,348841,399437,202308,157712,906142,627516,896289,466134,521238,67592,969572,410423,187682,48935,53923,311290,183133,751553,778138,345493,296039,289333,565866,458110,195364,990136,972282,294342,1632,926334,955455,504377,797042,499686,896742,183318,42430,929620,330261,389202,790561,72113,165192,670008,88831,449381,234535,632929,649403,646246,988376,662022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001166s ]