SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303851 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303851 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344110,982482,42295,399213,828157,484405,889528,791664,773444,215621,493910,1032297,766065,720059,180326,883665,801110,715912,692134,599003,281283,12943,499792,761610,173291,165616,913971,629287,294209,824365,434319,997696,38303,940446,174958,876485,142471,149831,606235,427544,148007,808422,92466,522011,620429,710011,784006,765276,684364,601232,593853,1018942,902009,590577,1009805,642795,847617,855586,264787,769752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]