SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438834 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438834 [ RunTime:0.003153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957192,140018,949186,637560,452077,607371,127295,1015331,240640,633445,384521,494795,605612,893200,628894,317108,190375,968054,697166,301113,709072,974824,315771,532096,859979,662573,418443,705197,647262,34360,884634,403323,614666,740954,326002,525896,1033169,794562,957135,579922,449724,97809,805850,677260,442224,169345,278787,125531,849113,715190,977770,246706,144399,257207,366428,723458,920658,267141,389601,156210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]