SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573934 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573934 [ RunTime:0.003388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276235,606837,517838,272896,541478,814700,418538,492973,166985,617665,124086,850761,531167,705190,589650,276650,562112,978634,951903,504665,673394,453085,378189,524976,465111,519001,361196,1012802,179646,198648,969502,719302,833521,1009191,1006457,110412,597169,488180,932120,1037619,509623,282527,684840,214076,763114,81686,391277,507077,696834,556995,883675,481568,249567,842901,650334,130157,319203,392394,862180,1010561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]