SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001794s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025635 LIMIT 1 [ RunTime:0.000762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025635 [ RunTime:0.003325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543608,611118,1036927,171588,726198,901431,317480,854061,735778,433850,1023919,858533,767431,516153,856327,597443,511254,191397,105695,686607,546827,935265,966049,81015,720515,407313,886380,989846,784659,629404,321472,808284,366361,455344,264623,467515,899770,1028845,165686,927221,919099,297299,242923,89354,125222,885461,248372,80615,286537,743483,244783,554045,90924,302603,944600,108947,372713,4711,1025291,846812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025635 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025635 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000859s ]