SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427811 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427811 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805896,433935,750620,989484,1010249,550277,957967,651470,762480,544549,89744,166296,465287,820025,1017807,223063,432017,506810,606604,66367,297480,70793,377437,138910,793645,951241,193573,785597,324546,202321,842169,71295,749288,335228,98288,731750,196144,218392,321544,350882,404964,11411,200344,201846,517403,1045608,338419,523935,747569,817401,275579,738290,623467,580221,209607,353701,218093,214378,89459,480127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]