SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3941 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3941 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814621,662554,889291,39202,269418,74000,445368,297633,1043427,723621,986257,23294,783940,817479,109778,762738,622641,330687,676994,1010222,270883,933246,55218,612078,757388,74708,452177,219585,105259,272764,505094,668536,428047,469268,286610,66946,45873,759381,1019620,442814,698566,986370,116823,773776,422667,237640,951684,903809,571623,260907,416628,822253,151784,742980,296239,374015,60734,593962,563766,740447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]