SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419590 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419590 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128254,284784,132891,129662,375691,198642,1014555,577011,468781,1021885,453126,663989,546797,98293,792495,136597,349142,1012443,334833,540139,200606,319929,82561,162629,214986,492249,459668,628874,540757,970553,12554,337192,892727,384660,117728,566578,184827,108333,845165,425629,716016,865358,756184,387467,940076,541193,850068,24370,300588,651380,237426,1001665,480920,233554,433958,644824,728805,529554,50809,1034693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]