SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31882 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31882 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614056,466979,384786,451661,861373,310740,768757,939737,321003,85029,290870,792540,150713,751081,136091,814518,606133,153096,586258,560090,812401,790965,224026,783131,447807,372164,135416,992499,285826,999459,348608,642166,713069,780725,508219,269911,374948,433619,168083,236459,671614,424835,874441,399753,1032972,588237,711269,76946,672826,241603,428858,888127,440872,1038437,509391,1019587,631034,30464,85217,211740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]