SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502313 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502313 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254871,530304,741146,430627,652581,191251,409354,67506,785176,523492,223278,208310,759516,386653,344837,911081,961104,184151,614909,372555,115808,238329,440966,801147,547429,721397,140503,141041,989516,914946,819339,35527,949165,20002,55017,1000029,202056,925774,677734,674866,369355,799269,1033577,458322,301340,873143,617945,666080,854510,829641,496426,439436,573923,1048101,788847,279744,531258,226999,434732,1007887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]