SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5251 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5251 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808487,437485,867988,285618,1019782,509850,857702,51094,147853,749903,704104,578304,288964,317115,825514,449029,678949,553069,688022,359088,877598,45322,710072,114648,680576,636815,888942,445358,84347,239040,691195,682759,661165,501646,634882,109033,933569,859386,939870,367264,416890,668660,530704,252678,1042329,518836,52294,727006,813372,520727,431267,42078,208468,720112,558332,126095,882353,460351,83102,968304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]