SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684763 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684763 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327777,941843,1045338,87011,183723,117661,124296,785200,917096,859101,900114,702009,390789,728348,935382,657750,737329,181930,844382,151154,221774,858282,510650,277156,585139,460550,631363,525251,688298,983669,239567,416986,384926,265063,356750,561994,266714,890870,54711,687230,124801,494391,1046732,708802,619895,416715,530261,1005014,179004,863543,80928,6657,989638,15400,135268,974721,331682,59234,216822,836427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]