SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401424 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401424 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59863,831923,77908,74967,228564,62394,552661,1037888,1031660,72744,984166,567713,831650,744891,838843,264135,66322,592906,905209,442180,644880,487511,40818,735656,915729,959397,780366,727364,641782,705512,870086,527315,253682,560412,854778,101975,424370,149200,234470,614829,18746,629413,458704,213593,742315,639536,785344,743642,694866,833272,306183,100503,466323,107952,549012,76428,745703,909504,405581,362430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]