SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001871s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804454 LIMIT 1 [ RunTime:0.002344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804454 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679188,588289,864193,644499,1023478,101998,651321,934487,111182,422461,757277,943744,561667,19362,489592,104509,777652,493465,70710,958186,30300,917578,54261,702332,888791,667740,924616,999876,71292,981166,730344,434908,103608,149101,713186,126787,814186,71541,287927,837292,784400,57275,984677,685322,270585,587475,673776,786861,956502,628205,129028,218848,768005,311106,607737,354489,758229,903391,52657,479533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002282s ]