SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479911 LIMIT 1 [ RunTime:0.001128s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479911 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561025,48689,836703,291140,1012596,79970,766616,672512,862623,183683,571948,759359,208117,684173,100804,640311,120347,959692,231228,289621,293061,313850,493387,616397,966487,729547,468754,410125,26803,258214,251124,798931,966936,422769,1003553,200653,47621,770150,702237,833864,573236,726336,478416,713072,431255,507247,645481,230764,905923,64136,497099,270075,598845,328454,453101,493931,847713,420907,619264,784204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]