SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488501 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488501 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716111,661267,580397,1026456,23349,818691,960657,264733,883112,37946,205168,357519,364241,490712,235446,520174,962628,85394,389197,12782,228147,1034207,465115,951031,1023484,505542,447006,729989,830205,364227,241828,417725,851204,626837,860658,662438,798319,1046655,871521,936722,260962,221093,141352,873924,891341,70201,514580,656654,1009758,746674,916095,127900,885301,127393,596841,638055,556265,524358,430231,529709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]