SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44683 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44683 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71957,1043680,844864,925795,947902,562212,958314,60161,537515,823885,243230,21896,460889,279494,67095,632189,600577,281795,30834,475597,230554,328435,120292,86730,204423,354190,129225,994983,67040,885389,653615,851730,908365,627268,616167,770072,1041571,174637,135607,284354,869533,332432,753364,573419,816570,788625,236932,309114,616864,446714,1035605,654363,582642,793101,352985,468351,965141,705724,691344,496355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]