SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808401 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808401 [ RunTime:0.004760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650404,744696,811429,465368,951716,5284,147009,586207,931033,1037022,1048628,862990,232409,944525,395880,386403,547015,739200,132833,651613,828484,289828,35157,636063,727531,438101,62684,715214,455665,370218,985058,971874,274811,256169,832930,651428,585719,990598,512173,790525,971707,1006597,672988,81944,131490,839106,681907,582462,733820,80420,1027448,176944,983384,21646,864009,740946,458941,289026,137776,432917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]