SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046281 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046281 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47881,521602,156408,61430,360817,166961,43784,102477,723916,585178,155850,22756,934565,611461,138290,439504,15124,54775,71828,396779,583503,326428,59013,647840,324694,659605,525656,787092,440646,836541,466141,705778,988543,46276,156165,349247,822493,764941,488936,293416,63210,265181,283725,17004,262013,239174,920709,669157,254689,865535,976641,770208,837006,198984,118448,461387,377760,729732,704988,200890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]