SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582991 LIMIT 1 [ RunTime:0.001201s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582991 [ RunTime:0.002646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300685,490029,419181,430107,615624,715811,763503,589788,849027,922879,34497,459082,400861,317157,1976,897165,386700,825947,88006,298934,322592,89560,376408,509235,527821,95240,74866,409060,367508,319244,85517,397706,780183,138644,608675,650628,191727,1000051,104875,622882,624819,427174,952028,254338,694388,185007,97825,37363,808866,930031,301397,85904,282502,910653,333240,339941,268742,682964,577154,1010671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.037722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002075s ]