SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537241 LIMIT 1 [ RunTime:0.001191s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537241 [ RunTime:0.005821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219821,662837,972588,365469,39412,759704,896627,1044273,795428,921062,896091,166230,829935,927772,830756,747478,449499,479525,1043887,113700,491221,919811,745415,135533,547283,914874,711490,177943,871438,34434,1025941,396596,853518,27797,642257,520391,416021,378407,748573,316288,553703,365506,388505,392894,1044922,951634,594412,38417,815021,291004,538447,194562,1025177,163054,629041,413827,155079,96221,643204,902670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001503s ]