SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485405 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485405 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574490,154802,361257,1005109,928057,166484,792804,871583,832605,1001387,258367,92273,176406,259650,581748,612049,865396,55043,743797,149892,10513,38069,703093,269738,608309,410224,365700,690894,705551,203604,807090,524747,91376,291369,1017059,592109,531254,542854,270831,500560,269577,576184,619656,690888,19749,429400,85037,830741,889963,838025,792153,426186,898596,245910,800073,620967,172214,214958,664530,956381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000872s ]