SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287676 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287676 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041698,181169,587902,750059,968579,138724,415565,116359,509560,169624,420169,78502,442373,459530,644378,764017,787945,368111,735984,449676,40086,367419,183039,828802,649543,1044213,200670,257581,662439,650961,335323,101083,772420,982365,532726,511192,1037317,716767,850050,244058,56684,513215,119741,996129,764424,448325,582577,273121,1047198,158905,758870,459358,992101,781100,911926,312150,562610,933870,254314,383573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]