SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 96743 LIMIT 1 [ RunTime:0.003201s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 96743 [ RunTime:0.003369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470689,107438,288895,929102,210698,800303,677680,241970,927899,1031408,757470,594900,7441,250930,782260,496313,511088,234437,247476,317363,1035543,598689,433512,116913,322459,749979,401364,267935,254697,261630,145333,961473,344903,291360,20751,396824,118619,183345,25244,335765,468710,58810,726750,865263,234790,737384,433805,715827,935338,849010,244705,82814,720211,223214,861355,875203,868112,135261,243333,679268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 96743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 96743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]