SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012375 LIMIT 1 [ RunTime:0.000862s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012375 [ RunTime:0.003257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919262,547158,152121,756049,395106,788895,296613,43458,426458,254920,795863,10742,162388,54877,557770,60130,21671,234068,843805,667576,543974,272083,451707,479877,854998,463612,899494,850717,98999,82381,596627,306409,707169,414025,863878,146329,135176,20770,746765,844468,768868,920127,20046,325406,628583,146163,772743,980060,593074,177491,210311,88526,583179,758496,927789,510866,295644,700134,1000662,727688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012375 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012375 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000866s ]