SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022898 LIMIT 1 [ RunTime:0.001581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022898 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290176,135863,406138,629938,605403,343918,574758,444114,691096,770462,785655,87700,1014827,517309,951588,742074,355424,723047,87446,499088,627643,607297,797070,876966,49729,679820,16640,505806,87121,260342,186196,672815,401313,467345,516459,232925,1048358,292824,734309,744580,494583,516142,262099,760864,736558,143573,546624,54681,239519,949880,1032540,630773,700529,338682,301060,427030,104917,626866,878498,562023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]