SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39083 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39083 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656801,891432,688178,888323,488386,503378,648137,149179,582571,289398,22905,140176,558307,1007113,756870,303232,108880,370440,688618,273184,397535,461709,598581,401881,921272,619894,454644,347740,1019007,525501,56,665154,1044841,266907,83686,353428,460822,339963,768417,596843,286193,860639,941991,725403,310640,624835,686992,903431,15230,629686,288028,30588,922035,12615,796324,502447,83044,765499,788574,447619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]