SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353654 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353654 [ RunTime:0.003237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395569,523802,822122,1042353,845759,1047462,523074,751181,361064,342818,590385,23877,354614,690953,304994,432650,128125,487253,130672,510802,656601,138699,144017,124066,116054,888477,683742,148450,72404,627892,1004592,896106,442929,59203,152815,901091,663008,714720,329784,177338,1008795,109909,961924,140799,428509,871843,831852,717952,239304,464676,133313,805044,469558,145943,628960,529521,254312,538990,875802,861916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]