SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33380 LIMIT 1 [ RunTime:0.000849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33380 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228201,800476,450872,752015,91456,688099,721876,232613,110784,593841,1007042,807174,838953,619690,634493,827896,190863,852936,77460,595562,685237,744907,683754,1022715,158373,1036036,34425,400316,720500,706970,161244,1007703,809960,1007420,553530,733171,296539,79000,565647,554890,773514,680258,995148,559257,764797,793987,106356,113207,946681,804841,878217,91818,676880,1044628,376154,842016,943188,828944,685381,932515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]