SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547728 LIMIT 1 [ RunTime:0.001561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547728 [ RunTime:0.004389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926398,247102,82758,890592,468445,660301,643194,729776,785686,361378,102853,524968,776575,580788,907952,569515,931967,124240,709543,234968,568993,796349,599829,313052,912260,245420,951609,802905,1008786,85420,890698,761852,580339,338930,922299,433919,569636,197962,90506,622041,1011534,5612,168916,585595,274273,597791,550860,308723,736998,403373,382629,478073,644841,28589,619464,844757,832726,586625,672699,649148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001359s ]