SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001900s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334143 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334143 [ RunTime:0.006576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517548,1018753,909026,538427,334443,727252,286658,635728,995426,976623,348431,761979,872028,754954,224832,821511,674140,957868,767291,924834,1023426,199165,576026,160347,502510,266207,963041,784151,600346,509118,750224,956218,367354,1019024,662528,282969,1027618,457766,941303,371915,203448,302694,691868,123873,183998,392432,553135,1025416,688552,46030,633604,563974,950266,598795,332922,998289,804540,1003961,36543,106573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000809s ]