SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914509 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914509 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419624,891686,776668,665211,42552,742815,98552,916454,649658,833541,341315,218238,142364,23049,999596,1002438,549187,785431,127154,168594,128065,855522,272687,269899,445915,470567,866508,345354,670741,359487,919907,269266,267858,752729,592825,942342,41594,405067,893070,945625,817062,1299,762294,841946,709756,365354,800190,711842,248088,919760,368057,200371,549623,929362,270581,142909,126526,36431,39013,801762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]