SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590083 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590083 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808440,876560,147045,105853,911830,209873,504315,419577,595215,651055,215129,142269,109708,101035,283438,877563,584693,35029,683685,657161,163681,3035,228660,101485,837627,286604,903010,772180,136113,58160,905869,368295,206220,23942,390629,476790,775245,558624,867970,432269,648519,616011,410293,34890,425851,178054,143483,296845,33996,800030,416697,580008,163050,931179,1040935,300295,243741,13157,933800,294780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]