SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 761483 LIMIT 1 [ RunTime:0.002831s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 761483 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80918,169377,906361,23922,897329,75889,298023,871907,5210,431613,390810,622245,355349,133912,564832,569119,508693,233402,593925,391770,920743,950031,1032913,37184,839898,469200,933456,652920,661114,717389,900569,1047408,366836,888507,870307,381305,177776,885364,634205,792107,413072,984903,837809,749582,571872,367084,211796,673259,23414,1028073,735948,887365,405462,65740,956965,193827,342499,182567,400438,383817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 761483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 761483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]