SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498953 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498953 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340065,371139,729122,41736,489624,847040,740645,105964,1045336,752003,937861,604490,989363,192486,133507,702600,927643,26326,787900,585217,932478,467774,802156,64915,258025,232208,272015,684231,949466,342242,897484,171678,820269,657910,255206,864785,794382,519024,211868,170103,44117,99747,811058,304072,1034746,253035,261532,359251,64953,345674,675947,140671,1010003,618534,885381,16646,271716,346061,953114,256912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]