SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29187 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29187 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961918,207264,832968,750013,630705,495027,458941,582981,351409,1043535,395700,846614,448872,83085,150869,639040,985803,128338,197812,883006,363641,952491,164740,111052,532785,826858,465387,129835,139649,893838,1031112,383490,378518,906051,338005,456008,153616,166275,739002,272923,38424,103471,458824,691658,804421,873716,231452,135564,479044,915146,894142,392469,539047,624142,122515,361882,358086,440793,627826,703191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]