SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101364 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101364 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384882,556848,559589,873865,266020,654594,70471,79431,491081,1013316,604626,269649,11160,534898,764892,367835,465528,749846,420804,745333,321216,716696,447876,173155,80839,16393,907339,395737,954856,145727,241205,808397,75098,342035,837874,183590,730090,855229,887811,827260,391894,175153,193525,233542,155374,643175,133635,326236,300986,190206,455833,772860,895012,742168,518636,165781,413799,610758,16363,345370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002146s ]