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` = 1012039 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012039 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583141,364470,580898,492210,790230,275803,888596,924716,962473,194055,33182,321561,616107,871611,794457,532365,54144,439605,737523,780983,52617,522227,522811,1043728,139140,870191,196631,964387,771484,691095,845402,476244,1044654,67905,991643,950786,539606,358741,915140,946045,945879,45493,767711,665000,647373,311707,321697,59447,108147,46385,174619,392774,49694,363219,73282,63959,819131,608592,517789,223460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000978s ]