SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039986 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039986 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852406,199986,509665,955584,454057,123822,92244,723386,443191,176387,490571,579486,816722,726820,1032561,437909,370403,253963,1041493,580169,69583,587848,147320,281240,289095,782364,554732,492666,532996,49694,200444,218644,847279,965718,958389,150442,790091,929242,189927,917224,701479,320494,102747,375697,890243,659096,956501,119410,1023231,917248,903510,881029,42297,392333,182182,240584,73248,852355,237354,528110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]