SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861891 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861891 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822982,231738,870868,816582,810035,412385,175811,5492,43958,854154,937070,134012,101516,710402,25882,3666,570763,873565,900591,194474,642013,716636,205012,46453,132150,141153,576268,994844,571421,20473,39809,35197,596790,115906,622745,844944,772151,883922,120839,361652,392743,153434,163825,924533,599729,874153,886444,402057,782005,585929,879058,486511,504352,16811,974250,520097,219452,154825,801407,261420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]