SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51902 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51902 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324038,185150,295213,951516,183466,939035,947632,77542,732533,690158,608825,616290,369619,152459,650015,121848,352557,725218,1017994,589448,586417,642003,858337,916380,1017244,100107,115135,40594,1038907,1040890,954922,879949,81497,274398,294634,488434,715721,321863,596490,386271,1023414,811668,869776,279577,280083,579521,906486,903388,697427,419752,241585,959438,116859,948322,177386,263198,1034237,958416,736247,752142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]