SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31958 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31958 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682792,1033080,132387,463713,850640,692562,6806,629415,573803,1045266,696206,228319,417525,181824,1046936,935678,57060,85964,734421,423800,629521,463063,613648,455758,961290,1031257,815868,712250,557726,1043161,181993,145394,666950,1000742,379851,464184,838027,846808,21474,1020129,364521,1014162,927014,327437,859994,510741,146717,519166,135396,942203,934714,819108,1011106,406470,569512,1011866,179050,900985,150711,494415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002545s ]