SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 73438 LIMIT 1 [ RunTime:0.002439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 73438 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764823,404083,731196,503554,889780,831387,910491,633158,607914,791523,1000772,411453,756038,608418,696613,164778,548415,561443,160279,412944,770357,477758,329731,505431,141033,597583,50656,623898,465807,573006,307174,534868,488414,905465,335143,423400,272057,868002,551239,1000104,886202,787359,530674,460940,342771,96910,388315,205579,755251,660862,824555,460372,252420,324012,824226,970012,945848,470088,510083,756033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 73438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 73438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]