SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537674 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537674 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749490,881034,497405,746715,177710,562817,60889,989557,814244,1042038,300315,977012,771395,501703,427137,764584,640444,768469,585910,435305,304760,127471,417134,535392,381405,296468,862872,830702,556518,151249,138349,1008378,128561,502173,238966,438114,510137,776780,374673,94590,787404,383600,580397,826851,925737,967234,744517,62206,78737,752770,467781,414121,732401,470085,646962,1025454,665928,198076,503490,320782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]