SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31080 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31080 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372774,162504,964611,623064,1033135,770639,596062,568632,425811,841204,883324,102081,1029475,528636,332689,65352,73098,463779,358841,259940,790291,247664,336959,16918,808560,257479,297869,522277,719006,983258,201058,63342,491068,397551,291883,508413,1027947,150478,937204,597159,1028342,241165,947119,864697,606125,909397,98967,230364,315978,614163,491858,126094,64070,964722,1013273,734233,250870,173112,39234,121987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]