SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001749s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017386 LIMIT 1 [ RunTime:0.001780s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017386 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369866,217218,99163,391007,538134,908256,126340,241387,715562,565692,195851,682800,231863,255950,668665,909161,542681,526248,205125,332428,458127,48419,706995,794583,805641,135204,283116,872835,65070,233977,622237,809973,265155,959079,535991,219312,972785,927605,664851,908545,561159,350602,1018294,814487,251879,412090,556734,635985,846003,65118,372572,862098,525850,755978,112641,365431,902656,351732,1044269,3440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017386 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017386 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000809s ]