SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002916s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505722 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505722 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158524,23678,568543,525296,1021263,644901,479311,55503,337510,517507,964879,267341,712985,291354,785948,561882,211151,783812,90862,407102,264603,647219,942284,702865,509590,836421,380582,418756,351197,533494,141789,509558,30411,344170,470526,1008858,158720,981072,809197,217821,534008,126855,770118,770868,317978,807453,348031,795071,796020,498094,835139,428084,751664,493253,326945,198092,13261,129618,272059,831691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001378s ]