SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283471 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283471 [ RunTime:0.005725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599879,103639,437058,1041738,174650,1042231,56008,126562,524128,83085,743952,451764,210149,362392,840589,156914,848007,335643,377356,232889,330617,551059,618370,383914,396576,215616,666730,601900,901470,497469,652937,373549,144894,1001890,140708,697918,386367,551312,180469,782518,949511,884081,49846,766562,227997,545474,975706,922051,709851,788736,788026,282299,796537,373412,612267,222603,891079,786934,812375,649495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]