SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322901 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322901 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599715,539714,6743,1027020,625375,196280,446847,996620,862550,463530,380290,733352,1003201,392679,894494,186175,140410,140556,461034,462213,176748,344262,1021058,868777,930176,275178,517619,970887,318019,932649,1048192,1019932,21012,83980,932416,278359,261484,152205,664062,760334,350572,558184,23145,512174,512284,778799,1036370,604452,116070,842758,774342,151009,784845,870871,997093,867914,173308,75984,294553,218855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]