SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683843 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683843 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49578,433316,273386,38244,856176,319088,951274,619380,581670,116830,94563,480109,1014824,460094,145479,137931,991638,788062,942012,503914,401,208676,349332,656305,540372,557456,60658,606018,415753,703175,983090,1005054,732300,119793,509250,279294,480506,197620,517266,634090,102675,750331,306209,304396,637143,645340,430860,486304,1025553,860719,90152,944250,336401,7218,825755,557165,419051,872172,223027,610979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]